Data & Analytics Manager BI, GOC
Company:WPP Media
Location:Colombia
Languages:English
Seniority level:Manager, 3+ years
Experience:3+ years
Skills:
Project ManagementSQLBusiness AnalysisBusiness IntelligenceETLMicrosoft AzureGoogle AnalyticsTableauMicrosoft Excel
Requirements:
- Bachelors or advanced degree in Statistics, Economics, Business, Math, Computer Science, or Sciences is preferred.
- Minimum 3 years’ experience in data governance processes in a data warehousing, ETL and business intelligence environment.
- 3 years’ experience in media; digital Investment, analytics, or ad operations is preferred.
- 1-2 years’ experience in business analysis.
- Experience and understanding of processes across multiple media channels (digital, search, social, offline, etc.).
- Experience in handling diverse datasets (paid media, owned, etc.).
- Strong familiarity with relational database management systems; Experience with SQL, Microsoft Azure a plus.
- Familiarity with project/product management tools like Smartsheets, Azure DevOps/VSTS.
- Familiarity with business intelligence tools such as Tableau, PowerBI, Datorama, DOMO, Looker, GDS.
- Experience with advertising campaign management/buying platforms such as Sizmek, DCM, Moat, DV, IAS, Mediaocean, Media Tools, Nielsen, ComScore, Facebook, Twitter, Pinterest, Snapchat, 4C, Brand Networks, YouTube, Google Ads, Bing, Kenshoo, SA360, DV360, Google Analytics, Adobe Analytics.
- Advanced excel data manipulation skills required; VBA/macros is a plus.
- Familiarity with programming languages/development tools a plus: Python, R, JavaScript, GitHub, etc.
Responsibilities:
- Manage the development and maintenance of business intelligence and data quality compliance tools.
- Act as the subject matter expert in managed tools and processes.
- Gather knowledge from SMEs and requirements from stakeholders.
- Manage the creation of project plans and prioritization of tasks.
- Facilitate project progression through status meetings and act as an intermediary.
- Manage the investigation and resolution of potential data issues within business intelligence tools.
- Proactively identify, propose, and generate solutions for data quality issues and operational inefficiencies.
- Track the progress and resolution of data issues and elevate critical issues to upper management.
- Supervise Senior Associates and Associates to perform data quality assurance and data processing tasks.
