Senior Data Architect (Hybrid, Boston) - Snowflake & ELT Expert

Key2Source; Boston (MA); Hybrid; USD 120,000 - 180,000; Full time

Job summary

Key2Source in Boston, MA, seeks a Senior Data Architect with P&C insurance experience to design enterprise data architectures in a hybrid work setting. You will lead data modeling efforts and guide cloud ELT/ETL initiatives across Snowflake-based data platforms.

The role requires hands-on data architecture, strong Python and SQL skills, and familiarity with modern data patterns, metadata, and governance to support quality and lineage across the data estate.

Qualifications

• Bachelor's degree in computer science or relevant field required
• 3-5 years of experience in data architecture and data engineering
• Strong data modeling expertise (conceptual, logical, physical)
• Hands-on experience designing enterprise data architectures and cloud ELT/ETL

Skills

Data modeling

ELT/ETL development

Python for data engineering

SQL for big data

Data governance & quality

CDC / event-driven ingestion

APIs & streaming patterns

Education

Bachelor's degree in CS or related field

Tools

Snowflake

DBT

Airflow

Azure Data Factory

Power BI

Job description

Key2Source in Boston, MA, seeks a Senior Data Architect with P&C insurance experience to design enterprise data architectures in a hybrid work setting. You will lead data modeling efforts and guide cloud ELT/ETL initiatives across Snowflake-based data platforms.

The role requires hands-on data architecture, strong Python and SQL skills, and familiarity with modern data patterns, metadata, and governance to support quality and lineage across the data estate.