Data Warehouse Engineer

Job Responsibilities

• Translate business and technical requirements into business application systems.
• Technical and Business collaboration to ensure the utilization of data warehouse architecture and development
• Engage alongside business analysts and project managers to develop analytical requirements.
• Design and implement ETL procedures for intake of data from both internal and outside sources, as well as ensuring the data is verified and quality is checked.
• Work on complex projects that require deep knowledge in several technologies and the overall business structure.
• Engage on projects, across business requirements, systems analysis, development and modification activities, as well as support and maintenance.
• Aid in the process of planning sessions with business users to analyse business requirements and provide design recommendations
• Write clear and concise technical specifications based on analysis of complex business requirements.

Experience Required

• In depth knowledge of SQL which includes stored procedures, functions, query optimization, indexing strategy.
• 3+ years of experience of SSIS and SQL Server Databases.
•  Proficiency in designing, building and maintaining large/complex Data Warehouse systems is desirable.
• Strong data and dimensional modelling skills (including slowly changing dimensions).
• Experience with data quality and data profiling.
• Experience in the design and development of ETL/ELT
• Experience with Tableau.
• Experience of Azure Data Storage, Azure Data Lakes and Azure SQL DB is desirable
• Experience of Azure Devops (pipelines, repos, releases etc.) is also desirable

Essential and Desirable Skills

• Excellent communication skills
• Ability to work effectively in a team environment.
• Highly organised and structured approach to working
• Strong analytical skills that ensure projects are delivered to an accurate and high-quality standard.

Educational Requirements

• Computer Science or IT 3^rd level qualification
• MS/Azure certifications are desirable

Working Hours & Benefits

• Pension Scheme
• Annual Bonus
• Christmas saving scheme