Data Analyst: Transform SAP Data into Strategic Insights

Molex; Lisle (IL); On-site; USD 90,000 - 115,000; Full time

Job summary

Molex's Optical Connectivity Group is seeking a Data Analyst to transform SAP data into reliable insights that support portfolio, financial, resource, and operational decisions.

The role partners with engineering, product management, and finance to clean, standardize, and maintain data, establish trusted metrics, and translate findings into actionable recommendations that create value across the organization.

Qualifications

• Experience analyzing business, financial, operational, project, or portfolio data.
• Experience with SAP or a comparable ERP system.
• Experience cleaning, reconciling, validating, and interpreting data from multiple software systems.
• Advanced experience using Microsoft Excel or comparable analytical tools.
• Experience developing and applying business metrics, KPIs, and analytic methodologies.
• Demonstrated ability to investigate data discrepancies, determine root causes, and improve data quality.

Responsibilities

• Clean, standardize, reconcile, and validate data from SAP and other systems to improve accuracy and usability.
• Identify data gaps and quality issues; coordinate corrective actions with owners.
• Establish repeatable processes, business rules, and controls for data quality.
• Analyze data to identify trends, risks, performance gaps, and value opportunities.
• Link information across systems to create trusted views of performance.
• Develop and maintain definitions, KPIs, and calculation methods for critical data.
• Support portfolio prioritization, capital planning, forecasting, and resource allocation.
• Investigate drivers of results to explain why and what actions are needed.
• Reduce manual data collection and reporting via standardization and automation.
• Collaborate with leaders to translate questions into analytical requirements and solutions.
• Communicate complex findings to technical and non-technical audiences to drive action.

Skills

Analytical thinking

Business acumen

Problem solving

Cross-functional collaboration

Communication

Education

Bachelor's degree in data analytics or related field

Tools

SAP

SQL

Excel

Job description

Molex's Optical Connectivity Group is seeking a Data Analyst to transform SAP data into reliable insights that support portfolio, financial, resource, and operational decisions.

The role partners with engineering, product management, and finance to clean, standardize, and maintain data, establish trusted metrics, and translate findings into actionable recommendations that create value across the organization.