Senior Data Engineer: Data Pipelines, Modeling & Governance

Palomar Holdings; Edina (MN); On-site; USD 125,000 - 165,000; Full time

Benefits offered by this job

Medical Benefits

Stock options

401k with employer contributions

PTO + Holidays

Lifestyle Spending Allowance

Professional Development Assistance

Career Exploration Opportunities

Social events

Job summary

Palomar Holdings seeks a Senior Data Engineer to lead design, develop and optimize robust data solutions powering our business. You will mentor engineers, drive best practices, and collaborate across teams to deliver production-ready data assets and pipelines for statistical reporting with Actuarial and Compliance.

Responsibilities include building ELT/ETL pipelines, data modeling and architecture, ensuring data quality, governance, and reliability, while partnering with stakeholders to

Qualifications

• 6+ years of experience in data engineering or related field.
• Advanced proficiency in SQL and Python.
• Experience with modern data warehousing (Snowflake, Redshift, BigQuery).
• Deep understanding of data modeling/architecture and cloud platforms (AWS/Azure/GCP).
• Experience with orchestration tools (Airflow, dbt, Cloud Composer).
• Strong problem-solving, analytical, and communication skills.
• Ability to mentor/lead technical teams.
• Insurance domain experience preferred.
• Statistical reporting experience preferred.

Responsibilities

• Lead Data Pipeline Development: architect, build and optimize ELT/ETL pipelines at scale.
• Data Architecture & Modeling: design advanced data models and architectures for analytics and reporting.
• Statistical Reporting: partner with Actuarial/Compliance to build source mappings and transformations.
• Performance & Reliability: monitor and improve data systems for performance and reliability.
• Data Quality & Governance: implement validation, monitoring and governance processes.
• Collaboration & Leadership: work with stakeholders, BI and DB teams; mentor juniors.
• Documentation & Standards: maintain comprehensive docs and promote best practices.
• Innovation: evaluate new technologies to enhance data capabilities.

Skills

SQL

Python

Data Warehousing

Data Modeling

Cloud Platforms

Orchestration Tools

Mentoring/Leadership

Insurance experience

Statistical reporting

Tools

Airflow

dbt

Cloud Composer

Job description

Palomar Holdings seeks a Senior Data Engineer to lead design, develop and optimize robust data solutions powering our business. You will mentor engineers, drive best practices, and collaborate across teams to deliver production-ready data assets and pipelines for statistical reporting with Actuarial and Compliance.

Responsibilities include building ELT/ETL pipelines, data modeling and architecture, ensuring data quality, governance, and reliability, while partnering with stakeholders to