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
