Data Infrastructure Engineer

ZipRecruiter; Wilmslow; Hybrid; GBP 50,000 - 70,000; Full time

Job summary

A leading company is seeking a Senior Data Engineer to enhance their data capabilities and maintain the data infrastructure. This hybrid role focuses on developing ETL/ELT data pipelines, leveraging AWS services, and collaborating with various teams to ensure the delivery of insights. Ideal candidates should possess a strong background in data engineering, SQL, and cloud infrastructure, along with excellent communication skills. Enjoy a collaborative work culture with opportunities for growth.

Benefits

25 days holiday plus birthday off

Gym membership discount

Healthcare

Childcare vouchers

Pension contributions

Qualifications

• Experience with enterprise-grade data pipelines and infrastructure.
• Experience designing data warehouse technical architectures.
• Experience deploying cloud data infrastructure services.

Responsibilities

• Develop and maintain ETL/ELT data pipelines using AWS services.
• Manage and optimize data storage solutions like Amazon S3 and Redshift.
• Implement and manage infrastructure-as-code using Terraform.

Skills

Data Engineering

ETL/ELT

AWS Services

SQL

Python

Analytical Skills

Tools

Terraform

CloudFormation

Airflow

Databricks

Job description

Job Description

Job Title: Senior Data Engineer

Location: Hybrid – 1 day per fortnight in the Wilmslow offices

Working hours 0900 to 1730

The Role

Following recent investment, The Citation Group are looking to build out their data capabilities to be Best in Class. As such, a fantastic opportunity has arisen for a strong data engineer to work in the data engineering team, to expand and maintain the data infrastructure that provides the foundations from which our BI, Data Science and Operational Data teams deliver insights and revenue to the functions across the wider group.

We’re looking for an individual who has experience working with enterprise grade data pipelines and infrastructure, who can implement processes on our modern tech stack with robust, pragmatic solutions.

Responsibilities

• develop, and maintain ETL/ELT data pipelines using AWS services Data, Databricks and dbt
• Manage and optimize data storage solutions such as Amazon S3, Redshift, RDS, and DynamoDB.
• Implement and manage infrastructure-as-code (IaC) using tools like Terraform or AWS CloudFormation.
• Monitor and optimize the performance, cost, and scalability of data infrastructure.
• Develop data access policies and implement security best practices for data in transit and at rest.
• Support data ingestion from structured and unstructured sources, including APIs, streaming data, and batch loads.
• Work closely with Data Scientists, Analysts, and Software Engineers to provide data access and tooling.

The Person

We are looking for someone who can roll their sleeves up and ‘dig in’ with the rest of the team. In addition, the successful candidate should have:

• Excellent writing and communication skills with an attention to detail
• Experience designing data warehouse technical architectures and infrastructure components
• Experience deploying could data infrastructure services
• Programming experience in Python
• Experience writing, troubleshooting, and debugging advanced SQL queries
• Outstanding analytical and problem-solving skills
• Experience working with ETL/ELT, and reporting and analytic tools

Skills and experience we’d love you to have… But if not? We’ll help you get there:

• Understanding of cloud computing security concepts
• Proficiency with IaC tools like Terraform or CloudFormation.
• Experience with workflow orchestration tools (e.g., Airflow, Dagster).
• Good understanding of Cloud providers – AWS, Microsoft Azure, Google Cloud
• Familiarity with DBT, Delta Lake, Databricks
• Experience working in Agile environments with tools like Jira and Git.

About Us

We are Citation. We are far from your average service provider. Our colleagues bring their brilliant selves to work every day and we create an environment where they can shine. We are a nice bunch. We don’t do office politics or “that’s not my job”. We listen, support and take ownership.

We have been proudly delivering valuable HR and Health and Safety services to SME’s across the UK for over 20 years. Passionate about service, we’re on a mission to revolutionise our colleague’s and client’s experience by employing brilliant people who are experts at what they do and smile whilst they are doing it.

Working for Citation you will have access to 25 days holiday, plus your birthday off work, gym membership discount, healthcare, childcare vouchers, the opportunity to purchase extra leave, pension contributions and more.

It’s a great place to work because of the people we employ. Fun and professional, we want likeminded individuals who love to love their job and want the Company to succeed.

So, if our culture sounds like a good fit for you and you want to be part of our success story, then send us your details.