Senior Data Engineer

Job description

Job responsibilities

The primary purpose of the role is to be responsible for designing, building, optimising and maintaining the infrastructure that allows data to flow from various sources to storage systems, supports data storage, processing, and analysis, enables high-quality, secure, and scalable data delivery across the organisation. About the Role

1. Designing, building and maintaining data pipelines.
2. Building and maintaining data warehouses.
3. Data cleansing and transformation.
4. Developing and maintaining ETL processes (ELT = extract, transform, load) to extract, transform, and load data from various sources into data warehouses.
5. Validating charts and reports created by systems built in-house. Creating validation tools.
6. Developing and maintaining data models, data tools.
7. Monitoring and optimising the performance of data pipelines, data storage and processes, identifying and resolving bottlenecks to ensure efficient data processing and retrieval.
8. Ability to integrate data from multiple sources, including databases, APIs, websites, and flat files for efficient data processing.
9. Selecting and integrating appropriate tools and technologies
10. Troubleshooting and resolving data-related issues.
11. Architect scalable data solutions to support advanced analytics, machine learning, and real-time processing needs.
12. Design and implement data governance frameworks, including metadata management, lineage tracking, and cataloging.
13. Ensuring data quality and reliability; ensuring data security and compliance, including GDPR.
14. Document data engineering standards, design decisions, and infrastructure setup for operational transparency.
15. Collaborating with other teams to ensure data availability.
16. Collaborate with data scientists and analysts to ensure data availability for experimentation, model training, and deployment.
17. Defining and delivering clear data engineering work packages and deliverables.
18. Supporting the implementation of new infrastructure to improve the quality and efficiency of projects delivery.
19. Identify opportunities for innovation, improved productivity, efficiency, and quality.
20. Evaluate and prototype new tools or technologies, recommending enhancements to the existing data stack.

Person Specification

Qualifications

• Knowledge and proficiency in working with database systems (SQL/PostgreSQL) and writing performant SQL queries.
• Proficiency in optimising database queries, pipelines, and storage for speed, scalability, and cost-efficiency.
• Skilled in using Git.

Experience

• At least 3 years industry experience.
• Experience in R programming language.
• Experience in Python programming language.
• Experience in designing, building and maintaining data pipelines.
• Experience with data warehousing and data lakes.
• Experience in developing and maintaining ETL processes.
• Experience in developing data integration tools.
• Experience in data manipulation, data analysis, data modelling.
• Experience with cloud platforms (AWS, Azure, etc.)
• Experience in designing scalable, secure, and cost-efficient data architectures aligned with business needs.
• Strong track record of problem-solving ability and troubleshooting skills.
• Excellent IT skills including fluency with all Microsoft packages, particularly Excel, Word, PowerPoint, PowerBi.
• Evidence of excellent communication and interpersonal skills. Clearly communicate technical concepts to both technical and non-technical audiences.
• Adaptability and willingness to learn new technologies.

Disclosure and Barring Service Check

This post is subject to the Rehabilitation of Offenders Act (Exceptions Order) 1975 and as such it will be necessary for a submission for Disclosure to be made to the Disclosure and Barring Service (formerly known as CRB) to check for any previous criminal convictions.

Employer details

Employer name

Mountain Healthcare Ltd

Address

Manchester

City Of Manchester

M4 7DB

Employer's website

https://www.mountainhealthcare.co.uk/