Lead Data Architect

Motion Recruitment; Boston (MA); Ibrido; USD 150.000 - 190.000; Tempo pieno

Vantaggi offerti da questo lavoro

Health insurance

Dental insurance

Vision coverage

Hybrid work model

Office near South Station

401K

Descrizione del lavoro

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.

Competenze

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

Mansioni

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

Conoscenze

Data architecture

Data engineering

Technical leadership

SQL

Python

ETL/ELT pipelines

Data quality

Governance

Mentoring engineers

Communication to leadership

Formazione

Bachelor's degree in Computer Science or related field

Strumenti

Snowflake

dbt

Airflow

Azure Data Factory

Power BI

Descrizione del lavoro

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.

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

Posted By: Matthew Power