Department: Core - Finance Location: 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.

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 setting, 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





Analysis & Decision Support

Develop and track KPIs to measure business performance, including revenue, cost and headcount analysis (A vs. 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

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

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

Accidental, term life and medical insurance

Hybrid Work model

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.

Unfortunately, we are unable to accept applications via email, telephone, or social media platforms.

📌 SQL / BI Data Analyst (Gurugram)
🏢 Aurora Energy Research
📍 Gurugram