Business Performance Analyst

SPH Media; Singapore; On-site; SGD 60,000 - 90,000; Full time

Job summary

SPH Media is seeking an analytically driven analyst to own subscription revenue and cost reporting. You will work with Finance, Customer Intelligence and Sales & Marketing to deliver timely insights that inform strategic decisions. The role emphasizes Excel modeling, Power Query, and data-driven storytelling for leadership reviews.

You will collaborate across functions to validate data, build dashboards, and automate reporting processes, enabling accurate monthly performance assessments.

Qualifications

• Diploma or Degree in Business, Finance, Accountancy, Economics, Data Analytics or a related discipline.
• Proficient in Microsoft Excel with advanced formulas and data tools.
• Experience with Power Query; knowledge of Tableau or BI tools is a plus.
• Strong analytical, problem-solving and attention to detail.
• Effective communication with cross-functional stakeholders.
• Ability to manage multiple priorities in a fast-paced environment.

Responsibilities

• Own the monthly revenue and cost reporting process for the subscription business, including the preparation, consolidation and maintenance of reporting models and datasets.
• Analyse business performance by identifying key trends, variances, risks and opportunities, and provide actionable insights to support decision-making.
• Prepare and support Monthly Business Review (MBR), ELT and other management reporting, including commentaries, dashboards and presentation materials.
• Perform data validation and monthly reconciliations to ensure accuracy and integrity of reporting.
• Collaborate with Finance, Business Units and stakeholders to gather requirements, resolve data issues and improve reporting quality.
• Develop and maintain reporting models using Excel and Power Query, and identify opportunities to automate processes.
• Support ad hoc analyses and strategic projects as required.

Skills

Excel advanced

Power Query

Data analysis

Communication

Stakeholder mgmt

Education

Bachelor's degree / Diploma in Business, Finance, Economics or related

Tools

Tableau / BI tools

Job description

SPH Media’s mission is to be the trusted source of news and lifestyle content in Singapore and Asia. One of our core purposes is to produce credible, balanced, and objective news and analysis, always with a view to uphold the public good and fostering an informed, engaged citizenry.

We welcome talented individuals to join us and grow a career in a vibrant and collaborative environment built around a culture of respect and inclusivity.

As an employer, we are committed to rewarding our people fairly and developing them in their careers.

About the Role

As part of the Business Planning team within the Consumer & Audience Marketing Division, you will play a key role in supporting business performance through insightful reporting and analysis. You will own the monthly reporting process for the subscription business and work closely with stakeholders across Finance, Customer Intelligence and Sales & Marketing to deliver timely, accurate and actionable insights that support strategic and operational decision-making.

Key Responsibilities

• Own the monthly revenue and cost reporting process for the subscription business, including the preparation, consolidation and maintenance of reporting models and datasets.
• Analyse business performance by identifying key trends, variances, risks and opportunities, and provide actionable insights to support decision-making.
• Prepare and support the Monthly Business Review (MBR), Executive Leadership Team (ELT) and other management reporting, including business commentaries, dashboards and presentation materials.
• Perform data validation and monthly reconciliations to ensure the accuracy, completeness and integrity of operational and financial reporting.
• Collaborate with Finance, Business Units and other stakeholders to gather business requirements, resolve data issues and continuously improve reporting quality.
• Develop and maintain reporting models using Microsoft Excel and Power Query, while identifying opportunities to automate manual processes and improve reporting efficiency.
• Support ad hoc business analyses, commercial initiatives and strategic projects as required.

Requirements

• Diploma or Degree in Business, Finance, Accountancy, Economics, Data Analytics or a related discipline.
• Strong proficiency in Microsoft Excel, including PivotTables, XLOOKUP, INDEX/MATCH and other advanced formulas.
• Experience with Power Query is preferred. Knowledge of Tableau or other BI tools will be an advantage.
• Strong analytical, problem-solving and critical thinking skills with keen attention to detail.
• Able to communicate insights clearly and work effectively with stakeholders across different functions.
• Self-motivated, organised and able to manage multiple priorities in a fast-paced environment.