Data Warehouse Architect

Found in: Appcast UK C2 - 2 weeks ago

Manchester Area, United Kingdom James Adams Full time

Our client 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.


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.
  • Experience with Google Cloud Platform (GCP)
  • 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.


This position is a fully remote role (Although you are welcome in their Manchester offices if you'd like to come in)

  • Data Warehouse Developer

    3 weeks ago

    Manchester, United Kingdom Data Science Festival Full time

    Data Warehouse Architect Location: Remote/Hybrid Data Idols are working with one of the largest entertainment organisations growing rapidly within their global operations. With innovation, creativity, and data at the company’s heart, they are looking for a Data Warehouse Architect to join the team. As a Data Warehouse Architect you will be...

  • Data Warehouse Architect

    Found in: Whatjobs ES C2 - 1 week ago

    Manchester Area, United Kingdom bet365 Full time

    Who we are looking for A Data Warehouse Architect who will be responsible for designing the changes and improvements required within the data warehouse. Working within a key team in the data engineering department, this role represents an opportunity to design the data warehouse where the day-to-day work is varied and interesting. You will be designing...

  • Data Warehouse Architect

    2 days ago

    Manchester, United Kingdom Energy Jobline ZR Full time

    Job Description Who we are looking for A Data Warehouse Architect who will be responsible for designing the changes and improvements required within the data warehouse. Working within a key team in the data engineering department, this role represents an opportunity to design the data warehouse where the day-to-day work is varied and interesting. You...

  • Data Warehouse Architect

    3 weeks ago

    Manchester, United Kingdom bet365 Full time

    Who we are looking for A Data Warehouse Architect who will be responsible for designing the changes and improvements required within the data warehouse. Working within a key team in the data engineering department, this role represents an opportunity to design the data warehouse where the day-to-day work is varied and interesting. You will be designing...

  • Data Warehouse Architect

    Found in: Jooble UK C2 - 3 weeks ago

    Manchester, United Kingdom bet365 Full time

    Who we are looking for A Data Warehouse Architect who will be responsible for designing the changes and improvements required within the data warehouse. Working within a key team in the data engineering department, this role represents an opportunity to design the data warehouse where the day-to-day work is varied and interesting. You will be designing...

  • Data Architect

    Found in: Appcast Linkedin GBL C2 - 2 days ago

    London Area, United Kingdom Mastek Full time

    Job Summary: We are looking for a skilled and experienced Data Architect Technical to work as part of our IT team. As a Data Architect Technical, you will be responsible for designing, developing, and maintaining the data architecture for our organization. You will have a strong understanding of data integration best practices and will play a key role in...

  • Data Architect

    Found in: Appcast UK C C2 - 16 hours ago

    London Area, United Kingdom Mastek Full time

    Job Summary: We are looking for a skilled and experienced Data Architect Technical to work as part of our IT team. As a Data Architect Technical, you will be responsible for designing, developing, and maintaining the data architecture for our organization. You will have a strong understanding of data integration best practices and will play a key role in...

  • Data Architect

    Found in: Whatjobs ES C2 - 2 days ago

    London Area, United Kingdom Mastek Full time

    Job Summary: We are looking for a skilled and experienced Data Architect Technical to work as part of our IT team. As a Data Architect Technical, you will be responsible for designing, developing, and maintaining the data architecture for our organization. You will have a strong understanding of data integration best practices and will play a key role in...

  • Data Architect

    Found in: Appcast UK C2 - 17 hours ago

    London Area, United Kingdom Mastek Full time

    Job Summary: We are looking for a skilled and experienced Data Architect Technical to work as part of our IT team. As a Data Architect Technical, you will be responsible for designing, developing, and maintaining the data architecture for our organization. You will have a strong understanding of data integration best practices and will play a key role in...

  • Service Architect

    5 days ago

    Manchester, United Kingdom Energy Jobline ZR Full time

    The Senior Data Architect is accountable for enabling the technical vision and strategy for the organisations use of data. You will be accountable for defining and maintaining the technical data architecture roadmap offering advise and guidance to business stakeholders. You will ensure that data architect solutions align with business requirements and data...

  • Service Architect

    Found in: Jooble UK C2 - 3 weeks ago

    Manchester, United Kingdom TalkTalk Full time

    The Senior Data Architect is accountable for enabling the technical vision and strategy for the organisations use of data. You will be accountable for defining and maintaining the technical data architecture roadmap offering advise and guidance to business stakeholders. You will ensure that data architect solutions align with business requirements and data...

  • Service Architect

    3 weeks ago

    Manchester, United Kingdom TalkTalk Full time

    The Senior Data Architect is accountable for enabling the technical vision and strategy for the organisations use of data. You will be accountable for defining and maintaining the technical data architecture roadmap offering advise and guidance to business stakeholders. You will ensure that data architect solutions align with business requirements and data...

  • Senior Data Architect

    Found in: Appcast Linkedin GBL C2 - 3 weeks ago

    Manchester Area, United Kingdom TalkTalk Full time

    Job Description SummaryThe Senior Data Architect is accountable for enabling the technical vision and strategy for the organisations use of data. You will be accountable for defining and maintaining the technical data architecture roadmap offering advise and guidance to business stakeholders. You will ensure that data architect solutions align with business...

  • Senior Data Architect

    Found in: Appcast UK C C2 - 2 weeks ago

    Manchester Area, United Kingdom TalkTalk Full time

    Job Description SummaryThe Senior Data Architect is accountable for enabling the technical vision and strategy for the organisations use of data. You will be accountable for defining and maintaining the technical data architecture roadmap offering advise and guidance to business stakeholders. You will ensure that data architect solutions align with business...

  • Senior Data Architect

    Found in: Whatjobs ES C2 - 1 week ago

    Manchester Area, United Kingdom TalkTalk Full time

    Job Description Summary The Senior Data Architect is accountable for enabling the technical vision and strategy for the organisations use of data. You will be accountable for defining and maintaining the technical data architecture roadmap offering advise and guidance to business stakeholders. You will ensure that data architect solutions align with...

  • Senior Data Architect

    Found in: Appcast UK C2 - 2 weeks ago

    Manchester Area, United Kingdom TalkTalk Full time

    Job Description SummaryThe Senior Data Architect is accountable for enabling the technical vision and strategy for the organisations use of data. You will be accountable for defining and maintaining the technical data architecture roadmap offering advise and guidance to business stakeholders. You will ensure that data architect solutions align with business...

  • Data Architect

    Found in: Appcast Linkedin GBL C2 - 3 days ago

    London Area, United Kingdom AgnesCole Consulting Full time

    Data Architect (Azure)Our client, a leading analytics and consulting firm, is seeking an experienced Data Architect to join their dynamic team. In this role, you will be responsible for designing and implementing robust data solutions leveraging the power of Microsoft Azure.Key Responsibilities:Analyse business requirements and translate them into scalable,...

  • Data Architect

    Found in: Appcast UK C C2 - 3 days ago

    London Area, United Kingdom AgnesCole Consulting Full time

    Data Architect (Azure)Our client, a leading analytics and consulting firm, is seeking an experienced Data Architect to join their dynamic team. In this role, you will be responsible for designing and implementing robust data solutions leveraging the power of Microsoft Azure.Key Responsibilities:Analyse business requirements and translate them into scalable,...

  • Data Architect

    Found in: Appcast UK C2 - 3 days ago

    London Area, United Kingdom AgnesCole Consulting Full time

    Data Architect (Azure)Our client, a leading analytics and consulting firm, is seeking an experienced Data Architect to join their dynamic team. In this role, you will be responsible for designing and implementing robust data solutions leveraging the power of Microsoft Azure.Key Responsibilities:Analyse business requirements and translate them into scalable,...

  • Data Architect

    Found in: Whatjobs ES C2 - 3 days ago

    London Area, United Kingdom AgnesCole Consulting Full time

    Data Architect (Azure) Our client, a leading analytics and consulting firm, is seeking an experienced Data Architect to join their dynamic team. In this role, you will be responsible for designing and implementing robust data solutions leveraging the power of Microsoft Azure. Key Responsibilities: Analyse business requirements and translate them into...