Wholesale Analytics Specialist

About the role

The Wholesale Analytics Specialist supports the Energy Markets function from Manila — preparing and validating market and portfolio data, producing the recurring reporting, reconciling settlements and automating manual work, so that the Sydney desk's time goes into judgement rather than production. Day-to-day priorities come from the Energy Market Analyst in Sydney; the standard of the work is the Specialist's own.

Key responsibilities

• Collect, validate and prepare the daily and weekly market and portfolio datasets — prices, demand, generation, half-hourly load and hedge positions.
• Produce the recurring reporting suite — exposure, position, margin and prudential reporting — to a set daily, weekly and monthly cadence.
• 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, and explain material movements.
• Value and mark contracts to market — swaps, caps, power purchase agreements and certificate positions.
• Prepare scenario and sensitivity analysis on request, with written commentary.
• Support trade execution and administration, pre-trade data packs, deal capture and maintenance of the trade register, and reconciliation of broker and exchange confirmations against it.
• Own the settlement and invoice reconciliation cycle; investigate and clear exceptions, escalating with cause and financial effect.
• Analyse invoiced revenue against wholesale cost and quantify the drivers of variance.
• Prepare the Energy Markets inputs to month-end reporting.

About you

• A bachelor's degree in a quantitative discipline — statistics, mathematics, applied mathematics, economics, electrical engineering, computer science or data science. BS Information Technology and BS Information Systems will be considered only where equivalent quantitative training can be demonstrated.
• Four to eight years' experience in market or commercial analytics, trading operations, settlements, pricing, risk or financial analysis — in energy, utilities, financial markets, or a global capability centre serving international clients.
• 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 an equivalent business-intelligence platform.
• Exceptional accuracy and attention to detail. The role produces figures that inform financial commitments.
• Strong written English, and the self-direction to deliver with limited real-time supervision across a time-zone difference.
• Comfortable in a specialist, non-supervisory role — taking priorities from a colleague in another country, and raising concerns rather than proceeding on an assumption.
• Work Location Preference: Willing to work onsite in either Ortigas, Pasig City or Muñoz, Quezon City, depending on the Company's business needs and operational requirements.