Senior BI/Data Developer

WPP is seeking a Senior BI/Data Developer to join their team in Mexico City. This role is within the GroupM IT team and involves delivering critical trading and finance data and business intelligence software for North America. The ideal candidate will understand business and technical requirements and deliver end-to-end solutions.

Responsibilities:

• 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.
• Design, build and deploy ETL and data management processes.
• Conform to agile development practices.
• Work collaboratively with Business Partner Team and Business Stakeholder during projects.
• Provide production support for data load jobs.
• Write customized query to generate automatic periodic reports.
• Build applications writing SQL scripts to manipulate data.
• Maintain or upgrade existing applications.
• Attend key design meetings and provide support.

Requirements:

• 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 creating and managing SQL Server Integration Services (SSIS) and Azure Data Factory (ADF) 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 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

WPP Offers:

• Opportunity to create, influence and complete projects at a scale that is unparalleled in the industry.
• Passionate, inspired people