Data Engineer I

Summary

Join Coalition, a leading Active Insurance provider, and contribute to our mission of preventing digital risk. As a Data Modeler, you will own and maintain robust data models, ensuring data fidelity and accessibility across all business areas. Collaborate with cross-functional teams to report on KPIs and improve our analytics data stack. This role requires a Bachelor's degree, 1-2 years of experience in a related field, and strong SQL proficiency. We offer competitive compensation, comprehensive benefits including 100% medical, dental, and vision coverage, flexible PTO, and a remote-first work environment. Bonus points for experience with visualization platforms and analytics engineering tools.

Requirements

• A Bachelor's degree in Statistics, Economics, Mathematics or related technical field
• 1-2 years of experience in related analytical, data science or consulting background
• SQL proficiency with proven competencies in designing well-architected data models, optimizing for query performance, and clearly documenting code
• Strong communication skills and ability to convey complex topics to non-technical audiences
• Passion, drive, and a deep sense of responsibility. We build the systems that keep us and our customers safe!

Responsibilities

• Own and maintain robust data models that serve all verticals and areas of Coalition’s business
• Set the standard for fidelity and metrics consistency across all data models, ensuring all team members have access to the latest and most accurate data, via query or our business intelligence platform
• Collaborate with Product, Analytics, Engineering, and Business team members to help report on KPIs, OKR performance monitoring, and metrics anomalies
• Improve our analytics data stack’s efficiency and deliver timely data even as the business scales
• Make new data sources available and query-able via a ETL pipeline or other data processing jobs

Preferred Qualifications

• Work in Tableau, Looker, or similar visualization / business intelligence platform
• Experience with dbt, Airflow, dagster, Prefect, or similar analytics engineering tools
• Experience with Python, R, or similar programming language
• Understanding of and experience with experimental design, statistical methods and machine learning
• Experience in insurance, insurtech and fintech industries
• Experience using data science tools like scikit-learn, pandas, numpy, XGBoost, TensorFlow
• Exposure to causal inference and other advanced statistical methods

Benefits

• 100% medical, dental and vision coverage
• Flexible PTO policy
• Annual home office stipend and WeWork access
• Mental & physical health wellness programs (One Medical, Headspace, Wellhub, and more)!
• Competitive compensation and opportunity for advancement