The Role
Build and maintain reliable cloud-based data pipelines and transformations, design analytics-friendly data models, support data quality and governance, collaborate with stakeholders to translate requirements into scalable data solutions, and contribute to documentation and monitoring.
Summary Generated by Built In
Please note that we are open to considering candidates who require visa sponsorship (subject to eligibility and company approval)
We are seeking a Data Engineer to join our growing Business Data team within Internal Technology. The role will focus on building, maintaining, and evolving a centrally governed business data platform, supporting analytical and operational use cases across the organisation.
We are seeking a Data Engineer to join our growing Business Data team within Internal Technology. The role will focus on building, maintaining, and evolving a centrally governed business data platform, supporting analytical and operational use cases across the organisation.
Working closely with Senior and Lead Data Engineers, as well as business stakeholders, you will contribute hands-on to data ingestion, transformation, and modelling activities using our core data platform technologies. This role is well suited to someone who enjoys translating business data requirements into robust, scalable data solutions and wants to deepen their experience in an enterprise data environment.
You will operate in a collaborative, intellectually stimulating environment, with exposure to modern cloud-native data tooling and real-world business problems in a fast-growing, data-driven organisation.
Key Responsibilities
- Build and maintain reliable data pipelines to ingest and transform data from enterprise systems, including finance, CRM, HR, and collaboration platforms
- Develop and manage data transformations to support business intelligence and analytical use cases
- Contribute to the design and implementation of dimensional and analytics-friendly data models
- Work with senior engineers to implement data engineering best practices, standards, and governance controls
- Support data quality, validation, and monitoring processes to ensure trusted reporting and insights
- Collaborate with analysts, engineers, and business stakeholders to understand reporting requirements and translate them into technical solutions
- Contribute to documentation, data lineage, and technical knowledge sharing across the team
Skills, Knowledge and Expertise
Required attributes:
- Experience delivering data engineering solutions in a production environment
- Practical experience with:
- SQL for data transformation and modelling
- Python for data processing or orchestration
- Cloud-based or modern data platforms (e.g. Microsoft Fabric or equivalent)
- Experience ingesting data from relational databases and/or SaaS platforms via APIs
- Understanding of core data engineering concepts such as:
- Data modelling (e.g. dimensional models)
- Data quality and validation
- Basic data governance principles
- Strong analytical and problem-solving skills, with attention to detail
- Good communication skills, with the ability to work effectively with technical and non-technical stakeholders
- Ability to manage tasks independently while contributing effectively within a team
Desirable attributes:
- Exposure to PySpark or notebook-based data development
- Familiarity with enterprise systems such as ERP, CRM, or HR platforms
- Experience working in a governed, multi-environment (DEV / TEST / PROD) data platform
- Awareness of CI/CD or DevOps practices for data engineering
- Interest in building scalable and maintainable data platforms in a fast-growing organisation
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.
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.
About
From its academic roots, Aurora Energy Research is a thriving, rapidly growing company, currently serving over 1000 of the world’s most influential energy sector participants, including utilities, investors, and governments. While we constantly strive to reach new markets and diversify our product portfolio, we are already active across the globe in Asia-Pacific, Latin America, Europe, South Africa and North America, working with leading organisations to provide comprehensive market intelligence, bespoke analytic and advisory services, and cutting-edge software. We are a diverse team of experts with vast energy, financial, and consulting backgrounds, covering power, hydrogen, carbon, and fossil commodities. With this, we provide data-driven intelligence to fuel strategic decisions in the global energy transformation.
Skills Required
- Experience delivering data engineering solutions in a production environment
- SQL for data transformation and modelling
- Python for data processing or orchestration
- Cloud-based or modern data platforms (e.g. Microsoft Fabric or equivalent)
- Experience ingesting data from relational databases and/or SaaS platforms via APIs
- Understanding of data modelling (e.g. dimensional models)
- Understanding of data quality and validation
- Basic data governance principles
- Strong analytical and problem-solving skills
- Good communication skills for technical and non-technical stakeholders
- Ability to manage tasks independently while contributing effectively within a team
- Exposure to PySpark or notebook-based data development
- Familiarity with enterprise systems such as ERP, CRM, or HR platforms
- Experience working in a governed, multi-environment (DEV / TEST / PROD) data platform
- Awareness of CI/CD or DevOps practices for data engineering
Aurora Energy Research Compensation & Benefits Highlights
The following summarizes recurring compensation and benefits themes identified from responses generated by popular LLMs to common candidate questions about Aurora Energy Research and has not been reviewed or approved by Aurora Energy Research.
-
Healthcare Strength — Healthcare in certain offices is described as comprehensive, including core medical coverage with vision and dental. Feedback suggests supportive health resources are accessible alongside standard coverage.
-
Leave & Time Off Breadth — Time off is portrayed as generous in some locations, with standard PTO supplemented by additional company-wide holidays. Parental leave policies are also described as robust in certain markets.
-
Wellbeing & Lifestyle Benefits — Wellbeing support is highlighted through a 24/7 assistance programme and locally tailored perk platforms. Feedback suggests these offerings complement core benefits and support everyday needs.
Aurora Energy Research Insights
What's It Like to Work at Aurora Energy Research?
Aurora Energy Research Culture & Values
Aurora Energy Research Career Growth & Development
What's the Work-Life Balance Like at Aurora Energy Research?
Aurora Energy Research Leadership & Management
Aurora Energy Research Company Growth, Stability & Outlook
Am I A Good Fit?
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.
Success! Refresh the page to see how your skills align with this role.
The Company
What We Do
From its academic roots, Aurora Energy Research has grown to become the largest dedicated power market analytics company in Europe, providing data-driven intelligence for strategic decisions in the global energy transformation. We are a diverse team of over 350 experts with vast energy, financial and consulting backgrounds, covering power, hydrogen, carbon and fossil commodities. We are active in Europe, APAC and the US, working with world-leading organisations to provide comprehensive market intelligence, bespoke analytic and advisory services, and cutting-edge software.
