Senior Data Engineer: Data Vault & Snowflake Pipelines

Pie Insurance; Northern (KY); Hybrid; USD 140,000 - 175,000; Full time

Benefits offered by this job

Competitive cash compensation

Generous PTO

Future 401k match

Generous parental leave

Job summary

Pie Insurance is seeking a hands-on data engineer to build production Python and SQL data pipelines, develop Airflow DAGs, and contribute to a Data Vault 2.0 data warehouse. You will power data used in pricing, underwriting, and services for small business customers, ensuring accuracy and reliability.

You’ll own data quality, testing, and observability, collaborating with Executive, Product, and Engineering teams to translate business needs into scalable technical solutions.

Qualifications

• 5+ years experience as a software or data engineer focused on data systems.
• Advanced proficiency writing complex SQL and manipulating large structured and semi-structured datasets.
• Proficiency in Python for building production-grade data pipelines.
• Hands-on Snowflake administration experience, including RBAC and cost governance.
• Demonstrable experience designing and implementing modern data warehouses, with an understanding of best practices.
• Experience modeling data in cloud data warehouses such as Snowflake, Redshift, or BigQuery. Data Vault 2.0 experience strongly preferred.
• Demonstrated experience using testing frameworks to validate data and code in a production environment.
• Hands-on experience with data observability tooling.
• Proficiency using AI coding assistants as part of development workflow.
• Track record of leading technical projects end-to-end without a Product Manager.
• Comfort working in a regulated environment (SOX-relevant financial reporting).
• Willingness to develop deep domain expertise in insurance and Pie business.

Responsibilities

• Develop complex and efficient data pipelines to transform raw data sources into reliable, well-tested components of our data models.
• Design, build, and maintain data pipelines that deliver accurate, trusted data with the freshness our stakeholders depend on.
• Make data modeling decisions within our Data Vault 2.0 warehouse that balance raw fidelity with downstream consumption.
• Administer and optimize Snowflake across sizing, query performance, access controls, RBAC and cost tuning.
• Build and maintain resilient Airflow DAGs and CI/CD pipelines for predictable deployments.
• Implement automated testing (unit, integration, and data quality) so issues are caught in CI before production.
• Own production observability, respond to incidents, and feed learnings back into pre-load validation and CI checks.
• Leverage AI-powered tools to accelerate code generation, documentation, and code quality.

Skills

SQL

Python

Snowflake

Data Vault 2.0

Data modeling

Data observability

Testing frameworks

AI coding tools

Leadership

SOX compliance

Tools

Airflow

CI/CD pipelines

Snowflake administration

Job description

Pie Insurance is seeking a hands-on data engineer to build production Python and SQL data pipelines, develop Airflow DAGs, and contribute to a Data Vault 2.0 data warehouse. You will power data used in pricing, underwriting, and services for small business customers, ensuring accuracy and reliability.

You’ll own data quality, testing, and observability, collaborating with Executive, Product, and Engineering teams to translate business needs into scalable technical solutions.