Data Engineer / Data Analytics Specialist
21 Cfr Part 11
Automation Developer
Business Analytics
Business Intelligence
Business Intelligence Tools
Cloud Platform
Cloud Platforms
Data Analytics
Data Analytics Tools
Data Engineer
Data Management
Data Modeling
Data Visualization
DAX
Gmp (good Manufacturing Practices)
Gxp
Hr Technology
Information Technology (IT)
Microsoft
Microsoft 365
Microsoft Office
Microsoft Power Platform
Office 365
Power BI
Power Platform
Product Management
Programming
Reporting and Analytics
Software Development
SQL
Job Description
JC Automation Corp supports global pharmaceutical manufacturing clients with data and reporting solutions around Rockwell PharmaSuite MES. In this onsite role in Carolina, PR, you will design, validate, and operate SQL and Power BI analytics that help manufacturing, quality, and operations teams work with consistent, GxP-aligned data.
This position focuses on building and maintaining validated data models and dashboards in a GxP-regulated environment, supporting change management, documentation, deployments, and troubleshooting across development, test, and production environments.
Responsibilities
- Design and develop analytical SQL views and data models on PharmaSuite MES data using established corporate SQL and programming standards.
- Build and maintain Power BI semantic models, DAX measures, and dashboards for manufacturing and quality reporting (including yield, defects, IPC, and order status).
- Collect, analyze, and document site requirements, managing them through the change and validation lifecycle via ALM and ServiceNow Change Requests.
- Create GxP/GMP-compliant documentation, including requirements, risk and impact analyses, implementation guides, test evidence, and source code reviews.
- Support deployments and site replication across DEV, TEST, and PROD, ensuring strict environment verification.
- Troubleshoot data discrepancies, resolve RITMs and incidents, and conduct root cause analysis.
- Optimize query performance while ensuring data quality, integrity, and security.
- Collaborate with geographically dispersed teams across time zones and cultures in English.
Requirements
- 3+ years of experience in data analytics or reporting, ideally in pharmaceutical, biotech, or medical device manufacturing.
- 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 including GxP, GAMP 5, and 21 CFR Part 11.
- Strong SQL proficiency (including T-SQL and SQL Server) and relational data modeling skills.
- Hands-on experience with Power BI including Power Query, DAX, and data modeling.
- Knowledge of GAMP 5, 21 CFR Part 11, and data integrity principles including ALCOA+.
- Fluent English in written and spoken communication.
Technologies
- Rockwell PharmaSuite MES, SQL, T-SQL, SQL Server, Power BI, Power Query, DAX
- ALM, ServiceNow Change Requests, GxP, GMP, GAMP 5, 21 CFR Part 11, ALCOA+
- DEV, TEST, PROD, RITMs
- Azure SQL, Azure Web Apps, Azure AD authentication, Always On Availability Groups
- Denodo, Python, HTML, CSS, JS, GitHub
- Power Automate, CSV, Agile, EBR, batch records, MES
- Data Governance, Master Data Management, Business Intelligence, MES platforms, Rockwell PharmaSuite
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, plus familiarity with HTML/CSS/JS for lightweight web tools.
- Cloud experience, preferably Azure, including Azure SQL, Azure Web Apps, and Azure AD authentication.
- Familiarity with SQL Server high availability (including Always On Availability Groups) and Denodo or other data virtualization layers.
- Experience with Agile practices, GitHub, and workflow automation (including 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, while English remains required.
Soft Skills
- 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.
- Self-directed and organized, able to handle several site deliverables at once.
- Comfortable working remotely with teams across time zones.