Lead Data Architect

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

Posted By: Matthew Power