Explore roles
Graduate
Junior
Mid
Senior
Leader
Description
Hybrid requirements: 3 days per week in the office.
Application questions:
Are you a British citizen? If you are not a British citizen, please state your current visa status.
Do you currently require visa sponsorship?
Will you require visa sponsorship in the future?
What are your salary expectations for this position? Please state your gross, annual salary expectations in GBP.
Please inform us of your notice period.
Aurora Energy Research is based in Oxford and currently we are benefiting from a hybrid working model, working three days from the office and two days from home, as per our policy. Would you be open working in a hybrid basis?
May we consider your application for a different role within Aurora Energy Research?
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 SuccesFactors (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
Experience in analysing and manipulating numerical and business data; a high level of numerical & analytical competence
Excellent time management, organisational skills and an attention to detail
Strong communication and interpersonal skills
Flexible approach to work, positive, can-do attitude, and a team player
Ability to work independently, to deadlines, managing priorities
Confidence working with varied business stakeholders; excellent interpersonal skills with ability to build relationships at all levels
Delivery oriented and happy to role-up your sleeves to get things done
Exceptional problem-solving skills
A passion for technology and how to use it to solve real 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
Experience with 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.
Culture overview
Our culture is entrepreneurial, dynamic, and progressive. Underpinned by strongly-held values and based on a passionate commitment to independent research, we always strive to go to the next level in our analysis and service for our clients.
Our values speak to our mindset, our approach, and our direction. As a company, we thrive on open feedback, and we take on a trial-and-error approach to achieve rapid progress in building great things.
With this, we take our work very seriously, but we maintain a friendly and laid-back atmosphere in the office where you can go over and have a conversation with anyone in the company. Despite our successes, we have a long journey ahead to fulfil our potential.
A rapidly growing organisation creates unique and powerful development opportunities for our team, so we are always looking at what’s next!
We want to hear from you if you:
-> thrive in a fast-moving, collaborative environment.
-> love to discover and pursue new paths to improvement. -> are devoted to securing great results with an international team.
-> are driven to achieve positive change in global energy.
Employee benefits
Cycle To Work
Enhanced parental leave
Enhanced sick leave
Flexible Working
Free Food
Laptop
Learning/Development days
Pension
Wellbeing Programme
Office vibe
Clubs & Meetups
Free Coffee
Friday Drinks
Open Plan
Social Events
Team Building Days
Location
Leadership
Stuart Tricklebank
Director Software Engineering
Engineering principles
Continuous delivery
Refactoring
Unit testing
Company tech stack
AWS
C#
Java
JavaScript
Node.js
Python
React
TypeScript