Data Warehouse Architect - United Kingdom - James Adams

Description

Job Description:
Data Warehouse Architect

Company Overview:
We are in search of a dynamic Data Warehouse Architect to join our esteemed data engineering department.

This role offers an exciting opportunity to design and enhance our data warehouse, catering to a range of projects from large-scale business transformative programmes to minor user-specific improvements.

Position Summary:
The Data Warehouse Architect will play a pivotal role in designing changes and improvements to our data warehouse.

This role requires collaboration with various departments to ensure high-quality work and to meet the evolving demands of the business.

Key Responsibilities:
1.

Data Warehouse Design:

• Develop and refine the data warehouse design using the Kimball methodology.
• Design logical Change Data Capture (CDC) strategies to extract data from source systems.
• Collaborate with the Extract, Transform, Load (ETL) process and data warehouse developers, providing them with detailed information to modify and enhance the data warehouse based on business requirements

2 Team Collaboration:

• Work closely with report developers to ensure the data warehouse design optimizes reports generated within MicroStrategy and SSRS.
• Participate in multi-developer projects, collaborating effectively with other team members

3 Business Understanding:

• Acquire an in-depth understanding of the business data structures to design solutions that align with business objectives and requirements

4 Development and Documentation:

• Develop solutions in compliance with departmental standards and the established development process.
• Create and maintain comprehensive documentation related to data warehouse design, changes, and improvements

Preferred Skills and Experience:

• Proven knowledge of database and data warehouse design, including expertise in the Kimball methodology.
• Commercial experience in data warehouse implementation, preferably in a Cloud environment.
• Strong understanding of relational theory and set-based processing.
• Excellent communication skills with a keen ability to meet deadlines.
• Proficiency in writing complex SQL queries.
• Experience working in a team-focused environment, delivering high-quality solutions.
• Ability to thrive in a dynamic and reactive environment, demonstrating a flexible and proactive approach to work.
• A strong interest in understanding and maximizing the business value of data

Qualifications:

• Bachelor's degree in Computer Science, Information Systems, or a related field.
• Relevant certifications in data warehousing, database design, or related areas are a plus

What We Offer:

• Competitive salary and benefits package.
• Opportunity to work in a collaborative and innovative environment.
• Continuous learning and professional development opportunities.
• A culture that values diversity, inclusion, and work-life balance.

Join us and contribute to shaping the future of our data warehouse, making a meaningful impact on our business and ensuring we remain at the forefront of data-driven decision-making.