Data Engineer

Palomar; Edina (MN); On-site; USD 105,000 - 145,000; Full time

Benefits offered by this job

Medical Benefits

Stock options

401k

PTO and holidays

Lifestyle allowance

Professional development

Career exploration

Social events

Job summary

Palomar is seeking a Data Engineer to design, build, and maintain scalable data assets and pipelines in a fast-growing insurance tech environment. You will collaborate with Quality Engineering and BI teams to support Palomar's data strategy and ensure data quality across enterprise datasets.

Join a team that values agility, innovation, and authenticity, delivering robust data solutions while growing your expertise across cloud data platforms and modern warehousing technologies.

Qualifications

• 4+ years of experience in data engineering or a related role; insurance experience strongly preferred.
• Knowledge of data governance and compliance standards.
• Proficiency in SQL and experience with relational databases (e.g., MySQL, PostgreSQL).
• Familiarity with cloud platforms (e.g., AWS, Azure, Google Cloud).
• Experience with data warehousing solutions (e.g., Snowflake, Redshift, BigQuery).
• Understanding of data modeling and data architecture.
• Excellent problem-solving and analytical skills.
• Strong communication and collaboration skills.
• Ability to work independently and as part of a collaborative team.

Responsibilities

• Design and build data pipelines.
• Develop and maintain ELT processes to ingest data from various sources.
• Partner with Data Operations team to monitor pipelines and systems for issues, perform root cause analysis, and implement solutions.
• Data Solutioning: collaborate with SMEs and solutions architects to create scalable data assets and tooling.
• Database Management: design, implement, and manage relational databases; optimize performance and storage.
• Data Integration & Normalization: integrate data from internal and external sources; ensure data cleanliness and integrity.
• Data Quality & Governance: enforce data quality checks and governance policies with QA team.
• Collaboration: work with Quality Engineering, BI, and SMEs to understand data requirements and implement solutions.
• Documentation: maintain comprehensive documentation of data workflows, processes, and systems.

Skills

SQL proficiency

Relational databases

Data pipelines

Cloud platforms

Data warehousing

Data governance & compliance

Problem solving

Collaboration

Tools

MySQL

PostgreSQL

Snowflake

Redshift

BigQuery

ETL tools

Airflow

Job description

Why choose Palomar?

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.

Want to learn more about our exciting journey? https://ir.plmr.com/corporate-profile/default.aspx

We are Hiring!

Location:

La Jolla, CA; Edina, MN

The Details

As a Data Engineer at Palomar, you will play a critical role in designing, building, and maintaining our data solutions. You will be responsible for building scalable data assets and tooling based on larger data strategy and business needs. You will also work closely with our Quality Engineering team and Business Intelligence team on a regular basis to support the larger Palomar Data strategy.

What Will You Do

• Design and Build Data Pipelines:
  • Develop and maintain ELT (Extract, Load, Transform) processes to ingest data from various sources.
  • Partner with Data Operations team to monitor pipelines and systems for issues, perform root cause analysis, and implement solutions.
• Data Solutioning
  • Partner with subject matter experts and solutions architects to create scalable data assets and tooling
• Database Management:
  • Design, implement, and manage relational database.
  • Partner with our Data Operations team to troubleshoot and optimize database performance and storage.
• Data Integration & Normalization:
  • Integrate data from internal and external sources.
  • Ensure data cleanliness, consistency, and integrity within our data solutions.
• Data Quality and Governance:
  • Partner with Quality Engineering team to implement data quality checks and validation processes.
  • Enforce data governance policies to ensure compliance and data security.
• Collaboration:
  • Work closely with Quality Engineering team, Business Intelligence team, and subject matter experts to understand data requirements in order to recommend and implement ideal solutions.
• Documentation:
  • Maintain comprehensive documentation of data workflows, processes, and systems.
    

What We Are Looking For

• 4+ years of experience in data engineering or a related role; insurance experience strongly preferred.
• Knowledge of data governance and compliance standards.
• Proficiency in SQL and experience with relational databases (e.g., MySQL, PostgreSQL).
• Familiarity with cloud platforms (e.g., AWS, Azure, Google Cloud).
• Experience with data warehousing solutions (e.g., Snowflake, Redshift, BigQuery).
• Understanding of data modeling and data architecture.
• Excellent problem-solving and analytical skills.
• Strong communication and collaboration skills.
• Ability to work independently and as part of a collaborative team.

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
• Long Term Financial Incentives – STOCK!
• 401k with 3.5% Automatic Fully Vested Employer Contributions
• Competitive PTO + Holiday Program
• Lifestyle Spending Allowance
• Professional Development Assistance
• Career Exploration Opportunities
• Regular company-wide social events (even virtually!)
• To learn more visit us at www.plmr.com

Diversity at Palomar

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

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

CCPA Job Applicant

Pay Range: $105,000 - $145,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.