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.