Data Engineer (T-SQL, Python)

Mick George Group; Ellington; On-site; GBP 35,000 - 55,000; Full time

Job summary

A leading construction firm in England is seeking a Data Engineer to enhance their data infrastructure. The successful candidate will develop and maintain T-SQL queries, design data pipelines, and manage SQL Server databases. This is an exciting opportunity for someone with a passion for data to work in a dynamic team environment. The role offers company benefits, including a pension and training opportunities.

Benefits

Company Pension

Employee Assistance Programme

28 days holiday inclusive of bank holidays

Company benefit platform

Cycle to work scheme

Internal training and career development

Qualifications

• Experience with T-SQL and SQL Server (2016 or later preferred).
• Background as a SQL Database Administrator.
• Experience with data warehouse design principles.

Responsibilities

• Develop, optimise, and maintain T-SQL queries and stored procedures.
• Design and implement efficient data pipelines.
• Support the management of SQL Server databases.

Skills

T-SQL

Python scripting

SQL Database Administration

SSIS ETL concepts

Microsoft SSRS

PowerBI

Problem-solving

Communication skills

Git awareness

Cloud services (Azure)

Job description

As part of our continued growth, we are seeking a Data Engineer with expertise in T‑SQL, Python, and some SQL Database Administration (DBA) to join our dynamic team. You will play a pivotal role in the reporting, design, development, and optimisation of our data infrastructure. You will be responsible for managing and reporting on our databases, building robust data pipelines, and ensuring the integrity and performance of critical systems and data warehouses. This is an excellent opportunity for someone who is passionate about data and wants to work in a fast‑paced environment where they can make a big impact.

Responsibilities

• Develop, optimise, and maintain complex T‑SQL queries, stored procedures, and functions.
• Design and implement efficient data pipelines.
• Support maintaining Microsoft SSRS and PowerBI reporting.
• Support the management of SQL Server databases, including installation, configuration, upgrades, and performance tuning.
• Monitor database health and troubleshoot performance issues as necessary.
• Ensure data quality, normalisation, security, and compliance with internal and external standards.
• Collaborate with and aid Business Stakeholders in the delivery of efficient data solutions.
• Assist in developing best practices and standards for data engineering.
• Adhoc tasks within the department as required.

Qualifications

• Experience with T‑SQL and SQL Server (2016 or later preferred).
• Python for scripting, data processing, and automation.
• Background as a SQL Database Administrator.
• Experience with SSIS ETL concepts and data warehouse design principles.
• Experience with Microsoft SSRS and PowerBI (or similar reporting technology).
• Understanding of data warehouse principles.
• Excellent problem‑solving skills and attention to detail.
• Strong communication skills and the ability to work collaboratively in a team environment.
• Awareness of source control systems such as Git.
• Exposure to cloud services (e.g., Azure) and DevOps principles.

Benefits

• Company Pension
• Employee Assistance Programme
• 28 days holiday inclusive of bank holidays
• Company benefit platform
• Cycle to work scheme
• Internal training and career development.

Equal Opportunity Statement

The Mick George Group is committed to providing equality of opportunity for all. The company seeks to employ a workforce that reflects the diverse community at large and values the individual's contribution irrespective of sex, age, marital status, disability, sexual orientation, gender reassignment, race, colour, religion or belief, ethnic or national origin.