The Role
Build and manage financial data models, pipelines, Power BI dashboards, DAX measures, and automated reporting solutions using Microsoft Fabric and Dynamics 365. Support FP&A through KPI tracking, monthly reporting, scenario analysis, and decision support. Collaborate with finance, IT, and data teams to ensure data quality, governance, documentation, and a trusted source of financial information for business stakeholders.
Summary Generated by Built In
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
Data & Platform
- 5+ years of experience
- 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
Reporting & Visualisation
- 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
Analysis & Decision Support
- 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
Stakeholder Engagement
- 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
Governance & Compliance
- 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
Required attributes:
- 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
Desirable attributes:
- 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.
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
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.
Skills Required
- Hands-on experience with Microsoft Fabric, including Lakehouse, Data Factory pipelines, Warehouse, or equivalent
- Strong Power BI and Power Platform skills, including advanced DAX, Power Query, and dimensional data modelling
- Practical experience working with Dynamics 365 finance data and understanding its reporting implications
- Experience working directly within a Finance function or closely partnering with one
- Strong analytical and problem-solving skills
- Ability to translate data into meaningful business insight
- Excellent communication skills and ability to explain technical concepts to non-technical stakeholders
- Strong Excel skills
- Understanding of P&L, balance sheet, budgeting, and forecasting
- Ability to work in a fast-paced environment with competing priorities
- Experience in a private-equity-backed or fast-growth environment
- Part-qualified or qualified accountant, such as ACA, ACCA, CIMA, or equivalent
- Finance or data-related degree
- Familiarity with SQL, Power Automate, Python, or version control and deployment pipelines
Aurora Energy Research Compensation & Benefits Highlights
The following summarizes recurring compensation and benefits themes identified from responses generated by popular LLMs to common candidate questions about Aurora Energy Research and has not been reviewed or approved by Aurora Energy Research.
-
Healthcare Strength — Healthcare in certain offices is described as comprehensive, including core medical coverage with vision and dental. Feedback suggests supportive health resources are accessible alongside standard coverage.
-
Leave & Time Off Breadth — Time off is portrayed as generous in some locations, with standard PTO supplemented by additional company-wide holidays. Parental leave policies are also described as robust in certain markets.
-
Wellbeing & Lifestyle Benefits — Wellbeing support is highlighted through a 24/7 assistance programme and locally tailored perk platforms. Feedback suggests these offerings complement core benefits and support everyday needs.
Aurora Energy Research Insights
What's It Like to Work at Aurora Energy Research?
Aurora Energy Research Culture & Values
Aurora Energy Research Career Growth & Development
What's the Work-Life Balance Like at Aurora Energy Research?
Aurora Energy Research Leadership & Management
Aurora Energy Research Company Growth, Stability & Outlook
Am I A Good Fit?
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.
Success! Refresh the page to see how your skills align with this role.
The Company
What We Do
From its academic roots, Aurora Energy Research has grown to become the largest dedicated power market analytics company in Europe, providing data-driven intelligence for strategic decisions in the global energy transformation. We are a diverse team of over 350 experts with vast energy, financial and consulting backgrounds, covering power, hydrogen, carbon and fossil commodities. We are active in Europe, APAC and the US, working with world-leading organisations to provide comprehensive market intelligence, bespoke analytic and advisory services, and cutting-edge software.
