At a Glance
- Tasks: Transform business questions into insightful solutions using Microsoft Fabric and Power BI.
- Company: Join a dynamic team at Aurora, a leader in data and insights.
- Benefits: Enjoy private medical insurance, dental cover, and flexible working options.
- Other info: Collaborative environment with opportunities for continuous improvement and career growth.
- Why this job: Make a real impact by delivering actionable insights that drive business success.
- Qualifications: Experience in Power BI and strong analytical skills are essential.
The predicted salary is between 40000 - 50000 £ per year.
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.
- 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.
- 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.
- 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.
Business Insights Developer in Oxford employer: Aurora Energy Research Limited
Aurora is an exceptional employer, offering a dynamic work environment in Oxford where innovation meets collaboration. With a strong focus on employee growth, we provide comprehensive benefits including private medical insurance, dental coverage, and a cycle-to-work scheme, all while promoting a flexible hybrid working model that values work-life balance. Join our Data and Insights team to not only enhance your skills in Power BI and Microsoft Fabric but also to contribute to meaningful business outcomes in a supportive and inclusive culture.
Contact Details:
Aurora Energy Research Limited Recruitment Team
StudySmarter Expert Advice🤫
We think this is how you could land Business Insights Developer in Oxford
✨Tip Number 1
Network like a pro! Reach out to people in the industry, especially those who work at Aurora or similar companies. A friendly chat can lead to insider info about job openings and even referrals.
✨Tip Number 2
Show off your skills! Create a portfolio showcasing your Power BI projects and insights you've developed. This will give potential employers a taste of what you can do and set you apart from the crowd.
✨Tip Number 3
Prepare for interviews by practising common questions related to data insights and Power BI. Think about how you can demonstrate your analytical thinking and problem-solving skills with real-life examples.
✨Tip Number 4
Don’t forget to apply through our website! It’s the best way to ensure your application gets seen by the right people. Plus, it shows you’re genuinely interested in joining the team.
We think you need these skills to ace Business Insights Developer in Oxford
Some tips for your application 🫡
Tailor Your Application:Make sure to customise your CV and cover letter for the Business Insights Developer role. Highlight your experience with Power BI, Microsoft Fabric, and any relevant projects that showcase your analytical skills. We want to see how you can turn business questions into actionable insights!
Showcase Your Skills:Don’t just list your skills; demonstrate them! Include specific examples of how you've used DAX, semantic modelling, or data visualisation in past roles. This will help us understand your hands-on experience and how you can contribute to our Data and Insights team.
Be Clear and Concise:When writing your application, clarity is key. Use straightforward language and avoid jargon unless it’s relevant to the role. We appreciate a well-structured application that makes it easy for us to see your qualifications and fit for the position.
Apply Through Our Website:We encourage you to apply directly through our website. It’s the best way to ensure your application gets to us quickly and efficiently. Plus, you’ll find all the details about the role and our company culture there!
How to prepare for a job interview at Aurora Energy Research Limited
✨Know Your Power BI Inside Out
Make sure you brush up on your Power BI skills before the interview. Be ready to discuss your experience with DAX, report design, and semantic modelling. Prepare examples of how you've used these skills to deliver insights in previous roles.
✨Understand the Business Needs
Familiarise yourself with the business divisions you'll be partnering with. Think about how you can translate their decision-making needs into actionable insights. Being able to articulate this during the interview will show that you’re not just technically savvy but also business-minded.
✨Showcase Your Collaboration Skills
This role requires working closely with various teams, so be prepared to share examples of how you've successfully collaborated in the past. Highlight any experiences where you gathered requirements or provided feedback on data quality, as this will demonstrate your ability to work effectively across teams.
✨Prepare for Governance Discussions
Since governance is a key part of the role, be ready to discuss your understanding of documentation, data definitions, and insight governance practices. Bring examples of how you've ensured compliance with governance standards in your previous projects.
