Data Engineer (Azure Data Factory)

Company Description

We offer professional services and innovative solutions that streamline business and government. 

Job Description

As a Data Engineer at Procentrix, you will play a key role in modernizing our data ecosystem by leading efforts to migrate on-premise data sources—including Informix databases and binary objects—into Dataverse and Azure storage. You will design, implement, and maintain Azure Data Factory (ADF) pipelines that enable seamless data movement while ensuring reliability, scalability, and compliance with security standards.

This role requires direct interaction with customers to review and confirm requirements, validate data migration needs, and ensure proper configuration and connectivity of the Self-hosted Integration Runtime (SHIR) for secure on-prem to cloud integration. You will collaborate with stakeholders to ensure data quality, troubleshoot issues, and provide guidance on best practices for pipeline automation, scheduling, and error handling. Your work will include building and managing data pipelines, performing transformations, handling error detection and recovery, and ensuring data is delivered efficiently for use across applications and services. Additionally, you will be responsible for configuring integrations with Dataverse, managing blob storage for binary data, and implementing automation and scheduling to support ongoing operational needs.

The projected compensation range for this position is $130K - $150K annualized (USD). The final salary offered will generally fall within this range and is determined by various factors, including but not limited to the individual's particular combination of education, knowledge, skills, competencies, and experience, as well as internal pay equity, location, contract-specific affordability and other organizational requirements.

Required Skills

• Strong hands-on experience with Azure Data Factory (ADF), including pipeline design, data flows, and integration runtime setup.
• Experience working with on-premise databases (e.g., Informix) and migrating data into cloud environments.
• Proficiency in SQL for data transformation and schema alignment.
• Knowledge of Dataverse integration using API or OData connectors.
• Experience implementing error handling, logging, and retry policies in ADF pipelines.
• Familiarity with Azure Blob Storage and management of binary/object data.
• Experience with scheduling and automation of pipelines in ADF.
• Strong problem-solving skills, attention to detail, and ability to work independently and as part of a team.

Desirable Skills

• Experience with Microsoft Power Platform and working with Dataverse in enterprise environments.
• Familiarity with Azure DevOps or similar CI/CD tools for pipeline deployment and management.
• Knowledge of SharePoint integration for binary data movement.
• Background in cloud security and access control best practices.
• Prior experience supporting large-scale data migration or modernization projects.

Additional Information

Procentrix is an Equal Opportunity employer and does not discriminate on the basis of race, color, religion, gender, national origin, age, marital or veteran status, the presence of a non-job related medical condition or handicap, or any other legally protected status.