Lead Data Architect - Hybrid Snowflake & Data Platform

Motion Recruitment; Boston (MA); Hybrid; USD 150,000 - 190,000; Full time

Benefits offered by this job

Health insurance

Dental insurance

Vision coverage

Hybrid work model

Office near South Station

401K

Job summary

Motion Recruitment is seeking a Lead Data Architect to design a modern, cloud-based data platform centered on Snowflake. You will shape data strategy, mentor a data engineering team, and collaborate with business leaders to deliver accessible, accurate analytics.

You will lead the design and evolution of enterprise data architecture, build scalable data pipelines, optimize Snowflake performance, and establish standards for data modeling, quality, and governance in a hybrid Boston environment.

Qualifications

• 5–10 years of experience in data architecture and data engineering, including leadership.
• Strong expertise in data modeling and enterprise data architecture.
• Hands-on Snowflake experience or similar cloud data warehouse.
• Advanced SQL and Python skills.
• Experience building and optimizing ETL/ELT pipelines.
• Knowledge of data quality, metadata lineage and governance.
• Mentoring engineers and communicating designs to senior leadership.
• Bachelor's degree in CS or related field.

Responsibilities

• Lead the design and evolution of enterprise data architecture.
• Build scalable, automated data pipelines and modernize legacy processes.
• Establish standards for data modeling, quality, security, and governance.
• Optimize Snowflake performance, cost, and reliability.
• Design bronze, silver, and gold data layers for data ingestion and analytics.
• Mentor engineers, review technical designs and code, and guide engineering best practices.
• Partner with business, analytics, actuarial, and technology teams to deliver data solutions.

Skills

Data architecture

Data engineering

Technical leadership

SQL

Python

ETL/ELT pipelines

Data quality

Governance

Mentoring engineers

Communication to leadership

Education

Bachelor's degree in Computer Science or related field

Tools

Snowflake

dbt

Airflow

Azure Data Factory

Power BI

Job description

Motion Recruitment is seeking a Lead Data Architect to design a modern, cloud-based data platform centered on Snowflake. You will shape data strategy, mentor a data engineering team, and collaborate with business leaders to deliver accessible, accurate analytics.

You will lead the design and evolution of enterprise data architecture, build scalable data pipelines, optimize Snowflake performance, and establish standards for data modeling, quality, and governance in a hybrid Boston environment.