Hybrid Data Integration Engineer – Azure & ETL/ELT

Biopharma Careers; Cary (NC); Hybrid; USD 110,000 - 170,000; Full time

Job summary

Chiesi USA seeks a Data Integration Engineer to design, develop, and maintain scalable ETL/ELT pipelines across on-prem and cloud environments. The role emphasizes Azure Data Factory, Databricks, and Power BI, with collaboration across data scientists and analysts in a hybrid Cary, NC setting.

You will monitor pipelines, troubleshoot data issues, and implement data quality controls while contributing to secure, scalable data architectures that drive business insights.

Qualifications

• Bachelor's degree in Computer Science, Information Technology, or related field.
• 5+ years of relevant experience, including 3+ years as a data engineer or data integration specialist.
• Strong proficiency in Azure SQL Database, SQL Server, Azure Data Factory, SSIS, and Databricks.
• Experience with cloud solutions and Azure services (Synapse, Blob).
• Experience with Power BI or other reporting tools.
• Programming knowledge (PowerShell, Python).
• Familiarity with ESB and application integration.
• Excellent communication and collaboration in a hybrid team.

Responsibilities

• Design, develop, and maintain reliable and scalable ETL/ELT processes, integrating structured and semi-structured data from multiple sources using Azure Data Factory, SSIS, and Databricks.
• Monitor data pipelines and jobs.
• Troubleshoot and resolve data-related issues.
• Optimize data workflows for performance and scalability.
• Implement data quality checks and ensure data integrity and security across systems.
• Design cloud architecture solutions to support data projects.
• Design and implement SSIS packages to support with existing on-premise systems.
• Create Power BI dashboards and paginated reports for business users.
• Collaborate with data scientists, analysts, and stakeholders to understand data requirements.
• Maintain documentation for data processes and systems.

Skills

Data integration

Data modeling

Analytical skills

Communication

Team collaboration

Education

Bachelor's degree in Computer Science/IT

Tools

Azure Data Factory

SSIS

Databricks

SQL Server

Azure Synapse Analytics

Power BI

PowerShell

Python

Job description

Chiesi USA seeks a Data Integration Engineer to design, develop, and maintain scalable ETL/ELT pipelines across on-prem and cloud environments. The role emphasizes Azure Data Factory, Databricks, and Power BI, with collaboration across data scientists and analysts in a hybrid Cary, NC setting.

You will monitor pipelines, troubleshoot data issues, and implement data quality controls while contributing to secure, scalable data architectures that drive business insights.