Data Engineer - Azure Data Factory & Snowflake
Skills
About the role
This is a Data Engineer role at Cognizant, building cloud data pipelines with Azure Data Factory and Snowflake for a client engagement based in Milwaukee. It suits an experienced data engineer skilled in ADF, Snowflake and SQL who can handle end-to-end pipeline delivery from source analysis through production support. The posting describes the work model as remote for qualified US applicants, despite listing a Milwaukee location.
What you’ll do
- Build and orchestrate ingestion and transformation pipelines in Azure Data Factory
- Develop and optimize Snowflake objects including tables, views, streams, tasks and stored procedures
- Write complex SQL for transformation logic and implement SCD Type 1 and Type 2 patterns
- Tune warehouse sizing, clustering and query performance for cost efficiency
- Integrate ADF with Azure Data Lake Storage Gen2, Azure SQL, Key Vault and Databricks or Synapse
- Implement CI/CD for ADF and Snowflake through Azure DevOps or GitHub
- Set up monitoring, alerting and data quality/reconciliation checks
What they’re looking for
- 4+ years of hands-on experience with Azure Data Factory and Snowflake
- Advanced SQL and data warehousing concepts including dimensional modeling and ELT design
- Working knowledge of Azure Data Lake Storage Gen2, Azure SQL Database and Azure Key Vault
- Experience with Python or PySpark for data processing
- Git-based version control and CI/CD pipeline experience
- Understanding of performance tuning, cost optimization and data security including RBAC and masking
Nice to have
- Exposure to Agile methodology
- Experience in production support environments
What’s on offer
- $115,000-$135,000 annual salary depending on experience
- Discretionary annual incentive program
- Medical, dental, vision and life insurance
- Paid holidays and paid time off
- 401(k) plan and contributions
- Paid parental leave
- Employee stock purchase plan
Questions about this role
Is this role remote?
The posting says it is open remotely to qualified US applicants, though a Milwaukee, Wisconsin location and hybrid work model are also listed.
How much does it pay?
$115,000-$135,000 per year depending on experience.
How many years of experience do I need?
4+ years of hands-on experience with Azure Data Factory and Snowflake.
Is visa sponsorship available?
No, this role is not able to offer visa transfer or sponsorship now or in the future.
Related roles
MLOPS Engineer
A hybrid MLOps Engineer role at Cognizant in Chennai, building deployment, monitoring and retraining pipelines for machine learning models. Suits an experienced engineer, 6 to 15 years, strong in Kubernetes and cloud ML platforms.
Gen AI Engineer
A hybrid Generative AI Engineer role at Cognizant in Chennai, building and fine-tuning multimodal foundation models and deploying them to the cloud. Suits a candidate with 5+ years of ML/AI engineering experience.
Lead Data Engineer – Databricks & AI | Remote Canada
Lead data engineer role for a financial services client, requiring 10+ years of Databricks expertise and experience collaborating with AI/ML teams to build scalable data infrastructure.
Data Analyst - Data Quality & Databricks
A data analyst role centered on data quality, profiling and reconciliation using Databricks, SQL and PySpark, open across Bangalore, Chennai and Pune for candidates with 7-11 years of experience.
Data Engineer, Data Platform & ML (Remote)
A Poland-remote Data Engineer role building a cloud-based corporate data warehouse for business analytics and machine learning. It suits a data engineer with at least three years of experience in Python, SQL, warehouse design, and modern data tooling.
Data Engineer, Data Platform & Machine Learning (Remote)
A Serbia-remote data engineering role building Tabby's corporate data warehouse, data integrations, and pipelines. It is intended for a data engineer with warehouse design, Python, SQL, and cloud data-stack experience.