Senior Cloud Data Architect: Snowflake & Pipelines Lead

Motion Recruitment; Massachusetts; Remote; USD 140,000 - 210,000; Full time

Job summary

Coverys is seeking a Lead Data Architect to design and evolve our enterprise data platform and data integration pipelines. You will define architectural blueprints, establish data modeling standards, and lead the development of scalable Snowflake-based pipelines for analytics, reporting, and operations.

You will mentor the data engineering team, collaborate with business and tech stakeholders, and ensure data is accurate, trusted, and available for underwriting, claims, actuarial, and finance

Qualifications

• Bachelor's degree in CS or a related field.
• 5-10 years of experience in data architecture and data engineering with leadership experience.
• Advanced ELT/ETL development experience (cloud-native).
• Deep experience with cloud data warehouses, ideally Snowflake.
• Proficiency in Python for data engineering and automation.
• Strong SQL skills for large-scale data processing.
• Experience with data quality frameworks, metadata management, and lineage.
• Understanding of modern data patterns (CDC, event-driven ingestion, APIs, streaming).
• Experience in the insurance industry, preferred.
• Snowflake certification is a plus.
• Familiarity with dbt, Airflow, Azure Data Factory, or similar.
• Knowledge of MDM, canonical modeling, and governance frameworks.
• Experience with Power BI or other BI tools.
• Mentoring data engineering teams.
• Ability to communicate designs to senior leadership.

Responsibilities

• Lead the design and maintenance of enterprise data architecture aligned to business domains (Policy, Party, Claims, Billing, Underwriting).
• Ensure data architecture aligns with enterprise architecture standards.
• Develop canonical and semantic data models to support analytics, reporting, and operations.
• Define standards for data modeling, data quality, metadata, lineage, and documentation.
• Partner with stakeholders to translate requirements into scalable data structures and provide technical recommendations.

Skills

Data architecture

Data modeling

Data engineering

Leadership

Mentoring

Python

SQL

Cloud computing

Communication

Power BI

Governance

Analytical thinking

Education

Bachelor's degree in Computer Science or related field

Tools

Snowflake

dbt

Airflow

Azure Data Factory

BI Tools

ETL frameworks

Job description

Coverys is seeking a Lead Data Architect to design and evolve our enterprise data platform and data integration pipelines. You will define architectural blueprints, establish data modeling standards, and lead the development of scalable Snowflake-based pipelines for analytics, reporting, and operations.

You will mentor the data engineering team, collaborate with business and tech stakeholders, and ensure data is accurate, trusted, and available for underwriting, claims, actuarial, and finance