Data Warehouse Architect

at  TPM

WHO ARE WE?

T&Pm 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&Pm 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.

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&Pm 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

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