Data Engineer - Snowflake/Azure Data Factory
First seen by Alion on Oct 21, 2026.
Role Overview :
We are looking for a skilled Data Engineer with strong hands-on experience in Snowflake, Azure Data Factory (ADF), SQL, Python, and dbt to build, maintain, and optimize scalable cloud-based data pipelines.
Key Responsibilities :
- Develop data ingestion pipelines from relational databases, files, and APIs into Snowflake.
- Build and maintain data transformation pipelines using dbt.
- Implement data pipelines using the Medallion Architecture (Bronze, Silver, and Gold layers).
- Develop reusable, metadata-driven ingestion frameworks.
- Implement data quality checks, error handling, reconciliation, and pipeline monitoring.
- Perform source data profiling, troubleshoot data issues, and support defect resolution.
- Maintain source-to-target mappings, technical documentation, and operational runbooks.
- Participate in code reviews, Agile ceremonies, and collaborative development activities.
Required Skills :
- Strong SQL skills and hands-on Snowflake development experience.
- Practical experience with Azure Data Factory (ADF).
- Python programming for data engineering, automation, and API integration.
- Production-level experience with dbt (Core or Cloud).
- Knowledge of orchestration tools such as Airflow, Dagster, ADF, or Snowflake Tasks.
- Familiarity with CDC and data replication tools such as Fivetran, Qlik Replicate, or Debezium.
- Understanding of Git, CI/CD, and data pipeline deployment practices.
- Experience working with Coalesce is required.
- Strong problem-solving and communication skills.
Good to Have :
- SnowPro Core certification.
- Experience with AWS or Azure cloud storage and API integrations.
- Experience in large-scale data migration or source consolidation projects.
- Experience supporting production-grade data platforms.
Skills
Data Engineering, Azure Data Factory, Python, SQL, ETL, Snowflake DB, Data Build Tool, Medallion Architecture, Data Pipeline, Apache Airflow, AWS