.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 115,000 accomplished people in 110 countries. WPP has headquarters in New York, London and Singapore and a corporate presence in major markets worldwide.We create transformative ideas and outcomes for our clients through an integrated offer of communications, experience, commerce, and technology.Why we're hiring: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.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 Local Systems Team for North America. This position will work with the team responsible for delivering critical trading and finance data and business intelligence software used within North America. This position will also have responsibility for understanding client business and technical requirements and then delivering appropriate end-to-end solutions consisting of component-based, services-oriented applications. They will also be responsible for supporting existing applications and processes.What you'll be doing:Assist in the build, development, and management of custom databases/solutions using SQL, SSIS, and ADF both on premise and in Azure.Clearly communicate technical terms to non-technical people and help them understand why change might be required to achieve a specific goal or to complete a project.Design, build and deploy ETL and data management processes. Develop and deploy ETL job workflow with reliable error/exception handling and rollback framework.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.Build applications writing SQL scripts to manipulate data and / or writing specific instructions for an off-shore programmer to write the scripts.Maintain or upgrade existing applications.Attend key design meetings and provide support.Other ad hoc duties