Aurora Energy Research provides energy market analytics and strategic intelligence for organizations navigating the global energy transition. Based in Oxford, the company supports planning, portfolio management, and investment decisions through market outlooks, software for evaluating wind and battery projects, and tailored advisory work. Its research is also shared through reports, podcasts, webinars, and industry events focused on major developments in energy markets.
BI Data Analyst – Microsoft Fabric and Power BI (Hybrid)
Build Microsoft Fabric and Power BI reporting for Aurora Energy Research’s finance team. Automate financial analysis and help the Group make informed, data-led decisions.
Description
- Create, maintain and optimise financial data models and pipelines in Microsoft Fabric
- Manage the transfer of financial and operational data from Dynamics 365 into the reporting environment
- Investigate and fix data-quality issues as close to their source as possible
- Collaborate with IT and Data teams on architecture, governance, security and quality standards
- Create and maintain Power BI dashboards and reports
- Automate recurring management reports and reduce reliance on manual Excel work
- Build reliable DAX measures and document the semantic model as the reporting source of truth
- Help produce the monthly reporting pack
- Define and monitor KPIs covering revenue, costs and headcount
- Contribute to presentations for senior leaders and board reviews
- Deliver ad hoc analysis, scenario modelling and sensitivity analysis
- Partner with FP&A, Financial Control and the wider business to turn reporting requirements into scalable solutions
- Serve as a reliable contact for reporting-related questions
- Follow data controls, reporting policies and change-management procedures
- Document data sources, definitions and report logic to support auditability and continuity
Requirements
- At least five years of professional experience
- Hands-on experience with Microsoft Fabric, including Lakehouse, Data Factory pipelines, Warehouse or equivalent capabilities
- Strong Power BI and broader Power Platform expertise, including advanced DAX, Power Query and dimensional modelling
- Practical experience working with Dynamics 365 finance data and understanding its structure and reporting implications
- Direct experience in a Finance function or close collaboration with one is strongly preferred
- Strong analytical and problem-solving ability
- Skill in turning data into clear, useful insight
- Excellent communication skills and the ability to explain technical subjects to non-technical stakeholders
- Advanced Excel skills
- Sound understanding of financial fundamentals, including P&L, balance sheets, budgeting and forecasting
- Ability to manage multiple competing priorities in a fast-moving environment
- Experience in a private-equity-backed or high-growth organisation is advantageous
- Part-qualified or qualified accountant, such as ACA, ACCA or CIMA, or a degree in finance or a data-related discipline
- Familiarity with SQL, Power Automate, Python, or version-control and deployment pipelines
Benefits
- Accidental death, term life and medical insurance
- Hybrid working model
- Employee Provident Fund Scheme
- Maternity leave
- Informal, collaborative and international working culture
- Access to the Aurora Academy training programme
- Access to the Employee Assistance Programme, providing expert advice and compassionate guidance 24/7/365