Lead Data Architect
Core
Lead the architecture assessment, transition planning, and modernization of client data platforms, specifically migrating SQL transformations to a dbt framework within Snowflake.
Role type
Lead Data Architect (Data Platform Modernization)
Builds
Scalable, modern ELT data platforms using Snowflake, dbt, and Airflow for client portfolios.
Domain
Business Intelligence, Data Warehousing, Cloud Data Engineering
Deliverable
production ML models | product features | dashboards & analysis | infrastructure
Required skills
Snowflake architecture, dbt transformation frameworks, Apache Airflow orchestration, Python programming, SQL modeling and optimization, ELT pipeline design, AWS cloud environments
Preferred skills
Snowflake certification, leading data platform migrations, Medallion architecture patterns, data governance frameworks, distributed/global team leadership
Technologies
Snowflake, dbt, Apache Airflow, AWS, Python, SQL
Responsibilities
Lead architecture assessment and documentation of current data platforms; Design future-state data platform architecture following modern ELT and dbt best practices; Define standards for data modeling, pipeline architecture, transformation frameworks, governance, and data quality; Lead migration of transformation logic into dbt models; Implement automated testing frameworks within dbt; Conduct discovery sessions and technical workshops with client engineering teams; Document architecture, pipelines, and operational processes; Establish standards for CI/CD, monitoring frameworks, and data quality validation; Optimize Snowflake compute usage and platform performance; Design scalable orchestration strategies for Airflow pipelines.
Seniority
Senior, hands-on IC with leadership responsibilities
