FP&A Analyst – Data Analytics & Automation

Main Responsiblities:

FP&A Core

• Perform monthly reconciliations (NOP, sales register) with accuracy and timeliness.
• Support forecast and budget preparation, including variance analysis (e.g., Price-Volume-Mix analysis to pinpoint margin fluctuations).
• Prepare cost allocation and adjustment calculations (e.g., intercompany charges, fixed cost allocation).
• Maintain and update tracking files supporting Actuals close.
• Support ad-hoc financial analysis requests from the Assistant Manager, FP&A and other stakeholders.

Data Analytics & Automation

• Identify manual, repetitive FP&A tasks and redesign them using Power Query, Power BI, or Power Automate.
• Build and maintain automated data pipelines connecting source systems (ERP data from both manufacturing sites, SAP FI/CO modules) into a single reporting layer, rationalising duplicate and legacy tracking files into one source of truth across Dumai and Genthin.
• Act as the day-to-day bridge between FP&A and IT/Data teams on data structure issues.
• Convert static comparison/tracking files into live, self-refreshing dashboards.
• Explore generative AI tools (e.g. Microsoft Copilot, ChatGPT) to accelerate report drafting, data summarisation, and early-stage predictive forecasting.

Stakeholder & Communication

• Analyse and interpret financial data, including key performance indicators, trends, and variances, and provide actionable insight to the business and senior management.
• Clearly communicate and translate technical/automated outputs into business terms for nontechnical finance and operational stakeholders.
• Support ad-hoc requests and cross-functional collaboration with regional finance teams across Sinarmas Cepsa Group markets.

Job Requirements:

• Bachelor’s degree in Finance, Accounting, Business, or a related discipline.
• 2–4 years of relevant experience in FP&A, financial reporting, cost accounting, or a similar finance analyst role.
• Proven experience in automating manual or spreadsheet-based processes.
• Good understanding of financial reconciliation, cost allocation, budgeting, and forecasting.
• Advanced Microsoft Excel skills, including Power Query and PivotTables.
• Proficiency in Power BI, including dashboard development and basic DAX.
• Familiarity with SAP (FI/CO) or other ERP systems is an advantage.
• Knowledge of SQL, Power Automate, Python, or Generative AI tools is an added advantage.
• Strong analytical skills, attention to detail, and a continuous improvement mindset.