Data Warehouse Architect

2 weeks ago

Manchester, 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: 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 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

    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

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

  • 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...

  • Service Architect

    3 weeks ago

    Greater Manchester, United Kingdom TalkTalk Telecom Group PLC Full time

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

  • Senior Data Architect

    Found in: beBee jobs GB - 2 weeks ago

    Manchester, United Kingdom TalkTalk Full time

    Job Description SummaryIf you think you are the right match for the following opportunity, apply after reading the complete description.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...

  • Senior Data Architect

    Found in: beBee S GB - 2 weeks ago

    Manchester, United Kingdom TalkTalk Full time

    Job Description SummaryIf you think you are the right match for the following opportunity, apply after reading the complete description.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...

  • Senior Data Architect

    5 days ago

    Manchester, United Kingdom Energy Jobline ZR Full time

    Job Description 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...

  • Senior Data Architect

    Found in: Jooble UK C2 - 3 weeks ago

    Manchester, 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

    3 weeks ago

    Manchester, 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: Talent UK 2A C2 - 3 weeks ago

    Manchester, 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

    3 weeks ago

    Manchester, United Kingdom Maxwell Bond Full time

    Are you a Data Architect looking for a new challenge? I am on the hunt for a Data Architect, who has extensive experience in data migrations from on premise solutions to Azure, who is interested in joining a well known retail and ecommerce company. What's in it for the successful Data Architect: Be part of an innovative retail and ecommerce leader. ...

  • Data Architect

    3 weeks ago

    Manchester, United Kingdom Maxwell Bond Full time

    Are you a Data Architect looking for a new challenge? I am on the hunt for a Data Architect, who has extensive experience in data migrations from on premise solutions to Azure, who is interested in joining a well known retail and ecommerce company. What's in it for the successful Data Architect: Unrivalled learning and growth opportunities. Flexible...

  • Service Architect

    5 days ago

    Salford, Greater Manchester, United Kingdom Knewin Full time

    You will review the ‘as is’ solution, work closely across TalkTalk and wider teams to identify an approach that allows us to move data across various data warehouses to agreed tight timelines and budget. You will support the design data models and metadata systems ensuring artifacts are created, managed and maintained. You will be responsible for...

  • 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: 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...