data analyst / visualization
key responsibilities :
- support the creation of automated reporting, helping drive business improvement processes across ipg mediabrand and client businesses, taking direction from the client / agency manager overseas
- managing clients /ipg mediabrands reporting and dashboards, ensuring they are well maintained and easy to use.
- investigate and understand the opportunities of new data sources in the context of integration into tableau/datorama or other dashboard tool.
- updating tableau/datorama/excel/powerpoint as required for daily/weekly client reporting.
- experience in excel dashboard, powerpoint and vba coding will be an added advantage
- trouble shooting any issues that arise in the updating of existing dashboards.
- liaise with internal mediabrands teams when investigating new data streams and trouble shooting.
- learning how to translate business requirements into technical requirements
- manage expectations of business intelligence manager to help ensure delivery of high quality product within deadlines
- keep up to date with new data visualisation tools and general trends in the analytics & bi industry
required skills & qualities:
- suggested minimum of 2 years- experience in any of these tools: - tableau, datorama or similar data visualization tool.
- excellent sql or similar database skills (2+ years) with the ability to write complex queries and the ability to analyse, understand, clean, integrate and process complex data
- experience in excel and powerpoint dashboard will be an added advantage
- excellent communication skills including the ability to communicate with non-technical stakeholders and present findings in a concise manner
- the ability to understand complex business requirements and translate into technical specifications
- experience working with digital social media or media advertising data and understanding web analytics highly desirable