IT - Data Analyst - IT II

Data Analysis & Reporting
• Extract, cleanse, validate, and analyze data from:
o SAP ERP
o Siemens MES
o Data warehouses and reporting databases
o Quality and manufacturing systems
• Develop recurring operational reports and analytics related to:
o Material Inventory
o Purchase Price Variance (PPV)
o Manufacturing Cycle Time
o Work Order Performance
o Material Over-Issue
o Scrap and Yield Performance
o Capacity Utilization
o Production Throughput
o Labor Productivity
o Plan Attainment
o MRB (Material Review Board) Monitorin
• Analyze manufacturing trends and identify opportunities to:
o Improve inventory utilization
o Reduce manufacturing lead times
o Reduce material consumption variances
o Improve schedule adherence
o Improve operational efficiency
• Perform ad hoc analysis for Operations Leadership and Plant Management.
________________________________________
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.
________________________________________
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.
________________________________________
Financial & Variance Analysis
• Monitor Purchase Price Variance (PPV) and identify key drivers.
• Analyze manufacturing cost variances.
Develop monthly variance reports and management summaries.
________________________________________
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.
________________________________________
Dashboard Development & Visualization
• Design and maintain executive and operational dashboards.
• Create automated reporting tools using:
o Microsoft Power BI
o Tableau
o SAP Analytics Cloud
o Excel Power Query/Power Pivot
o Echelon AI Dashboards
• Present complex data in a concise and business-friendly format.
• Develop KPI scorecards, trend charts, heat maps, and executive summaries.
________________________________________
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.
________________________________________
Required Qualifications
Education
• Bachelor's Degree in:
o Business Analytics
o Industrial Engineering
o Supply Chain Management
o Operations Management
o Finance
o Manufacturing Engineering
o Data Analytics
o Related discipline
________________________________________
Experience
• 3–7+ years of experience in:
o Manufacturing Analytics
o Operations Analysis
o Supply Chain Analysis
o Manufacturing Planning
o Medical Device Manufacturing or highly regulated industries
• Experience working within:
o FDA-regulated environments
o ISO 13485 environments
o Medical Device Manufacturing preferred
________________________________________
Required Technical Skills
Enterprise Systems
• Strong SAP ERP experience including:
o MM (Materials Management)
o PP (Production Planning)
o WM/EWM (Warehouse Management)
o CO (Controlling)
o Inventory Management
• Experience with Siemens MES systems such as:
o Opcenter MES
o SIMATIC IT
o Camstar (preferred)
________________________________________
Reporting & Analytics
• Advanced Microsoft Excel
o Pivot Tables
o Power Query
o Power Pivot
o 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 Qualifications
• 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:
o Data Warehouses
o Azure Data Services
o SQL Server
o SAP BW/HANA
o Python or R for Analytics
o AI-driven analytics tools
________________________________________
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:
o Manufacturing
o Engineering
o Quality
o Finance
o Supply Chain
o Leadership Teams
Problem Solving
• Strong investigative mindset.
• Ability to identify root causes and implement sustainable solutions.
• Ability to prioritize multiple business-critical projects simultaneously.
________________________________________
Key Performance Indicators (KPIs)
The Business Analyst will be evaluated on their ability to improve visibility and decision-making around:
• Plan Attainment %
• Manufacturing Cycle Time
• Inventory Accuracy
• Inventory Turns
• Material Over-Issue %
• Purchase Price Variance (PPV)
• MRB New Cases
• MRB Processing Time
• MRB Aging
• Production Throughput
• Schedule Adherence
• First Pass Yield (FPY)
• Dashboard Adoption and Utilization
• Report Accuracy and Timeliness
________________________________________
Ideal Candidate Profile
A successful candidate combines strong manufacturing business knowledge with advanced analytical skills and hands-on experience using SAP and Siemens MES systems. They are highly proficient in transforming raw manufacturing data into actionable insights, developing executive dashboards, and driving operational improvements across inventory management, production performance, material utilization, quality metrics, and financial variances within a regulated medical device manufacturing environment.

Soft Skills & Leadership Competencies
In addition to the technical and analytical qualifications, the Business Analyst should demonstrate the following soft skills:
Communication & Presentation Skills
• Ability to communicate complex data and analytical findings in a clear, concise, and actionable manner.
• Excellent written, verbal, and presentation skills.
• Comfortable presenting operational performance metrics and recommendations to all levels of the organization, including senior leadership.
• Ability to translate technical data into business-focused insights.
Collaboration & Relationship Building
• Strong ability to build effective partnerships across Manufacturing, Supply Chain, Quality, Engineering, Finance, and Operations leadership teams.
• Demonstrated ability to influence stakeholders without direct authority.
• Skilled at facilitating discussions and aligning cross-functional teams around common objectives.
• Establishes credibility as a trusted advisor and business partner.
Critical Thinking & Problem Solving
• Naturally curious with a continuous improvement mindset.
• Ability to identify trends, uncover root causes, and recommend data-driven solutions.
• Strong analytical reasoning and decision-making capabilities.
• Proactively identifies operational risks and improvement opportunities before they become significant issues.
Business Acumen
• Understanding of the relationship between manufacturing performance, inventory management, quality, and financial outcomes.
• Ability to connect operational metrics with business goals and strategic objectives.
• Capable of balancing short-term operational needs with long-term process improvement initiatives.
Organizational & Time Management Skills
• Ability to manage multiple priorities and deadlines simultaneously in a fast-paced manufacturing environment.
• Strong project management and organizational skills.
• Detail-oriented while maintaining a focus on broader business objectives.
• Ability to work independently with minimal supervision.
Adaptability & Learning Agility
• Comfortable working in a rapidly changing manufacturing and business environment.
• Willingness to learn new systems, technologies, and analytical tools.
• Flexible and resilient when responding to changing business priorities.
• Ability to quickly adapt reporting and dashboards to meet evolving organizational needs.
Leadership Presence
• Demonstrates ownership and accountability for deliverables.
• Leads through influence and data-driven recommendations.
• Acts with professionalism, integrity, and sound judgment.
• Supports a culture of operational excellence, continuous improvement, and collaboration.
Customer Focus
• Maintains a strong internal customer service mindset.
• Understands stakeholder needs and delivers timely, accurate, and actionable information.
• Ensures reporting and dashboards provide meaningful business value and support decision-making.
________________________________________
Preferred Candidate Profile
The ideal candidate is a highly analytical and collaborative professional who can effectively partner with manufacturing and business leaders, leverage SAP and Siemens MES data to generate actionable insights, build executive dashboards, and drive continuous improvement initiatives. They possess a strong blend of technical expertise, business acumen, communication skills, and leadership presence necessary to influence decisions and improve operational performance within a regulated medical device manufacturing environment.

EEO:

“Mindlance is an Equal Opportunity Employer and does not discriminate in employment on the basis of – Minority/Gender/Disability/Religion/LGBTQI/Age/Veterans.”