Data Engineer T-SQL Python

The Mick George Group; Huntingdon; On-site; GBP 60,000 - 80,000; Full time

Job summary

A leading construction supplier in the UK is seeking a Data Engineer with expertise in T-SQL and Python to enhance their data infrastructure. The successful candidate will design data pipelines, optimize query performance, and manage SQL Server databases. This role offers the opportunity to work collaboratively in a dynamic team, providing a significant impact on the company's data solutions. Ideal for proactive candidates passionate about data and innovation.

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

• Expertise in T-SQL for query development and optimization.
• Proficient in Python for data processing and automation.
• Experience as SQL Database Administrator is preferred.
• Familiarity with SSIS ETL concepts and data warehouse design.

Responsibilities

• Develop and maintain T-SQL queries and stored procedures.
• Design data pipelines for efficient data flow.
• Manage SQL Server installations and performance tuning.
• Ensure data quality and compliance with standards.

Skills

T-SQL and SQL Server

Python

SQL Database Administration

SSIS ETL concepts

Microsoft SSRS

PowerBI

Datawarehouse Principles

Problem-solving skills

Communication skills

Git awareness

Cloud services (e.g., Azure)

Job description

Here at the Mick George Group, we are currently recruiting a Data Engineer (T-SQL, Python) to join the Technology department.

Location: Mick George Head Office - Huntingdon

Working Hours: Monday – Friday 8am – 5pm

Pay: To be discussed during interview.

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

Who is Mick George?

One Man, One Tipper, One dream, may seem a distant memory, but the dream is very much a reality, as we find ourselves approaching 40 years since the business started trading.

Now operating over 600 HGV vehicles from over 40 separate sites, employing more than 1,000 local people, gives an indication of the scale to which the business has evolved over the years and explains why the Mick George Group has grown to become one of the leading suppliers to the Construction Industry in the heart of East Anglia and East Midlands.

Our aim is to ensure that we provide the highest possible standards to each and every stakeholder that comes in to contact with any aspect of our business, whether that be as an employee, supplier, customer or other.

Role Purpose

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 with maintaining Microsoft SSRS and PowerBI reporting
• Support in the management of SQL Server databases, including installation, configuration, upgrades, and performance tuning
• Support in monitoring database health and if necessary, troubleshoot performance issues
• 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

Key Skills

• T-SQL and SQL Server (2016 or later preferred)
• Python for scripting, data processing, and automation
• Experience of SQL Database Administrator
• Experience of SSIS ETL concepts and data warehouse design principles
• Experience of Microsoft SSRS and PowerBI (or similar Reporting Technology)
• Understanding of Datawarehouse 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) & DevOps principles

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.