Data Engineer - Azure Data Factory & Snowflake
About The Role
As a Data Engineer - Azure Data Factory (ADF) & Snowflake, you will make an impact by designing, building, and supporting cloud data pipelines that ingest data from multiple source systems into Snowflake using Azure Data Factory. This role covers end-to-end delivery, from source analysis and data modeling through pipeline development, performance tuning, and production support. You will be a valued member of the Data Engineering team and work collaboratively with data architects, BI teams, and business stakeholders.
Responsibilities
- Build and orchestrate ingestion and transformation pipelines in Azure Data Factory using mapping and data flows, linked services, datasets, triggers, and parameterized, metadata-driven frameworks.
- Develop and optimize Snowflake objects including databases, schemas, tables, views, streams, tasks, stored procedures, and Snowpipe-based loads.
- Write complex SQL for transformation logic, implement SCD Type 1 and Type 2 patterns, and tune warehouse sizing, clustering, and query performance for cost efficiency.
- Integrate ADF with Azure Data Lake Storage Gen2, Azure SQL, Key Vault, Logic Apps, and Databricks or Synapse where required.
- Implement CI/CD for ADF and Snowflake through Azure DevOps or GitHub, along with monitoring, alerting, and data quality and reconciliation checks.
Requirements
- Strong hands-on experience with Azure Data Factory and Snowflake (4+ years).
- Advanced SQL and data warehousing concepts, including dimensional modeling, star and snowflake schemas, and ELT design patterns.
- Working knowledge of Azure Data Lake Storage Gen2, Azure SQL Database, and Azure Key Vault.
- Experience with Python or PySpark for data processing, along with Git-based version control and CI/CD pipelines.
- Understanding of performance tuning, cost optimization, and data security, including RBAC, masking, and row-level access policies.
Qualifications
- Exposure to Agile methodology.
- Experience in production support environments.
Skills
These will help you stand out:
- Exposure to Agile methodology.
- Experience in production support environments.
Benefits
- Cognizant offers the following benefits for this position, subject to applicable eligibility requirements:
- Medical/Dental/Vision/Life Insurance
- Paid holidays plus Paid Time Off
- 401(k) plan and contributions
- Long-term/Short-term Disability
- Paid Parental Leave
- Employee Stock Purchase Plan
Pay
The annual salary for this position is between $115,000-$135,000 depending on experience and other qualifications of the successful candidate.
Schedule
This is a remote position open to qualified applicants in the United States.
Benefits
- Cognizant offers the following benefits for this position, subject to applicable eligibility requirements:
- Medical/Dental/Vision/Life Insurance
- Paid holidays plus Paid Time Off
- 401(k) plan and contributions
- Long-term/Short-term Disability
- Paid Parental Leave
- Employee Stock Purchase Plan
Application Instructions
Applications will be accepted until September 25, 2026.