Data Analyst - IT II

Job Title: Data Analyst - IT II

Job Location - Irvine, CA

Duration - 18 months

Description

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

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) Monitoring

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.

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:

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.

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:

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 Qualifications

• Experience 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 Warehouses

• Azure Data Services

• SQL Server

• SAP BW/HANA

• Python or R for Analytics

• 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:

• 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.

• 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

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.

Pay rate: 50-55 USD per Hour Job type: Contract Division: eTeam Inc (US) Reference: 26-60202