Data Engineer at WPP Media

Chennai, tamil nadu, India -

Full Time

Start Date

Immediate

Expiry Date

26 Aug, 26

Salary

0.0

Posted On

28 May, 26

Experience

2 year(s) or above

Remote Job

Yes

Telecommute

Yes

Sponsor Visa

Skills

SQL, Azure Data Factory, T-SQL, Azure Data Lake, Data Modeling, ELT Pipelines, Azure Synapse, Google BigQuery, Azure DevOps, Agile Methodology, API Integration, Master Data Management, Data Warehousing, Git, Unit Testing, Azure Purview

Industry

Advertising Services

Description

WPP is the trusted growth partner for the world’s leading brands. We unite cutting-edge media intelligence and data solutions, world-class creativity, next-generation production, transformative enterprise solutions and expert strategic counsel in a single company – powered by exceptional talent and our agentic marketing platform, WPP Open, to help our clients navigate change, capture opportunity and deliver transformational growth. We have been building the world's most valuable brands for 50 years and have global reach across 100+ markets, with deep local expertise. Our people are the key to our success. We're committed to fostering a culture of creativity, belonging and continuous learning, attracting and developing the brightest talent, and providing exciting career opportunities that help our people grow. For more information, visit WPP.com. Why we're hiring: WPP is at the forefront of the marketing and advertising industry's largest transformation. Our Global CIO is leading a significant evolution of our Enterprise Technology capabilities, bringing together over 2,500 technology professionals into an integrated global team. This Team will play a crucial role in enabling the ongoing transformation of our agencies and functions. At WPP, technology is at the heart of everything we do, and it is WPP IT’s mission to enable everyone to collaborate, create and thrive. WPP IT is undergoing a significant transformation to modernise ways of working, shift to cloud and micro-service-based architectures, drive automation, digitise colleague and client experiences and deliver insight from WPP’s petabytes of data. 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. 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. This role will work as part of the Global Investment Systems Team. You will be responsible for product development and maintenance of data solutions. You will collaborate with the implementation function for supporting solution roll-out. What you'll be doing: Assist in the build, development, and management of custom databases/solutions using SQL and Azure data technology stack. Design, build and deploy ELT pipelines and data management processes. Operationalise ELT job workflow with reliable error/exception handling and rollback framework. 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. Participate in developing, designing, configuring, and documenting database architecture. Monitor and improve data loading performance. Conform to agile development practices – Evolutionary design, refactoring, continuous integration/delivery, test-driven development. Work collaboratively with Business Partner Team and Business Stakeholder during projects scoping and feasibility phases as a SME for concept investigation/viability and technical impact; Identify and communicate technical risks and mitigations. Provide production support for data load jobs. Write customized query to generate automatic periodic reports. Maintain or upgrade existing applications. Attend key design meetings and provide support. Who you'll be working with: Bachelor’s degree in computer science, Engineering, Mathematics or other technical field is highly preferred. Experience in creating and managing Azure Data Factory pipelines and writing TSQL (views/functions/stored procedures). Experience in managing Azure Data Lake structure and security Experience with data modeling Ability to understand and communicate business requirements from non-technical stakeholders while simultaneously managing their expectations. Experience with the full development life cycle of an application stack - from architecture through test and deployment. Experience in Master Data management solutions. Experience in data warehouse analysis and design, with full knowledge of data warehouse methodologies and data modelling. Unit testing low level components – SQL scripts, Stored Procedures, ETL/ELT modules; Integration testing data transition points; Performance, load and stress testing. Knowledge and experience in software development methodology and toolset for implementing, lifecycle and management – Agile methodology. GIT code repository and branching strategies; Microsoft Release Management and any deployment tools; Azure DevOps knowledge. Experience with Azure cloud solutions; Knowledge of Azure Data Factory, Azure Automation, Azure Data Lake, Azure Synapse, Azure Purview, Azure KeyVault, and Azure Batch. Experience with Google Cloud Platform solutions; knowledge of Google BigQuery, Google Storage, and Google CloudRun Experience with APIs. Team player Organized and detail oriented Excellent communication, presentation, and writing skills Thrives in a fast paced, constantly changing environment 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 open-minded: to 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 aim to create a culture in which people can 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? 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. WPP 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. Please read our Privacy Notice (https://www.wpp.com/en/careers/wpp-privacy-policy-for-recruitment) for more information on how we process the information you provide.

Responsibilities

Responsible for the development and maintenance of custom data solutions and ELT pipelines using the Azure data technology stack. Collaborates with business stakeholders to design database architectures and provide production support for data load jobs.