Lead Data Architect - Remote EST (Insurance Experience Required)

Tech in Motion; Boston (MA); Remote; USD 140,000 - 200,000; Full time

Benefits offered by this job

Medical Insurance

Dental Benefits

Vision Benefits

Paid Time Off (PTO)

401(k)

Job summary

Motion Recruitment seeks a Lead Data Architect to drive strategy and evolution of a modern enterprise data platform for a leading insurance organization. You will define standards, build scalable data solutions, and lead data engineering teams in a cloud-native, governed environment.

Ideal candidates bring 5–10+ years in data architecture, deep Snowflake expertise, strong SQL and Python skills, and insurance industry experience.

Qualifications

• 5-10+ years in data architecture and data engineering
• Experience leading enterprise-scale data architecture initiatives
• Strong data modeling (conceptual/logical/physical)
• Hands-on with Snowflake and cloud data platforms
• Advanced SQL development
• Strong Python for data engineering and automation
• Experience building cloud-native ELT/ETL solutions
• Experience with CDC, event-driven architectures, APIs, ingestion patterns
• Data quality, metadata, lineage, governance frameworks
• Mentoring data engineers and leading technical teams
• Strong communication for senior leadership
• Insurance industry experience is required
• Bachelor's degree in CS or related field
• US work authorization without sponsorship

Responsibilities

• Define and maintain enterprise data architecture standards
• Design scalable data models for multiple domains
• Develop modern ELT/ETL pipelines and cloud-native solutions
• Migrate legacy data to automated, event-driven architectures
• Establish data quality, governance, lineage, and metadata standards
• Optimize Snowflake performance, reliability, and cost
• Oversee medallion architecture (bronze/silver/gold)
• Translate requirements into scalable technical solutions
• Evaluate new technologies and lead POCs
• Provide architectural oversight across data programs
• Mentor data engineering teams and enforce standards
• Support analytics, reporting, and operational decision-making

Skills

Data architecture

Snowflake

SQL

Python

ETL/ELT

Event-driven architecture

Data governance

Cloud platforms

Leadership

Communication

Insurance industry experience

Education

Bachelors in CS or related field

Tools

dbt

Airflow

Azure Data Factory

Job description

A leading insurance organization is seeking a Lead Data Architect to drive the strategy, design, and evolution of a modern enterprise data platform. This individual will play a critical role in defining data architecture standards, building scalable data solutions, and leading the transformation of complex data environments into a governed, cloud-based ecosystem.

The ideal candidate will combine deep hands-on technical expertise with architectural leadership, working closely with business and technology stakeholders across underwriting, claims, policy administration, billing, actuarial, finance, and analytics functions. This is a highly visible role responsible for establishing enterprise-wide data standards and delivering scalable data solutions that support operational and strategic decision-making.

Required Skills & Experience

• 5-10+ years of experience in data architecture and data engineering
• Proven experience leading enterprise-scale data architecture initiatives
• Strong expertise in conceptual, logical, and physical data modeling
• Deep hands-on experience with Snowflake and cloud data platforms
• Advanced SQL development skills
• Strong Python experience for data engineering and automation
• Experience designing and developing cloud-native ELT/ETL solutions
• Expertise with CDC, event-driven architectures, APIs, and modern data ingestion patterns
• Experience with data quality, metadata management, lineage, and governance frameworks
• Experience leading technical teams and mentoring data engineers
• Strong communication skills with the ability to present architectural decisions to senior leadership
• Insurance industry experience is required
• Bachelor's degree in Computer Science or a related field
• Must be authorized to work in the United States without sponsorship

Desired Skills & Experience

• Snowflake certification
• Experience with dbt, Airflow, Azure Data Factory, or similar technologies
• Knowledge of Master Data Management (MDM)
• Experience building canonical and semantic data models
• Familiarity with Power BI or other enterprise BI platforms

What You Will Be DoingDaily Responsibilities

• Define and maintain enterprise data architecture standards and best practices
• Design scalable data models supporting policy, claims, underwriting, billing, and actuarial domains
• Lead the development of modern ELT/ETL pipelines and cloud-native data solutions
• Drive the migration of legacy data environments to automated and event-driven architectures
• Establish data quality, governance, lineage, and metadata standards
• Optimize Snowflake performance, reliability, and cost efficiency
• Design and oversee medallion architecture frameworks including bronze, silver, and gold layers
• Partner with business stakeholders to translate requirements into scalable technical solutions
• Evaluate emerging technologies and lead proof-of-concept initiatives
• Provide architectural oversight across enterprise data programs
• Mentor and guide data engineering teams, ensuring adherence to engineering standards and best practices
• Support enterprise analytics, reporting, and operational decision-making through trusted data assets

The Offer

• Competitive salary and bonus opportunity
• Opportunity to shape and lead a next-generation enterprise data platform
• High-visibility leadership role with significant technical influence
• Collaborative environment focused on innovation and modernization

You will receive the following benefits

• Medical Insurance
• Dental Benefits
• Vision Benefits
• Paid Time Off (PTO)
• 401(k)

Applicants must be currently authorized to work in the US on a full-time basis now and in the future.