Cloud Data Architect: Snowflake & Data Platform Lead

Coverys; United States; On-site; USD 96,650 - 130,755; Full time

Job summary

Coverys is seeking a Data Architect to design and evolve our enterprise data platform and data integration pipelines. You will drive architectural standards, data modeling, and scalable ELT/ETL solutions in Snowflake, partnering with business and technology teams to ensure accurate, trusted data for analytics and decision-making.

The role emphasizes governance, data quality, and data-as-a-product principles, with mentorship of a growing data engineering team and collaboration across

Qualifications

• Bachelor’s degree in CS or related field is required.
• 3-5 years of experience in data architecture and data engineering.
• Strong data modeling across conceptual, logical, and physical layers.
• Hands-on enterprise data architecture design experience.
• Advanced ELT/ETL development, preferably 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, and lineage.
• Knowledge of modern data patterns (CDC, event-driven ingestion, APIs, streaming, orchestration).
• Insurance industry experience preferred.
• Snowflake certification is a plus.
• Familiarity with dbt, Airflow, Azure Data Factory.
• Knowledge of MDM, canonical modeling, governance.
• Experience with Power BI or other BI tools.
• Eligible to work in the US without sponsorship.

Responsibilities

• Design and maintain enterprise data architecture aligned to business domains.
• 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 migration from legacy batch processes to automated 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).
• Work with Data Governance to establish data dictionaries, lineage, classification, data quality and stewardship models.
• Promote data-as-a-product principles and reusable data assets.
• Mentor SQL developers and analytics engineers; lead the data engineering team.
• Provide architectural oversight for major data initiatives across the enterprise.
• Support evolving business needs as applicable.

Skills

SQL

Python

Data Modeling

ETL/ELT

Snowflake

Cloud Data Warehouse

dbt

Airflow

Power BI

Data Governance

CDC

Event-driven Ingestion

Insurance Industry

Education

Bachelor’s degree in CS or related field

Tools

dbt

Airflow

Azure Data Factory

Power BI

Job description

Coverys is seeking a Data Architect to design and evolve our enterprise data platform and data integration pipelines. You will drive architectural standards, data modeling, and scalable ELT/ETL solutions in Snowflake, partnering with business and technology teams to ensure accurate, trusted data for analytics and decision-making.

The role emphasizes governance, data quality, and data-as-a-product principles, with mentorship of a growing data engineering team and collaboration across