Data Architect

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

Position Summary

The Data Architect will help design, build, and evolve our next‑generation enterprise data platform & data integration pipeline. This role is central to our transformation toward a modern, governed, cloud‑based data ecosystem that supports all functions at Coverys (notably underwriting, claims, actuarial, finance, and enterprise analytics etc.)

Position Summary

The Data Architect will help design, build, and evolve our next‑generation enterprise data platform & data integration pipeline. This role is central to our transformation toward a modern, governed, cloud‑based data ecosystem that supports all functions at Coverys (notably underwriting, claims, actuarial, finance, and enterprise analytics etc.)

The Data Architect will help define the architectural blueprint, establish data modeling standards, and guide the development of scalable, automated data pipelines in Snowflake. In addition to design of the architecture, this position will work closely with business and technology teams to ensure data is accurate, trusted, and available for advanced analytics, reporting, and operational decision‑making.

Essential Duties & Responsibilities

Data Architecture & Modeling

• Design and maintain enterprise data architecture aligned to business domains (Policy, Party, Claims, Billing, Underwriting, etc.).
• Ensure data architecture design aligns to enterprise architecture standards & partners closely with Enterprise Architecture.
• Develop canonical and semantic data models to support analytics, reporting, and operational use cases.
• Define standards for data modeling, data quality, naming conventions, metadata, lineage, and documentation.
• Partner with business stakeholders to translate requirements into scalable data structures.

Data Engineering & Pipeline Development

• Build ELT/ETL pipelines using modern cloud-native tools and frameworks.
• Lead the migration from legacy batch processes to automated, event-driven, or CDC-based ingestion patterns.
• Implement data quality rules, validation frameworks, and reconciliation logic.
• Optimize Snowflake workloads for performance, cost, and reliability.

Cloud Data Platform Leadership

• Design and oversee medallion-style data layers (bronze/silver/gold) for ingestion, curation, and consumption.

Governance, Standards & Best Practices

• Work with Data Governance to establish data dictionaries, lineage, classification, data quality and stewardship models.
• Ensure consistent use of canonical identifiers across systems and domains.
• Promote data-as-a-product principles and guide teams toward reusable, scalable data assets.

Collaboration & Leadership

• Partner with business analysts, data scientists, actuaries, and analytics teams to support data needs.
• Mentor SQL developers and analytics engineers transitioning into modern data engineering roles. Mentor and coach the data engineering team & lead the development of pipeline and architecture platforms.
• Provide architectural oversight for major data initiatives across the enterprise.
• Support evolving business needs, as applicable.

Education, Experience, Competencies & Values

• Bachelor’s degree in computer science or relevant field from an accredited college or university, required.
• 3-5- years of experience in data architecture, data engineering, required.
• Strong data modeling expertise (conceptual, logical, physical).
• Hands‑on experience designing enterprise data architectures.
• Advanced ELT/ETL development experience (preferably cloud‑native).
• Deep experience with cloud data warehouses, ideally Snowflake.
• Proficiency in Python for data engineering and automation.
• Strong SQL skills and experience with large-scale data processing.
• Experience with data quality frameworks, metadata management, and lineage.
• Understanding of modern data patterns (CDC, event‑driven ingestion, APIs, streaming, orchestration).
• Experience in the insurance industry, preferred.
• Snowflake certification, a plus.
• Familiarity with tools such as dbt, Airflow, Azure Data Factory, or similar.
• Knowledge of MDM, canonical modeling, and governance frameworks.
• Experience with Power BI or other BI tools.
• Qualified candidates must be eligible to work in the US without sponsorship or restriction.

Base salary range is $96,650 - 130,755. Individual compensation packages are based on a variety of factors that are unique to each candidate including location, skill set, experience, qualifications and education.

If you're a caring and customer focused individual who enjoys working with passionate team members, Coverys is the right company for you!