Data Warehouse Developer

Job Responsibilities

• Design and implement ETL procedures for intake of data from both internal and outside sources, as well as ensure data is verified and quality is checked;
• Collaborate with business and technology stakeholders in ensuring data warehouse architecture development and utilization.
• Work with business analysts and project managers to develop and refine reporting and analytics requirements.
• Work on complex projects that require both depth and breadth of knowledge in a number of technologies and the business.
• Participate on projects, clarifying the business requirements, performing systems analysis, development and modification activities, as well as related maintenance & support.
• Assist in planning sessions with the business users to analyze business requirements, and provide design recommendations.
• Write concise and clear technical specifications based on analysis of complex business requirements.
• Translate business and technical requirements into business application systems.

Experience Required

• Advanced knowledge of SQL including complex stored procedures, functions, query optimization, indexing strategy.
• 3+ years of experience of SSIS and SQL Server Database.
• Proven track record in delivering scalable and reliable DW solutions.
• Strong data modeling and dimensional modeling skills (including slowly changing dimensions).
• Experience with data quality and data profiling.
• ETL/ELT design and development experience.
• Experienced in designing, building and maintaining large/complex DW systems is desirable.
• Experience with Tableau is also desirable.
• Experience of Azure Data Storage, Azure Data Lakes and Azure SQL DB is desirable
• Experience of Azure DevOps (pipelines, repos, releases etc.) is desirable

Essential and Desirable Skills

• Delivery focused with a strong aptitude for team motivation
• Highly organised and structured approach to working
• Strong analytical skills that ensure projects are delivered to an accurate and high quality standard.
• Ability to work effectively in a team environment.
• Superb oral/written communication skills.

Educational Requirements

• Third Level Qualification in Computer Science / IT or relevant work experience.
• MS/Azure certifications desirable