Senior Data Engineer — Lakehouse Pipelines (Remote)

Kin Insurance, Inc.; Northern (KY); Hybrid; USD 120,000 - 180,000; Full time

Benefits offered by this job

Salary + equity

401(k) match

Medical/dental/vision

HSA contributions

Life insurance

Flexible PTO

Parental leave

Professional development

Job summary

Kin Insurance is seeking a Senior Data Engineer to turn raw data into trusted, analytics-ready datasets powering reporting across the company. You’ll design scalable pipelines and models, working with App Engineering and Analytics Eng to understand source systems and deliver trusted data.

This remote-first role offers growth and a strong benefits program. You’ll mentor teammates, apply data security best practices, and leverage AI tools to improve efficiency as Kin grows its data-driven

Qualifications

• 4+ years in data engineering, analytics engineering, or dimensional modeling roles, building production data models.
• Advanced SQL skills, with experience transforming data from multiple sources into a scalable warehouse or lakehouse.
• Proficiency in Python (Pandas, NumPy) for data transformation and pipeline development.
• Expertise in dimensional modeling, ELT workflows, and modern data architecture patterns.
• Proven ability to model raw, complex data into well-structured, analytics-ready datasets.
• Experience with Databricks, Snowflake, or Redshift.
• Ability to translate ambiguous business requirements into scalable datasets.
• Excellent written and verbal communication skills, with the ability to explain complex concepts to non-technical stakeholders.

Responsibilities

• Design and build scalable, production-grade data pipelines and data models to power downstream analytics and enterprise reporting.
• Implement and enforce data validation, testing, and QA standards across data models to ensure accuracy and reliability.
• Partner with App Engineering to understand source systems and define how raw data should be captured and modeled downstream.
• Collaborate with Analytics Engineering, BI, and business stakeholders to translate ambiguous reporting needs into scalable, well-modeled datasets.
• Ensure data models comply with data security and privacy regulations (e.g., GDPR, CCPA, GLBA) through access controls and monitoring.
• Mentor other data engineers on modeling best practices, documentation, and data processing patterns.
• Leverage AI-assisted development tools where appropriate to improve engineering efficiency, code quality, and observability.

Skills

Advanced SQL

Python

Dimensional modeling

ELT workflows

Databricks

Snowflake

Redshift

Data modeling

Communication

Tools

Databricks

Snowflake

Redshift

Airflow

Job description

Kin Insurance is seeking a Senior Data Engineer to turn raw data into trusted, analytics-ready datasets powering reporting across the company. You’ll design scalable pipelines and models, working with App Engineering and Analytics Eng to understand source systems and deliver trusted data.

This remote-first role offers growth and a strong benefits program. You’ll mentor teammates, apply data security best practices, and leverage AI tools to improve efficiency as Kin grows its data-driven