Lead Cloud Data Architect | Snowflake & Data Platform

Coverys; New York (NY); On-site; USD 122,000 - 165,000; Full time

Job summary

Coverys is seeking a Lead Data Architect to drive the design, build, and evolution of a modern cloud-based data platform with Snowflake. You will set architectural standards, model data for analytics, and lead scalable ELT/ETL pipelines while partnering with business and tech teams to ensure trusted data for reporting and decision making.

The role combines hands-on engineering leadership with strategic governance, data quality, and guardrails, mentoring the data engineering team and aligning

Qualifications

• Bachelor’s degree in computer science or related field.
• 5–10 years in data architecture/engineering with leadership.
• Strong data modeling (conceptual, logical, physical).
• Hands-on design of enterprise data architecture.
• Cloud-native ELT/ETL experience.
• Deep Snowflake experience.
• Python for data engineering/automation.
• Strong SQL for large-scale processing.
• Experience with data quality, metadata, lineage.
• Insurance industry experience preferred.
• Snowflake certification a plus.
• Familiar with governance and MDM.
• Experience with Power BI or BI tools.

Responsibilities

• Lead the design and maintenance of the enterprise data architecture aligned to business domains (Policy, Party, Claims, Billing, Underwriting, etc.).
• Ensure data architecture design aligns to enterprise architecture standards and partners 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.
• Serve as a hands-on technical expert for complex data engineering challenges.
• Design and build reusable data engineering frameworks, shared components, and reference implementations.
• Evaluate emerging data technologies and lead proofs of concept for enterprise adoption.
• Define engineering guardrails for security, observability, resiliency, recoverability, and readiness of data products.
• Mentor the Engineering team to ensure adherence to standards and best practices.

Skills

Data modeling

Python

SQL

Power BI

Snowflake

ETL/ELT

Cloud data warehousing

Data governance

Mentoring

Leadership

Education

Bachelor’s degree

Tools

dbt

Airflow

Azure Data Factory

Job description

Coverys is seeking a Lead Data Architect to drive the design, build, and evolution of a modern cloud-based data platform with Snowflake. You will set architectural standards, model data for analytics, and lead scalable ELT/ETL pipelines while partnering with business and tech teams to ensure trusted data for reporting and decision making.

The role combines hands-on engineering leadership with strategic governance, data quality, and guardrails, mentoring the data engineering team and aligning