Role: Data Analyst 

Location:Glasgow, United Kingdom

ROLE MISSION

Working in partnership with our client, the Data Analyst will be a key member of the team. You will manage the reporting and analytics to track our team's financial and project health. You will partner with our operations team and work with the Managing Director and Program Director to build data dashboards that provide visibility and insights to team leads and internal and external stakeholders.  This role is remote but may require travel to client and/or agency offices for training and in-person meetings on occasion.   

WHAT YOU WILL BE DOING IN YOUR ROLE

• Using tools and interfaces to extract data from primary and secondary sources 
• Data hygiene – performing analysis to assess the data quality, removing corrupted data, and fixing errors and related data problems 
• Developing and maintaining databases and data systems – reorganizing data in a readable format if needed 
• Using statistical tools and data modeling techniques to identify, analyze, and interpret patterns and trends in complex data sets 
• Diagnose and predict business performance issues and identify ways in which The Studio can operate more efficiently 
• Preparing reports and dashboards for the leadership team stating trends and patterns by compiling financial, performance, and operational data 
• Develop reports including a full lifecycle analysis of all WIP projects by location; weekly and monthly reporting packs; global dashboards; customer business unity chargeback reports; YTD estimated revenue  
• Create and develop other ad hoc reports based on customer-specific requests; 
• Work with client and agency data teams to identify process improvement opportunities, propose system modifications, and comply with our data governance framework 

Key Success Factors  

• Problem-Solving: The ability to use creative thinking to identify and solve complex problems by approaching them from unique angles. 
• Attention to Detail: Exceptional administrative capabilities, with a keen eye for detail, ensuring accuracy and consistency in every facet of data analysis. This includes maintaining high-quality standards that align with our error-free reporting standards. 
• Collaborative Mindset: A proactive approach that helps to foster a team environment that values diverse perspectives, leading to more comprehensive and inventive problem-solving. 
• Curiosity: A voracious quest for knowledge, with an inherent desire to delve into data, ask probing questions, and uncover the “why” behind trends and patterns to drive deeper insights. 
• Creativity: An imaginative flair for interpreting data, employing original visualization and analysis techniques to discover novel insights and contribute to business goals. 
• Analytical Thinking: Robust analytical abilities that meticulously examine complex datasets, identifying critical trends and relationships that inform evidence-based decisions and guide business strategy. 
• Continuous Learning and Improvement: An unwavering commitment to personal and professional growth, seeking out new learning opportunities and methodologies to enhance analytical capabilities and drive innovation. 
• Strong communication skills: Must possess excellent communication abilities, enabling clear and concise expression of concepts, analysis, and insights to senior stakeholders within OLIVER and the client. 

WHAT SKILLS WILL HELP YOU BE SUCCESSFUL 

• Proven working experience as a Data Analyst or Business Data Analyst. 
• Technical expertise regarding data models, database design development, data mining, and segmentation techniques. 
• Financial Services analytics experience is advantageous. 
• 4 years of advanced Excel and statistical packages for analyzing datasets 
• 4 years of experience with analytic and reporting tools, such as Zoho, Tableau, Power BI, etc. 
• Strong mathematical, statistical, and analytical skills with the ability to collect, organize, analyze, and disseminate significant amounts of information with attention to detail and accuracy. 
• Adept at queries, report writing, and presenting findings. 
• Degree in Mathematics, Economics, Computer Science, Information Management, Statistics, or Business Management or demonstrably equivalent experience. 
• Time management and organizational skills 

Software Experience Requirements 

• Strong expertise in Microsoft Excel 
• Experience with SQL and intermediate queries 
• Analytics and dashboard tools such as Zoho, Tableau, Power BI, etc. 
• Microsoft Office 365 (i.e., Microsoft Teams, PowerPoint, Word, Outlook, OneDrive) and SharePoint 

ABOUT OUR COMPANY

Lots of agencies say they're different. OLIVER is.

OLIVER believes that agencies work better inside a brand's organisation; delivering more effective work at the speed required to drive modern businesses forward. Using our unique Inside Intelligence methodology, we build specialist, dedicated in-house agencies that collaborate with clients to form better marketing solutions.

Established in 2004, our model is now driven by over 4000 people, working across more than 200 in-house agencies globally. Clients include The Guardian, Unilever, Barclaycard, PepsiCo, AXA, The AA, Adidas, BMW, Post Office, and 3M. OLIVER is part of the Inside Ideas Group (IIG), which also includes a global content agency to Adjust your Set, design, experience, and engineering company DARE and property marketing specialists Aylesworth Fleming.

OUR VALUES

We are a company built on our values, we have given you a brief overview below but would love to tell you more.

Be Ambitious to succeed

Be Imaginative to push the boundaries of what’s possible

Be Inspirational to do groundbreaking work

Be always learning and listening to understand

Be Results-focused to exceed expectations

Be actively pro-inclusive and anti-racist across our community, clients and creations

Follow us on  Instagram oliver.talent

Job Id: 9603

#LI-KA1 #LI-Remote

We've set ambitious, market-leading environmental and social goals around sustainability at OLIVER. We have committed to be net zero by 2030 and take far reaching action on DE&I in the sector. We expect everyone to contribute to our mission, embedding sustainability into every department and through every stage of the project lifecycle. 

Inside Ideas Group and its’ affiliates are equal opportunity employers committed to creating an inclusive working environment where all our employees are encouraged to reach their full potential, and individual differences are valued and respected.  All [suitable] applicants shall be considered for employment without regard to race, ethnicity, religion, gender, sexual orientation, gender identity, age, neurodiversity, disability status, or any other characteristic protected by local laws.