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.
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.
what you'll need:
* 10+ years experience with creating and managing sql server integration services (ssis) and azure data factory (adf) processes and writing tsql (views/functions/stored procedures).
* bachelor’s degree in computer science, engineering, mathematics or other technical field is highly preferred.
* 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.
* experience with the full development life cycle of an application stack - from architecture through test and deployment.
* 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 tools; jira knowledge; azure devops knowledge.
* experience with azure cloud solutions.
* experience with apis.
* team player.
* organized and detail oriented.
* excellent communication, presentation, and writing skills.
* thrives in a fast paced, constantly changing environment.
* english language, advanced level is required for this role.
who you are:
you're open: we are inclusive and collaborative; we encourage the free exchange of ideas; we respect and celebrate diverse views.
you're optimistic: we believe in the power of creativity, technology and talent to create brighter futures for our people, our clients and our communities.
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?
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.
#j-18808-ljbffr