Business Intelligence Analyst
Posted 4 hours 1 minute ago by Elexon Ltd
Location: London Salary: 50000 Posted Date: 08 Dec 2025 Closing Date: 23 Dec 2025
Drive meaningful insights at Elexon as a Business Intelligence Analyst. Hybrid working, excellent benefits, and real influence on data-led decision-making.
We have an exciting opportunity for a Business Intelligence Analyst (Grade 10) to join the Settlement & Insights team on a permanent basis.
Team OverviewThe Settlement and Insights (S&I) team are accountable for the entirety of Settlement, and subsequent invoicing, all its processes and the development/changes of the S&I product in line with strategic, industry and customer needs. We manage the operations of these core processes across key products and solutions, and use stakeholder feedback to enhance these products through process and technology improvements.
Job PurposeThis role leads on the design and development of business intelligence solutions that deliver key insights in an effective, automated and reliable way. This position is a senior member of a Service Analyst team and is responsible for designing, developing and maintaining datasets, reports, models and dashboards that support Elexon's strategic objectives. The role works with a range of internal and external stakeholders to ensure business requirements are well understood and data is presented in a clear and engaging way, providing evidence based recommendations where appropriate. The insights gathered will have strategic impact on business processes. The postholder will maintain Elexon's solution architecture standards and assess data requirements to support the production of meaningful insights.
Key Responsibilities- Work with stakeholders to gather reporting business requirements.
• Design, develop and maintain reports, models and dashboards to support Elexon's strategic objectives.
• Implement and maintain reporting workflows.
• Manage the Open Data Request process and progress Open Data Requests to completion.
• Collaborate with Elexon Data Engineers to implement Data Models for Analytical Workloads. - Collaborate with Service Analysts, Data Scientists, Data Engineers, Service Providers to develop data processing pipelines.
• Monitor and manage data refresh schedules and troubleshoot issues.
• Ensure good data quality and integrity across team products.
• Identify opportunities for data and reporting insights.
• Promote reports and insights across the business.
• Influence internal and external decision making through reporting and analysis.
• Explore and recommend ways to enhance data quality and reliability.
• Knowledge transfer within the Settlement & Insights team.
• Educate the Settlement & Insights team on business intelligence and data analytic best practices.
• Develop SME knowledge in the relevant products, code.
• Assimilate an understanding of the rules by researching the BSC and subsidiary documents.
• Develop and follow the operational processes, procedures and obligations accurately.
• Monitor and review data, risks, and identify issues promptly.
• Advise colleagues and line manager of key operational issues and problems.
• Identify the root cause of issues and support resolution.
• Provide and present analysis, reporting, recommendations and commentary to committees, workgroups etc.
• Coordinate the validation and maintenance of key data.
• Support the delivery of changes to the service.
• Demonstrate a customer orientation in all aspects of operational delivery.
• Provide advice and support to customers and stakeholders.
• Keep customers informed of industry developments relevant to the service.
• Develop, review, improve and maintain processes and procedures.
• Propose, drive and implement continuous service improvement.
• Document, review and maintain Local Working Instructions, FAQs, and Guidance Notes.
• Support Service Analysts in resolving customer service queries and operational activities.
- Critical:
- Strong analytic skills related to working with large structured datasets
- Experience building ETL, ELT workflows
- Proven experience of advanced reporting design and implementation
- Advanced knowledge of Power BI, SQL
- Able to develop robust data models using Power Query, DAX, and write optimised SQL queries
- Able to build and maintain complex reports and implement workflows
- Able to monitor and manage data refresh schedules, and troubleshoot issues
- A good understanding of data science, business analytics, and data engineering principles
- Able to present data in a way that is simple to interpret and cascade out to the organisation whilst making insightful recommendations
- Able to link data interdependencies and communicate complex information simply
- Track record and strong understanding of KPI, Metric principles
- Highly analytical and strong critical thinker
- Able to write detailed papers and present analysis to committees, boards, justifying recommendations
- Ability to communicate and present clear thinking on all levels
- Strong listening, organisation and networking abilities
- Ability to support members of the team, and provide education to the business on Power BI and data analytic best practices
- Experience in the utilities sector, particularly the electricity industry
- Experience of Databricks
- Experience of Python and R
- Experience of project methodologies including Agile
- 28 days annual holiday + Bank Holidays
- Discretionary annual incentive scheme
- Life assurance
- Pension
- Private medical (Bupa)
- Hybrid working - 2 days per week at our London office
- Employee Assistance Programme
- Eye care voucher scheme
- Subsidised gym membership
- Cycle to Work Scheme
- Buying & selling holiday scheme
- Corporate Social Responsibility (CSR) days
- Season ticket loan
- Provide true equality of opportunity
- Attract and retain diverse talent
- Listen to all voices
- Be representative of the communities we work in
- Be a role model for Diversity and Inclusion in the industry
Elexon together, embracing differences, listening to all voices