Lead Data Architect (Snowflake)

TL;DR

Lead Data Architect (Snowflake/dbt): Leading the architecture assessment, transition planning, and modernization of client data platforms with an accent on scalable ELT pipelines and dbt frameworks. Focus on migrating SQL transformations to Snowflake, designing future-state architectures, and ensuring long-term governance and reliability.

Location: Remote (Must be US based)

Salary: $190,000 (base + bonus)

Company

hirify.global is a leading Business Intelligence and Data Analytics consulting firm specializing in tailored solutions for Data Warehousing and Project Management.

What you will do

• Lead architecture assessment and documentation for Snowflake, Airflow, and AWS platforms.
• Design future-state data architecture using modern ELT and dbt best practices.
• Define standards for data modeling, pipeline architecture, and governance.
• Lead the migration of SQL-based transformation logic into dbt models.
• Establish CI/CD, monitoring frameworks, and data quality validation.
• Optimize Snowflake compute usage and design scalable Airflow orchestration strategies.

Requirements

• 10+ years of experience in Data Engineering or Data Architecture.
• Expert-level proficiency with Snowflake and dbt transformation frameworks.
• Strong skills in Apache Airflow, Python, and advanced SQL modeling.
• Experience designing large-scale ELT pipelines and data warehouse architectures.
• Proficiency in cloud environments, preferably AWS.
• English: Advanced/fluent level required.

Nice to have

• Snowflake certification.
• Experience with Medallion architecture patterns.
• Experience leading data platform migrations or defining governance frameworks.

Culture & Benefits

• Collaborative, inclusive, and innovation-driven work culture.
• Diverse, global team of consultants.
• Fully remote work environment.