Job Description
We’re looking for a mid-level AWS Data Engineer to help us build and run reliable, scalable data pipelines. You’ll turn raw data from multiple data sources into trusted datasets for our internal users, working closely with analysts, data scientists, and the wider team. You will be responsible for developing pipelines end-to-end, but should also be happy working with established systems and architecture.
This is a great opportunity to join a small, collaborative team where you will have the chance to work on all aspects of Data Engineering and build up new skills on the job.
Key Responsibilities:
· Design, build, and maintain data pipelines in AWS.
· Create and maintain core datasets in both traditional databases and data lakes.
· Work with a variety of data sources managed by internal and external teams.
· Write clean, well-tested Python and SQL for data extraction and transformation.
· Improve performance, cost, and reliability of existing pipelines
· Implement data quality checks and alerting.
· Use Infrastructure as Code (IaC) to deploy processes (we use CloudFormation).
· Document datasets and processes so they are easy for others to work with.
Qualifications
Skills & Experience Required:
Technical Skills
· Min of 2 years of experience in data engineering or a similar role.
· Hands-on experience with core AWS data services (for example S3, Glue, Athena, Lambda, IAM, EMR).
· Strong SQL skills (joins, window functions, optimization).
· Solid Python for data processing.
· Experience building production ETL/ELT pipelines.
· Working knowledge of security and IAM (roles, policies, least privilege).
· Experience with Infrastructure as Code (IaC) and CI/CD for data (nice to have).
· AWS certification (nice to have).
Soft Skills
· Can break down requirements and ask the right questions.
· Communicates clearly with colleagues in a variety of different roles.
· Customer focused: our customers are our colleagues from other teams, but that doesn’t make them any less important!
· Enjoys problem solving and figuring out how to do new things.
· Shares information and knowledge freely. We can all learn from each other.
· Pragmatic: knows when to build from scratch vs. reuse.
· Ownership mindset — monitors what they build.
What we can offer you:
* Enhanced maternity, paternity and adoption pay and leave
* Company pension
* Life assurance scheme (x4 salary)
* Medicash Plan (includes cash payments towards dental, medical, therapeutic treatments) with the option to add up to 4 dependants
* Refer a friend scheme
* Employee assistance programme (access to GP appointments and mental health support)
* Competitive annual leave plus bank holidays
* Training and career progression opportunities
What Success Looks Like (First 6 Months)
· You’ve taken ownership of a set of data pipelines and made them faster, cheaper, or more reliable.
· New datasets and processes you deliver are well documented and easy for analysts to query.
· Stakeholders trust the data because you’ve added validation and monitoring.
About us:
Almost everyone wants their career to be meaningful and fulfilling, working in the water industry sector can be just that. Helping water companies throughout the world to manage their complex wastewater sewer networks, prevent flooding, reduce pollution and improve rivers and bathing water. Detectronic Ltd specialise in the design, manufacture and installation of wastewater flow, level and water quality monitoring equipment for smart network monitoring of sewerage, wastewater and trade effluent.
Additional Information
Adler and Allan are committed to fostering diversity and inclusion in our workplace. We proudly embrace equal opportunities for all applicants, regardless of race, colour, religion, sex, sexual orientation, gender identity or national origin. If you require any support with your application, whatever the circumstance, please let us know.