Data Engineer

Job Description

WPP is seeking a Data Engineer to join their Global Investment Systems Team. This role involves product development and maintenance of data solutions, collaborating with the implementation function for solution roll-out. The Data Engineer will assist in building, developing, and managing custom databases/solutions using SQL and Azure data technology stack. They will design, build, and deploy ELT pipelines and data management processes, ensuring reliable error/exception handling and rollback frameworks.Responsibilities:

• 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.
• Work collaboratively with Business Partner Team and Business Stakeholder during projects scoping and feasibility phases.
• 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.

Requirements:

• 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.
• Experience with the full development life cycle of an application stack.
• Experience in Master Data management solutions.
• Experience in data warehouse analysis and design.

What WPP offers:

• Passionate, inspired people.
• Scale and opportunity.
• Challenging and stimulating work.