JC Automation Corp supports global pharmaceutical manufacturing clients implementing and replacing Rockwell PharmaSuite MES, with a focus on reliable, validated analytics. If you want to build reporting that production, quality, and operations teams can trust in a GxP-regulated environment, this onsite role in Carolina, PR brings together data engineering, analytics development, and documentation for controlled systems.
Responsibilities
- Design and develop analytical SQL views and data models on PharmaSuite MES data using established corporate SQL and programming standards.
- Build and maintain Power BI semantic models, DAX measures, and manufacturing and quality dashboards (including yield, defects, IPC, and order status).
- Gather, analyze, and document site requirements, managing them through the change and validation lifecycle (ALM, ServiceNow Change Requests).
- Create GxP/GMP-compliant documentation including requirements, risk and impact analyses, implementation guides, test evidence, and source code reviews.
- Support deployments and site replication across DEV, TEST, and PROD with strict environment verification.
- Troubleshoot data discrepancies, resolve RITMs and incidents, and perform root cause analysis.
- Optimize query performance while ensuring data quality, integrity, and security.
- Collaborate with geographically distributed teams across time zones and cultures in English.
Requirements
- 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, including GxP, GAMP 5, and 21 CFR Part 11.
- Strong SQL skills (T-SQL / SQL Server) and relational data modeling.
- Hands-on experience with Power BI (Power Query, DAX, and data modeling).
- 3+ years in data analytics or reporting, ideally in pharmaceutical, biotech, or medical device manufacturing.
- Knowledge of GAMP 5, 21 CFR Part 11, and data integrity principles (ALCOA+).
- Fluent English in written and spoken communication.
Preferred Qualifications
- Experience with MES platforms, ideally Rockwell PharmaSuite, or with batch records, EBR, and manufacturing execution data.
- Experience with computer system validation (CSV) and documentation under a formal validation plan.
- Python for data analysis and automation, plus familiarity with HTML/CSS/JS for lightweight web tools.
- Cloud experience, Azure preferred, including Azure SQL, Azure Web Apps, and Azure AD authentication.
- Familiarity with SQL Server high availability (Always On Availability Groups) and with Denodo or other data virtualization layers.
- Experience with Agile, GitHub, and workflow automation using Power Automate.
- Ability to review and recommend design patterns, performance optimization, and deployment strategies.
- Knowledge of Data Governance, Master Data Management, and Business Intelligence concepts.
- Spanish, Portuguese, Japanese, or other language skills are a plus for supporting global sites (English required).
Technologies
Rockwell PharmaSuite MES, SQL, T-SQL, SQL Server, Power BI, Power Query, DAX, ALM, ServiceNow Change Requests, GxP, GMP, GAMP 5, 21 CFR Part 11, ALCOA+, DEV, TEST, PROD, RITMs, Azure SQL, Azure Web Apps, Azure AD authentication, Always On Availability Groups, Denodo, Python, HTML, CSS, JS, GitHub, Power Automate, CSV, Agile, EBR, batch records, MES, Data Governance, Master Data Management, Business Intelligence, MES platforms.
Soft Skills
- Attention to detail and a strong quality mindset in a regulated setting.
- Clear written and verbal communication with technical and non-technical stakeholders.
- Ownership and the ability to manage multiple deliverables, dependencies, and deadlines.
- Curiosity and willingness to challenge assumptions using data.
- Self-directed, organized, and able to manage several site deliverables at once.
- Comfort working remotely with teams across time zones.