Data Warehouse Developer

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

• Bachelor’s degree in Computer Science, Information Technology, or a related field.
• Proven experience in designing, developing, and maintaining data warehouses using the Microsoft Azure tech stack.
• Strong proficiency with Azure SQL Data Warehouse, Azure Data Factory, Azure Data Lake, and other relevant Azure services.
• Deep understanding of data warehousing concepts, ETL processes, and data integration techniques.
• Experience with handling large-scale data and ensuring data quality, consistency, and performance.
• Proficient in SQL and other data manipulation languages.
• Familiarity with data governance best practices and data management principles.
• Excellent problem-solving skills and the ability to troubleshoot complex data issues.
• Strong communication and collaboration skills, with the ability to work effectively with cross-functional teams.
• Detail-oriented with a focus on delivering high-quality, accurate, and efficient data solutions.
• Experience with Azure AI services and a solid understanding of how to apply AI and machine learning techniques to gather insights from data.
  If you are passionate about data, have a strong background in data warehousing, and are excited about working with cutting-edge technologies, we would love to hear from you. Join our team and contribute to the success of our data-driven initiatives.
  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

We are seeking a highly skilled and motivated Data Warehouse Developer to join our dynamic team. In this role, you will be responsible for designing and developing a robust data warehouse using the Microsoft Azure tech stack. You will create a scalable and high-performance architecture capable of handling very large volumes of data, ensuring data quality, consistency, and efficiency on an ongoing basis. Reporting directly to the Data Warehouse Architect, you will work closely with the Reporting and Data Science teams to understand their data requirements and manage complex data integrations from various sources. Additionally, you will support the Data Science team in gathering insights from the data using Azure’s AI services.

KEY RESPONSIBILITIES

• Design and develop a comprehensive data warehouse using Microsoft Azure technologies, including Azure SQL Data Warehouse, Data Factory, and Data Lake.
• Architect a scalable and performant data warehouse infrastructure to handle large volumes of data efficiently.
• Ensure the quality, consistency, and reliability of data within the warehouse, implementing best practices for data governance and management.
• Collaborate with the Reporting and Data Science teams to gather and understand data requirements, translating them into effective data warehouse solutions.
• Manage and integrate complex data from disparate sources, ensuring seamless data flow and integrity.
• Perform regular maintenance, monitoring, and optimization of the data warehouse to ensure optimal performance and efficiency.
• Troubleshoot and resolve any issues related to data integrity, data flow, or performance within the data warehouse.
• Support the Data Science team in leveraging Azure AI services to extract insights and actionable intelligence from the data.
• Stay updated with the latest trends and advancements in data warehousing and Microsoft Azure technologies, providing recommendations for improvements and innovations.