Junior Data Analyst - Temp

Who we are:

At VML we exist to inspire growth for ambitious brands. Part creative agency, part consultancy and part technology company, our experts provide end-to-end capabilities at a global scale to deliver inspiration across the entire brand and customer experience.

We are 20,000 strong in 90 markets around the world;our people bring together creative storytelling, diverse perspectives, inclusive thinking, and highly specialized vertical capabilities to drive growth for our clients. We offer deep expertise across the entire customer journey, including communications, commerce, consultancy, CRM, CX, data, production, and technology.

Who we are looking for: 

VML is seeking an Analyst with a background in data, business marketing, and strategic analysis. To be successful in this role, you must be able to thrive in a creative environment where collaboration, client service, intelligence and humor are a must. We work with a national client base in a wide array of industries. We provide keen insights based on data analysis that helps brands improve their online business. The core of this role revolves around extracting data, compiling reports and creating insightful presentations, but there will be many opportunities to work on a variety of projects. 

What you'll do: 

• Execute | Manage and update new and recurring client reports delivered in a hybrid of Excel, Power BI, and PowerPoint.
• Process | Generate or create both a static and interactive excel report/dashboard for client's performance.
• Support | Support and follow best practices for data acquisition, cleansing, transformation, and front-end publishing.
• Analyze | Audit client data and develop, maintain, and improve documentation for common team processes and best practices.
• Collaborate | Work directly with Strategy, Media, and Creative teams on their reporting and analysis requests, as well as working with clients on test & learn projects including A/B and multivariate testing.

Who you are: 

• A builder | Entrepreneurial attitude coupled with strong business acumen. Offer proactive solutions and ensure successful progression without guidance. Identify business and marketing problems, industry drivers, competitive landscapes, and trends and apply insights to enable clients to compete efficiently.
• Motivated l Has a sense of urgency and is an adaptive self-starter with the ability to work across different initiatives. Has a high bar for quality, takes ownership and drives accountability across the organization. 
• Team Player | Our team is close-knit and supportive and we're working with a lot of unknowns - you must champion team environments that are comfortable and encouraging.
• Optimistic and Resilient l Dig in and figure out how to work around problems. Exemplify a "Yes and why not?" posture. Maintain balance needed to maintain stamina and positivity.
• Detail Oriented l Sharp attention to detail and a drive for perfection.
• Excellent Communicator l Excellent written and verbal communication skills. The ability to intake simple and complex problems, listen, find the appropriate solutions, and teach to internal and external teams why your solutions will work and why they continue to work (or need adapting) once implemented.
• Ego-less|We all wear the hats that need wearing; it's a mentality that makes us successful. 

What it takes:

• Minimum 2 years as an advanced Excel user including experience with data models, excel macros, VBA a plus.
• Minimum 2 years of experience managing or updating online interactive dashboards preferably in Power BI and/or Tableau.
• 1+ years' experience working with site analytics raw data (Google, Omniture etc.)
• Strong prioritization skills with ability to deliver against multiple reporting deadlines each week.
• Strong communication skills to translate data-specific issues, impacts, and interpret requirements across multiple teams and stakeholders.
• Adobe Analytics and Reporting is a plus!