Senior Developer – EMDA Analytics (ETL, Biovia Pipeline Pilot)

About the Role :

We are seeking a highly skilled ETL Developer to join our EMDA (Environmental Monitoring Data Analytics) team. The role focuses on developing, deploying, and maintaining ETL workflows for a GMP-validated platform used across Pfizer’s global manufacturing sites. The candidate will work with Biovia Pipeline Pilot, integrating data from multiple sources, ensuring high-quality data analytics, and supporting environmental monitoring initiatives.

Key Responsibilities :

Design, develop, and optimize ETL protocols using Biovia Pipeline Pilot v2017R2 to extract, transform, and load data from lab systems (gLIMS, MODA, LabWare, Thermo Fisher) and flat files (Excel, CSV).

Configure and maintain ETL parameters including target DB environments (Dev, Test, Stage, Prod), data classes, study identifiers, folder paths, and runtime settings.

Integrate and transform data into the Oracle 19c business layer , ensuring data quality and compliance with GMP standards.

Troubleshoot ETL failures, protocol errors, ODBC connectivity issues, and Oracle-specific exceptions.

Collaborate with DBAs and EMDA support teams to resolve data access, performance, and integration issues.

Support audit trail retrieval , data verification processes, and validation documentation (ADLC plans, SOPs, design specifications).

Participate in Agile development cycles and contribute to continuous improvement initiatives.

Interpret environmental monitoring data and support EMDA modules including :

Heatmaps

MODA History & Trend Check

Utility / Water Trending

Automated Reports

ASRAT (Aseptic Site Risk Assessment Tool)

Skills & Qualifications :

Strong experience with Biovia Pipeline Pilot and ETL workflow design.

Proficient in Oracle 19c, SQL Server , and working with flat file data sources.

Experience with lab systems integration (gLIMS, MODA, LabWare, Thermo Fisher).

Strong troubleshooting skills for ETL and database-related issues.

Knowledge of GMP regulations , environmental monitoring data, and validation documentation.

Agile development experience and collaborative mindset.

Preferred Experience :

Prior experience in pharmaceutical or biotech environments .

Hands-on experience with EMDA modules and data visualization tools.