We are partnering with a large enterprise organisation to hire an experienced Senior Data Warehouse Engineer to join a high-performing data and analytics function.
This role sits within a team responsible for building and supporting mission-critical data platforms that underpin reporting, analytics, and strategic decision-making.
The successful candidate will bring strong end-to-end data warehousing expertise, a passion for high-quality data solutions, and the ability to work closely with both technical and business stakeholders.
Youll be involved in designing, developing, and enhancing data warehouse and data mart solutions across on-premise and cloud environments.
Key Responsibilities Design, build, and maintain robust ETL processes to ingest data from multiple internal and external sources Ensure data accuracy, validation, and quality controls across all pipelines Collaborate with architecture, engineering, and business teams to evolve and optimise the data warehouse platform Partner with business analysts and delivery teams to shape reporting and analytics requirements Contribute to complex data initiatives requiring deep technical expertise and broad system knowledge Translate business needs into scalable, well-designed technical solutions Produce clear, concise technical documentation and specifications Support ongoing enhancements, maintenance, and optimisation of existing data warehouse solutions Required Experience & Skills Advanced SQL expertise, including performance tuning, indexing strategies, and complex stored procedures 7+ years hands-on experience with SQL Server and SSIS Strong track record delivering scalable, reliable data warehouse solutions Excellent data modelling skills, including dimensional modelling and slowly changing dimensions Solid experience in ETL / ELT design and development Data quality, profiling, and reconciliation experience Proven ability to work on large-scale, complex data platforms Desirable Experience Tableau or similar BI/reporting tools Azure data services, including Azure Data Lake, Azure SQL Database, and cloud storage Azure Dev Ops (pipelines, repositories, release management) Experience operating across hybrid (on-prem and cloud) data environments Education & Certifications Third-level qualification in Computer Science, IT, or a related discipline (or equivalent professional experience) Microsoft / Azure certifications are an advantage Competencies Delivery-focused with a strong sense of ownership Highly organised with a structured approach to problem solving Strong analytical mindset and attention to detail Comfortable working collaboratively within cross-functional teams Excellent verbal and written communication skills