Senior SQL Data Engineer
Overview
We are seeking an experienced Senior SQL Data Engineer to design, build, and maintain scalable data solutions supporting reporting, analytics, and operational systems across our client platforms.
This role is ideal for someone with deep expertise in SQL Server, data warehousing, and complex ETL processes who enjoys solving challenging data problems in a business critical environment.
Key Responsibilities
Design, develop, and maintain high performance SQL Server data solutions
Build, optimise, and support complex stored procedures, functions, and views
Develop and maintain robust ETL/ELT pipelines feeding enterprise data warehouses
Ensure data quality, integrity, scalability, and performance across all data platforms
Collaborate with analysts, developers, and business stakeholders to translate requirements into technical solutions
Monitor, troubleshoot, and resolve production data issues
Contribute to data architecture, standards, and best practices
Document data models, workflows, and technical designs
Required Skills & Experience
Strong commercial experience with Microsoft SQL Server
Advanced SQL development and query optimisation skills
Experience designing and maintaining complex stored procedures and functions
Solid understanding of data warehouse principles including:
dimensional modelling
fact and dimension tables
slowly changing dimensions (SCDs)
Hands on experience building and maintaining ETL/ELT pipelines
Strong troubleshooting and problem solving capabilities
Ability to manage multiple priorities in a fast paced environment
Excellent communication and stakeholder engagement skills
Desirable Experience
Experience with ETL tools or SQL based integration solutions
Exposure to cloud platforms such as Microsoft Azure or Amazon Web Services
Familiarity with data governance, security, and compliance best practices
Experience supporting BI and analytics environments
Knowledge of Power BI, SSIS, or Azure Data Factory would be advantageous
What We Offer
Opportunity to work on business critical data platforms and large scale datasets
Collaborative and technically strong engineering environment
Competitive salary and benefits package
Flexible working arrangements
Real opportunity to influence architecture, tooling, and engineering standards