Business Intelligence Analyst

We have an exciting opportunity for a Business Intelligence Analyst (Grade 10) to join the Settlement & Insights team on a permanent basis.

Team Overview:
The 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 Purpose:
This 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.

Capabilities and competencies:
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

Developmental / Desirable:

• Experience in the utilities sector, particularly the electricity industry
  • Experience of Databricks
  • Experience of Python and R
  • Experience of project methodologies including Agile

Elexon career path / Potential next role(s):

• Service Lead
• Data Engineer
• Data Scientist
• Business Analyst

In return, Elexon provides:

• £50,000
• 28 days annual holiday + Bank Holidays
• Discretionary annual incentive scheme
• Life assurance
• Pension
• Private medical (Bupa)
• Private dental (Bupa)

At Elexon, our employee wellbeing is particularly important to us, which is why we are proud to provide:

• Hybrid working - 2 days per week at our London office
• BUPA health check
• Employee Assistance Programme
• Eye care voucher scheme
• Subsidised gym membership
• Cycle to Work Scheme
• Buying & selling holiday scheme
• Computing scheme
• Corporate Social Responsibility (CSR) days
• Season ticket loan

We believe a diverse and inclusive culture allows innovation and creativity to flourish. We are committed to continuously improving our culture for our colleagues and stakeholders. Through our hugely successful Diversity Forum, Mental Health First Aid network and regular programme of activities and events, we celebrate difference and recognise the value of employee wellbeing, which is a consistent outcome from annual employee surveys that we conduct. Likewise, as a community, we like to support each other, and all agree Elexon is a great place to work with a great workspace too!

• 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 voic es