Senior Data Architect — Cloud Data Platform (Snowflake)

Coverys; Boston (MA); On-site; USD 96,650 - 130,755; Full time

Job summary

Coverys is seeking a Data Architect to design and evolve an enterprise data platform and data integration pipeline. This role drives the transformation toward a modern, governed, cloud-based data ecosystem that supports underwriting, claims, actuarial, finance, and enterprise analytics.

The Data Architect will define architectural blueprints, establish data modeling standards, and guide scalable, automated data pipelines in Snowflake, collaborating with business and technology teams to ensure

Qualifications

• Bachelor’s degree in computer science or a related field.
• 3-5 years of experience in data architecture or data engineering.
• Strong data modeling and hands-on enterprise data architecture experience.
• Advanced ELT/ETL development experience, preferably cloud-native.
• Deep experience with cloud data warehouses, ideally Snowflake.
• Proficiency in Python and SQL for data engineering and automation.
• Knowledge of data quality frameworks, metadata management, and lineage.
• Understanding of modern data patterns (CDC, event-driven ingestion, APIs, streaming).
• Insurance industry experience is a plus; 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.
• Eligible to work in the US without sponsorship or restriction.

Responsibilities

• Design and maintain enterprise data architecture aligned to business domains.
• Ensure architecture aligns with enterprise standards and collaborate with Enterprise Architecture.
• Develop canonical and semantic data models to support analytics and reporting.
• Define data modeling, quality, metadata, and lineage standards.
• Translate requirements into scalable data structures with stakeholders.
• Build ELT/ETL pipelines using modern cloud-native tools.
• Migrate legacy batch processes to automated, event-driven ingestion.
• Implement data quality rules and reconciliation logic.
• Optimize Snowflake workloads for performance and cost.
• Design and oversee medallion-style data layers (bronze/silver/gold).
• Establish data dictionaries, lineage, and stewardship models with Data Governance.
• Promote data-as-a-product and reusable data assets.
• Partner with analysts, data scientists, actuaries, and analytics teams.
• Mentor data engineers and analytics engineers transitioning to modern roles.
• Provide architectural oversight for major data initiatives.

Skills

Data architecture

Data modeling

ELT/ETL development

Python for data engineering

SQL

Data governance

Data quality

Metadata management

Data lineage

CDC & event-driven ingestion

APIs & streaming

Orchestration

MDM & governance frameworks

Power BI

Insurance industry knowledge

Education

Bachelor’s degree in computer science or relevant field

Tools

Snowflake

dbt

Airflow

Azure Data Factory

Power BI

Job description

Coverys is seeking a Data Architect to design and evolve an enterprise data platform and data integration pipeline. This role drives the transformation toward a modern, governed, cloud-based data ecosystem that supports underwriting, claims, actuarial, finance, and enterprise analytics.

The Data Architect will define architectural blueprints, establish data modeling standards, and guide scalable, automated data pipelines in Snowflake, collaborating with business and technology teams to ensure