I.T. For Less
Description
Key Responsibilities
- Develop and maintain Tableau dashboards and data visualizations for the EMDA project—a GMP-validated analytics platform deployed across global manufacturing sites.
- Use Tableau Prep for data cleaning, shaping, and blending prior to visualization.
- Build and optimize data models using Oracle, Snowflake, and SQL Server to support EMDA analytics.
- Manage Tableau Server administration, including user provisioning and permission management.
- Configure and deploy Tableau workbooks (.twbx), and manage deployment paths across environments.
- Use Postman to test and validate API endpoints for data integration and automation.
- Collaborate with EMDA BTAMS support for security updates and Oracle procedures.
- Support heatmap visualizations and environmental trend analysis across sites.
- Work in Agile teams with cross-functional collaboration across Quality, Laboratory, and Manufacturing.
- Integrate Tableau dashboards with other applications under EMDA scope.
Required Skills
|
Skill |
Experience Required |
| Tableau Desktop & Server | Advanced dashboard dev, publishing, performance – 7 Yrs |
| Tableau Prep | Data prep for structured/semi-structured sources – 3 Yrs |
| Postman | API testing & validation for Tableau/data pipelines – 3 Yrs |
| SQL & Databases (Oracle, SQL, Snowflake) | Strong querying skills – 7 Yrs |
| ETL Coordination | PLP job dependencies, refresh windows – 5 Yrs |
| Validation & Compliance | GMP environments, SOPs, ADLC – 3 Yrs |
| Visualization Design | Heatmaps, trends, microbiological overlays – 7 Yrs |
Solution Overview
Environmental Monitoring Data Analytics (EMDA) is a GMP-validated enterprise solution built to automate the collection, trending, and reporting of environmental monitoring (EM) data across the client's global manufacturing network. It enhances regulatory compliance, contamination control, and operational efficiency by turning complex EM data into actionable insights.
Deployed at 25+ sites, EMDA integrates with systems such as:
- MODA, gLIMS, LabWare, and SQL Server
- Used for both routine monitoring and deviation investigations
Key Modules:
- EM Analytics Module
- MODA Trend Check & History Tool
- Heatmap Insights
- Utility/Water Trending
- Automated Reports
- Aseptic Site Risk Assessment Tool (ASRAT)
- 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