About the role
Senior Developer - EMDA Analytics - Tableau, Snowflake, Data Modeler
EMDA (Environmental Monitoring Data Analytics) - Tableau, Snowflake, SQL, Oracle
3-Expert
Seeking Tableau developer with strong experience in relational database and who have explored advanced Tableau concepts, particularly around Tableau Cloud , API usage, and extension capabilities to support the development and maintenance of dashboards and data visualizations for the EMDA project, a GMP-validated analytics platform used across global manufacturing sites. The ideal candidate will have strong Tableau expertise, database modeling skills, and hands-on experience with Tableau Prep and API testing tools like Postman.
- Design, develop, and maintain Tableau dashboards for EMDA Stage and Production environments.
- Use Tableau Prep to clean, shape, and blend data before visualization.
- Build and optimize data models for Oracle, Snowflake, and SQL Server to support EMDA analytics.
- Configure and manage Tableau workbooks (.twbx) and deployment paths:
- Administer Tableau Server , including user provisioning and permission management.
- Use Postman to test and validate API endpoints for data integration and automation.
- Collaborate with EMDA BTAMS support team for security updates and Oracle procedures .
- Support heatmap visualizations and environmental trend analysis across sites.
- Participate in Agile ceremonies and collaborate with cross-functional teams including Quality, Laboratory Solutions, and Manufacturing.
- Integrate Tableau dashboard with other applications with EMDA scope.
- Tableau Desktop & Server: Advanced dashboard development, publishing, and performance tuning- 7 Yrs
- Tableau Prep: Data preparation workflows for structured and semi-structured sources. - 3 Yrs
- Postman: API testing and integration validation for Tableau refresh and data pipelines. - 3 Yrs
- SQL & Databases: Strong querying skills in Oracle, SQL Server, and Snowflake. - 7 Yrs
- ETL Coordination: Understanding of PLP job dependencies and refresh windows - 5 yrs
- Validation & Compliance: Familiarity with GMP environments, SOPs, and ADLC processes. - 3 Yrs
- Visualization Design: Experience with heatmaps, trend charts, and microbiological data overlays - 7 Yrs
Solution Overview:
Environmental Monitoring Data Analytics (EMDA) is a GMP-validated enterprise solution developed to automate the collection, trending, and reporting of environmental monitoring (EM) data across Pfizer’s global manufacturing sites. It supports contamination control, regulatory compliance, and operational efficiency by transforming complex EM datasets into actionable insights.
EMDA is deployed across 25+ sites and integrates with systems like MODA, gLIMS, LabWare, and SQL Server to streamline data access and visualization. It supports both routine monitoring and deviation investigations, enabling stakeholders to focus on risk mitigation rather than manual data handling.
1. EM Analytics Module
2. MODA Trend Check & History Tool
3. Heatmap Insights
4. Utility/Water Trending
5. Automated Reports
6. Aseptic Site Risk Assessment Tool (ASRAT)
7. Advanced Business Process Trending
Technologies Used
Frontend: React JS, Tableau
Backend: .NET Core, Web API, Windows Services
ETL & Data Access: Pipeline Pilot (PLP), MODA integrations
Databases: Oracle 19C, SQL Server 2016
Document Generation: Aspose, ClosedXML