← Back to jobsJob ID col-cmwf4ssih039489hqrzy23eqv

JC AutomationPosted 9 days ago

Data Engineer / Data Analytics Specialist

Full-time
Remote
3+ years
Competitive
Posted 9 days ago

JC Automation is seeking a Data Engineer / Data Analytics Specialist to support pharmaceutical manufacturing clients implementing and replacing Rockwell PharmaSuite MES. The role builds and maintains validated data models, SQL views, reports, and Power BI dashboards that make manufacturing data reliable and usable for business operations.

Posted
9 days ago
Source
workforcenow.adp.com
Sector
Information Technology & AI

Opens the employer's application page in a new tab

Responsibilities

  • Design and develop analytical SQL views and data models on PharmaSuite MES data, following established corporate SQL and programming standards
  • Build and maintain Power BI semantic models, DAX measures, and dashboards for manufacturing and quality reporting (e.g., yield, defects, IPC, order status)
  • Gather, analyze, and document site requirements, and manage them through the change and validation lifecycle (ALM, ServiceNow Change Requests)
  • Produce GxP/GMP-compliant documentation: requirements, risk and impact analyses, implementation guides, test evidence, and source code reviews
  • Support deployments and site replication across environments (DEV, TEST, PROD) with strict environment verification
  • Troubleshoot data discrepancies, resolve RITMs and incidents, and perform root cause analysis
  • Optimize query performance and ensure data quality, integrity, and security
  • Collaborate with geographically dispersed teams across time zones and cultures, in English

Qualifications

  • 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 (GxP, GAMP 5, 21 CFR Part 11)
  • Strong SQL proficiency (T-SQL / SQL Server) and relational data modeling
  • Hands-on experience with Power BI (Power Query, DAX, data modeling)
  • 3+ years of experience in data analytics or reporting, ideally in pharmaceutical, biotech or medical device manufacturing
  • Knowledge of GAMP 5, 21 CFR Part 11 and data integrity (ALCOA+) principles
  • Fluent in English, written and spoken
  • Attention to detail and a strong quality mindset in a regulated setting
  • Clear written and verbal communication with technical and non-technical stakeholders
  • Ownership: able to manage multiple deliverables, dependencies, and deadlines
  • Curiosity and willingness to challenge assumptions with data
  • Clear communicator with technical and non-technical stakeholders
  • Self-directed and organized; able to manage several site deliverables at once

