Globgal MES Data Analytics & Reporting Specialist

JC Automation, Corp.; Carolina (PR); Remote; USD 90,000 - 130,000; Full time

Job summary

JC Automation Corp. seeks a Data Analytics & Reporting Specialist to support global pharmaceutical MES programs. You will design Power BI dashboards, write and optimize queries, and migrate Oracle reports to MS-SQL while ensuring data integrity.

Work with global site stakeholders across PR, US, Europe and Asia in a GMP environment and contribute to validation deliverables and Azure-hosted tools.

Qualifications

• 3+ years of experience in data analytics or reporting in pharma/biotech manufacturing.
• Experience with MES data, CSV docs and validation in GMP environments.
• Strong SQL (T-SQL) and Oracle to MS-SQL data migration skills.

Responsibilities

• Design, build and maintain Power BI reports and dashboards for MES data.
• Write and optimize T-SQL queries, views, and stored procedures.
• Migrate Oracle-based reports to MS-SQL and interconnect MES data with other systems.
• Develop Power Apps and Power Automate solutions for reporting workflows.
• Build and support web tools hosted in Azure for the MES program.
• Gather site requirements from PR, US, Europe and Asia and translate to specs.
• Prepare CSV deliverables and validation artifacts (IQ/OQ/PQ) per 21 CFR Part 11.

Skills

Data analytics

SQL tuning

Stakeholder comms

GxP compliance

English fluency

Education

Bachelor's degree

Tools

MS SQL Server

Oracle PL/SQL

Power BI

Power Apps

Power Automate

Azure

PharmaSuite

Job description

Globgal MES Data Analytics & Reporting Specialist

OPERATIONS Full Time Carolina, PR, PR

4 days ago Requisition ID: 1105

About Company:

JC Automation Corp. (JCA) was founded in 1997 with the mission of filling a gap between technology and regulatory requirements in the life science manufacturing industry. The company offers highly capable resources at an affordable cost to build solutions and execute projects in: Automation, Control Systems Integration, Information Technology, System Integration and Regulatory Compliance.

JCA is a HUBZone Certified Small Business Firm, NMSDC Certified Minority Business Enterprise, and Certified Critical Industry Supplier. It’s mission is to add value by delivering quality services & solutions on time all the time by transforming processes & technology into business advantages.

Position overview

JC Automation (JCA) is seeking a Data Analytics & Reporting Specialist to join its team supporting global pharmaceutical manufacturing clients. The initial assignment supports a global Manufacturing Execution System (MES) program, with SQL-based reporting, Power BI dashboards and data integration for manufacturing sites globally.

The specialist builds queries and views in Microsoft SQL Server, migrates reports and visualizations that consume Oracle data to MS-SQL, and delivers validated reporting solutions through the Microsoft Power Platform. The role works with site stakeholders and global MES teams in a GMP-regulated environment.

Key responsibilities

• Design, build and maintain Power BI reports and dashboards that visualize MES and manufacturing data for site and global stakeholders.
• Write and optimize queries, stored procedures and views in Microsoft SQL Server (T-SQL).
• Migrate existing reports and visualizations that consume Oracle (PL/SQL) data sources to MS-SQL-based data sources.
• Create MS-SQL views that interconnect MES data with other tools, applications and systems.
• Develop solutions with Power Apps and Power Automate where they add value to reporting and data workflows.
• Build and support web pages and tools hosted in Microsoft Azure for the global MES program.
• Gather reporting requirements from site teams in Puerto Rico, the US, Europe and Asia, and translate them into technical specifications.
• Prepare and execute computer system validation (CSV) deliverables for reports and tools: requirements, design specifications, test scripts (IQ/OQ/PQ) and traceability, following GAMP 5 and 21 CFR Part 11.
• Support MES implementations and migrations, such as PMX to PharmaSuite, by ensuring reporting continuity and data integrity across sites.
• Manage changes through change control and maintain documentation in line with client quality procedures.
• Coordinate across time zones with global MES teams, site IT, quality and operations.

Required qualifications

• 3+ years of experience in data analytics or reporting, ideally in pharmaceutical, biotech or medical device manufacturing.
• Strong Microsoft SQL Server skills: complex queries, views, stored procedures and performance tuning in T-SQL.
• Working knowledge of Oracle PL/SQL, with the ability to migrate queries and reports from Oracle to MS-SQL.
• Hands-on Power BI experience: data modeling, DAX, report design and publishing to the Power BI service.
• Experience with Manufacturing Execution Systems (MES), such as PharmaSuite, PAS-X, Syncade or similar, and an understanding of electronic batch records and shop-floor data.
• Experience writing and executing CSV documentation (URS, FS/DS, IQ/OQ/PQ, traceability matrix) in a GMP environment.
• Knowledge of GAMP 5, 21 CFR Part 11 and data integrity (ALCOA+) principles.
• Fluent in English, written and spoken.

Preferred qualifications

• Experience with Microsoft Azure (App Service, Azure SQL, Azure Data Factory or similar) for hosting web tools and data services.
• Experience with Power Apps and Power Automate.
• Prior work on an MES implementation or migration, especially Rockwell PharmaSuite.
• Experience supporting multiple manufacturing sites or global programs.
• Spanish proficiency is a plus.
• Clear communicator with technical and non-technical stakeholders.
• Self-directed and organized; able to manage several site deliverables at once.
• Comfortable working remotely with teams across time zones.

Education and work conditions

• Bachelor's degree in Computer Science, Information Systems, Engineering or a related field, or equivalent experience.
• Location: remote.
• Occasional meetings outside regular hours to align with teams globally.
• Open question: travel requirements, to be confirmed.