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 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 Aurora we will consider all requests for flexible working. For most roles, the following types of flexibility are usually possible: a hybrid model of remote and in-office working, part time hours and flexible start and finish times. Please talk to us at interview about the flexibility we could offer and we will explore what’s possible for the role. 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 and civil partnership and pregnancy and maternity. The successful candidate would start as soon as possible. The team will review applications as they are received. Salary will be competitive with experience. To apply, please submit your Résumé / CV, a personal summary, your salary expectations and please inform us of your notice period. About Aurora Energy Research From its academic roots, Aurora Energy Research is a thriving, rapidly growing company, currently serving over 950 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.