Senior Cloud Data Architect & Snowflake Platform Lead

Coverys; Pennsylvania; On-site; USD 122,000 - 165,000; Full time

Job summary

Coverys is seeking a Lead Data Architect to design and evolve our enterprise data platform and data integration pipeline. You will define architectural blueprints, establish data modeling standards, and drive scalable, automated data pipelines to support analytics and decision-making.

You will work with business and technology teams to ensure data is accurate, trusted, and available for underwriting, claims, actuarial, finance, and analytics.

Qualifications

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

Responsibilities

• Lead the design and maintenance of the enterprise data architecture aligned to business domains (Policy, Party, Claims, Billing, Underwriting).
• 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 and provide technical recommendations and tradeoffs.
• Lead the design and development of ELT/ETL pipelines using modern cloud-native tools and frameworks.
• Lead 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.
• Mentor the Lead of the Engineering team and ensure solution adheres to standards.
• Ensure that the data engineering team follows sound technical processes and best practices.

Skills

Data architecture

Data modeling

ELT/ETL

Python

SQL

Snowflake

Cloud data warehouses

Data governance

dbt

Airflow

Azure Data Factory

Power BI

Mentoring

Leadership

Communication

Education

Bachelor’s degree in computer science

Tools

Snowflake

dbt

Airflow

Azure Data Factory

Job description

Coverys is seeking a Lead Data Architect to design and evolve our enterprise data platform and data integration pipeline. You will define architectural blueprints, establish data modeling standards, and drive scalable, automated data pipelines to support analytics and decision-making.

You will work with business and technology teams to ensure data is accurate, trusted, and available for underwriting, claims, actuarial, finance, and analytics.