Data Architect Operational Analytics & MES Integration

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. As we continue to grow, 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 supportensuring clean, connected, and contextualized data from MES (Rockwell PharmaSuite), SQL databases, and Power BI to empower decision-makers across operations, quality, and leadership teams.

Key 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 stakeholdersoperators to senior leadershipand 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.