Job Description
The Senior ETRM Functional Business Analyst will act as the primary functional subject matter expert for the ETRM platform supporting the UK business. The role partners closely with traders, commercial stakeholders, and a US based technology organization to translate business needs into effective system configurations and workflows. A key responsibility will be modeling UK specific power, gas, renewable, and financial trades within an ETRM platform originally built for the US market, requiring strong functional judgment, collaboration with global teams, and support for evolving deal structures and products. This position plays a critical role in business continuity and operational readiness by serving as the UK data steward, ensuring market data, trades, and daily reports are accurate and available ahead of each trading day. The analyst will support position, P&L, and exposure reporting, work with US teams to resolve data issues, and ensure time series pricing and curves are correctly maintained. The role also supports analytics and reporting through SQL querying, Power BI dashboards, and Excel based analysis. The analyst will work alongside a dedicated technical resource and a large US based technology team that provides deeper development and scripting support. While scripting is not required, the role requires strong functional ownership, participation in testing and UAT, and the ability to support solution design from a business perspective. This is a high impact role with visibility into a growing UK trading business and a clear path to long term ownership as the organization continues to scale.
We are a company committed to creating diverse and inclusive environments where people can bring their full, authentic selves to work every day. We are an equal opportunity/affirmative action employer that believes everyone matters. Qualified candidates will receive consideration for employment regardless of their race, color, ethnicity, religion, sex (including pregnancy), sexual orientation, gender identity and expression, marital status, national origin, ancestry, genetic factors, age, disability, protected veteran status, military or uniformed service member status, or any other status or characteristic protected by applicable laws, regulations, and ordinances. If you need assistance and/or a reasonable accommodation due to a disability during the application or recruiting process, please send a request to HR@insightglobal.com.To learn more about how we collect, keep, and process your private information, please review Insight Global's Workforce Privacy Policy: https://insightglobal.com/workforce-privacy-policy/.
Required Skills & Experience
- Experience working with ETRM Systems (Endur Preferred)
- Background in power and/or gas trading (power preferred)
- Ability to model complex trades and products
- SQL experience – writing queries, validating data
- Experience with Power Bi and Excel (pivot tables)
- Understanding of time-series data
Nice to Have Skills & Experience
- Direct experience with Allegro ETRM, especially for power trading
- Exposure to renewables trading
- Experience supporting UK and EU energy markets
- Familiarity with SSAS / cubes or dimensional data models
Benefit packages for this role will start on the 1st day of employment and include medical, dental, and vision insurance, as well as HSA, FSA, and DCFSA account options, and 401k retirement account access with employer matching. Employees in this role are also entitled to paid sick leave and/or other paid time off as provided by applicable law.