Globgal MES Data Analytics & Reporting Specialist

JC-Automation; Carolina (PR); Teletrabalho; USD 85 000 - 105 000; Tempo integral

Vantagens oferecidas por esta oferta de emprego

Remote work

Resumo da oferta

JC Automation Corp. seeks a Data Analytics & Reporting Specialist to join its MES program, delivering SQL-based reporting, Power BI dashboards, and data integration for global pharmaceutical sites.

You will design queries, migrate Oracle data to MS-SQL, develop Azure-hosted tools, and collaborate with site teams across time zones in a GMP environment.

Qualificações

• 3+ years of data analytics or reporting experience, preferably in pharma/biotech/medical device manufacturing.
• Strong MS SQL Server skills: complex queries, views, stored procedures, performance tuning in T-SQL.
• Experience with Oracle PL/SQL migration to MS-SQL for reports and data sources.
• Hands-on Power BI experience including data modeling, DAX, report design and publication to the Power BI service.
• Experience with MES systems (e.g., PharmaSuite, PAS-X, Syncade) and understanding of electronic batch records.
• Experience creating and executing CSV documentation (URS, FS/DS, IQ/OQ/PQ) in GMP.
• Knowledge of GAMP 5 and 21 CFR Part 11; data integrity (ALCOA+) principles.
• Fluent in English, both written and spoken.

Responsabilidades

• Design, build and maintain Power BI reports and dashboards for MES and manufacturing data.
• Write and optimize queries, stored procedures and views in MS SQL Server (T-SQL).
• Migrate reports/visualizations from Oracle to MS-SQL data sources.
• Create MS-SQL views interconnecting MES data with other tools and systems.
• Develop Power Apps and Power Automate solutions to enhance reporting workflows.
• Build and support web pages/tools hosted in Azure for the global MES program.
• Gather reporting requirements from sites (PR/US/Europe/Asia) and translate into tech specs.
• Prepare and execute CSV deliverables: requirements, design specs, test scripts, traceability (IQ/OQ/PQ).
• Support MES implementations/migrations (e.g., PMX to PharmaSuite) ensuring data integrity across sites.
• Coordinate changes via change control and maintain documentation per client quality procedures.
• Coordinate across time zones with global MES teams, site IT, quality and operations.

Conhecimentos

Data analytics

GMP knowledge

English fluency

Formação académica

Bachelor's degree in CS/IS/Engineering

Ferramentas

SQL Server

Oracle PL/SQL

Power BI

Azure

Descrição da oferta de emprego

Globgal MES Data Analytics & Reporting Specialist

OPERATIONS Full Time Carolina, PR, PR

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.