Process Data Engineer III - MSAT

Role Summary

Process Data Engineer III – MSAT based in Framingham, MA. The role focuses on designing, developing, and maintaining automated data systems, providing advanced analytics and system modeling support across manufacturing functions, and enabling data-driven decision making within MSAT.

Responsibilities

• Design, develop, and maintain robust ETL processes to integrate data from various sources
• Create and optimize data models to support business intelligence and analytics initiatives
• Collaborate with cross-functional teams to identify data requirements and deliver tailored solutions
• Implement data quality checks and ensure data integrity across all systems
• Develop and maintain documentation for data processes, models, and pipelines
• Continuously improve data infrastructure and processes to enhance performance and scalability
• Partner with internal stakeholders from multiple departments to identify opportunities for applying data engineering and process monitoring solutions for new manufacturing facilities
• Exploit opportunities to leverage manufacturing data to develop data engineering and ML models and real-time process monitoring approaches
• Translate data analytics outcomes to non-scientific audiences, champion data-driven decision making and empower end-users to perform simple analytics
• Support various stakeholders to ensure timely delivery of data engineering, visualization, ML and AI capabilities, with a focus on data integrity, validation, and governance

Qualifications

• Required: Bachelor's degree with 5+ years or Master's with 3+ years or PhD with 1 year of relevant experience in data sciences, computer sciences, chemical engineering, or related pharmaceutical field
• Required: Proficiency in SQL and experience with relational databases (e.g., MySQL, PostgreSQL)
• Required: Strong programming skills in Python or R
• Required: Experience with ETL tools and processes
• Preferred: Strong knowledge of data historian systems (e.g., Aspen IP21 or AVEVA PI AF & PI Event Frames), MES and IoT solutions
• Preferred: Familiarity with Snowflake, AWS, Azure, GitHub and no-code/low-code tools such as Dataiku
• Preferred: Experience developing data visualization platforms (Power BI, R Shiny, Streamlit)
• Experience with SAP data and use of transactional and genealogical data for data contextualization
• Experience in writing reports and knowledge management documentation

Skills

• Data engineering
• Data modeling
• ETL development
• Data quality and governance
• Data visualization
• ML/enhanced analytics
• Cross-functional collaboration
• Communication of analytics to non-technical audiences

Education

• BS in data sciences, computer sciences, chemical engineering or related field; or MS/PhD with relevant experience

Additional Requirements

• Hybrid work arrangement: 3 days per week in Framingham, MA is required