Cloud Data Architect: Snowflake & Data Platform Lead

Coverys; East Lansing (MI); On-site; USD 96,650 - 130,755; Full time

Job summary

Coverys is seeking a Data Architect to design, build, and evolve our data platform and data integration pipeline. This role supports underwriting, claims, actuarial, finance, and analytics in a modern, governed, cloud-based environment.

You will define architectural blueprints, build ELT/ETL pipelines in Snowflake, establish data models, and partner with business and tech teams to ensure data is accurate, trusted, and available for advanced analytics.

Qualifications

• Bachelor’s degree in computer science or relevant field, required.
• 3–5 years of experience in data architecture and data engineering.
• Strong data modeling expertise (conceptual, logical, physical).
• Hands-on experience designing enterprise data architectures.
• 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 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.

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.
• Build ELT/ETL pipelines using modern cloud-native tools.
• Lead the migration from legacy batch processes to automated ingestion patterns.
• 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, and quality models.
• Promote data-as-a-product and reusable data assets.
• Mentor SQL developers and analytics engineers transitioning to modern data roles.
• Provide architectural oversight for major data initiatives across the enterprise.
• Support evolving business needs.

Skills

SQL proficiency

Python for data engineering

Data modeling

Data governance

CDC / event-driven patterns

Team collaboration

Mentoring

Insurance industry knowledge

Education

Bachelor's degree in CS or related field

Snowflake certification (preferred)

Tools

Snowflake

dbt

Airflow

Azure Data Factory

Power BI

ETL tooling

Job description

Coverys is seeking a Data Architect to design, build, and evolve our data platform and data integration pipeline. This role supports underwriting, claims, actuarial, finance, and analytics in a modern, governed, cloud-based environment.

You will define architectural blueprints, build ELT/ETL pipelines in Snowflake, establish data models, and partner with business and tech teams to ensure data is accurate, trusted, and available for advanced analytics.