Sr. Data Engineer

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 a rapidly growing and innovative insurer focused on providing specialty insurance to residential and commercial customers.Palomar welcomes the best and brightest to our thriving team. Guided by an entrepreneurial spirit, Palomar is building a dynamic and diverse team.

Join a company built on a culture of agility, innovation and authenticity that delivers peace of mind and protection to individuals and businesses impacted by adversity.

As a Senior Data Engineer at Palomar, you will lead the design, development, and optimization of robust, scalable data solutions that power our business. You will mentor junior engineers, drive best practices, and collaborate with cross-functional teams to deliver high-quality, production-ready data assets and pipelines. Your expertise will help shape our data architecture and ensure the reliability, security, and performance of our data ecosystem. For this role specifically, that work is centered on building and maintaining the data infrastructure for statistical reporting across all direct admitted business, in partnership with Actuarial and Compliance.

What will you do:

• 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.

What we are looking for:

• 6+ years of experience in data engineering or a related field, with a proven track record of delivering large-scale data solutions.
• 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.

We love people who want to:

• Build strong relationships through transparency, trust, and respect for each other.
• Work in an agile environment, with a resilient mindset to find creative solutions to challenges.
• Collaborate and celebrate diverse perspectives, promoting inclusivity and equality.
• Do the right thing with strong conviction and integrity.
• Be bold and innovative to help make an impact.
• Demonstrable track record of working autonomously and driving progress
• Be intellectually curious, think creatively, and pragmatic

If you thrive in a dynamic environment, and like working with happy, authentic, talented people, you'll enjoy a career with Palomar!

What will you get in return?

• Full Suite of Medical Benefits
• 401k with 3.5% Automatic Fully Vested Employer Contributions
• Competitive PTO + Holiday Program
• Professional Development Assistance
• Regular company-wide social events (even virtually!)

At Palomar, we are committed to diversity, equality and inclusion in all facets of the organization. We have built an open culture that celebrates the diversity of our workforce, while actively championing equality and inclusion practices that make us a company people want to work with and work for.

We believe that diversity, equality and inclusion yields greater organizational creativity and productivity, which helps us serve our customers and partners more effectively. Delivering on our diversity commitment returns greater value to our shareholders and ultimately makes a positive impact to the communities in which we do business and to the people who live in them

#PalomarPride #Insurancejobs #hiring

Accommodations:

Palomar will consider reasonable accommodations to ensure a qualified applicant with a disability can be considered for the position. Palomar will also consider necessary modifications to the physical work environment, or to the way a job is usually performed, so an individual with a disability can perform the essential functions of the position. Additional accommodations will be considered that enable an employee with a disability to enjoy equal benefits and privileges of employment like those that are enjoyed by other employees without disabilities.

For more information about our company, visit us at www.plmr.com. Palomar is an Equal Opportunity Employer.

No phone calls or agency solicitation please

Pay Range: $125,000 - $165,000 + Bonus Potential & Participation in our Competitive Long-Term Incentive (LTI) Program.

The above pay range is for all US-based roles based on function and level, benchmarked against companies of similar size and scope. To be compliant with local legislation as well as provide greater transparency to candidates, we disclose salary ranges on all job postings regardless of the desired job location. We also offer a competitive annual discretionary bonus program and the opportunity for annual long-term incentive stock grants. In addition, we offer a highly competitive benefits package. Final offer amounts are determined by multiple factors, including candidate experience and qualifications, and may vary from the amounts listed above.