Business Insights Developer

Aurora Energy Research

Business Insights Developer working closely with business stakeholders to design and deliver insight solutions with Power BI. Collaborating with the data platform team to ensure consistent data quality and performance.

Posted 7/27/2026full-timeOxford • 🇬🇧 United KingdomMid-LevelSeniorWebsite

Core Competencies

Role fit

Core Competencies

Use this summary to align your resume positioning with the role.

Demonstrates expertise in Power BI report development, data modelling, and governance practices, with a strong ability to translate business requirements into actionable insights. Proficient in DAX, SQL, and Excel for data validation and exploration, while fostering collaboration across teams to enhance data quality and reporting standards.

Highest-signal resume keywords

Power BI Report DevelopmentDAX ProficiencyData Modelling PrinciplesSQL SkillsMicrosoft Fabric Experience

ATS Keywords

Tailor your resume

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills

Power BI DesktopPower QuerySemantic ModellingData Quality ValidationReport DesignData ExplorationReconciliationStar SchemaMeasuresDimensions

Soft Skills

CollaborationAttention to DetailOrganizational SkillsCommunication Skills

Tools & Technologies

Microsoft FabricPower AutomatePower AppsDynamics 365SalesforceSAP SuccessFactors

Industry Keywords

Insight DeliveryGovernance StandardsWorkspace ManagementData AccessLifecycle Management

Tech Stack

Tools & technologies

SQL

About the role

Key responsibilities & impact

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.
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.
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.
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.
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.
Help improve delivery standards, reusable assets, and ways of working across the Data and Insights team, with a focus on consistency, trust, and maintainability.

Requirements

What you’ll need

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.

Benefits

Comp & perks

Private Medical Insurance
Dental Insurance
Parental Support
Salary-Exchange Pension
Employee Assistance Programme (EAP)
Local Oxford Discounts
Cycle-to-work Scheme
Flu Jabs