Senior Data Engineer — Data Pipelines & Analytics Architect

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

Benefits offered by this job

Medical benefits

401k with employer contributions

PTO + holidays

Professional development assistance

Company-wide social events

Job summary

Palomar Holdings, Inc. is seeking a Senior Data Engineer in Edina, MN to lead the design, development, and optimization of scalable data solutions that power our reporting across direct admitted business. You will mentor junior engineers and drive best practices with cross-functional partners.

You will architect ELT/ETL pipelines, model complex data structures, and ensure data quality, governance, and security. Collaboration with actuarial and compliance teams is required.

Qualifications

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

Responsibilities

• Lead Data Pipeline Development: Architect, build, and optimize complex ELT/ETL pipelines to ingest, transform, and deliver data from diverse sources at scale.
• Data Architecture & Modeling: Design and implement advanced data models and architectures to support analytics, reporting, and operational needs.
• Statistical Reporting: Partner with Actuarial and Compliance SMEs to build and validate source mappings + transformation logic; design system to generate filing-ready outputs for statistical agents.
• Performance & Reliability: Proactively monitor, troubleshoot, and enhance data systems for performance, scalability, and reliability.
• Data Quality & Governance: Champion data quality, integrity, and governance by implementing robust validation, monitoring, and compliance processes.
• Collaboration & Leadership: Partner with business stakeholders, BI engineers, and database engineers to translate business requirements into technical solutions. Mentor and guide junior team members.
• Documentation & Standards: Establish and maintain comprehensive documentation and promote engineering best practices across the team.
• Innovation: Evaluate and introduce new technologies, tools, and methodologies to improve data engineering capabilities.

Skills

SQL

Python

Data modeling

Data architecture

Cloud platforms

Data warehousing

Insurance experience

Statistical reporting

Tools

Airflow

dbt

Cloud Composer

Job description

Palomar Holdings, Inc. is seeking a Senior Data Engineer in Edina, MN to lead the design, development, and optimization of scalable data solutions that power our reporting across direct admitted business. You will mentor junior engineers and drive best practices with cross-functional partners.

You will architect ELT/ETL pipelines, model complex data structures, and ensure data quality, governance, and security. Collaboration with actuarial and compliance teams is required.