Remote Lead Data Architect - Snowflake, SQL & Python

Motion Recruitment; Boston (MA); Hybrid; USD 144,000 - 176,000; Full time

Benefits offered by this job

Medical Insurance

Dental Benefits

Vision Benefits

Paid Time Off

401(k)

Job summary

Motion Recruitment seeks a Lead Data Architect to design and evolve a modern enterprise data platform. You will drive scalable, cloud-native data solutions, set architecture standards, and mentor engineers across analytics teams.

The role partners with engineering, analytics, and business stakeholders to deliver trusted data for reporting, operational intelligence, and advanced analytics. Remote or hybrid options in the US.

Qualifications

• 5+ years of experience specifically in a Data Architect role.
• 8+ years of overall experience in data architecture, data engineering, or related disciplines.
• Expert-level data modeling experience (conceptual, logical, physical).
• Hands-on Snowflake architecture and optimization experience.
• Strong SQL development skills in large-scale environments.
• Python development for data engineering and automation.
• Experience designing enterprise data platforms and cloud-native solutions.
• ELT/ETL pipeline development experience.
• Experience implementing data quality, metadata, and lineage frameworks.
• Understanding of modern data architectures, CDC, event-driven ingestion, and orchestration patterns.

Responsibilities

• Lead enterprise-wide data architecture strategy and roadmap development.
• Design scalable data models supporting reporting, analytics, and operational use cases.
• Build and optimize Snowflake-based data platforms and solutions.
• Architect and oversee cloud-native ELT/ETL pipelines.
• Establish data standards, governance processes, and architecture best practices.
• Design medallion architecture frameworks and data modernization initiatives.
• Drive performance, reliability, scalability, and cost optimization.
• Collaborate with stakeholders to translate requirements into data solutions.
• Provide architectural oversight across major data initiatives.
• Mentor data engineers, analytics engineers, and developers.
• Explain architectural principles and design decisions clearly.
• Review designs and guide on complex data challenges.
• Evaluate emerging technologies and lead PoC initiatives.

Skills

Data modeling

SQL development

Python for data engineering

Cloud ELT/ETL

Stakeholder communication

Leadership

US work authorization

Tools

Snowflake

Databricks

dbt

Airflow

Azure Data Factory

Power BI

Job description

Motion Recruitment seeks a Lead Data Architect to design and evolve a modern enterprise data platform. You will drive scalable, cloud-native data solutions, set architecture standards, and mentor engineers across analytics teams.

The role partners with engineering, analytics, and business stakeholders to deliver trusted data for reporting, operational intelligence, and advanced analytics. Remote or hybrid options in the US.