Maintain Multi-Market Budget/Planned vs Delivered Dashboard
- Create muti-market campaign dashboard for easy reference of data (spends, performance, campaigns, etc)
- Work with performance lead to create a benchmarking tool for campaign performance
- Work on reporting automation
- Unify data from multiple platforms to create single view of the campaign
- Work with performance lead to create campaign health score
- QC of real time flow of data into ETL structure (Extract, Transform and Load)
- Data visualization
- Anticipate and Craft reporting templates basis business requirements for various markets
- Data Governance
- Create Post Eval Presentations
- Manage and Maintain Global data Templates
- Co-ordinate and work with various markets in SEA and procure relevant data based on various data templates
- Extract data as per requirements from various platform dashboards (Google Ads, Meta Business Manager, DV, DV360, TikTok, TTD, etc)
- Proactively think and design data templates or Automation to bring in efficiencies in Day to Day operations
- Maintain Productivity Tracker
- identify and understand emerging trends in the client's multi-market data
- Responsible for data quality and data accuracy across all group/division delivery initiatives.
- Responsible for data analysis, data profiling, data modeling, and data mapping capabilities.
- Develop portfolio MIS and track the portfolio performance and recommend course of action
**Desired Technical Skill Sets**:
- Power BI
- Adverty
- SQL
- Google Studio
- Google Cloud (If Possible)
- Data Extraction from platform Dashbaord
- Proficiency in basic statistics
- Python
- R-Programming
- Power Point
- Excel
**Other Skills**
- Ability to identify, clearly articulate and solve complex business problems and present them to the team and client in a structured and simpler form
- Excellent communication skills, ability to explain complex technical concepts and analysis implications to varied audiences
- Ability to translate business objectives into actionable analysis
- Proven ability to work with teams that are geographically separated
- Should be a self-starter with a high level of initiative
- Ability to identity root cause & provide recommendation
- Should have excellent communication and inter-personal skills
- Good process/project management skills
- Ability to work in teams
- Ability to work in Pressure situations
- Contribute to organizational initiatives in wide ranging areas including competency development, training, organizational building activities etc.