AWS Data Engineer: Lakehouse & Data Platform Builder

Forsyth Barnes Consultancy; Nottingham; On-site; GBP 60,000 - 90,000; Full time

Job summary

Forsyth Barnes Consultancy in Nottingham, England, seeks an AWS Data Engineer to design and deliver cloud data capabilities enabling reliable reporting and analytics. You will engineer ingestion, transformation and storage across a modern AWS estate, ensuring data moves from sources into trusted datasets.

You will build resilient pipelines, data models and reusable products, collaborating with platform, architecture, product and analytic specialists to deliver scalable data solutions and

Qualifications

• Proven track record delivering production data engineering on AWS.
• Strong SQL capabilities for complex transformations and validation.
• Hands-on Python for automation and pipeline development.
• Experience with dbt and data-modeling in lakehouse environments.
• Knowledge of data governance, metadata, lineage, and security.

Responsibilities

• Architect and implement secure, scalable data pipelines using AWS-native services and modern engineering patterns.
• Develop ingestion frameworks for relational systems, APIs, files, events and change-data-capture sources.
• Build transformation workflows and dimensional or domain-oriented models using SQL, Python and dbt.
• Structure data across lakehouse layers so that raw, curated and consumption-ready information remains traceable and fit for purpose.
• Create reusable data products that serve operational insight, customer solutions, reporting, machine learning and emerging AI use cases.
• Establish automated controls for validation, reconciliation, completeness, freshness and other critical data-quality measures.
• Embed metadata, lineage, access management and governance requirements into the engineering lifecycle.
• Use monitoring, logging and alerting to improve pipeline reliability, incident response and platform observability.
• Review workload performance and cloud consumption, identifying opportunities to improve efficiency and manage AWS costs responsibly.
• Partner with architects, software engineers, analysts, product owners and platform teams to translate requirements into maintainable solutions.
• Contribute to engineering standards, reusable components, documentation, code reviews and continuous improvement practices.
• Help shape data-product ownership and federated delivery principles as the wider platform matures.

Skills

AWS

SQL

Python

dbt

Lakehouse

S3

Glue

Athena

DMS

Step Functions

Data governance

Data modeling

Observability

Cost control

Education

AWS Certification (Solutions Architect / Data Engineer)

Tools

Amazon S3

AWS Glue

Athena

Lake Formation

DMS

Step Functions

Python

dbt

SQL

Job description

Forsyth Barnes Consultancy in Nottingham, England, seeks an AWS Data Engineer to design and deliver cloud data capabilities enabling reliable reporting and analytics. You will engineer ingestion, transformation and storage across a modern AWS estate, ensuring data moves from sources into trusted datasets.

You will build resilient pipelines, data models and reusable products, collaborating with platform, architecture, product and analytic specialists to deliver scalable data solutions and