Pharma Data Engineer: Power BI & SQL Analytics

JC Automation Corp; Carolina (PR); On-site; USD 85,000 - 110,000; Full time

Job summary

JC Automation Corp is seeking a Data Engineer / Data Analytics Specialist to support global pharmaceutical manufacturing clients, focusing on PharmaSuite MES, validated SQL, and Power BI analytics in a GxP environment for manufacturing reporting.

The role emphasizes SQL data modeling, BI dashboards, documentation, and cross‑functional collaboration with teams in multiple time zones, all conducted in English.

Qualifications

• Bachelor’s degree or equivalent experience in a technical field.
• Regulated pharma environment experience (GxP, 21 CFR Part 11) highly preferred.
• 3+ years in data analytics or reporting, pharma/biotech background ideal.
• Strong SQL (T-SQL/SQL Server) and data modeling required.
• Hands-on Power BI with data modeling, DAX, and Power Query.

Responsibilities

• Design analytical SQL views and data models on PharmaSuite MES data.
• Build Power BI semantic models and dashboards for manufacturing quality reporting.
• Document site requirements and manage validation lifecycle in ALM/ServiceNow.
• Create GxP/GMP-compliant documentation and artifact reviews.
• Support deployments across DEV/TEST/PROD and ensure data integrity.
• Troubleshoot data discrepancies, RITMs, and perform root cause analysis.
• Collaborate with global teams across time zones in English.

Skills

SQL skills

Power BI

Data analytics

GxP compliance

English fluency

Education

Bachelor’s degree in CS/IS/Engineering or related field

Tools

SQL Server

Azure SQL

Power BI Desktop

Denodo

GitHub / Power Automate

Job description

JC Automation Corp is seeking a Data Engineer / Data Analytics Specialist to support global pharmaceutical manufacturing clients, focusing on PharmaSuite MES, validated SQL, and Power BI analytics in a GxP environment for manufacturing reporting.

The role emphasizes SQL data modeling, BI dashboards, documentation, and cross‑functional collaboration with teams in multiple time zones, all conducted in English.