About the position
As a member of the WPP IT - GroupM IT team, you will be responsible for designing and implementing enterprise analytics and reporting products, as well as performance management solutions. You will contribute to the data architecture and integration, analyze business/data requirements, and provide support for data warehouse and reporting solutions. Proficiency with Power BI and experience in modern data warehousing, Azure technologies, and data visualization concepts are required. Additionally, certifications in relevant skills and experience in the media/advertising industry are beneficial.
Responsibilities
- Design and implement enterprise analytics, reporting products, and performance management solutions
- Contribute to the design, configuration, and deployment of enterprise performance solutions using Microsoft SQL Server analytics technology stack
- Contribute to data architecture and data integration with dimensional data modeling, data sourcing/mapping, and data flow within the implemented solution
- Analyze business/data requirements, estimate, and perform data preparation
- Provide ideas to enhance the product and deliver additional value to users
- Act as an expert to deliver consistent answers for reinsurance data-related questions
- Support key users and business users regarding data warehouse and reporting solutions to improve data analysis interpretation
- Proficiency with Power BI, including experience with Power Query and end-to-end implementation of Power BI solutions
- Implement row-level security on data and understand application security layer models in Power BI
- Knowledgeable in M and DAX, skilled in SQL
- Experience with modern data warehousing, Azure Data Factory, Azure Automation, Azure Data Lake, and Azure Data Lake Analytics
- Design and implement new data visualization concepts and global business intelligence approaches
- Design new reporting approaches based on warehouse data model and reporting standards
- Familiarity with agile software development and technology best practices
- Knowledge of data governance processes
- Comfort with industry-standard version control tooling
- Media/advertising industry experience is a plus
- Certifications or equivalent skills in AZ-204, AI-900, DP-100, DA-100, and/or DP-203 are beneficial
- Excellent English skills, other languages are a plus
Requirements
- Completed university studies in Computer Science, Information Technology, or a comparable field
- Proficiency with Power BI, including 3+ years of Power BI and Power Query experience
- End-to-end experience within Power BI, including ETL, publishing secure reports and dashboards, and implementing row-level security
- Knowledgeable in M and DAX, skilled in SQL
- Experience working with modern data warehousing and Azure technologies such as Azure Data Factory, Azure Automation, Azure Data Lake, and Azure Data Lake Analytics
- Experience with design and implementation of new data visualization concepts and reporting approaches
- Familiarity with agile software development and technology best practices
- Understanding of data governance processes and industry standard version control tooling
- Media/advertising industry experience is a plus
- Certifications or equivalent skills in AZ-204, AI-900, DP-100, DA-100, and/or DP-203 are beneficial
- Very good English skills, other languages are a plus
Benefits
- Global network of accomplished people in 110 countries
- Opportunity to work with world's biggest companies and organizations
- Headquarters in New York, London, and Singapore
- Technology provider for some of the world's most creative brands
- Design and implementation of enterprise analytics and reporting products
- Contribute to data architecture and integration
- Opportunity to enhance the product and deliver additional value
- Support and improve data analysis interpretation
- Proficiency with Power BI
- Experience with modern data warehousing and data visualization concepts
- Agile software development and technology best practice methodologies
- Comfort with industry standard version control tooling
- Inclusive and collaborative work culture
- Opportunity to create, influence, and complete projects at a large scale
- Challenging and stimulating work environment
- Equal opportunity employer that values diversity and inclusion