Data Architect Operational Analytics & MES Integration

PharmEng Technology; Barcelona; Presencial; EUR 60.000 - 80.000; Jornada completa

Descripción de la vacante

A leading consulting firm in pharmaceuticals seeks a Data Architect to design and manage data systems that support manufacturing operations and analytics. This full-time role requires expertise in SQL and Power BI, with a focus on integrating diverse data sources. Ideal candidates will have strong communication skills and experience in the life sciences sector. Join a dynamic team and contribute to innovative solutions within the industry.

Servicios

Competitive compensation

Opportunities for professional growth

Dynamic work environment

Formación

• 4 years of hands-on experience in data analytics, preferably in manufacturing, life sciences, or pharmaceuticals.
• Proficient in SQL (views, stored procedures, query tuning).
• Proven experience with Power BI (data modeling, DAX, dashboard design).

Responsabilidades

• Design and implement a structured scalable data architecture linking MES, ERP, LIMS, and SCADA systems.
• Develop and maintain Power BI dashboards providing real-time insights into production metrics.
• Identify inefficiencies in data workflows and lead efforts for resolution.

Conocimientos

SQL

Data Analytics

Power BI

Data Integration

Cross-functional Communication

Educación

Bachelors or Masters degree in Data Science, Computer Science, Engineering

Herramientas

SQL Server

Rockwell PharmaSuite

Python

Descripción del empleo

Overview

PharmEng / Efor is a leading pharmaceutical and biopharmaceutical consulting firm committed to providing innovative solutions to the challenges facing our industries. We pride ourselves on our dedication to quality safety and excellence in everything we do. We are seeking a highly qualified and motivated Data Architect to join our team.

Job Title: Data Architect Operational Analytics & MES Integration

Location: Spain and France

Position Overview

We are seeking a hands-on business-savvy Data Architect to lead the design development and ongoing management of data systems that support daily manufacturing operations and performance analytics. This role blends strategic data architecture with daily tactical support ensuring clean connected and contextualized data from MES (Rockwell PharmaSuite) SQL databases and Power BI to empower decision-makers across operations quality and leadership teams.

Responsibilities

• Data Architecture & Integration (Strategic):
  • Design and implement a structured scalable data architecture linking MES ERP LIMS and SCADA systems.
  • Build and manage SQL-based data pipelines and ETL processes to support manufacturing analytics and compliance reporting.
  • Establish data standards definitions and governance protocols to ensure high data quality and consistency.
• Analytics & Daily Operations Support:
  • Develop and maintain Power BI dashboards that provide real-time insights into production metrics (e.g. batch cycle times downtime OEE quality deviations).
  • Serve as the day-to-day go-to for operations QA and engineering teams for data troubleshooting ad hoc reporting and system data queries.
  • Collaborate with floor personnel to translate real-world process challenges into data-driven solutions.
  • Monitor daily data feeds and alerts from MES and other systems to proactively address data gaps or process disruptions.
• Process Optimization & Continuous Improvement:
  • Identify inefficiencies or blind spots in current data workflows and lead efforts to resolve them with better automation analytics or data visibility.
  • Support and participate in Lean Six Sigma or continuous improvement initiatives with data analysis and visualization.
  • Conduct root cause data investigations and recommend system or process changes.

Qualifications

• Bachelors or Masters degree in Data Science Computer Science Engineering or related field.
• 4 years of hands-on experience in data analytics preferably within manufacturing life sciences or pharmaceuticals.
• Proficient in SQL (views stored procedures query tuning) and relational database management (e.g. SQL Server).
• Proven experience with Power BI (data modeling DAX dashboard design publishing).
• Experience working with Rockwell PharmaSuite or other MES platforms (functional knowledge sufficient for integrating / reporting).
• Ability to engage with cross-functional stakeholders—operators to senior leadership—and translate data into actionable insights.

Preferred Skills

• Familiarity with GxP cGMP and FDA data integrity requirements.
• Understanding of ISA-95 hierarchy and MES-to-ERP integration.
• Experience with scripting or automation tools (e.g. Python Power Automate) a plus.
• Comfortable in fast-paced hands-on environments where priorities shift based on operational needs.

Join Us

If you are a dedicated and highly motivated individual with a passion for ensuring the highest standards of Engineering and Quality in the Pharmaceutical Industry we encourage you to apply. PharmEng / Efor offers a dynamic and inclusive work environment competitive compensation and opportunities for professional growth. Join our team and contribute to the success of our industry-leading solutions.

PharmEng / Efor is an equal opportunity employer and welcomes candidates of all backgrounds to apply.

Thank you for your consideration and application! We review all resumes and submissions; however due to the high volume of applications we receive only successful candidates will be contacted.

Key Skills

Active Directory Administration, Logistics Operations, Bar Management, Advertising Sales, Drafting, Inventory Management

Employment Details

Employment Type: Full Time

Experience: years

Vacancy: 1