Lead Data Architect

Motion Recruitment; United States; Hybrid; USD 140,000 - 190,000; Full time

Benefits offered by this job

Health, Dental, Vision

401K

Hybrid

Office near South Station

Job summary

Motion Recruitment is seeking a Lead Data Architect to lead the design and development of a modern, cloud-based data platform focusing on Snowflake, data architecture, and data engineering. You’ll shape data strategy while staying hands-on.

This role offers mentoring, modernization of legacy systems, and collaboration with business and technology leaders to make data accessible, accurate, and valuable.

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 or similar cloud data warehouses.
• Advanced SQL skills and proficiency in Python.
• Experience developing and optimizing ETL/ELT pipelines.
• Knowledge of data quality, metadata management, lineage, and governance.
• Experience mentoring engineers and communicating designs to senior leadership.
• Bachelor’s degree in Computer Science or related field.
• Must be authorized to work in the U.S. without sponsorship or restrictions.

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 modeling

Snowflake

SQL

Python

ETL/ELT pipelines

Data governance

Mentoring engineers

US work authorization

Education

Bachelor’s degree in Computer Science or related field

Tools

dbt

Airflow

Azure Data Factory

Job description

We’re looking for a Lead Data Architect to lead the design and development of a modern, cloud-based data platform. This role focuses on Snowflake, data architecture, and data engineering, helping build reliable, scalable data solutions that support business operations, reporting, and advanced analytics.

This is a great opportunity for a hands-on technical leader who enjoys shaping data strategy while staying involved in engineering. You’ll have the chance to modernize legacy systems, establish best practices, mentor a data engineering team, and work closely with business and technology leaders to make data more accessible, accurate, and useful.

Required Skills & Experience

• 5-10 years of experience in data architecture and data engineering, including technical leadership.
• Strong expertise in data modeling and enterprise data architecture.
• Hands-on experience with Snowflake or similar cloud data warehouses.
• Advanced SQL skills and proficiency in Python.
• Experience developing and optimizing ETL/ELT pipelines.
• Knowledge of data quality, metadata management, lineage, and governance.
• Experience mentoring engineers and communicating technical designs to senior leadership.
• Bachelor’s degree in Computer Science or a related field.
• Must be authorized to work in the U.S. without sponsorship or restrictions.

Desired Skills & Experience

• Experience in the insurance industry.
• Snowflake certification.
• Familiarity with dbt, Airflow, Azure Data Factory, or similar tools.
• Knowledge of change data capture (CDC), event-driven architecture, APIs, and data orchestration.
• Experience with master data management (MDM), canonical data modeling, and Power BI or other BI tools.

What You Will Be Doing

Tech Breakdown

• Snowflake and cloud data architecture
• SQL and Python
• ETL/ELT pipelines and data integration
• Data modeling, governance, and quality frameworks

Daily 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.

The Offer

• Competitive pay
• Health, Dental, Vision
• 401K
• Hybrid
• Office located near South Station