Data Engineer

As part of their continued growth, we are seeking a Data Engineer with expertise in T-SQL, Python, and some SQL Database Administration (DBA) to join their dynamic team.

You will play a pivotal role in the reporting, design, development, and optimisation of their data infrastructure. You will be responsible for managing and reporting on the 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

• 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 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) & DevOps principles.