Globgal MES Data Analytics & Reporting Specialist

JC Automation Corp; De Pere (WI); Remote; USD 90,000 - 130,000; Full time

Job summary

JC Automation Corp is seeking a Data Analytics & Reporting Specialist to support global pharmaceutical MES programs. The role builds SQL Server queries, migrates Oracle-based reports to MS-SQL, and delivers validated Power BI dashboards for site and global stakeholders.

You will work with site teams in multiple regions, develop Power Apps and Power Automate solutions, and ensure data integrity in a GMP environment. Remote work across time zones is expected.

Qualifications

• Experience in data analytics or reporting in pharma/biotech/manufacturing.
• Strong SQL Server skills: complex queries, views, procedures, tuning.
• Power BI development and publishing to the service; data modeling and DAX.
• Experience migrating reports from Oracle to MS SQL and validating reporting.
• Knowledge of GMP, CSV, GAMP 5 and 21 CFR Part 11 principles.

Responsibilities

• Design, build and maintain Power BI reports and dashboards for MES data.
• Write and optimize T-SQL queries, stored procedures, and views.
• Migrate reports from Oracle to MS-SQL data sources.
• Develop MS-SQL views interconnecting MES data with other tools.
• Create solutions with Power Apps and Power Automate for data workflows.
• Build web tools in Azure and support global MES program.
• Gather requirements from global site teams and translate to specs.
• Prepare CSV deliverables and validate reports per GMP and QMS.

Skills

Data analytics

Power BI

Stakeholder communication

Remote collaboration

Education

Bachelors in Computer Science / Information Systems / Engineering or equivalent

Tools

SQL Server

Oracle PL/SQL

Power Apps

Power Automate

Azure

Job description

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.
• Web development skills (HTML, JavaScript, C# or similar) for building internal tools.
• Experience supporting multiple manufacturing sites or global programs.
• Spanish proficiency is a plus.

Soft skills

• 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.