Senior/Lead Data Engineer

Aurora Energy Research; Oxford; Hybrid; GBP 60,000 - 80,000; Full time

Job summary

A data solutions company in Oxford is seeking a Senior/Lead Data Engineer to oversee the delivery of business data solutions. This role involves working closely with stakeholders to define specifications, ensuring data governance, and fostering a scalable and robust data environment. Candidates should have experience with Microsoft Fabric and strong data analytical abilities. The position offers hybrid working options and various employee benefits.

Benefits

Private Medical Insurance

Dental Insurance

Parental Support

Salary-Exchange Pension

Employee Assistance Programme

Local Oxford Discounts

Cycle-to-work Scheme

Flu Jabs

Qualifications

• Minimum of 2 years’ experience delivering data solutions to organisations.
• Proven ability to analyse and manipulate complex numerical and business data.
• Excellent time management and attention to detail.
• Strong communication skills and confidence in building relationships.

Responsibilities

• Build a centrally managed, governed data layer for business insights.
• Steer decisions on data integration and flow across systems.
• Work with teams to understand and address reporting challenges.
• Implement policies for a scalable, secure, and robust data layer.
• Guide junior members in effective technical delivery.

Skills

Data extraction from databases

Data transformation

Dimensional modelling

Data governance

Microsoft Fabric

Python/PySpark

SQL

SaaS and API based data extraction

Power BI

Job description

Senior/Lead Data Engineer

Department: Internal Technology

Employment Type: Permanent - Full Time

Location: Oxford, UK

Reporting To: Head of Architecture and Engineering

Description

Based in Oxford, you will be joining the growing business data team within Internal Technology. Working to the Head of Architecture and Engineering you will take primary ownership of delivering the business data solution with the agreed technology stack, Microsoft Fabric. You will liaise with senior business stakeholders to define functional specifications for business intelligence reports that deliver to agreed technology standards. You will represent these functional specs through Technical Design Authority and take a hands‑on role in delivering the required data infrastructure with the rest of the team to enable the reporting insights. As the practice senior you will also be involved in defining processes and practices to ensure they are scalable, secure and robust.

You will work in a creative, intellectually stimulating environment. You will enjoy autonomy, and the opportunity to have a significant impact on Aurora’s data strategy, ensuring that our business intelligence can draw on all our enterprise effectively and meet the needs of this very fast growing, data heavy business.

Key Responsibilities

• Work as the data lead within the Architecture and Engineering function to build a centrally managed, governed, data layer to provide insight across our enterprise software systems, including Microsoft Dynamics 365 F&O, Salesforce, SharePoint, SAP SuccessFactors (HRMS), and new systems that are needed as the company grows
• Steer key decisions on how they integrate and how data flows between the systems to ensure we have an extensible, well managed eco‑system which enables the business to work efficiently and effectively as it grows and does not obstruct data insights being leveraged cross‑system
• Work with internal teams to understand what challenges they face, particularly in their reporting requirements, where technology can have an impact
• Put in place policies and practices to ensure our business data layer is scalable, secure and robust
• Guide junior members of the team in how to deliver technically and effectively

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
• Proven ability to analyse and manipulate complex numerical and business data
• Excellent time management, organisational skills and and attention to detail
• Strong communication
• Confidence working with varied business stakeholders, excellent interpersonal skills with ability to build relationships at all levels
• Delivery oriented, happy to role‑up your sleeves to get things done, positive can‑do attitude

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.