The Role
Partner with business stakeholders and the data platform team to design and deliver scalable Power BI and Microsoft Fabric-based insight solutions. Build reports, semantic models and measures using DAX and Power Query, ensure governance, document assumptions, validate data quality, and support adoption and continuous improvement of reporting standards.
Summary Generated by Built In
Aurora is seeking a Business Insights Developer to join our growing Data and Insights team in Oxford. This is a mid-level role for someone who can turn business questions into trusted, well-designed insight solutions using Microsoft Fabric and Power BI.
This role sits within the Data and Insights team, which works closely with business divisions to understand decision-making needs, define meaningful metrics, and deliver actionable insight. It is part of the wider data team, alongside Data Platform Engineers who are responsible for sourcing data, transforming it, and producing trusted gold data products in Microsoft Fabric.
The Data and Insights Developer will partner with business stakeholders and the data platform team to design insight solutions that are scalable, governed, and user-focused. The role will primarily consume curated gold-layer data products and shared semantic models, helping ensure that insight delivery is consistent, performant, and aligned to enterprise data standards.
Successful candidates will combine strong analytical thinking with practical Power BI delivery skills, including semantic modelling, DAX, data visualisation, and stakeholder engagement. You should be comfortable working independently on agreed priorities while collaborating closely with colleagues across data engineering, architecture, and business teams to continuously improve how insight is delivered and used.
Key Responsibilities
- Business partnering and requirements discovery: Work closely with business divisions to understand decision-making and insight goals, define KPIs, translate requirements into clear user stories, and shape solutions that support better business outcomes.
- Power BI and Fabric solution delivery: Build and maintain high-quality Power BI reports, dashboards, and semantic models using curated Microsoft Fabric data assets, applying strong visual design, usability, and performance practices.
- Semantic modelling and insight design: Create robust, reusable semantic models and measures that support consistent insight delivery across teams, using sound modelling principles, DAX, and a strong understanding of business definitions.
- Governance, documentation, and adoption: Document insight solutions, data definitions, assumptions, and usage guidance; support adoption; and work within agreed governance standards for workspace management, data access, and solution lifecycle.
- Collaboration with the data platform team: Provide feedback on data quality, modelling needs, and new data and insight requirements so that upstream Fabric gold data products continue to meet business insight needs.
- Continuous improvement: Help improve delivery standards, reusable assets, and ways of working across the Data and Insights team, with a focus on consistency, trust, and maintainability.
Skills, Knowledge and Expertise
Required attributes:
- Experience delivering data, insight, and reporting solutions in Power BI, ideally in a mid-level analyst or developer role.
- Strong hands-on skills in Power BI Desktop, Power Query, DAX, report design, and semantic modelling.
- Experience working with Microsoft Fabric or closely related modern Microsoft data platforms, including consumption of curated lakehouse, warehouse, or shared semantic model data.
- Good understanding of data modelling principles such as star schema, measures, dimensions, hierarchies, and reusable business definitions.
- Ability to work with business stakeholders to gather requirements, challenge assumptions, and communicate insights clearly to both technical and non-technical audiences.
- Experience with data quality validation, documentation, and insight and reporting governance practices.
- Comfort working across multiple priorities with strong organisation, attention to detail, and a collaborative mindset.
- Strong SQL and Excel skills for data exploration, validation, and reconciliation.
Desirable attributes:
- Experience working with Fabric-aligned data and reporting patterns such as shared semantic models, Direct Lake, deployment pipelines, or governed workspace structures.
- Experience reporting on enterprise systems such as Dynamics 365, Salesforce, SAP SuccessFactors, or other SaaS business applications.
- Awareness of Power BI governance concepts including workspace roles, row-level security, endorsement, and lifecycle management.
- Experience with broader Power Platform capabilities such as Power Automate or Power Apps where they support reporting workflows.
What we offer
Some of the benefits we include are:
- Private Medical Insurance
- Dental Insurance
- Parental Support
- Salary-Exchange Pension
- Employee Assistance Programme (EAP)
- Local Oxford Discounts
- Cycle-to-work Scheme
- Flu Jabs
At AER, we are committed to offering flexibility in the way we work. Most of our roles are hybrid with a mix of in-office/home working and potentially adjustable working hours. Let’s discuss what works for you and AER during the interview process.
The Company is committed to the principle that no employee or job applicant shall receive unfavourable 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
- Experience delivering data, insight, and reporting solutions in Power BI
- Hands-on skills in Power BI Desktop, Power Query, DAX, report design, and semantic modelling
- Experience working with Microsoft Fabric or closely related modern Microsoft data platforms
- Good understanding of data modelling principles (star schema, measures, dimensions, hierarchies)
- Ability to gather requirements, work with business stakeholders, and communicate insights to technical and non-technical audiences
- Experience with data quality validation, documentation, and reporting governance practices
- Strong SQL skills for data exploration, validation, and reconciliation
- Strong Excel skills for data exploration and reconciliation
- Comfort working across multiple priorities with strong organisation and attention to detail
- Experience with Fabric-aligned patterns (shared semantic models, Direct Lake, deployment pipelines, governed workspaces)
- Experience reporting on enterprise systems such as Dynamics 365, Salesforce, or SAP SuccessFactors
- Awareness of Power BI governance concepts including workspace roles, row-level security, endorsement, and lifecycle management
- Experience with Power Platform capabilities (Power Automate, Power Apps) supporting reporting workflows
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.
