Billing & Settlement Analyst — Excel & Power BI Pro

San Miguel Global Power; Philippines; On-site; PHP 223,000 - 469,000; Full time

Job summary

San Miguel Global Power is seeking an engineering graduate to support daily nomination analysis, load profiles, generation and WESM price tracking, and settlement reporting. The role involves assisting in reconciliation with the electricity trading group, maintaining data interfaces, and preparing communications with stakeholders.

Location is Pasig City, on-site. The ideal candidate has a year of relevant experience and is proficient in Excel, Power BI, and Power Query, with strong report

Qualifications

• Engineering graduate required.
• Proficient in Microsoft Excel, Power BI, Power Query and skilled in analyzing reports.
• At least 1 year of relevant work experience.

Responsibilities

• Assist in analyzing daily nomination of direct customers, their daily load profiles, generation, and load from settlement statements in WESM, monthly replacement power, and daily WESM prices for both generation and load side.
• Assist in preparing and disseminating billing and settlement reports on generation, load, and raw meters for each billing period.
• Assist in reconciliation of settlement statements from WESM with the electricity trading group.
• Establishes and maintains interface and close coordination internally and externally.
• Prepares correspondences with internal and external stakeholders.
• Secures files and maintains records necessary to sustain the group's centralized filing system.
• Performs other functions and responsibilities as may be required

Skills

Report analysis

Education

Engineering degree

Tools

Microsoft Excel

Power BI

Power Query

Job description

San Miguel Global Power is seeking an engineering graduate to support daily nomination analysis, load profiles, generation and WESM price tracking, and settlement reporting. The role involves assisting in reconciliation with the electricity trading group, maintaining data interfaces, and preparing communications with stakeholders.

Location is Pasig City, on-site. The ideal candidate has a year of relevant experience and is proficient in Excel, Power BI, and Power Query, with strong report