AWS Data Engineer

Adler & Allan
West Kilbride
4 days ago
Create job alert

Join to apply for the AWS Data Engineer role at Adler & Allan.


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
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.


Location

West Kilbride, Scotland, United Kingdom


Seniority Level

Mid-Senior level


Employment type

Full-time


Job function

Information Technology


Industries

Data Infrastructure and Analytics


#J-18808-Ljbffr

Related Jobs

View all jobs

AWS Data Engineer

AWS Data Engineer

AWS Data Engineer

AWS Data Engineer

AWS Data Engineer

AWS Data Engineer

Subscribe to Future Tech Insights for the latest jobs & insights, direct to your inbox.

By subscribing, you agree to our privacy policy and terms of service.

Industry Insights

Discover insightful articles, industry insights, expert tips, and curated resources.

Data Science Jobs for Career Switchers in Their 30s, 40s & 50s (UK Reality Check)

Thinking about switching into data science in your 30s, 40s or 50s? You’re far from alone. Across the UK, businesses are investing in data science talent to turn data into insight, support better decisions and unlock competitive advantage. But with all the hype about machine learning, Python, AI and data unicorns, it can be hard to separate real opportunities from noise. This article gives you a practical, UK-focused reality check on data science careers for mid-life career switchers — what roles really exist, what skills employers really hire for, how long retraining typically takes, what UK recruiters actually look for and how to craft a compelling career pivot story. Whether you come from finance, marketing, operations, research, project management or another field entirely, there are meaningful pathways into data science — and age itself is not the barrier many people fear.

How to Write a Data Science Job Ad That Attracts the Right People

Data science plays a critical role in how organisations across the UK make decisions, build products and gain competitive advantage. From forecasting and personalisation to risk modelling and experimentation, data scientists help translate data into insight and action. Yet many employers struggle to attract the right data science candidates. Job adverts often generate high volumes of applications, but few applicants have the mix of analytical skill, business understanding and communication ability the role actually requires. At the same time, experienced data scientists skip over adverts that feel vague, inflated or misaligned with real data science work. In most cases, the issue is not a lack of talent — it is the quality and clarity of the job advert. Data scientists are analytical, sceptical of hype and highly selective. A poorly written job ad signals unclear expectations and immature data practices. A well-written one signals credibility, focus and serious intent. This guide explains how to write a data science job ad that attracts the right people, improves applicant quality and positions your organisation as a strong data employer.

Maths for Data Science Jobs: The Only Topics You Actually Need (& How to Learn Them)

If you are applying for data science jobs in the UK, the maths can feel like a moving target. Job descriptions say “strong statistical knowledge” or “solid ML fundamentals” but they rarely tell you which topics you will actually use day to day. Here’s the truth: most UK data science roles do not require advanced pure maths. What they do require is confidence with a tight set of practical topics that come up repeatedly in modelling, experimentation, forecasting, evaluation, stakeholder comms & decision-making. This guide focuses on the only maths most data scientists keep using: Statistics for decision making (confidence intervals, hypothesis tests, power, uncertainty) Probability for real-world data (base rates, noise, sampling, Bayesian intuition) Linear algebra essentials (vectors, matrices, projections, PCA intuition) Calculus & gradients (enough to understand optimisation & backprop) Optimisation & model evaluation (loss functions, cross-validation, metrics, thresholds) You’ll also get a 6-week plan, portfolio projects & a resources section you can follow without getting pulled into unnecessary theory.