Remote Pharma 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

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.