In short
Data analyst role at XP Power in Singapore focused on supply chain analytics: querying large datasets with SQL from SAP S/4HANA, building Power BI dashboards, automating reports, leading root-cause investigations, and applying AI/predictive analytics to demand planning, inventory and supplier performance.
About the role
As a supply chain data analyst, your key areas of focus:
1. Data Analysis and Interrogation
- Extract, manipulate and analyse large datasets from multiple sources, including ERP systems such as SAP S/4HANA.
- Use SQL to query databases, join multiple tables, manipulate data and investigate complex business questions.
- Identify trends, patterns, correlations, anomalies and emerging risks within Supply Chain data.
- Develop robust analytical models to support demand and supply planning, inventory optimisation, supplier performance, delivery performance and operational efficiency.
- Validate data quality, investigate discrepancies and establish confidence in the accuracy and integrity of analytical outputs.
- Translate complex datasets into clear, concise insights and recommendations for both technical and non-technical stakeholders.
2. Business Intelligence and Reporting
- Design, develop and maintain interactive BI dashboards and reports, using tools such as Power BI.
- Automate recurring reports and manual analytical processes to improve efficiency, consistency and scalability.
- Build drill-down reporting capabilities that enable users to move beyond high-level KPIs and identify underlying causes of performance gaps.
- Ensure reporting provides actionable insights and supports operational reviews and strategic decision-making.
3. Root Cause Analysis and Problem Solving
- Lead data-driven investigations into Supply Chain performance issues, moving beyond identifying symptoms to establish underlying root causes.
- Investigate recurring material shortages, late deliveries, inventory imbalances, excess stock, planning exceptions and service-level failures.
- Segment performance issues by supplier, material, product family, site, customer, planner, time period and other relevant dimensions to identify common drivers.
- Apply structured problem-solving techniques, including Pareto analysis, trend analysis, correlation analysis and hypothesis testing.
- Distinguish between isolated incidents and systemic process or parameter issues.
- Quantify the operational and financial impact of identified root causes, including service, production continuity, inventory and working capital.
- Develop repeatable analytical approaches that enable the business to identify and address issues proactively rather than reactively.
4. AI and Advanced Analytics
- Identify and implement opportunities to use AI tools to accelerate data analysis, automate repetitive tasks and improve insight generation.
- Use AI-assisted analytical techniques to support trend identification, anomaly detection, data interpretation and hypothesis generation.
- Explore opportunities to develop predictive analytics and early-warning indicators for Supply Chain risks, such as potential material shortages, supplier delays and inventory exposure.
- Use AI tools to improve the efficiency of SQL development, report creation, documentation and analytical workflows, validating outputs before business use.
5. Continuous Improvement and Business Partnering
- Partner with Supply Chain teams to understand business challenges and translate operational questions into analytical solutions.
- Proactively identify opportunities for process improvement through data analysis rather than relying solely on stakeholder requests.
- Support Supply Chain improvement projects by establishing baselines, quantifying opportunities and measuring realised benefits.
- Develop standardised analytical tools and repeatable reporting processes that reduce manual effort and improve decision-making.
- Present findings, recommendations and improvement opportunities to operational teams and senior stakeholders.
Required Experience & Skills
Essential:
- Experience in a data analyst, business intelligence analyst, supply chain analyst or similar analytical role.
- Strong SQL skills, including querying large datasets, joining tables, aggregating data and performing complex data transformations.
- Demonstrable experience analysing large, complex datasets to answer business questions and identify actionable insights.
- Experience developing interactive dashboards and reports using Power BI or an equivalent BI platform.
- Strong analytical and problem-solving skills, with the ability to conduct structured root cause analysis and identify underlying drivers of performance issues.
- Experience automating reports, data preparation or recurring analytical processes.
- Strong Excel skills, including advanced formulas, data manipulation and analytical techniques.
- Ability to communicate complex findings clearly and translate analysis into practical business recommendations.
- A proactive, inquisitive mindset, with the confidence to challenge assumptions and investigate issues independently.
- Strong attention to detail and a disciplined approach to data validation and analytical accuracy.