Software Data Engineer

WPP is the creative transformation company. We use the power of creativity to build better futures for our people, planet, clients and communities.

Working at WPP means being part of a global network of more than 109,000 accomplished people in 110 countries. We create transformative ideas and outcomes for its clients through an integrated offer of communications, experience, commerce, and technology. WPP and our award-winning agencies work with most of the world's biggest companies and organisations – from Ford, Unilever and P&G to Google, HSBC, and the UN. 

GroupM is the world’s leading media investment company responsible for more than $63B in annual media investment through agencies Mindshare, MediaCom, Wavemaker, Essence and m/SIX, as well as the outcomes-driven programmatic audience company, Xaxis and data and technology company Choreograph. GroupM’s portfolio includes Data & Technology, Investment and Services, all united in a vision to shape the next era of media where advertising works better for people. By leveraging all the benefits of scale, the company innovates, differentiates and generates sustained value for our clients wherever they do business. 

WPP IT provides IT services for WPP, the world’s largest communications services group. As a creative transformation company, WPP is helping its clients transform the future through extraordinary work. WPP IT is an integral part of that journey and we are proud to provide technology for some of the world’s most creative brands.

The GroupM IT team in WPP IT are the technology solutions partner for the GroupM group of agencies and are accountable for co-ordinating and assuring end-to-end change delivery, managing the GroupM IT technology life-cycle and innovation pipeline. 

Visit our LinkedIn page to see what we're up to!

#LI-Hybrid

What you'll be doing:

As a member of the WPP, IT - GroupM IT team: 

• Design, build, and test end to end data pipeline including data ingestion (streaming, events, and batch), data integration, data curation.
• Build and oversee data architecture & pipelines platforms and systems, managing the flow of data from internal and external sources by leveraging both distributed and local structures.
• Support data platform on the cloud.
• Build and support reusable framework to ingest, integration and provision data.
• Work with disaster recovery planning and execution with other team members.
• Participate in developing, designing, configuring, and documenting database architecture.
• Assist the data analytics team with analyzing and improving data models and answering data questions
• Develop and maintenance of data scrambling procedure for lower environments
• Assist developers and end users in implementing best practices for database architect
• Perform best practice database troubleshooting; fix data corruption; and/or perform daily database administrator (DBA) tasks during Software Development Life Cycle (SDLC), including review logs, and establishing as well as responding to automated monitoring
• Continuous security and maintenance of all SQL instances
• Validation of our entire SQL environments with constructive recommendations for improvement (task automation, etc.).
• Assist in assessing product quality and release readiness

** Working hours: 1:30pm - 9:30pm (IST) - Aligned to UK business hours 

What you'll need:

• Education: completed university studies in Computer Science, Information Technology or comparable
• Personality and Working Practice: team player, good communication skills, analytical thinking and structured
• Experience and Knowledge: 4 years of recent experience in the following areas:
• • Experience with Azure Data Engineering services are mandatory, including Azure Data Lake Data Bricks and Datawarehouse
  • Data analysis, data modeling, and data integration using Azure technologies like Azure Data Factory (ADF) is required
  • Big Data Architecture Concepts (HDFS, Hive)
  • Standard ETL tools and developing and maintaining ETL processes
  • Coordinate with Data Warehouse Architects and DevOps Engineers to implement and enhance data pipeline orchestration using Azure DevOps
  • Using SQL Profiler traces and other tools to find the most frequently run queries and debugging skills
  • Expert-level knowledge of backups, restores, recovery models, database maintenance operations
  • Expert in Performance tuning and query optimization using DMVs, Performance Monitor, SQL Profiler, and other related monitoring and troubleshooting tools
  • Proficiency authoring and analyzing T-SQL code and schema (stored procedures, functions, tables, views, triggers, indexes, constraints)
  • Experience in troubleshooting, configuration management and experience with High Availability (HA)
  • Experience in Managing SQL database Cluster, replication & Mirroring
  • Ability to write complex SQL queries, stored procedures, and data migration scripts.
  • Agile software development and technology best practice methodologies
  • Data Governance processes
  • Comfort with industry standard version control tooling 
  • Media / advertising industry experience is a plus
• Qualifications: certifications or equivalent skills of AZ-204, AI-900, DP-100, DA-100 and/or DP-203 are beneficial
• Languages: very good English skills - other languages are a plus 

Who you are:

You're open: We are inclusive and collaborative; we encourage the free exchange of ideas; we respect and celebrate diverse views. We are accepting: of new ideas, new partnerships, new ways of working.

You're optimistic: We believe in the power of creativity, technology and talent to create brighter futures or our people, our clients and our communities. We approach all that we do with conviction: to try the new and to seek the unexpected.

You're extraordinary: we are stronger together: through collaboration we achieve the amazing. We are creative leaders and pioneers of our industry; we provide extraordinary every day.

What we'll give you:

Passionate, inspired people – We promote a culture of people that do extraordinary work.

Scale and opportunity – We offer the opportunity to create, influence and complete projects at a scale that is unparalleled in the industry.

Challenging and stimulating work – Unique work and the opportunity to join a group of creative problem solvers. Are you up for the challenge?

If this role hasn’t captured your interest, that’s ok! Would you consider sharing your opinion?
  
At WPP, we’re always trying to improve our hiring process, so your feedback is appreciated. Don’t worry, all responses will not influence any future applications that you may make. 

https://forms.office.com/r/JdFf70VQdP

WPP is an equal opportunity employer and considers applicants for all positions without regard to race, color, religion or belief, sex, age, national origin, citizenship status, marital status, military/veteran status, genetic information, sexual orientation, gender identity, physical or mental disability. We believe in creating a dynamic work environment that values diversity and inclusion and strives to recruit a diverse slate of candidates to help us achieve that goal.

Note: We rely on legitimate interest as a legal basis for processing personal information under the GDPR for purposes of recruitment and applications for employment.

When you click the "Submit Application" button below, this will send any information you add below to WPP. Before you do this, we think it's a good idea to read through our Privacy Policy: https://bit.ly/secrets-kept. This explains what we do with your personal data when you apply for a role with us, and, how you can update the information you have provided us with or how to remove it.