Data Warehouse Engineer

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. You’ll 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 DevOps (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