Data Architect

Coverys

Data Architect at Coverys designing and evolving enterprise data platform. Collaborating with teams to ensure data accuracy and effective analytics.

Posted 7/23/2026full-timeRemote • Massachusetts, Missouri, New York • 🇺🇸 United StatesMid-LevelSenior💰 $96,650 - $130,755 per yearWebsite

Core Competencies

Role fit

Core Competencies

Use this summary to align your resume positioning with the role.

Demonstrates expertise in designing and implementing enterprise data architectures, with a strong focus on data modeling, cloud-native ELT/ETL development, and data quality frameworks. Proficient in leveraging Snowflake and Python for data engineering, while collaborating with cross-functional teams to support advanced analytics and operational decision-making.

Highest-signal resume keywords

Data Architecture DesignCloud-Native ELT/ETL DevelopmentSnowflake ProficiencyData Modeling ExpertiseSQL Skills

ATS Keywords

Tailor your resume

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills

Data ModelingELT DevelopmentETL DevelopmentPythonSQLData Quality FrameworksMetadata ManagementData LineageCloud Data WarehousingData Governance

Soft Skills

MentoringCollaborationCommunication

Tools & Technologies

SnowflakeDbtAirflowAzure Data FactoryPower BI

Certifications & Qualifications

Snowflake Certification

Industry Keywords

Insurance IndustryData EcosystemData GovernanceCanonical ModelingEvent-Driven Ingestion

Tech Stack

Tools & technologies

AirflowAzureCloudETLPythonSQL

About the role

Key responsibilities & impact

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.
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.
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.
Design and oversee medallion-style data layers (bronze/silver/gold) for ingestion, curation, and consumption.
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.
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.

Requirements

What you’ll need

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.

Benefits

Comp & perks

Our benefits package is available day 1 of employment, so you never miss a beat.
There is truly something for everyone in our benefits package, whether you are raising a family or a furry friend, or you're an avid traveler who uses PTO to chase down your next adventure.
Connecting with colleagues takes on new meaning when you're elbow-deep planting trees or rolling up your sleeves serving lunch to those in need.
The giving doesn't end there—Coverys cares about the initiatives near and dear to your heart. That's why we offer directed donations, as well as company matchings, to support the organizations that you are personally involved with.