Data Analyst (FP&A)

JSIT for WST (Wholesale Trade) by Singapore Business Federation (SBF); Singapore; On-site; SGD 60,000 - 100,000; Full time

Job summary

Wholesale Trade Company, supported by the Singapore Business Federation (SBF) under the JSIT WST initiative, is seeking a meticulous Data Analyst (FP&A) to drive data-led financial planning and analysis. You will develop forecasting models, finance dashboards and automated reporting to support strategic decisions.

You will lead budgeting, rolling forecasts and variance analyses, partnering with Data Engineering on data definitions and pipelines to empower finance dashboards and a semantic layer

Qualifications

• 3–5 years of experience in FP&A, finance analytics or management reporting.
• Strong SQL skills to extract and aggregate data from relational databases.
• Advanced Excel modelling, pivot/lookup mastery and maintainable Finance models.
• Experience with Python for data manipulation and automating reporting tasks.
• Understanding of financial statements, unit economics and performance metrics.

Responsibilities

• Lead and support the annual budget, rolling forecasts and scenario planning.
• Build and maintain forecasting models (volume, price, mix, cost) and validate against actuals.
• Develop finance dashboards (Power BI) to explain revenue, gross margin, opex and cash trends.
• Automate monthly management reporting to shorten the reporting cycle.
• Define KPI logic and ensure reproducibility of numbers.

Skills

SQL

Excel

Python

Forecasting

Power BI

Education

Bachelor's degree in Finance/Accounting or related field

Tools

Power BI

Job description

This role is posted on behalf of the Wholesale Trade Company with support from the Singapore Business Federation (SBF) under the JSIT WST initiative. SBF/JSIT facilitates outreach and connections only and does not act as an employment agency. All hiring decisions are made solely by the hiring company.

Our member company is seeking a meticulous and motivated Data Analyst (FP&A) to join the team In this role, you will play a critical part in driving data-led financial planning and analysis by developing forecasting models, finance dashboards and automated reporting to support strategic business decisions.

Job Responsibilities

• Lead and support the annual budget, rolling forecasts and scenario planning using data-driven, driver-based models rather than static spreadsheets.
• Build and maintain forecasting models (volume, price, mix, cost) and validate assumptions against actual transactional data.
• Run variance analysis (actual vs. budget vs. forecast) and clearly explain the underlying business drivers behind the gaps.
• Design, build and maintain finance dashboards (Power BI) that explain key financial trends to leadership — revenue, gross margin, opex, working capital and cash.
• Automate recurring monthly management reporting to reduce manual spreadsheet effort and shorten the reporting cycle.
• Define and document KPI logic, calculation rules and dashboard caveats so numbers are reproducible and defensible.
• Perform product mix and customer mix analysis to explain movements in revenue and margin.
• Conduct uplift, price/volume/mix bridging and year-on-year / period-on-period trend analysis.
• Support profitability analysis, cost optimisation initiatives and investment or business case evaluation.
• Partner with the Data Engineering team on data models, definitions and pipelines that feed finance reporting; contribute to the semantic layer used by finance dashboards.
• Document data lineage, business logic and assumptions to ensure consistency and auditability.
• Streamline FP&A processes for greater efficiency, accuracy and timeliness — replacing manual steps with SQL, Python or automated refreshes.
• Identify opportunities to apply automation and AI tooling to reporting, commentary generation and data quality checks.

Job Requirement

• Bachelor's degree in Finance, Accounting, Economics, Business Analytics, Data Science or a related field.
• 3–5 years of experience in FP&A, finance analytics, business analysis or management reporting.
• SQL — able to write queries independently to extract, join and aggregate data from relational databases.
• Excel — strong financial modelling, pivot/lookup mastery and comfort building maintainable models.
• Python — working knowledge for data manipulation and analysis (e.g. pandas), automation of repetitive reporting tasks.
• Solid understanding of financial statements, unit economics and business performance metrics.
• Excellent communication and presentation skills; able to translate financial and analytical output into clear, actionable recommendations for non-technical stakeholders.
• High attention to detail, strong ownership, and a structured problem-solving mindset.

We thank all applicants for their interest. Due to the volume of applications, only shortlisted candidates will be contacted. Please note that applicants must already possess valid work authorization to work in Singapore at the time of application.