Energy Markets Analytics Specialist, Python, SQL & BI

NAIS CORP; Pasig; On-site; PHP 600,000 - 1,000,000; Full time

Job summary

NAIS CORP in Metro Manila is seeking a seasoned energy markets analyst to join our analytics team in Pasig. You will collect market data, build automated pipelines in Python and SQL, and develop Power BI reports to support daily, weekly and monthly reporting.

The role requires 4–8 years in market analytics, strong English, and the ability to work across time zones with minimal supervision. On-site work at Ortigas or Muñoz will be required.

Qualifications

• Bachelor's degree in a quantitative discipline; BS Information Technology or BS Information Systems acceptable with equivalent quantitative training.
• Four to eight years' experience in market or commercial analytics, trading operations, settlements, pricing, risk or financial analysis in energy/utilities/financial markets.
• Python to production standard, including work with time-series data.
• SQL — able to write and optimise non-trivial queries independently against a relational database.
• Advanced Microsoft Excel and Power BI or equivalent BI platform.
• Strong written English and ability to work across a time-zone difference.

Responsibilities

• Collect, validate and prepare daily and weekly market and portfolio datasets.
• Produce the recurring reporting suite — exposure, position, margin and prudential reporting.
• Build and maintain Python and SQL pipelines and Power BI reporting, replacing manual handling with automated, tested processes.
• Monitor and report hedge position and portfolio exposure across electricity, gas and environmental certificates.
• Value and mark contracts to market — swaps, caps, PPAs and certificate positions.
• Prepare scenario and sensitivity analysis with written commentary.
• Own settlement and invoice reconciliation cycle; investigate and clear exceptions, escalating with cause and financial effect.
• Analyse invoiced revenue against wholesale cost and quantify drivers of variance.
• Prepare the Energy Markets inputs to month-end reporting.
• Support rate-card construction and offer modelling, and test margin outcomes across tariffs and customer segments.
• Maintain and quality-assure pricing and calculator models, including reconciliation to benchmarks.
• Maintain current, tested runbooks and model documentation with version control.
• Identify and deliver automation and process improvements.

Skills

Python (production quality)

SQL (queries & optimization)

Time-series data handling

Advanced Excel

Power BI / BI platform

Education

Bachelor's degree in quantitative discipline

Tools

Python

SQL

Power BI

Excel (Advanced)

Job description

NAIS CORP in Metro Manila is seeking a seasoned energy markets analyst to join our analytics team in Pasig. You will collect market data, build automated pipelines in Python and SQL, and develop Power BI reports to support daily, weekly and monthly reporting.

The role requires 4–8 years in market analytics, strong English, and the ability to work across time zones with minimal supervision. On-site work at Ortigas or Muñoz will be required.