Senior Data Engineer - LA

Position Overview

Location: Los Angeles (On-Site). COVU is a venture-backed technology startup transforming the insurance industry by empowering independent agencies with AI-driven insights and digitized operations. We are seeking an experienced and product-focused Senior Data Engineer to join our Platform product team. In this high-impact role, you will help evolve our core data infrastructure and develop key components of our Policy Journal – the foundational data asset that serves as the single source of truth for all policy, commission, and client accounting information.

Key Responsibilities

• Develop the Policy Journal: Build and implement data models and pipelines that unify policy, commission, and accounting data from multiple sources.
• Ensure Data Quality and Reliability: Implement robust data quality checks, monitoring, and alerting to maintain accuracy and timeliness.
• Build the Foundational Analytics Platform: Enhance our analytics framework using modern tools (e.g., Snowflake, dbt, Airflow) to transform raw data into high-quality dimensional models.
• Modernize Core ETL Processes: Refactor and optimize legacy Java and SQL-based ETL systems by rewriting critical components in Python and migrating orchestration to Airflow.
• Implement Data Quality Frameworks: Develop automated data validation tests ensuring the completeness and integrity of our pipelines.
• Collaborate and Contribute to Design: Work closely with product managers, the Lead Data Engineer, and business stakeholders to translate requirements into scalable solutions.

Required Qualifications

• 5+ years of experience in data engineering with a proven track record of building and maintaining scalable data pipelines in production.
• Expert-level proficiency in Python and SQL.
• Strong experience with modern data stack technologies, including cloud data warehouses (Snowflake or Redshift), workflow orchestrators (preferably Airflow), and data transformation tools.
• Hands-on experience with AWS data services such as S3, Glue, Lambda, and RDS.
• Experience in the insurtech industry with an understanding of policies, commissions, and claims.
• Demonstrated ability to design robust data models for analytics and reporting.
• A pragmatic problem-solver capable of analyzing and refactoring complex legacy systems.
• Excellent communication skills with experience collaborating with technical and non-technical stakeholders.

Preferred Qualifications

• Direct experience with data from Agency Management Systems (e.g., Applied EPIC, Nowcerts, EZlynx).
• Experience working with Carrier data (such as Accord XML, IVANS AL3).
• Familiarity with business intelligence tools like Tableau, Looker, or Power BI.
• Prior experience in a startup or a fast-paced agile environment.