Senior/Lead Data Engineer presso Aurora Energy Research
Aurora Energy Research · Oxford, Regno Unito · Hybrid
- Senior
- Ufficio in Oxford
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.
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.
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.
