Controlling Analyst (Power Query) - 1 Year

ACCA Careers; Singapore; On-site; SGD 90,000 - 150,000; Full time

Job summary

ACCA Careers is seeking a Controlling/Financial Analyst to join our Southeast Asia finance team in Singapore. The role involves managing data flows between SAP and Oracle Essbase, maintaining SAP price structures, and supporting monthly close activities while delivering detailed analyses for multiple stakeholders.

You will build robust data tools and coordinate with local and global teams, ensuring accurate reporting and streamlined processes in a dynamic environment.

Qualifications

• Experience with SAP-based financial processes and data flows.
• Strong Excel capabilities, especially Power Query for large datasets.
• Familiarity with Oracle Essbase or similar consolidation tools is advantageous.
• Ability to organize priorities and maintain meticulous documentation.

Responsibilities

• Manage data flows between SAP, Oracle Essbase, and other systems.
• Maintain pricing structures, discounts, and standard costs of SKUs in SAP.
• Support monthly closing activities and prepare performance analyses for stakeholders.
• Create and manage internal orders, cost centres, and PO approvals.
• Extract and share periodic performance reports from SAP, HFM, and history data.
• Prepare variance analyses in collaboration with Marketing and other teams.

Skills

Advanced Excel (Power Query)

Data analysis

Stakeholder communication

Process documentation

Tools

SAP

Oracle Essbase

Job description

A leading global organisation is seeking a Controlling/Financial Analyst to join their Southeast Asia finance team in Singapore. This role offers you the chance to immerse yourself in a broad spectrum of operative finance tasks, working closely with accounting, tax, treasury, consolidation, and regional teams.

What You’ll Do

As a Controlling/Financial Analyst based in Singapore, you will play an integral role in supporting the Southeast Asia controlling team by executing a wide range of operative finance tasks. Your day-to-day responsibilities will include managing data flows between systems such as SAP and Oracle Essbase, maintaining pricing structures within SAP, overseeing monthly closing activities, preparing detailed performance analyses for stakeholders across departments, and ensuring all documentation is meticulously organised. You will also be responsible for building reliable databases that underpin key financial processes while facilitating smooth communication between local teams and global functions. By proactively addressing issues as they arise and streamlining routine processes through diligent organisation, you will help create an environment where the controlling team can operate seamlessly even amidst changing business demands.

• Support the APAC Controlling Team by defining internal cluster deadlines and collaborating with stakeholders to ensure all timelines are met efficiently and accurately.
• Load forecast and budget data onto planning tools on a weekly, monthly, and biannual basis, ensuring information integrity throughout each cycle.
• Execute various closing activities in SAP during month-end periods, maintaining price structures, discounts, and standard costs of SKUs with meticulous attention to detail.
• Assist in the creation of new internal orders and cost centres while managing purchase order approvals and controls as part of daily operations.
• Extract, prepare, and disseminate periodic performance reports from multiple sources such as SAP, HFM, and historical records to provide actionable insights for controllers or other teams.
• Prepare variance analysis reports in collaboration with Marketing teams to ensure timely updates of A&P forecasts, offering clear explanations for any variances identified.
• Maintain a comprehensive list of priorities for the controlling team and drive accountability across all stakeholders involved in ongoing projects.
• Build robust databases that serve as primary data tools for controlling purposes, ensuring consistent mapping of SKU, country, customer, and other critical information across platforms.
• Document knowledge and execution steps for various operational activities to promote knowledge retention and effective dissemination within the team.
• Manage approvals using Docusign as well as record keeping for contracts, price lists, business cases; support global finance teams and external agencies with data collection activities.

What You Bring

To excel as a Controlling Analyst in this organisation's Southeast Asia finance team, you will bring proven experience working within complex finance environments where accuracy and reliability are paramount. Your background should include substantial exposure to SAP-based processes along with advanced Excel capabilities, particularly around Power Query, to ensure seamless management of large datasets. Experience with Oracle Essbase or similar tools will further strengthen your application. Your ability to organise competing priorities efficiently while maintaining high standards of documentation will be essential. You will demonstrate strong interpersonal skills by fostering positive connections across departments and supporting collective goals through clear communication. Your commitment to upholding best practices in record keeping and digital approval workflows will contribute significantly to the team's overall effectiveness.

• Demonstrated proficiency in SAP with hands‑on experience managing financial data within enterprise resource planning systems.
• Advanced skills in Microsoft Excel including proven ability to maintain Power Query solutions for efficient data manipulation and reporting.
• Familiarity with Oracle Essbase or similar financial consolidation tools is highly advantageous for this role.
• Exceptional organisational abilities with a keen eye for detail when handling multiple competing priorities under tight deadlines.
• Experience preparing variance analysis reports and collaborating effectively with cross‑functional teams such as Marketing or Accounting.
• Strong interpersonal skills that enable you to build dependable relationships across departments while promoting accountability among stakeholders.
• Ability to document operational procedures clearly for knowledge retention purposes within the team environment.
• Track record of managing approvals via digital platforms like Docusign alongside thorough record keeping practices for contracts or business cases.
• Comfortable supporting global finance teams or external agencies through accurate data collection activities as required by business needs.

What Sets This Company Apart

This organisation stands out for its unwavering commitment to nurturing talent within a truly inclusive environment. Employees benefit from access to extensive training opportunities designed to support both personal growth and professional advancement. The company places great emphasis on collaboration, encouraging open communication between teams at every level, and values individuals who bring structure and dependability to their work. Flexible working arrangements are supported wherever possible so that employees can balance their responsibilities effectively. With a reputation for excellence across global markets, this employer offers you not only stability but also the chance to make meaningful contributions within a supportive network dedicated to shared success.