Preferred

  • 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; 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 practices, GitHub, and workflow automation (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 working with global sites
  • Electronic batch records (EBR)
  • Computer system validation (CSV)
  • SQL Server high availability
  • Always On Availability Groups

Required skills

21 CFR Part 11ALCOA+ Data IntegrityDAXData Analytics and ReportingGAMP 5GxP/GMPPower BIPower QueryRelational Data ModelingRockwell PharmaSuite MESSQL ServerT-SQL

Full job description

JC Automation is seeking a Data Engineer / Data Analytics Specialist to support pharmaceutical manufacturing clients implementing and replacing Rockwell PharmaSuite MES. The role builds and maintains validated data models, SQL views, reports, and Power BI dashboards that make manufacturing data reliable and usable for business operations.

Responsibilities

  • Design and develop analytical SQL views and data models on PharmaSuite MES data, following established corporate SQL and programming standards
  • Build and maintain Power BI semantic models, DAX measures, and dashboards for manufacturing and quality reporting (e.g., yield, defects, IPC, order status)
  • Gather, analyze, and document site requirements, and manage them through the change and validation lifecycle (ALM, ServiceNow Change Requests)
  • Produce GxP/GMP-compliant documentation: requirements, risk and impact analyses, implementation guides, test evidence, and source code reviews
  • Support deployments and site replication across environments (DEV, TEST, PROD) with strict environment verification
  • Troubleshoot data discrepancies, resolve RITMs and incidents, and perform root cause analysis
  • Optimize query performance and ensure data quality, integrity, and security
  • Collaborate with geographically dispersed teams across time zones and cultures, in English

Preferred

  • 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; 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 practices, GitHub, and workflow automation (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 working with global sites
  • MES platforms
  • Rockwell PharmaSuite
  • Batch records
  • Electronic batch records (EBR)
  • Manufacturing execution data
  • Computer system validation (CSV)
  • Validation documentation
  • Python
  • Data analysis
  • HTML
  • CSS
  • JavaScript
  • Azure
  • Azure SQL
  • Azure Web Apps
  • Azure AD authentication
  • SQL Server high availability
  • Always On Availability Groups
  • Denodo
  • Data virtualization
  • Agile practices
  • GitHub
  • Power Automate
  • Design patterns
  • Performance optimization
  • Deployment strategies
  • Data governance
  • Master data management
  • Business intelligence
  • Spanish
  • Portuguese
  • Japanese
  • Additional languages

Company

  • Life sciences automation, integration, and compliance consulting
  • Morristown, New Jersey, USA
  • https://jcapr.com/
  • Founded in 1997
  • 51-200 employees

Qualifications

  • 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 (GxP, GAMP 5, 21 CFR Part 11)
  • Strong SQL proficiency (T-SQL / SQL Server) and relational data modeling
  • Hands-on experience with Power BI (Power Query, DAX, data modeling)
  • 3+ years of experience in data analytics or reporting, ideally in pharmaceutical, biotech or medical device manufacturing
  • Knowledge of GAMP 5, 21 CFR Part 11 and data integrity (ALCOA+) principles
  • Fluent in English, written and spoken
  • Attention to detail and a strong quality mindset in a regulated setting
  • Clear written and verbal communication with technical and non-technical stakeholders
  • Ownership: able to manage multiple deliverables, dependencies, and deadlines
  • Curiosity and willingness to challenge assumptions with data
  • Clear communicator with technical and non-technical stakeholders
  • Self-directed and organized; able to manage several site deliverables at once
  • 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; 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 practices, GitHub, and workflow automation (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 working with global sites
  • 3+ years of experience in data analytics or reporting, ideally in pharmaceutical, biotech or medical device manufacturing.

Required skills

  • 21 CFR Part 11, ALCOA+ Data Integrity, DAX, Data Analytics and Reporting, GAMP 5, GxP/GMP, Pharmaceutical and Life Sciences Environments, Power BI, Power Query, Relational Data Modeling, Rockwell PharmaSuite MES, SQL Server, T-SQL

Experience

  • 3+ years

Job details

Employment type

Full-time

Seniority level

3+ years

Date posted

Nov 12, 2026

Work mode

Remote

Job source

workforcenow.adp.com

Company

JC Automation

Information Technology & AI

Life sciences automation, integration, and compliance consulting

  • Morristown, New Jersey, USA
  • Information Technology & AI
  • 51-200 employees
  • Founded 1997
  • jcapr.com

Similar jobs

Matched on role, skills and location · live jobs only

See more Analytics Engineer jobs

Energy

1d ago

New

Sr Data & Analytics Engineer

Full-timeRemoteUnited StatesCompetitive

Baltimore Aircoil Company (BAC) is hiring a Senior Data & Analytics Engineer to support and modernize enterprise data and analytics capabilities using Microsoft Fabric and Power BI.

Why similarSame roleDAXPower BI

MSRcosmos LLC

1d ago

New

Business Intelligence/Data Analytics Developer

Full-timeRemoteUnited StatesCompetitive

MSRcosmos LLC is hiring a Business Intelligence/Data Analytics Developer to modernize healthcare data warehouse reporting by converting SAP BusinessObjects reports and universes to Power BI.

Why similarSame roleDAXPower BI

System One

1d ago

New

Senior Data Engineer (Analytics & Applied AI)

TemporaryRemoteUnited StatesCompetitive

System One is recruiting for a contract-to-hire Senior Data Engineer to build and operate data platforms, cloud pipelines, and analytics systems.

Why similarSame role

Get new Analytics Engineer jobs by email

Create job alert

Data Engineer / Data Analytics Specialist

JC Automation · Competitive

Apply on company site