Business / Technical Analyst

About WPP Media WPP is the creative transformation company. We use the power of creativity to build better futures for our people, planet, clients and communities. For more information, visit WPP Media is WPP's global media collective. In a world where media is everywhere and in everything, we bring the best platform, people, and partners together to create limitless opportunities for growth. For more information, visit About Choreograph: A Leading WPP Media Brand Choreograph is WPP's global data products and technology company. We're on a mission to transform marketing by building the fastest, most connected data platform that bridges marketing strategy to scaled activation. We work with agencies and clients to transform the value of data by bringing together technology, data and analytics capabilities. We deliver this through the Open Media Studio, an AI-enabled media and data platform for the next era of advertising. We're endlessly curious. Our team of thinkers, builders, creators and problem solvers are over 1,000 strong, across 20 markets around the world. Role Summary and Impact We are looking for a detail-oriented and analytical Technical Analyst to join our team building a state-of-the-art media data lake on Azure. This role will bridge the gap between business requirements and technical implementation, working closely with stakeholders, data engineers, and data architects. The Technical Analyst will be responsible for gathering requirements, defining data specifications, performing data analysis, and ensuring the data solutions meet business needs within the medallion architecture framework WHAT YOU WILL DO

• Collaborate with business users, product managers, and other stakeholders to gather, analyze, and document data requirements for the media data lake.
• Translate business requirements into detailed technical specifications, including data mapping, transformation rules, and data quality criteria.
• Work closely with Data Engineers and Data Architects to ensure a clear understanding of requirements and to support the design and development process.
• Perform data analysis, data profiling, and data validation to ensure data accuracy, completeness, and consistency within the Bronze, Silver, and Gold layers of the medallion architecture.
• Develop and maintain documentation related to data sources, data models, data flows, and business logic.
• Assist in the creation of test plans and participate in testing activities to ensure solutions meet requirements.
• Support business users with data-related queries, ad-hoc reporting, and data discovery.
• Identify opportunities for process improvements and data quality enhancements.
• Facilitate communication between technical teams and business stakeholders

Skills and Experience At WPP Media, we believe in the power of our culture and our people. It's what elevates us to deliver exceptional experiences for both our clients and each other. In this role it will be critical to embrace WPP & WPP Media's shared core values:

• Be Extraordinary by Leading Collectively to Inspire transformational Creativity.
• Create an Open environment by Balancing People and Client Experiences by Cultivating Trust .
• Lead Optimistically by Championing Growth and Development to Mobilize the Enterprise .
• Strong analytical and problem-solving skills with the ability to translate business needs into technical solutions.
• Proficiency in SQL for data querying and analysis.
• Experience with data modelling concepts and data warehousing principles.
• Familiarity with data lake concepts and architectures, preferably medallion architecture.
• Excellent communication, documentation, and interpersonal skills.
• Ability to work effectively with both technical and non-technical stakeholders.
• Experience with data visualization tools (e.g., Power BI, Tableau) is a plus.
• Experience working with Azure data services (e.g., Azure Data Lake Storage, Azure Databricks).
• Understanding of ETL/ELT processes.
• Familiarity with Agile development methodologies.
• Knowledge of the media or advertising industry.

Life at WPP Media & Benefits Our passion for shaping the next era of media includes investing in our employees to help them do their best work, and we're just as committed to employee growth as we are to responsible media investment. WPP Media employees can tap into the global WPP Media & WPP networks to pursue their passions, grow their networks, and learn at the cutting edge of marketing and advertising. We have a variety of employee resource groups and host frequent in-office events showcasing team wins, sharing thought leadership, and celebrating holidays and milestone events. Our benefits include competitive medical, group retirement plans, vision, and dental insurance, significant paid time off, preferential partner discounts, and employee mental health awareness days. WPP Media is an equal opportunity employer and considers applicants for all positions without discrimination or regard to particular characteristics. We are committed to fostering a culture of respect in which everyone feels they belong and has the same opportunities to progress in their careers.
We believe the best work happens when we're together, fostering creativity, collaboration, and connection. That's why we've adopted a hybrid approach, with teams in the office around four days a week. If you require accommodations or flexibility, please discuss this with the hiring team during the interview process. Please note this is a UK based role and requires individuals to have the right to work in this location Please read our Privacy Notice ( ) for more information on how we process the information you provide. While we appreciate all applications received, only those candidates selected for an interview will be contacted.