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 life cycle, 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 modelling principles, including dimensional modelling 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.