Data Engineer

Palomar is a rapidly growing and innovative insurer focused on providing specialty insurance to residential and commercial customers. The Data Engineer will design, build, and maintain scalable data solutions, pipelines, databases, and tooling while supporting data quality, governance, integration, and collaboration across technical and business teams.

Responsibilities

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

Preferred

insurance experience strongly preferred

Insurance Experience

Benefits

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!)

Bonus Potential

Participation in our Competitive Long-Term Incentive (LTI) Program

Annual discretionary bonus program

Opportunity for annual long-term incentive stock grants

Company

Specialty insurer for residential and commercial catastrophe insurance

La Jolla, California, USA

https://plmr.com/

Founded in 2014

501-1000 employees

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

Insurance experience strongly preferred

4+ years of experience in data engineering or a related role; insurance experience strongly preferred.

Required skills

Data Engineering, SQL, Relational Databases, Cloud Platforms, Data Warehousing, Data Modeling, Data Architecture, Data Governance

Preferred skills

insurance experience strongly preferred

Experience

4+ years