Data Engineer (Cary, NC, US)

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

About us

Based in Parma, Italy, Chiesi is an international research-focused pharmaceuticals and healthcare group with over 85 years' experience, operating in 30 countries with more than 6,000 employees (Chiesi Group). To achieve its mission of improving people's quality of life by acting responsibly towards society and the environment, the Group research, develops and markets innovative drugs in its three therapeutic areas: AIR (products and services that promote respiration, from new-born to adult populations), RARE (treatment for patients with rare and ultra-rare diseases) and CARE (products and services that support special care and consumer-facing self-care).

We are proud to be the largest global pharmaceutical group to be awarded B Corp Certification, a recognition of high social and environmental standards. We are a reliable company that adopts and promotes transparent ethical behavior at all levels.

We are committed to embrace diversity, inclusion and equal opportunities. In fact, we are a global family made up of different cultures, different genders, generations, ethnicities, abilities, sexual identities and many other enriching diversities.

Chiesi USA

Chiesi USA is a specialty pharmaceutical company focused on developing and promoting products for the hospital, adjacent specialty and rare disease markets. We are a B Corp and Benefit company awarded Top Employer status for six consecutive years and certified as a Great Place to Work.

At Chiesi, we share an entrepreneurial spirit and act as a force for good, pursuing high social and environmental standards, to ensure the wellbeing of our people, patients, and communities. We offer a work environment where professionals have the opportunity to build a purposeful career focused on helping others while achieving a fulfilling work-life balance, meeting exciting challenges, and engaging in important and rewarding work.

What we offer

Chiesi offers competitive benefits, services, and programs that enrich the personal and professional lives of our employees. Our shared values of passion, innovation, trust and integrity bring out the individual talents and diverse perspectives of each of our colleagues. Our environment encourages each individual to reach his or her full potential and drive outstanding results. We celebrate that \"Every one of us is different. Every one of us is Chiesi.\"

Who we are looking for

This is what you will do

The Data Integration Engineer will play a crucial role in designing, developing, and maintaining scalable data pipelines and cloud data architecture solutions. By leveraging on-premises and cloud technology, the Data Integration Engineer will ensure the efficient and reliable flow of data across the organization. This role is essential in enabling data-driven decision-making and supporting the company's mission to harness the power of data for business insights and innovation. The candidate should be able to support our hybrid work model from the Cary, NC office.

This position is not eligible for employment visa sponsorship. Candidates must be authorized to work in the United States without the need for sponsorship now or in the future.

You'll be responsible for:

• 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 existing and new jobs and data pipelines.
• Troubleshoot and resolve data-related issues in a timely manner.
• Optimize data workflows for high performance and scalability.
• Implement data quality checks and ensure data integrity and security across various systems.
• Design and implement cloud architecture solutions to support data engineering projects.
• Design and implement SSIS packages and processes to support with existing on-premise systems
• Create BI solutions like Power BI dashboards and paginated reports for business users.
• Collaborate with data scientists, analysts, and other stakeholders to understand data requirements and deliver solutions.
• Collaborate with the IT team to offer technical solutions and resolve issues.
• Maintain documentation for data processes and systems.

You will need to have

• Bachelor's degree in Computer Science, Information Technology, or a related field.
• 5+ years of relevant experience, with at least 3 years as a data engineer, data integration specialist, or a similar position, preferably in pharmaceuticals.
• Strong proficiency in Azure SQL Database, SQL Server, Azure Data Factory, SSIS, and Databricks.
• Experience with SQL and other database management systems.
• Knowledge of data architecture concepts, including Master Data Management, Data Warehousing, Data Lakehouse concepts and ETL/ELT processes.
• Experience working with cloud solutions.
• Familiarity with other Azure services such as Azure Synapse Analytics and Azure Blob Storage.
• Experience with Power BI, or other reporting solutions.
• Familiarity with PowerShell, Python or other programming languages.
• Familiarity with enterprise service bus (ESB) and application integration.
• Ability to work effectively in a collaborative, technical local and international team environment.
• Strong analytical and problem-solving skills.
• Strong communication skills (written and verbal).

Location

Hybrid position based in Cary, NC office. #LI-Hybrid

Chiesi USA is an equal opportunity employer committed to hiring a diverse work force at all levels of our business. All qualified applicants receive consideration for employment without regard to race, national origin, age, sex, religion, disability, sexual orientation, marital status, veteran status, gender identity or expression or any other basis protected by local, state or federal law. This policy applies with regard to all aspects of one's employment, including hiring, transfer, promotion, compensation, eligibility for benefits and termination.