BI and Data Analyst

Description

We are looking for an FP&A BI Analyst to join our finance team at an exciting moment in our growth as a business, to build and own the reporting and analytics that power financial decision making across the Group.

The FP&A BI Analyst will sit at the intersection of finance and data, turning information held in Microsoft Fabric, Power BI and Dynamics 365 into clear, reliable and commercially relevant insight. The role is responsible for designing and maintaining our financial reporting suite, automating manual processes, and ensuring a single trusted version of the numbers. The successful candidate will combine strong technical data skills with genuine financial understanding and the ability to translate complexity into something non-finance stakeholders can act on.

Key Responsibilities

• Build, maintain and optimise financial data models and pipelines within Microsoft Fabric, ensuring accuracy, performance and scalability
• Own the flow of financial and operational data from Dynamics 365 into the reporting environment, resolving issues at source wherever possible
• Partner with IT and Data teams to align on architecture, governance, security and data quality standards

• Design, build and maintain Power BI dashboards and reports that are clear, intuitive and support business decision making
• Automate recurring management reporting, replacing manual Excel processes with sustainable, well controlled solutions
• Develop robust DAX measures and a well-documented semantic model that acts as a single source of truth for financial data
• Understand the business model and value driving levers to ensure reporting reflects what genuinely matters to the business

• Support delivery of the monthly reporting pack, ensuring accuracy, timeliness, and clarity
• Develop and track KPIs to measure business performance, including revenue, cost and headcount analysis (A vs. B)
• Support preparation of presentations for senior leadership and board reviews
• Provide ad hoc analysis, scenario modelling and sensitivity analysis as required

• Work closely with FP&A, Financial Control and the wider business to understand reporting needs and translate them into practical, scalable solutions
• Act as a trusted point of contact for reporting queries, building confidence in the numbers across the organisation

• Ensure data controls, reporting policies and change management processes are adhered to
• Maintain clear documentation of data sources, definitions and report logic to support auditability and continuity

Skills, Knowledge and Expertise

• Demonstrable hands-on experience with Microsoft Fabric (Lakehouse, Data Factory pipelines, Warehouse or equivalent)
• Strong Power BI and wider Power Platform skills, including advanced DAX, Power Query and dimensional data modelling
• Practical experience working with Dynamics 365 finance data, including its structure and reporting implications
• Experience gained working directly within a Finance function, or in close partnership with one, is strongly preferred
• Strong analytical and problem-solving skills with the ability to translate data into meaningful insight
• Excellent communication skills, with the ability to explain technical concepts clearly to non-technical stakeholders
• Strong Excel skills and a solid grounding in core financial concepts including P&L, balance sheet, budgeting and forecasting
Comfortable working in a fast-paced, dynamic environment with multiple competing priorities

• Experience in a PE-backed or fast-growth environment advantageous
• Part-qualified or qualified accountant (ACA, ACCA, CIMA or equivalent), or a finance or data related degree
• Familiarity with SQL, Power Automate, Python or version control / deployment pipelines

What we offer

Some of the benefits we include are:

• Accidental, term life and medical insurance
• Hybrid Work model
• Employee’s Provident Fund Scheme
• Maternity leave
• A fun, informal, collaborative and international work culture
• Access to the Aurora Academy, our training programme offering a range of opportunities to develop your skills within the responsibilities of your role and within the wider context of the industry.
• Access to our Employee Assistance Programme (EAP), offering a complete support network that offers expert advice and compassionate guidance 24/7/365, covering a wide range of personal and professional aspects

The Company is committed to the principle that no employee or job applicant shall receive unfavorable treatment on grounds of age, disability, gender reassignment, race, religion or belief, sex, sexual orientation, marriage or civil partnership, pregnancy and maternity.

To apply, please submit your Résumé / CV, a personal summary, your salary expectations and please inform us of your notice period.

Unfortunately, we are unable to accept applications via email, telephone, or social media platforms. To be considered for this position, please submit your application using the link provided. Applications submitted through any other channel will not be reviewed.

About Aurora Energy Research

From its academic roots, Aurora Energy Research is a thriving, rapidly growing company, currently serving over 1000 of the world’s most influential energy sector participants, including utilities, investors, and governments.

While we constantly strive to reach new markets and diversify our product portfolio, we are already active across the globe in Asia-Pacific, Latin America, Europe, South Africa and North America, working with leading organisations to provide comprehensive market intelligence, bespoke analytic and advisory services, and cutting-edge software.

We are a diverse team of experts with vast energy, financial, and consulting backgrounds, covering power, hydrogen, carbon, and fossil commodities. With this, we provide data-driven intelligence to fuel strategic decisions in the global energy transformation.