Data Engineer / Data Analytics Specialist

JC Automation, Corp.; Carolina (PR); On-site; USD 90,000 - 120,000; Full time

Benefits offered by this job

Remote-friendly work environment

Job summary

JC Automation Corp. seeks a Data Engineer / Data Analytics Specialist to support global pharmaceutical manufacturing clients by implementing Rockwell PharmaSuite MES and replacing legacy MES.

You will design SQL views, build Power BI models, and deliver dashboards for manufacturing, quality and operations across multiple sites in a GxP-regulated environment. Strong English communication and remote-friendly collaboration are required.

Qualifications

• Bachelor’s degree in Computer Science, Information Systems, Engineering, or related field, or equivalent experience.
• Experience in regulated pharmaceutical or life sciences (GxP, 21 CFR Part 11).
• Strong SQL proficiency (T-SQL / SQL Server) and data modeling.
• Hands-on Power BI experience (Power Query, DAX, data modeling).
• 3+ years in data analytics or reporting, ideally in pharma/biotech/medical device manufacturing.

Responsibilities

• Design and develop analytical SQL views and data models on PharmaSuite MES data, following standards.
• Build and maintain Power BI semantic models, DAX measures, and dashboards for manufacturing and quality reporting.
• Gather, analyze, and document site requirements; manage changes through ALM and ServiceNow Change Requests.
• Produce GxP/GMP documentation: requirements, risk analyses, implementation guides, test evidence, source code reviews.
• Support deployments and site replication across DEV, TEST, PROD with environment verification.
• Troubleshoot data discrepancies, resolve incidents, and perform root cause analysis.
• Collaborate with global teams across time zones and cultures in English.

Skills

SQL

Power BI

Data analytics

GxP compliance

Education

Bachelor’s degree in Computer Science or related field

Tools

SQL Server

Power BI (Power Query, DAX)

Job description

OPERATIONS Full Time Carolina, PR, PR

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.

About Company:

Position overview

JC Automation (JCA) is seeking a Data Engineer / Data Analytics Specialist to join its team supporting global pharmaceutical manufacturing clients. This position implements Rockwell PharmaSuite MES at new manufacturing sites and replaces the legacy MES platform at existing ones. The Data Analytics work-stream delivers the analytical layer that turns MES data into reports, dashboards, and data products for manufacturing, quality, and operations users across multiple global sites.

Key responsibilities

A Data Engineer on the PharmaSuite MES program designs, develops, and maintains the data solutions that make PharmaSuite data available, reliable, and consumable for analysis and business operations. This person works with site stakeholders, MES teams, and data architects to translate manufacturing requirements into validated SQL views, reports, and dashboards in a GxP-regulated environment.

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

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

Preferred qualifications

• 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.
• 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 (English required).
• 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.
• Comfortable working remotely with teams across time zones.