Title: Business Analyst - Manufacturing Operations (Medical Device Manufacturing)
Summary:
- The 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 Responsibilities:
1. Data Analysis & Reporting:
- Extract, cleanse, validate, and analyze data from:
- SAP ERP
- Siemens MES
- Data warehouses and reporting databases
- Quality and manufacturing systems
- Develop recurring operational reports and analytics related to:
- Material Inventory
- Purchase Price Variance (PPV)
- Manufacturing Cycle Time
- Work Order Performance
- Material Over-Issue
- Scrap and Yield Performance
- Capacity Utilization
- Production Throughput
- Labor Productivity
- Plan Attainment
- MRB (Material Review Board) Monitorin
- Analyze manufacturing trends and identify opportunities to:
- Improve inventory utilization
- Reduce manufacturing lead times
- Reduce material consumption variances
- Improve schedule adherence
- Improve operational efficiency
- Perform ad hoc analysis for Operations Leadership and Plant Management.
2. SAP & Siemens MES Analytics:
- Utilize 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.
3. Inventory & Materials Analysis:
- Track and analyze:
- Raw Material Inventory
- Work-in-Process (WIP)
- Finished Goods Inventory
- Excess and Obsolete Inventory
- Inventory Accuracy
- Material Consumption Trends
- Material Over-Issue Trends
- Inventory Aging
- Support Supply Chain and Manufacturing teams in inventory optimization initiatives.
4. Financial & Variance Analysis:
- Monitor Purchase Price Variance (PPV) and identify key drivers.
- Analyze manufacturing cost variances.
- Develop monthly variance reports and management summaries.
5. Manufacturing Performance & Plan Attainment:
- Develop and maintain dashboards and scorecards for:
- Daily Plan Attainment
- Weekly Production Performance
- Monthly Manufacturing Metrics
- Schedule Adherence
- First Pass Yield (FPY)
- Production Throughput
- Cycle Time
- Capacity Utilization
- Provide daily, weekly, and monthly reporting packages for plant leadership.
6. Dashboard Development & Visualization:
- Design and maintain executive and operational dashboards.
- Create automated reporting tools using:
- Microsoft Power BI
- Tableau
- SAP Analytics Cloud
- Excel Power Query/Power Pivot
- Echelon AI Dashboards
- Present complex data in a concise and business-friendly format.
- Develop KPI scorecards, trend charts, heat maps, and executive summaries.
7. Continuous Improvement:
- Collaborate 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.
Key Competencies:
- Analytical Excellence:
- Ability to interpret large and complex data sets.
- Strong business intelligence and analytical thinking.
- Ability to identify trends, risks, and opportunities quickly.
- Communication:
- Excellent presentation skills.
- Ability to communicate findings to all levels of the organization.
- Experience presenting to plant leadership and executive management.
- Business Partnership: Ability to work cross-functionally with:
- Manufacturing
- Engineering
- Quality
- Finance
- Supply Chain
- Leadership Teams
- Problem Solving:
- Strong investigative mindset.
- Ability to identify root causes and implement sustainable solutions.
- Ability to prioritize multiple business-critical projects simultaneously.
Required:
Education:
Bachelor's Degree in:
- Business Analytics
- Industrial Engineering
- Supply Chain Management
- Operations Management
- Finance
- Manufacturing Engineering
- Data Analytics
- Related discipline
Experience:
- 3–7+ years of experience in:
- Manufacturing Analytics.
- Operations Analysis.
- Supply Chain Analysis.
- Manufacturing Planning.
- Medical Device Manufacturing or highly regulated industries.
- Experience working within:
- FDA-regulated environments.
- ISO 13485 environments.
- Medical Device Manufacturing preferred.
Required Technical Skills:
Enterprise Systems:
- Strong SAP ERP experience including:
- MM (Materials Management)
- PP (Production Planning)
- WM/EWM (Warehouse Management)
- CO (Controlling)
- Inventory Management
- Experience with Siemens MES systems such as:
- Opcenter MES
- SIMATIC IT
- Camstar (preferred)
Reporting & Analytics:
- Advanced Microsoft Excel
- Pivot Tables
- Power Query
- Power Pivot
- VBA (preferred)
- Power BI Dashboard Development
- SQL Query Development
- Data Modeling
- Statistical Analysis
- KPI Development
Business Analysis Skills:
- Trend Analysis
- Root Cause Analysis
- Variance Analysis
- Forecasting
- Manufacturing KPI Management
- Data Visualization
- Process Mapping
- Executive Reporting
Preferred:
- Experience in Medical Device Manufacturing.
- Certified Business Analysis Professional (CBAP).
- APICS CPIM or CSCP Certification.
- Lean Six Sigma Green Belt or Black Belt.
- SAP Certification.
- Experience with:
- Data Warehouses
- Azure Data Services
- SQL Server
- SAP BW/HANA
- Python or R for Analytics
- AI-driven analytics tools