Join to apply for the Senior/Lead Data Engineer role at Aurora Energy Research

Location: Oxford, UK

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.

The successful applicant will have a passion for solving business problems with technology and combine exceptional technical data capabilities with great communication skills and understanding of how the business operates.

The successful candidate 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 data integrates and flows between systems to ensure an extensible, well managed ecosystem that enables the business to work efficiently and effectively as it grows and does not obstruct data insights being leveraged cross-system.
• Collaborate with internal teams to understand challenges in 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.
• Data governance experience.
• Demonstrable experience with Microsoft Fabric, Python/PySpark Notebooks, SQL, SaaS and API based data extraction.
• Experience in analysing and manipulating numerical and business data; strong numerical and analytical competence.
• Excellent time management, organisational skills and attention to detail.
• Strong communication and interpersonal skills; flexible, can-do attitude and team player.
• Ability to work independently to deadlines, managing priorities; confident working with varied business stakeholders and building relationships at all levels.
• Delivery oriented and willing to roll up sleeves to get things done; exceptional problem-solving skills.
• A passion for technology and how to use it to solve real problems.
• Experience with reporting from existing Tier 1 systems.

Other desirable experience

• Dynamics 365 Finance and Operations
• SAP SuccessFactors
• Experience delivering Direct Lake data architectures with Microsoft Fabric
• Experience with 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
• Experience with Power Platform

What we offer

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

Seniority level

• Executive

Employment type

• Full-time

Job function

• Information Technology
• Industries
• Research Services