About the position
This role is part of the Local Systems Team for EMEA at WPP, a global creative transformation company. The main responsibility of this role is to support the existing and future business intelligence (BI) setup for EMEA markets. The role involves working with the BI development team to update the architecture and data models based on new data needs and changes in source systems. The successful candidate will also be involved in building, developing, and managing custom databases/solutions using SQL and SSIS, as well as designing and deploying ETL and data management processes. Strong communication and technical skills are required for this role.
Responsibilities
- Assist in the build, development, and management of custom databases/solutions using SQL and SSIS 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.
- 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.
- 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.
- Bachelor’s degree in Computer Science, Engineering, Mathematics or other technical field is highly preferred.
- 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.
- 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 modeling.
- 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.
- Experience with Azure cloud solutions; Knowledge of Azure Data Factory, Azure Synapse, Azure Automation, Azure Data Lake and Azure Data Lake Analytics.
- Experience with APIs.
- Team player.
- Organized and detail oriented.
- Excellent communication, presentation, and writing skills.
Requirements
- Bachelor's degree in Computer Science, Engineering, Mathematics, or other technical field is highly preferred
- 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 managing their expectations
- Experience with the full development life cycle of an application stack - from architecture through test and deployment
- Knowledge and experience with Master Data management
- Experience in data warehouse analysis and design, with knowledge of data warehouse methodologies and data modeling
- Unit testing low-level components such as SQL scripts, Stored Procedures, and ETL modules
- Knowledge and experience in software development methodology and toolset, specifically Agile methodology
- Experience with TFS/GIT code repository and branching strategies, Microsoft Release Management, and deployment tools, and Jira
- Experience with Azure cloud solutions, including Azure Data Factory, Azure Synapse, Azure Automation, Azure Data Lake, and Azure Data Lake Analytics
- Experience with APIs
- Team player
- Organized and detail-oriented
- Excellent communication, presentation, and writing skills
Benefits
- Passionate, inspired people
- Scale and opportunity
- Challenging and stimulating work