Media / Mobile Marketing Agency - Data Analyst (Paid)
Internship London (Greater London)
Job description
We are a leading, global, full service mobile marketing agency. We help brands engage with their customers using creative and effective mobile marketing and advertising solutions.
Our business has three core divisions; consultancy, mobile production and mobile media, where we presently looking for a talented individual to join our London team.
HOW CAN YOU EXPECT TO SPEND YOUR DAY?
On-board clients into BI and Mobile CRM programmes:
Determine client requirements, map data to warehouse, adapt ETL scripts
Work with DBA to design individual client cubes for use within Qlikview applications
Work with Qlikview Developer to design and build new and adapt existing Qlikview dashboards
User Acceptance Testing of Qlikview applications
Integrate relevant new datasets for use within programmes eg. app ranking, aggregated event/transactional
Analysis and interpretation of data eg. Recency/Frequency/Value, Descriptive statistics, multi-variate analysis
Maintain documentation and training resources for BI users is in place
Liaising with relevant technical staff and external suppliers in UK and other M&C offices
Control access permissions and privileges for relevant users
WHAT SKILLS CAN YOU EXPECT TO GAIN?
Working with Qlikview Business Intelligence platform
MySQL and data warehousing
Scripting and automation using ETL, Stored Procedures and Shell scripts
Understanding of mobile and digital advertising strategy
Usage of data for CRM communications
Statistical analysis techniques
Working with users and stakeholders to build BI applications