Data Analyst - IT II

Data Analyst - IT IIThe Business Analyst – Manufacturing Operations is responsible for collecting, analyzing, interpreting, and presenting manufacturing and supply chain data to drive operational performance across a regulated medical device manufacturing environment. This role serves as a key business partner to Manufacturing, Supply Chain, Quality, Finance, Engineering, and Materials Management teams by utilizing SAP ERP and Siemens Manufacturing Execution System (MES) data to identify trends, improve visibility, and support data-driven decision making.The position requires strong analytical capabilities, business acumen, and experience with manufacturing systems to monitor key performance indicators (KPIs), identify opportunities for improvement, and develop executive-level dashboards and reports that support plant objectives.Key ResponsibilitiesData Analysis & ReportingExtract, cleanse, validate, and analyze data from:SAP ERPSiemens MESData warehouses and reporting databasesQuality and manufacturing systemsDevelop recurring operational reports and analytics related to:Material InventoryPurchase Price Variance (PPV)Manufacturing Cycle TimeWork Order PerformanceMaterial Over-IssueScrap and Yield PerformanceCapacity UtilizationProduction ThroughputLabor ProductivityPlan AttainmentMRB (Material Review Board) MonitoringAnalyze manufacturing trends and identify opportunities to:Improve inventory utilizationReduce manufacturing lead timesReduce material consumption variancesImprove schedule adherenceImprove operational efficiencyPerform ad hoc analysis for Operations Leadership and Plant Management.SAP & Siemens MES AnalyticsUtilize SAP and Siemens MES systems to retrieve and analyze manufacturing and inventory data.Develop automated reporting solutions that integrate ERP and MES data sources.Reconcile inventory, production, and transaction records across systems.Monitor manufacturing execution metrics and identify process bottlenecks.Support data integrity initiatives for manufacturing transactions and master data.Inventory & Materials AnalysisTrack and analyze:Raw Material InventoryWork-in-Process (WIP)Finished Goods InventoryExcess and Obsolete InventoryInventory AccuracyMaterial Consumption TrendsMaterial Over-Issue TrendsInventory AgingSupport Supply Chain and Manufacturing teams in inventory optimization initiatives.Financial & Variance AnalysisMonitor Purchase Price Variance (PPV) and identify key drivers.Analyze manufacturing cost variances.Develop monthly variance reports and management summaries.Manufacturing Performance & Plan AttainmentDevelop and maintain dashboards and scorecards for:Daily Plan AttainmentWeekly Production PerformanceMonthly Manufacturing MetricsSchedule AdherenceFirst Pass Yield (FPY)Production ThroughputCycle TimeCapacity UtilizationProvide daily, weekly, and monthly reporting packages for plant leadership.Dashboard Development & VisualizationDesign and maintain executive and operational dashboards.Create automated reporting tools using:Microsoft Power BITableauSAP Analytics CloudExcel Power Query/Power PivotEchelon AI DashboardsPresent complex data in a concise and business-friendly format.Develop KPI scorecards, trend charts, heat maps, and executive summaries.Continuous ImprovementCollaborate with Manufacturing, Engineering, Quality, and Supply Chain teams to identify performance improvement opportunities.Support Lean Manufacturing and Continuous Improvement initiatives.Conduct root cause analysis and trend analysis.Develop recommendations to improve operational efficiency and plant performance.Required QualificationsEducationBachelor's Degree in:Business AnalyticsIndustrial EngineeringSupply Chain ManagementOperations ManagementFinanceManufacturing EngineeringData AnalyticsRelated disciplineExperience3–7 years of experience in:Manufacturing AnalyticsOperations AnalysisSupply Chain AnalysisManufacturing PlanningMedical Device Manufacturing or highly regulated industriesExperience working within:FDA-regulated environmentsISO 13485 environmentsMedical Device Manufacturing preferredRequired Technical SkillsEnterprise SystemsStrong SAP ERP experience including:MM (Materials Management)PP (Production Planning)WM/EWM (Warehouse Management)CO (Controlling)Inventory ManagementExperience with Siemens MES systems such as:Opcenter MESSIMATIC ITCamstar (preferred)Reporting & AnalyticsAdvanced Microsoft ExcelPivot TablesPower QueryPower PivotVBA (preferred)Power BI Dashboard DevelopmentSQL Query DevelopmentData ModelingStatistical AnalysisKPI DevelopmentBusiness Analysis SkillsTrend AnalysisRoot Cause AnalysisVariance AnalysisForecastingManufacturing KPI ManagementData VisualizationProcess MappingExecutive ReportingPreferred QualificationsExperience in Medical Device Manufacturing.Certified Business Analysis Professional (CBAP).APICS CPIM or CSCP Certification.Lean Six Sigma Belt or Black Belt.SAP Certification.Experience with:Data WarehousesAzure Data ServicesSQL ServerSAP BW/HANAPython or R for AnalyticsAI-driven analytics toolsKey CompetenciesAnalytical ExcellenceAbility to interpret large and complex data sets.Strong business intelligence and analytical thinking.