Data Warehouse Architect

7 days ago


London, United Kingdom Warehouse Nantes Full time

Who Are We?

T&P m is one of the world’s leading full service creative and media agencies, connecting talent and tech to drive growth for brands. Formed by the integration of The&Partnership and mSix&Partners, it brings together content and distribution into a single, holistic end-to-end marketing solution. Backed by WPP and GroupM and combined with the agility of an entrepreneurial Partner-led mindset, the multi-discipline agency spans four continents with 45 offices and over $1.2 billion dollars in billings globally. As an early adopter with the first ever AI-generated TV ad for Lexus in 2018, T&P m is focused on harnessing AI across all its outputs with its 1,900 people already trained on WPP’s proprietary AI platform Creative Studio, to deliver enhanced outcomes for clients.

We believe in The Power of &, bringing diverse talent together to transform the way great brands are built. Our teams blend creative, media, experience and technology specialists from across our marketing practices. The performance mindset of these teams optimises to business outcomes in every channel, fuelled by the latest innovations in AI. Working alongside our clients’ marketing departments, we deliver ‘&mplified Creativity’ to solve their business and brand challenges seamlessly, creatively and efficiently.

Ultimately of course, we are our people. They’re the most important part of our business, so we want to make a lasting impression on them in the same way they do on us, by striving to become the most important place in their careers.

That’s why we do our best to build strong communities around them; provide the best possible opportunities for them to develop & grow; and empower them to make a difference to their clients and the world at large. Our strengths often lie in our differences, so we challenge and champion each other and our clients, to be the very best we can be.

The Role

As we look to double in size again in the next five years across the group, we need to enhance our data infrastructure and related offering. This role will ensure the right data warehouse system is built and integrated with all the relevant data sources, the data can be accessed via reports (Power BI), dashboards, external clients, APIs, etc., the system is maintained with minimal downtime and data accuracy is regularly monitored with the help of the team reporting into them.

Key Responsibilities

  • Create a data warehouse architecture that will best support the specific data needs of T&Pm, and implement it using the Microsoft Azure tech stack
  • Build and manage a small team of integration and devolps specialists
  • Ensure data accuracy and system performance

Skills and Experience

  • Extract, Transform, Load (ETL) data integration process
  • Enterprise application integration (EAI)
  • Designing and organizing data models within a data warehouse platform
  • Database administration and software development experience
  • Working with large and frequently changing data sets
  • Reporting using Power BI and washboarding
  • Experience in modelling and integrating media performance data into a data warehouse would be beneficial

T&P m embraces and celebrates diversity, inclusivity, and equal opportunity. We are committed to building a team that represents a variety of backgrounds, perspectives, and skills. We are a worldwide creative agency that represents global clients. The more inclusive we are, the more brilliant work we can create together.

