Key Responsibilities
Design and build batch and near-real-time ELT/ETL pipelines into Snowflake from Azure sources using Azure Data Factory, ADLS Gen2, Event Grid, Databricks, Snowpipe, Streams and Tasks.
Develop data models (raw, curated, consumption layers), Dynamic Tables, stored procedures and Snowpark transformations; optimize SQL.
Administer and engineer the Snowflake platform: accounts, databases, schemas, warehouses, resource monitors and Dev/Test/Prod environments.
Implement RBAC, network policies, SSO/SCIM with Microsoft Entra ID, masking and row access policies, tagging and data governance controls.
Configure secure Azure integration: Private Link, storage integrations, Key Vault and VNet settings.
Automate provisioning and deployments with Terraform and CI/CD (Azure DevOps or GitHub Actions, schemachange or dbt).
Tune performance and manage cost: warehouse sizing, clustering, query profiling, caching and credit monitoring.
Build data quality checks, pipeline monitoring and alerting using Azure Monitor, Log Analytics and Snowflake Account Usage.
Implement data protection and recovery: Time Travel, Fail-safe, cloning, replication and failover.
Collaborate with architects, analysts, BI and security teams; document standards and support production operations.
Required Skills
Strong hands-on Snowflake data engineering and platform administration experience.
Advanced SQL and Python (Snowpark, SnowSQL) or equivalent scripting.
Azure experience: ADLS Gen2, Azure Data Factory, Entra ID, Key Vault, Azure Monitor.
Experience with Snowpipe, Streams, Tasks, Dynamic Tables and Secure Data Sharing.
Terraform, Git and CI/CD pipeline experience. • Solid understanding of data warehousing, dimensional modeling and ELT patterns.
Knowledge of data security, governance and compliance practices.