Wholesale Analytics Specialist

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.