Senior Data Engineer

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.

• 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; 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.
• 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.

Some of the benefits we include are:

• Private Medical Insurance
• Parental Support
• 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.