Subscription Analytics & Performance Analyst

Singapore Press Holdings Limited; Singapore; On-site; SGD 60,000 - 100,000; Full time

Job summary

Singapore Press Holdings Limited is seeking a data-driven analyst to join the Business Planning team within the Consumer & Audience Marketing Division to own monthly reporting for the subscription business. You will work with Finance, Customer Intelligence and Sales & Marketing to deliver timely insights that support strategic decisions.

You will develop and maintain reporting models in Excel and Power Query, automate processes, and contribute to monthly business reviews with clear commentaries

Qualifications

• 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.

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.

Skills

Excel (PivotTables/XLOOKUP)

Power Query

BI tools (Tableau)

Analytical thinking

Stakeholder communication

Education

Diploma or Degree in Business/Finance/Accountancy/Economics/Data Analytics

Tools

Tableau

Power BI

Job description

Singapore Press Holdings Limited is seeking a data-driven analyst to join the Business Planning team within the Consumer & Audience Marketing Division to own monthly reporting for the subscription business. You will work with Finance, Customer Intelligence and Sales & Marketing to deliver timely insights that support strategic decisions.

You will develop and maintain reporting models in Excel and Power Query, automate processes, and contribute to monthly business reviews with clear commentaries