Data Analyst - Management Accounting

Purview Asia Pacific; Singapore; On-site; SGD 90,000 - 150,000; Full time

Job summary

Purview Asia Pacific is seeking a skilled Management Accounting specialist in Singapore to drive financial analysis and data-driven reporting. You will work with data modellers/architects to translate business requirements into data models and ensure accurate management reporting across entities.

The role requires advanced SQL and Excel capabilities, experience with P&L structures, FTP, GL/CoA structures, and complex finance reporting suites.

Qualifications

• Experience in Management Accounting.
• Ability to translate business requirements into data requirements.
• Experience working with data modellers and data architects.
• Strong SQL skills for data analysis, reconciliation, validation and investigation.
• Advanced Microsoft Excel skills with complex formulas and large datasets.
• Experience defining source-to-target mappings, data transformations and data dictionaries.
• Experience working with complex Finance and Management Accounting reporting suites.
• Strong analytical and problem-solving capabilities.

Responsibilities

• Analyse Profit & Loss and profitability reporting.
• Analyse revenue and expense attribution.
• Analyse cost allocation and cost centre structures.
• Analyse Funds Transfer Pricing (FTP).
• Review General Ledger and Chart of Accounts structures.
• Examine hierarchies and reporting across product, customer, BU, legal entity, and org levels.
• Support management reporting and financial performance analysis.
• Understand data flow from source systems to GL and reporting layers.
• Identify gaps and improvements in finance processes, controls, data flows and reporting logic.

Job description

Roles & Responsibilities

• Analyse Management Accounting processes covering:

  • Profit & Loss and profitability reporting

  • Revenue and expense attribution

  • Cost allocation and cost centre structures

  • Funds Transfer Pricing (FTP)

  • General Ledger and Chart of Accounts structures

  • Product, customer, business unit, legal entity and organisational hierarchies

  • Management reporting and financial performance analysis

• Understand how financial transactions flow from source systems through the GL, Finance data platforms, allocation processes, FTP engines and Management Accounting reporting layers.

• Analyse existing finance processes, controls, data flows, calculations and reporting logic to identify gaps and improvement opportunities.

Skills/Requirements

• Experience in Management Accounting

• Strong practical knowledge of:

  • Banking Management Accounting

  • Profit & Loss structures

  • Cost allocation methodologies

  • Funds Transfer Pricing

  • General Ledger structures

  • Chart of Accounts

  • Cost centres and profit centres

  • Financial hierarchies and reference data

  • Management reporting

• Demonstrated experience performing business process analysis, not solely technical data analysis.

• Strong ability to translate business requirements into data requirements and data model concepts.

• Experience working closely with data modellers and data architects.

• Strong SQL skills for data analysis, reconciliation, validation and investigation.

• Advanced Microsoft Excel skills, including complex formulas, pivot tables, reconciliation models and large dataset analysis.

• Experience defining:

  • Source-to-target mappings

  • Business rules

  • Data transformations

  • Data dictionaries

  • Data lineage

  • Reporting specifications

• Experience working with complex Finance and Management Accounting reporting suites.

• Strong analytical and problem-solving capabilities.