Senior Data Engineer: Pipelines & Architecture

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

Benefits offered by this job

Medical benefits

401k with employer contributions 3.5%

PTO + Holidays

Professional development

Job summary

Palomar is seeking a Senior Data Engineer to design, develop and optimize robust data solutions that power our business. You will mentor junior engineers, drive best practices, and collaborate with cross-functional teams to deliver production-ready data assets and pipelines.

You will specialize in building and maintaining data infrastructure for statistical reporting, partnering with Actuarial and Compliance, and ensuring reliability, security and scalability across the data ecosystem.

Qualifications

• 6+ years of experience delivering large-scale data solutions.
• Advanced proficiency in SQL and Python; strong warehousing experience (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.

Responsibilities

• Lead development of ELT/ETL pipelines at scale.
• Design data models and architectures to support analytics and reporting.
• Partner with actuarial/compliance for statistical reporting workflows.
• Monitor and improve performance, reliability and data quality.
• Mentor junior engineers and promote best practices.

Skills

SQL

Python

Data modelling

Data architecture

Cloud platforms

ETL/ELT pipelines

Mentoring

Analytical thinking

Tools

Snowflake

Redshift

BigQuery

AWS

Azure

GCP

Airflow

dbt

Cloud Composer

Job description

Palomar is seeking a Senior Data Engineer to design, develop and optimize robust data solutions that power our business. You will mentor junior engineers, drive best practices, and collaborate with cross-functional teams to deliver production-ready data assets and pipelines.

You will specialize in building and maintaining data infrastructure for statistical reporting, partnering with Actuarial and Compliance, and ensuring reliability, security and scalability across the data ecosystem.