Data Engineer

Palomar•La Jolla, CA

11d•Onsite

About The Position

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.

Requirements

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.

Nice To Haves

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.

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.