Data Analyst - Management Accounting

PURVIEW ASIA PACIFIC PTE. LTD.; Singapore; On-site; SGD 90,000 - 120,000; Full time

Job summary

PURVIEW ASIA PACIFIC PTE. LTD. is seeking a Finance Analytics professional to lead management accounting analysis across P&L, cost centres and GL structures. You will translate business requirements into data models and work with data modellers and architects.

Key responsibilities include analyzing profitability reporting, FTP concepts, and performance analysis, with strong Excel and SQL skills to drive data-driven improvements.

Qualifications

• Experience with management accounting processes including P&L and profitability reporting.
• Strong practical knowledge of banking management accounting, cost allocation & FTP.
• Proficient in Data modelling concepts, data lineage and data dictionaries.
• Excellent SQL skills for data analysis, reconciliation and testing.
• Advanced Microsoft Excel with large datasets, complex formulas and pivot tables.
• Experience translating business requirements into data requirements and data model concepts.

Responsibilities

• Analyse management accounting processes covering P&L and profitability reporting.
• Understand revenue/expense attribution, cost allocation and FTP engines.
• Review GL structures, COA and hierarchies across multiple entities.
• Understand how financial transactions flow from source systems to GL and reporting layers.
• Analyse existing finance processes, controls, data flows and reporting logic to identify gaps and improvements.

Skills

Management Accounting

SQL

Advanced Excel

Data analysis

Profit & Loss structures

Cost allocation

Funds Transfer Pricing

GL structures

Chart of Accounts

Data modelling concepts

Data lineage

Source-to-target mappings

Business rules

Reconciliation

Reporting

Management reporting

Financial hierarchies

Reference data

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.