Hiring: Senior Data Architect with P&C insurance | Boston, MA (Hybrid)

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

Role: Senior Data Architect with P&C insurance

Location: Boston, MA (Hybrid)

• Bachelor's degree in computer science or relevant field from an accredited college or university, required.
• 3-5- years of experience in data architecture, data engineering, required.
• Strong data modeling expertise (conceptual, logical, physical).
• Hands-on experience designing enterprise data architectures.
• Advanced ELT/ETL development experience (preferably cloud-native).
• Deep experience with cloud data warehouses, ideally Snowflake.
• Proficiency in Python for data engineering and automation.
• Strong SQL skills and experience with large-scale data processing.
• Experience with data quality frameworks, metadata management, and lineage.
• Understanding of modern data patterns (CDC, event-driven ingestion, APIs, streaming, orchestration).
• Experience in the insurance industry, preferred.
• Snowflake certification, a plus.
• Familiarity with tools such as DBT, Airflow, Azure Data Factory, or similar.
• Knowledge of MDM, canonical modeling, and governance frameworks.
• Experience with Power BI or other BI tools.