Azure Data Engineer
Remote
Why Open
Supporting data warehouse/Oracle DataStage migration to data lake/Azure & Databricks/Azure Data Factory
Selling Points
Long term contract - possibility for extension, fully remote (if local to MN, can work hybrid if desired and infrequent onsite collaboration meetings would be ideal to have them attend)
Our client seeks an Azure Data Engineer to modernize an enterprise data platform by migrating data and workloads from an on-premises Oracle data warehouse and IBM DataStage environment to a cloud-based Azure data lake architecture. You will design, build, and optimize scalable data pipelines using Azure Databricks and Azure Data Factory, implement data-quality and validation processes, and promote data through medallion architecture layers. You will collaborate with engineers, architects, analysts, and business partners to build reliable, maintainable, and trusted data products. Healthcare or health-plan domain knowledge is beneficial, but strong Azure Databricks and data-platform engineering capabilities are the primary priorities.
Position Overview
As a Azure Data Engineer, you will help modernize an enterprise data platform by migrating data and workloads from an on-premises Oracle data warehouse and IBM DataStage environment to a cloud-based Azure data lake architecture.
You will design, build, and optimize scalable data pipelines using Azure Databricks and Azure Data Factory. Your work will include ingesting data from legacy and enterprise source systems, implementing data-quality and validation processes, and promoting data through medallion architecture layers. You will collaborate with engineers, architects, analysts, and business partners to build reliable, maintainable, and trusted data products.
Healthcare or health-plan experience is beneficial, particularly experience with claims, billing, finance, or plan-administration data, but strong Azure Databricks and data-platform engineering capabilities are the primary priorities.
Responsibilities
- Design, develop, test, and maintain data pipelines using Azure Databricks and Azure Data Factory.
- Support the migration of data and ETL workloads from an on-premises Oracle and DataStage environment to an Azure cloud data lake.
- Develop scalable ingestion, transformation, and data-processing solutions.
- Design and implement medallion architecture patterns across Bronze, Silver, and Gold data layers.
- Build data-quality, reconciliation, and validation checks directly into data pipelines and engineering workflows.
- Automate validation and testing to improve the reliability of data products.
- Troubleshoot pipeline failures, data-quality issues, and performance problems.
- Collaborate with engineers, analysts, architects, and business stakeholders to translate requirements into practical data solutions.
- Participate in code reviews, documentation, testing, deployment, and continuous-improvement activities.
- Promote reusable development patterns and sound engineering practices across the team.
Experience Requirements
- Hands-on data engineering experience in enterprise environments.
- Demonstrated experience with Azure Databricks and Azure Data Factory.
- Strong SQL and Python or PySpark development skills.
- Experience designing and developing batch data pipelines and ETL or ELT workflows.
- Experience implementing data-quality, data-validation, and reconciliation processes.
- Knowledge of medallion or lakehouse architecture, including Bronze, Silver, and Gold data layers.
- Experience working with relational databases and large, complex datasets.
- Understanding of data modeling, schema design, partitioning, and performance optimization.
- Experience with Git or another version-control platform.
- Experience working with CI/CD and automated deployment practices.
- Analytical, troubleshooting, and problem-solving skills.
- Ability to contribute directly to development while providing technical guidance to other team members.
- Communication and collaboration skills.
- Preferred: Experience migrating platforms or ETL workloads from on-premises to Azure, Oracle databases, IBM DataStage, Azure data lake or lakehouse solutions, Delta Lake and Databricks capabilities, automated data testing and monitoring, Azure DevOps and cloud CI/CD, Agile or Scrum, healthcare or finance data, and regulated enterprise environments.
Required Qualifications
- Strong hands-on data engineering experience in enterprise environments.
- Demonstrated experience with Azure Databricks and Azure Data Factory.
- Strong SQL and Python or PySpark development skills.
- Experience designing and developing batch data pipelines and ETL or ELT workflows.
- Experience implementing data-quality, data-validation, and reconciliation processes.
- Knowledge of medallion or lakehouse architecture, including Bronze, Silver, and Gold data layers.
- Experience working with relational databases and large, complex datasets.
- Understanding of data modeling, schema design, partitioning, and performance optimization.
- Experience with Git or another version-control platform.
- Experience working with CI/CD and automated deployment practices.
- Strong analytical, troubleshooting, and problem-solving skills.
- Ability to contribute directly to development while providing technical guidance to other team members.
- Strong communication and collaboration skills.
Preferred Qualifications
- Experience migrating data platforms or ETL workloads from on-premises environments to Azure.
- Experience with Oracle databases and IBM DataStage.
- Experience designing Azure data lake or lakehouse solutions.
- Experience with Delta Lake, Delta tables, or related Databricks capabilities.
- Experience implementing automated data testing and monitoring.
- Familiarity with Azure DevOps and cloud-based CI/CD pipelines.
- Experience working in Agile or Scrum development environments.
- Knowledge of healthcare, health-plan administration, claims, billing, reimbursement, or finance data.
- Experience working in a regulated enterprise environment.