At a Glance
- Tasks: Lead data solutions and build a robust data layer for business insights.
- Company: Join Aurora Energy Research, a dynamic tech company in Oxford.
- Benefits: Enjoy private medical insurance, parental support, and local discounts.
- Why this job: Make a real impact on data strategy in a fast-growing environment.
- Qualifications: 2+ years in data solutions, experience with Microsoft Fabric, Python, and SQL.
- Other info: Creative workspace with opportunities for career growth and development.
The predicted salary is between 36000 - 60000 £ per year.
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.
#J-18808-Ljbffr
Senior/Lead Data Engineer employer: Aurora Energy Research
Contact Detail:
Aurora Energy Research Recruiting Team
StudySmarter Expert Advice 🤫
We think this is how you could land Senior/Lead Data Engineer
✨Tip Number 1
Network like a pro! Reach out to current employees at Aurora Energy Research on LinkedIn. A friendly chat can give you insider info and might just get your application noticed.
✨Tip Number 2
Prepare for the interview by brushing up on your technical skills. Be ready to discuss your experience with Microsoft Fabric, Python, and data governance. Show them you’re the data wizard they need!
✨Tip Number 3
Don’t forget to showcase your soft skills! Communication and relationship-building are key in this role. Think of examples where you’ve successfully collaborated with stakeholders.
✨Tip Number 4
Apply through our website for a smoother process. It’s the best way to ensure your application lands directly in the right hands. Plus, it shows you’re keen on joining the team!
We think you need these skills to ace Senior/Lead Data Engineer
Some tips for your application 🫡
Tailor Your CV: Make sure your CV is tailored to the Senior/Lead Data Engineer role. Highlight your experience with Microsoft Fabric, Python, and data governance. We want to see how your skills match what we're looking for!
Craft a Compelling Cover Letter: Your cover letter is your chance to shine! Use it to explain why you're passionate about data engineering and how you can contribute to our team at Aurora Energy Research. Keep it engaging and relevant!
Showcase Your Projects: If you've worked on any relevant projects, don’t hold back! Share examples of how you've tackled data challenges or improved processes. We love seeing real-world applications of your skills!
Apply Through Our Website: We encourage you to apply directly through our website. It’s the best way for us to receive your application and ensures you’re considered for the role. Plus, it’s super easy!
How to prepare for a job interview at Aurora Energy Research
✨Know Your Tech Stack
Make sure you’re well-versed in Microsoft Fabric and the other technologies mentioned in the job description. Brush up on your Python, SQL, and any relevant tools like Power BI. Being able to discuss how you've used these technologies in past projects will show that you're not just familiar but also experienced.
✨Understand the Business Context
Research Aurora Energy Research and its data strategy. Understand their business model and how data plays a role in their decision-making. This will help you tailor your answers to demonstrate how your skills can directly benefit their operations.
✨Prepare for Scenario Questions
Expect questions that ask you to solve hypothetical problems related to data governance or integration challenges. Think of examples from your past experience where you successfully navigated similar situations, and be ready to explain your thought process.
✨Showcase Your Leadership Skills
As a Senior/Lead Data Engineer, you'll need to guide junior team members. Be prepared to discuss your leadership style and provide examples of how you've mentored others or led projects. Highlight your ability to communicate complex ideas clearly to varied stakeholders.