Description
Remote in either Remote or MN or ND or SD or WI or IA
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.
We can facilitate w2 and corp-to-corp consultants. For our w2 consultants, we offer a great benefits package that includes Medical, Dental, and Vision benefits, 401k with company matching, and life insurance.
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.