What are the responsibilities and job description for the Snowflake ADF Architect position at CBC?
Snowflake ADF Architect
Location: Plano, TX
Contract: W2 Only
Job Summary
Lead the design and implementation of scalable data architectures using Snowflake data warehouse and Azure Data Factory (ADF) for ETL pipelines and data integration. Architect end-to-end solutions including data modeling, cloud migration, and performance optimization on Azure platforms. Collaborate with stakeholders to translate business needs into robust, event-driven data systems supporting analytics and AI/ML workloads.
Key Responsibilities
Design data pipelines following Medallion Architecture (Bronze, Silver, Gold layers) and integrate Snowflake with Azure services like ADF, Synapse, and Databricks.
Develop dimensional data models, manage metadata catalogs, and ensure data governance, quality, and streaming processing.
Lead data warehouse development, ETL processes, and optimization for scalability across multi-cloud environments including Azure, AWS, and GCP.
Required Qualifications
5-7 years in Snowflake data architecture, with proven expertise in Azure Data Factory, Snowflake SnowPro certification preferred.
Strong skills in data modeling, distributed systems, SQL Server, Python, and cloud platforms (Azure focus).
Experience advising clients, managing stakeholders, and delivering scalable AI/ML-enabled data solutions.