Senior Data Warehouse Engineer - Contract Role

Senior Data Warehouse Engineer - Contract Role

* Location: Hybrid (Dublin-based), 1-2 days per week onsite
* Day Rate: £450 per day (approx. €525 per day)
* Duration: Daily rate contractor

Overview
We are seeking a highly skilled Senior Data Warehouse Engineer to join our growing IT team. This role is pivotal in designing, developing, and maintaining enterprise-level data solutions that support critical business operations. You will work across the full development lifecycle, delivering robust data warehouse and ETL processes both on-premises and in the cloud. The position involves close collaboration with stakeholders to ensure solutions align with strategic objectives while maintaining compatibility with existing reporting frameworks.

Key Responsibilities

* Design and build efficient ETL workflows to integrate data from internal and external sources, ensuring accuracy and quality throughout the process.
* Partner with business and technical teams to shape and optimize data warehouse architecture.
* Translate business requirements into technical specifications and deliver scalable reporting and analytics solutions.
* Contribute to complex projects requiring deep technical expertise across multiple technologies.
* Participate in planning and analysis sessions, providing recommendations for data design and architecture.
* Develop clear, concise documentation for technical specifications and system changes.
* Ensure new solutions integrate seamlessly with legacy reporting systems.

Required Experience

* Advanced SQL skills, including performance tuning, indexing strategies, and complex stored procedures.
* Minimum 7 years of hands-on experience with SSIS and SQL Server.
* Proven ability to deliver reliable, scalable data warehouse solutions.
* Strong understanding of data modeling principles, including dimensional modeling and slowly changing dimensions.
* Experience in ETL/ELT design and development.
* Familiarity with data quality and profiling techniques.
* Background in building and maintaining large-scale data warehouse environments.
* Exposure to Tableau for reporting and visualization (preferred).
* Knowledge of Azure Data Services (Data Lake, Azure SQL DB) and Azure DevOps tools (pipelines, repos, releases) is highly desirable.

Education & Certifications

* Degree in Computer Science, Information Technology, or equivalent professional experience.
* Microsoft/Azure certifications are an advantage.

Core Competencies

* Results-driven with strong problem-solving and analytical skills.
* Highly organized with a structured approach to project delivery.
* Excellent communication skills, both written and verbal.
* Ability to work collaboratively within a team environment.
* Strong attention to detail and commitment to quality.