Data Engineer II

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
• Mentor junior employees

Skills and Qualifications

• A Bachelor's degree in Statistics, Economics, Mathematics or related technical field
• 3+ years of experience in related analytical, data science or consulting background
• Expert SQL proficiency with proven competencies in designing well-architected data models, optimizing for query performance, and clearly documenting code
• Experience with dbt, Airflow, dagster, Prefect, or similar analytics engineering tools
• Strong programming skills in Python, R, or similar programming language
• Work in Tableau, Looker, or similar visualization / business intelligence platform
• 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!

Bonus Skills

• 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

Perks

• 100% medical, dental, and vision coverage
• Flexible PTO
• Annual home office stipend and WeWork access
• Mental & physical health wellness programs like Headspace, Lumino, and more!
• Competitive compensation and opportunity for advancement