Data Engineer

Harvey Nash Group; City of Edinburgh; Hybrid; GBP 80,000 - 100,000; Full time

Job summary

A technology recruitment firm is seeking a Data Engineer for a 6-month contract based in Edinburgh. The ideal candidate will focus on developing internal casework-profiling solutions and ensuring data integration is robust and efficient. This role emphasizes collaborative development in a hybrid work environment, requiring significant experience with Python, SQL, and DevOps tools. Applicants should also be familiar with Agile methodologies and have a strong commitment to delivering high-quality solutions.

Qualifications

• Significant commercial experience in data engineering roles.
• Expertise in SQL, data transformation, and analysis.
• Experience in Agile methodologies like Scrum or Kanban.

Responsibilities

• Contribute to data warehouse solutions integrating new datasets.
• Collaborate on new data products with stakeholders.
• Ensure resiliency of data integration solutions.

Skills

Python

PostgreSQL

REST APIs

DevOps practices

CI/CD

Tools

Docker

GitLab CI

AWS CodePipeline

AWS CDK

AWS CloudFormation

Job description

Data Engineer | 6 Month Contract | (Outside IR35) | Hybrid, Edinburgh | Starting ASAP

Day Rate: £470

About the Role:

The focus of the work will be the collaborative development of internal casework‑profiling solutions using data extraction & processing techniques applied to semi‑structured and unstructured documents and forms. The candidate will also be expected to deliver robust and resilient data integration solutions and automation of data products and services to ensure that the Data Warehouse is fit‑for‑purpose.

The client is in the process of creating a Data Warehouse to enhance the data analytics capability and ensure robust data governance and data management. It is envisaged that the Data Warehouse will provide the foundation for the development of new data products and derivatives to support core operational and commercial activities. The Data domain is one of six product domains established to enable the client to develop and support high quality and resilient digital products. The small team is multi‑functional with a collaborative and agile culture.

Main Duties

• Contribute to the development and delivery of solutions to integrate new datasets into the data warehouse
• Support the development of new data products in collaboration with the Senior Data & AI Product Manager and other stakeholders
• Assist in activities to migrate the data warehouse from on‑prem to AWS cloud
• Support the delivery of ongoing data engineering activities
• Ensure technical resiliency of all data integration solutions and services
• Support the delivery of ongoing data engineering activities
• Enhance and support existing data product outputs for both internal and external customers.
• Collaborate with technical colleagues across the organisation to design robust data integration solutions
• Demonstrate excellent, sustainable and collaborative software development practice that's focused on delivering highly readable, maintainable and appropriate artefacts.
• Actively participate in all team events, leading where specialist knowledge is required and supporting the team to improve their process through inspection and adaptation.
• Troubleshooting and fixing development and production problems across multiple environments and operating platforms.

Requirement for Data Engineering services

• Engage with the wider communities of practice and interest to share knowledge, technique and experience
• Ensures high quality of developed solutions through development and maintenance of unit tests - with appropriate code coverage - and code analysis using code quality tools,
• Ensure that developed software complies with non-functional software requirements such as accessibility, security, UI/UX, performance, maintainability and deployability,
• Routinely use collaborative development practices such as pairing and mobbing techniques in programming, code reviews, system design and requirements analysis, etc.
• Support and deliver the disaster recover assurance of digital services, striving towards a sustainable Recovery Time Objective of 2hrs and Recovery Point objective of zero. This will be assured at 6 weekend points over the course of a FY year

Essential Skills & Experience:

Significant commercial experience with the following technology:

• Python
• PostgreSQL
• REST APIs
• Modern DevOps and CI/CD practices and tooling including Docker, GitLab CI, AWS CodePipeline, AWS CDK and AWS CloudFormation

Significant and demonstrable commercial experience in the following areas:

• Expertise in SQL, data transformation and analysis
• Delivering high quality software collaboratively in high-performing, cross-functional development teams.
• Experience implementing data ETLs, data streaming systems and data integration solutions
• Experience working in the Agile delivery models - such as Scrum and/or Kanban frameworks.

Desirable Qualifications

• Data warehousing
• Hybrid on-premises/cloud solutions
• AWS Glue, Step Functions, Lambda functions, S3, RDS, Data Migration Service
• Using testing tools for unit testing, including system test automation frameworks
• Openshift
• PostGIS for PostgreSQL
• Designing and implementing solutions using service and event-based architectures
• Monitoring, alerting, intelligence tools and processes, including Grafana
• Human‑centred, research‑driven, inclusive design practices
• Developing within Digital First or GDS quality standards
• TDD

This role has been deemed Outside IR35 by the client. Applicants must hold, or be happy to apply for, a valid Basic Disclosure Scotland. Please click the link to apply.