*wpp* is the 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.
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.
*
*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.
our clients include 61 of the ftse 100, 317 of the fortune global 500, all 30 of the dow jones 30 and 62 of the nasdaq 100.
wpp are the leader in the bloomberg gender equality index and 8th in the ftse 100 rankings for women on boards.
*
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.
*visit our linkedin page to see what we're up to
*
li-hybrid
*what you'll be doing*:
- responsible for oversight of their team's projects and activities.
- provides coaching and mentorship to team members and actively develops the capabilities of the team
- responsible for in-depth knowledge of assigned software, technologies, and functions, serving as a liaison between program managers users and developers.
- maintain strategic and tactical relationships both internally within the developers, program managers and even externally with business stakeholders
- help the team meet and exceed the support goals
- monitors and communicates team progress to the necessary stakeholders
- simultaneously supports the entire project management cycle of multiple projects
- focuses on the importance of reporting, meeting stated deadline commitments, and communication to stakeholders
- 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.
*skills requirement*:
- bachelor's degree in computer science, engineering, mathematics or other technical field is highly preferred.
- experience with project management methodologies such as agile, waterfall, or hybrid.
previously agile methodology experience is also preferred.
- be skilled in project and priority triage work effectively within broad parameters, and operate with considerable autonomy
- experience creating and managing sql server integration services (ssis) processes and writing tsql (views/functions/stored procedures).
- experience with data modeling, and working with star schema
- ability to understand and communicate business requirements from non-technical stakeholders while simultaneously managing their expectations.
- demonstrated knowledge and experience with master data management.
- demonstrated 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 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.
- tfs/git code repository and branching strategies; microsoft release management and any deployment