Revenue Analyst

MGEN Thermal Energy Inc.; Manila; Sur place; PHP 600 000 - 800 000; Plein temps

Résumé du poste

MGEN Thermal Energy Inc. is seeking a Revenue Analyst in Manila to convert diverse data into reliable revenue insights. You will validate data, run trend analyses, monitor anomalies, and support billing and tariff testing to inform management decisions.

You will maintain dashboards, data dictionaries, and issue trackers, escalating unresolved items to the Revenue Assurance Head as needed. Strong Excel and BI skills are essential.

Qualifications

• Bachelor’s degree in Accounting, Finance, Economics, Engineering, Data Analytics, Mathematics, Statistics, Business, or related field.
• 2 to 5 years of experience in revenue analytics, financial analysis, data validation, billing analytics, or management reporting.
• Experience in utilities, power, or shared services is an advantage.
• Training or certification in Excel, Power BI, Tableau, SQL, Python or data analytics is advantageous.
• Ability to escalate issues and maintain issue trackers and evidence files.

Responsabilités

• Extract, reconcile, and validate revenue-related data sets for accuracy.
• Prepare trend analyses, rate-volume-mix summaries and variance explanations.
• Monitor leakage and anomalies; raise unusual patterns for review.
• Support bill simulations, tariff testing, rate mapping, and before-and-after analyses.
• Maintain dashboards, data dictionaries, and recurring management reporting inputs.
• Update issue logs, recovery trackers, and evidence files; coordinate follow-ups.

Connaissances

Revenue analytics

Financial analysis

Data validation

Management reporting

Audit analytics

Communication

Problem solving

Formation

Bachelor's degree in Accounting, Finance, Economics, Engineering, Data Analytics, Mathematics, Statistics, Business, or related discipline

Outils

Excel

Power BI

Tableau

SQL

Python

Description du poste

The Revenue Analyst perform assigned revenue analytics and assurance support by validating source data, preparing trend and driver analyses, supporting leakage and anomaly monitoring, generating dashboards and management report inputs, and maintaining issue trackers and evidence files. The role focuses on converting customer, metering, billing, tariff, operational, and financial data into reliable analysis for review, while escalating unusual patterns, missing data, and potential leakage indicators to the Senior Revenue Officer or Revenue Assurance Head.

General Responsibilities:

Revenue Data Extraction and Validation

Extract, compile, reconcile, and validate assigned customer, meter, billing, tariff, revenue, accounts receivable, operational, and financial data sets for completeness, accuracy, and consistency.

Trend, Driver and Variance Analysis

Prepare trend analyses, rate-volume-mix summaries, variance explanations, and standard revenue driver commentary to support management reports, forecast inputs, and issue reviews.

Leakage and Anomaly Analytics

Run assigned anomaly checks, leakage indicators, exception reports, and monitoring routines; identify unusual patterns; and prepare initial analysis for reviewer action.

Billing/Tariff Data Testing Support

Support bill simulations, rate table checks, tariff testing, adjustment analytics, data mapping checks, and before-and-after analyses for billing or contract changes.

Dashboard and Management Reporting Support

Maintain dashboard inputs, refresh files, data dictionaries, visual summaries, and recurring management schedules with clear assumptions, data sources, and control checks.

Issue Tracking and Evidence Management

Update issue logs, recovery trackers, action lists, data quality logs, and evidence files; coordinate follow-ups with data owners; and elevate unresolved or high-impact items.

Technical Competencies:

Revenue Data Extraction, Validation and Source Checks

Compiles and validates customer, meter, billing, tariff, revenue, accounts receivable, operational, and financial data sets using approved queries, extracts, templates, and checks. Confirms completeness and consistency, documents assumptions, and escalates gaps that may affect reporting or assurance conclusions.

Revenue Trend, Volume, Rate and Mix Analytics

Analyzes recurring revenue movements by volume, rate, tariff, customer, dispatch, outage, and mix drivers. Prepares clear analytical schedules and commentary that explain standard movements and isolate items requiring deeper review.

Leakage and Anomaly Analytics

Runs assigned leakage and anomaly routines to identify missing billings, unusual adjustments, source-data gaps, pricing inconsistencies, outlier usage, or non-technical loss indicators. Prepares initial findings, quantifies potential impact, and tracks reviewer disposition.

Billing, Tariff and Data Testing Support

Supports recurring bill simulations, tariff table checks, rate mapping, before-and-after analysis, adjustment testing, and data validation for billing or contract changes. Documents test results and flags differences requiring contract, billing, or management review.

Dashboarding and Management Reporting Support

Maintains revenue dashboards, recurring management report inputs, data dictionaries, and refresh routines. Produces clear visual summaries and source references that allow reviewers to trace numbers and understand trends.

Revenue Controls Evidence and Issue Tracking

Maintains control evidence, issue trackers, recovery logs, action lists, and data quality records for assigned analytical routines. Ensures outputs are organized, version-controlled, and sufficiently supported for review and audit use.

Analytical Thinking and Problem Solving

Applies structured analysis to isolate drivers, validate assumptions, compare expected versus actual results, and identify practical next steps. Uses facts and evidence to distinguish data errors, timing items, business drivers, and potential control issues.

Communication, Storytelling and Quality Discipline

Presents analytical findings clearly, checks work for accuracy and traceability, and translates data into concise messages for reviewers and stakeholders. Communicates limitations, open items, and actions without overstating conclusions.

Qualifications:

Education

Bachelor’s degree in Accounting, Finance, Economics, Engineering, Data Analytics, Mathematics, Statistics, Business, or a related discipline.

Experience

At least 2 to 5 years of experience in revenue analytics, financial analysis, data validation, billing analytics, management reporting, audit analytics, reconciliation, or business intelligence support. Internship or junior analyst experience in utilities, power, commercial finance, or shared services is an advantage.

Licenses / Certifications

Training or certification in Excel, Power BI, Tableau, SQL, Python, data analytics, financial analysis, accounting, or process improvement is an advantage.