Pharma Data Engineer - MES & Power BI Expert (Remote)

ADP, Inc.; Carolina (PR); On-site; USD 90,000 - 120,000; Full time

Job summary

JC Automation (JCA) seeks a Data Engineer / Data Analytics Specialist to support global pharmaceutical manufacturing clients. The role implements Rockwell PharmaSuite MES at new sites and replaces legacy platforms across facilities.

The Data Analytics work-stream delivers dashboards and data products for manufacturing, quality, and operations users across multiple global sites. You will design SQL views, build Power BI models, and ensure data integrity in a GxP environment.

Qualifications

• Bachelor’s degree in Computer Science, Information Systems, Engineering, or a related field, or equivalent work experience.
• Experience working in a regulated pharmaceutical or life sciences environment (GxP, GAMP 5, 21 CFR Part 11).
• Strong SQL proficiency (T-SQL / SQL Server) and relational data modeling.
• Hands-on experience with Power BI (Power Query, DAX, data modeling).
• 3+ years of experience in data analytics or reporting, ideally in pharmaceutical, biotech or medical device manufacturing.
• Knowledge of GAMP 5, 21 CFR Part 11 and data integrity (ALCOA+) principles.
• Fluent in English, written and spoken.

Responsibilities

• Design, develop, and maintain data solutions for PharmaSuite MES data.
• Translate manufacturing requirements into validated SQL views, reports, and dashboards.
• Build BI models, DAX measures, and dashboards for manufacturing and quality reporting.
• Gather site requirements and manage them through change and validation lifecycle.
• Produce GxP/GMP-compliant documentation and source code reviews.
• Support deployments and site replication across DEV, TEST, PROD environments.
• Troubleshoot data discrepancies and perform root-cause analysis.
• Optimize query performance and ensure data quality and security.
• Collaborate with teams across time zones and cultures in English.

Skills

Strong SQL proficiency

Fluent English

GxP/regulatory mindset

Education

Bachelor’s degree in Computer Science, Information Systems, Engineering, or related field

Tools

Power BI

SQL Server

ALM/ServiceNow

GitHub

Power Automate

Job description

JC Automation (JCA) seeks a Data Engineer / Data Analytics Specialist to support global pharmaceutical manufacturing clients. The role implements Rockwell PharmaSuite MES at new sites and replaces legacy platforms across facilities.

The Data Analytics work-stream delivers dashboards and data products for manufacturing, quality, and operations users across multiple global sites. You will design SQL views, build Power BI models, and ensure data integrity in a GxP environment.