The Role
Build and govern a centrally managed business data platform using Microsoft Fabric. Collaborate with stakeholders to define BI requirements, present designs to Technical Design Authority, implement data extraction, transformation and dimensional models, ensure data governance, mentor junior engineers, and define scalable, secure best practices to enable enterprise reporting and insights.
Summary Generated by Built In
Please note that we are open to considering candidates who require visa sponsorship (subject to eligibility and company approval)
Based in Oxford, you will join the growing Business Data team within Internal Technology. Working alongside the Lead Data Engineer, you will play a key role in delivering the business data platform using the agreed technology stack, Microsoft Fabric.
Based in Oxford, you will join the growing Business Data team within Internal Technology. Working alongside the Lead Data Engineer, you will play a key role in delivering the business data platform using the agreed technology stack, Microsoft Fabric.
A key aspect of this role is collaborating with senior business stakeholders to define functional specifications for business intelligence reports that align with established technology standards. These specifications will be presented through the Technical Design Authority, while you take a hands-on role in building the required data infrastructure with the team to enable high-quality reporting and insights. As a senior member of the practice, you will also help define scalable, secure, and robust processes and best practices.
The successful applicant will be passionate about solving business problems through technology, combining strong technical data expertise with excellent communication skills and a solid understanding of business operations.
You will work in a creative and intellectually stimulating environment, enjoying autonomy and the opportunity to make a meaningful impact on Aurora’s data strategy. Your work will help ensure the business intelligence capability effectively leverages enterprise data to support the needs of a fast-growing, data-driven organisation
Key Responsibilities
- Work within the Architecture and Engineering function to build a centrally managed, governed data layer that provides insight across enterprise systems, including Microsoft Dynamics 365 F&O, Salesforce, SharePoint, SAP SuccessFactors (HRMS), and future platforms introduced as the company grows
- Support the Lead Data Engineer in guiding key decisions on system integration and data flows, ensuring a scalable and well-managed ecosystem that enables efficient business operations and cross-system insights
- Collaborate with internal teams to understand operational challenges, particularly around reporting requirements, and identify where technology and data solutions can deliver value
- Help establish policies, standards, and best practices to ensure the business data layer remains scalable, secure, and robust
- Guide junior team members to support high-quality technical delivery and effective ways of working
What we are looking for
Required attributes:
- Minimum of 2 years’ experience delivering data solutions to organisations including:
- Extraction of data from traditional database systems and online systems via API
- Transformation of data to support tactical and broad business insight requirements
- Dimensional modelling
- Data governance
- Demonstrable experience with: Microsoft Fabric / Python / PySpark Notebooks /SQL / SaaS and API based data extraction
- Strong experience analysing and manipulating numerical and business data, with a high level of analytical capability
- Excellent time management, organisational skills, and attention to detail
- Strong communication and interpersonal skills, with the ability to build relationships with stakeholders at all levels
- Ability to work independently, manage competing priorities, and deliver to deadlines
- Flexible and proactive approach to work, with a positive, team-oriented mindset
- Delivery-focused, with a hands-on attitude and willingness to take ownership to get things done
- Strong problem-solving skills and the ability to translate business challenges into data and technology solutions
- Passion for technology and its application to solving real business problems
Desirable attributes:
- Experience with reporting from any of our existing Tier 1 systems (Dynamics 365 Finance and Operations, Salesforce CRM, SAP SuccessFactors, Entra ID)
- Experience with delivering Direct Lake data architectures with Microsoft Fabric
- Experience with utilising CI/CD patterns and DevOps tooling to orchestrate configuration across environments
- Experience working with Power BI (including Power Query and DAX)
- Experience working with Logic Apps, Power Platform
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.
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.
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
- Minimum of 2 years' experience delivering data solutions
- Extraction of data from traditional database systems and online systems via API
- Transformation of data to support tactical and broad business insight requirements
- Dimensional modelling
- Data governance
- Experience with Microsoft Fabric
- Experience with Python
- Experience with PySpark Notebooks
- Experience with SQL
- Experience with SaaS and API based data extraction
- Strong experience analysing and manipulating numerical and business data
- Excellent time management, organisational skills, and attention to detail
- Strong communication and interpersonal skills with stakeholder management
- Ability to work independently, manage competing priorities, and deliver to deadlines
- Flexible and proactive, team-oriented mindset
- Delivery-focused with hands-on attitude and ownership
- Strong problem-solving skills and translate business challenges into data solutions
- Passion for technology and applying it to business problems
- Experience reporting from Dynamics 365 F&O, Salesforce, SAP SuccessFactors, or Entra ID
- Experience delivering Direct Lake data architectures with Microsoft Fabric
- Experience utilising CI/CD patterns and DevOps tooling
- Experience with Power BI including Power Query and DAX
- Experience with Logic Apps and Power Platform
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.
