At a Glance
- Tasks: Transform business questions into insightful solutions using Microsoft Fabric and Power BI.
- Company: Join Aurora, a forward-thinking company in Oxford focused on data and insights.
- Benefits: Enjoy private medical insurance, parental support, local discounts, and a cycle-to-work scheme.
- Other info: Dynamic team environment with opportunities for continuous improvement and career growth.
- Why this job: Make a real impact by delivering actionable insights that drive better business outcomes.
- Qualifications: Experience in Power BI, strong analytical skills, and ability to collaborate with stakeholders.
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.
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.
What we offer: Private Medical Insurance, Parental Support, Employee Assistance Programme (EAP), Local Oxford Discounts, Cycle-to-work Scheme, Flu Jabs.
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
Aurora is an exceptional employer, offering a dynamic work environment in Oxford where innovation and collaboration thrive. As a member of the Data and Insights team, you will have access to continuous professional development opportunities, a supportive culture that values diverse perspectives, and a range of benefits including private medical insurance and local discounts. Join us to make a meaningful impact through data-driven insights while enjoying a healthy work-life balance.
StudySmarter Expert Advice🤫
We think this is how you could land Business Insights Developer in Oxford
✨Get Involved in Data Science Meetups
Tap into local data science meetups or workshops to connect with fellow enthusiasts and professionals. These events are goldmines for networking, and sometimes even lead directly to job openings at companies like Aurora Energy Research!
✨Show Off Your Projects
Start building a public portfolio showcasing your data science projects on platforms like GitHub or personal websites. Highlight unique analyses or models you've developed. This not only demonstrates your skills but also gets your name out there for roles like Business Insights Developer at Aurora Energy Research.
✨Leverage Professional Networks
Join professional bodies related to data science, like the Data Science Society or similar organisations. Getting involved can lead to mentorship opportunities and insider knowledge about full-time positions at companies like Aurora Energy Research.
✨Apply Directly through Our Website
When you find a suitable opening like Business Insights Developer at Aurora Energy Research, make sure to apply directly through our website. It gives you an edge and shows you're keen to join our team. Plus, who doesn’t love a direct application? It’s easier than navigating through job boards!
We think you need these skills to ace Business Insights Developer in Oxford
Some tips for your application 🫡
Show Off Your Projects:In the world of data science, your projects can speak volumes about your skills. Make sure to showcase a few key projects in your CV or portfolio, especially those that highlight your ability to work with data sets, build models, or use relevant tools like Python, R, or SQL. Don’t forget to include links to any GitHub repositories if applicable!
Quantify Your Achievements:Employers love numbers! When drafting your CV, highlight your achievements with quantifiable results. For instance, mention how your data analysis led to a certain percentage increase in efficiency or revenue at a previous job or project. These details can really make your application pop!
Craft a Tailored Cover Letter:For a full-time role at Aurora Energy Research, your cover letter should reflect your passion for data science and your excitement about the specific projects or values of the company. Dive into why you’re a good fit, how your skills align with their needs, and any unique perspectives you can bring to the team.
Stand Out with Relevant Courses and Certifications:Although experience talks, relevant courses or certifications can be your ticket to impressing hiring managers at Aurora Energy Research. Mention any standout courses you've completed that equipped you with essential skills, such as machine learning certifications or data visualisation courses. This shows your commitment to continuously developing your skills in the field!
How to prepare for a job interview at Aurora Energy Research
✨Brush Up on Your Statistics
For a data science role, we need to seriously sharpen our statistics skills. Get ready to tackle technical questions on probability distributions, hypothesis testing, and regression analysis. These are often the bread and butter of data science interviews, so don't just skim over them!
✨Showcase Your Projects
Prepare a killer portfolio showcasing your data science projects. We should include details about the datasets used, the tools and techniques applied, and the impact of your findings. If we can walk them through a particularly challenging project or a cool visualisation that had real-world implications, it’ll really make us stand out!
✨Get Comfortable with Python and R
Most data science positions require us to be proficient in programming languages like Python and R. We should practice common libraries like pandas, NumPy, and scikit-learn, and be ready for live coding exercises or algorithm questions. Showing off our coding chops can really impress the interviewers at Aurora Energy Research!
✨Prepare for Case Studies
Expect to encounter real-world case studies during the interview. We might be asked how we’d approach a data problem or analyse a dataset to extract insights. It's essential to think out loud and demonstrate our problem-solving process so that the interviewer can see our logical thinking in action.