#J-18808-Ljbffr

  • London, Greater London, United Kingdom Warehouse Nantes Full time

    About the RoleWe are seeking a highly skilled Data Warehouse Architect to join our team at Warehouse Nantes. As a key member of our data infrastructure team, you will be responsible for designing and implementing a robust data warehouse system that meets the specific needs of our organization.Key ResponsibilitiesDesign and implement a data warehouse...


  • London, Greater London, United Kingdom Warehouse Nantes Full time

    About the RoleWe are seeking a highly skilled Data Warehouse Architect to join our team at Warehouse Nantes. As a key member of our data infrastructure team, you will be responsible for designing and implementing a robust data warehouse system that meets the specific needs of our organization.Key ResponsibilitiesDesign and implement a data warehouse...


  • London, Greater London, United Kingdom Warehouse Nantes Full time

    About the RoleWe are seeking a highly skilled Data Warehouse Architect to join our team at Warehouse Nantes. As a key member of our data infrastructure team, you will be responsible for designing and implementing a robust data warehouse system that meets the specific needs of our organization.Key ResponsibilitiesDesign and implement a data warehouse...


  • London, Greater London, United Kingdom Warehouse Nantes Full time

    About the RoleWe are seeking a highly skilled Data Warehouse Developer to join our team at Warehouse Nantes. As a Data Warehouse Developer, you will play a critical role in designing, implementing, and maintaining our data warehouse system.Key ResponsibilitiesCreate a data warehouse architecture that will best support the specific data needs of Warehouse...


  • London, Greater London, United Kingdom Warehouse Nantes Full time

    About the RoleWe are seeking a highly skilled Data Warehouse Developer to join our team at Warehouse Nantes. As a Data Warehouse Developer, you will play a critical role in designing, implementing, and maintaining our data warehouse system.Key ResponsibilitiesCreate a data warehouse architecture that will best support the specific data needs of Warehouse...


  • London, United Kingdom Warehouse Nantes Full time

    Who Are We? T&P m is one of the world’s leading full service creative and media agencies, connecting talent and tech to drive growth for brands. Formed by the integration of The&Partnership and mSix&Partners, it brings together content and distribution into a single, holistic end-to-end marketing solution. Backed by WPP and GroupM and combined with...


  • London, United Kingdom Warehouse Nantes Full time

    Who Are We? T&P m is one of the world’s leading full service creative and media agencies, connecting talent and tech to drive growth for brands. Formed by the integration of The&Partnership and mSix&Partners, it brings together content and distribution into a single, holistic end-to-end marketing solution. Backed by WPP and GroupM and combined with...


  • London, Greater London, United Kingdom Data Idols Full time £60,000 - £65,000

    About the RoleWe are seeking a highly skilled Data Warehouse Developer to join our team at Data Idols. As a Data Warehouse Developer, you will play a critical role in designing, building, and maintaining our data warehouse infrastructure.Key ResponsibilitiesDesign and implement data warehouse solutions using SQL, AB Initio, and GCP.Develop and maintain ETL...


  • London, Greater London, United Kingdom Data Idols Full time £60,000 - £65,000

    About the RoleWe are seeking a highly skilled Data Warehouse Developer to join our team at Data Idols. As a Data Warehouse Developer, you will play a critical role in designing, building, and maintaining our data warehouse infrastructure.Key ResponsibilitiesDesign and implement data warehouse solutions using SQL, AB Initio, and GCP.Develop and maintain ETL...


  • London, Greater London, United Kingdom Data Idols Full time

    About the RoleData Idols is seeking a highly skilled Data Warehouse Developer to join our team. As a Data Warehouse Developer, you will play a key role in designing, building, and maintaining our data warehouse infrastructure.The OpportunityDesign and implement data warehouse solutions using Ab InitioWork closely with cross-functional teams to understand...


  • London, Greater London, United Kingdom Data Idols Full time

    About the RoleData Idols is seeking a highly skilled Data Warehouse Developer to join our team. As a Data Warehouse Developer, you will play a key role in designing, building, and maintaining our data warehouse infrastructure.The OpportunityDesign and implement data warehouse solutions using Ab InitioWork closely with cross-functional teams to understand...


  • London, Greater London, United Kingdom Data Idols Full time £60,000 - £65,000

    About the RoleWe are seeking a highly skilled Data Warehouse Developer to join our team at Data Idols. As a key member of our organization, you will be responsible for designing and implementing a scalable data warehouse solution to support our business growth.Key ResponsibilitiesDesign and develop a robust data warehouse architecture to meet the needs of...


  • London, Greater London, United Kingdom Data Idols Full time £60,000 - £65,000

    About the RoleWe are seeking a highly skilled Data Warehouse Developer to join our team at Data Idols. As a key member of our organization, you will be responsible for designing and implementing a scalable data warehouse solution to support our business growth.Key ResponsibilitiesDesign and develop a robust data warehouse architecture to meet the needs of...


  • London, Greater London, United Kingdom Mentmore Recruitment Full time

    Job Title: Data Warehouse ArchitectCompany: Mentmore RecruitmentJob Type: Full-timeLocation: Remote (London)About the Company:Mentmore Recruitment is a leading recruitment agency specializing in placing top talent in the data and technology sector. We work closely with our clients to understand their unique needs and provide tailored solutions to drive...


  • London, Greater London, United Kingdom Mentmore Recruitment Full time

    Job Title: Data Warehouse ArchitectCompany: Mentmore RecruitmentJob Type: Full-timeLocation: Remote (London)About the Company:Mentmore Recruitment is a leading recruitment agency specializing in placing top talent in the data and technology sector. We work closely with our clients to understand their unique needs and provide tailored solutions to drive...


  • London, Greater London, United Kingdom Mentmore Full time £80,000

    About the RoleMentmore is seeking a highly skilled and motivated Data Warehouse Developer to join their dynamic team. As a key member of the data team, you will be responsible for designing and developing a robust data warehouse using the Microsoft Azure tech stack.Key ResponsibilitiesDesign and develop a comprehensive data lake + data warehouse using...


  • London, Greater London, United Kingdom Mentmore Full time £80,000

    About the RoleMentmore is seeking a highly skilled and motivated Data Warehouse Developer to join their dynamic team. As a key member of the data team, you will be responsible for designing and developing a robust data warehouse using the Microsoft Azure tech stack.Key ResponsibilitiesDesign and develop a comprehensive data lake + data warehouse using...


  • London, Greater London, United Kingdom T&Pm Full time

    About T&PmT&Pm is a leading global creative and media agency, connecting talent and technology to drive growth for brands. As a pioneer in the industry, we've integrated The&Partnership and mSix&Partners to bring together content and distribution into a single, holistic end-to-end marketing solution.Our MissionWe believe in harnessing the power of artificial...


  • London, Greater London, United Kingdom T&Pm Full time

    About T&PmT&Pm is a leading global creative and media agency, connecting talent and technology to drive growth for brands. As a pioneer in the industry, we've integrated The&Partnership and mSix&Partners to bring together content and distribution into a single, holistic end-to-end marketing solution.Our MissionWe believe in harnessing the power of artificial...


  • London, United Kingdom Warehouse Nantes Full time

    T&P m is one of the world’s leading full service creative and media agencies, connecting talent and tech to drive growth for brands. Formed by the integration of The&Partnership and mSix&Partners, it brings together content and distribution into a single, holistic end-to-end marketing solution. As an early adopter with the first ever AI-generated TV ad...