company_logo

Full Time Job

Short Term Data Analyst

Moving Picture Company

London, United Kingdom 11-03-2021
 
  • Paid
  • Full Time
Job Description
With offices all over the globe, MPC is one of the world's leading visual effects (VFX) studios, creating award winning, high-end VFX for the film and advertising industries.

We are constantly looking for the best talent in the world, enthusiastic people that come in everyday to be a part of some of the best work in the industry. Our teams in London, and throughout our global network of studios, produce creative, visually stunning and technically challenging VFX and digital projects of the highest quality, and we are looking for candidates with a desire to be involved in the
success of these projects.

The Workforce Planning team are expanding across Brands within Technicolor. You will work across the organisation to understand their data & reporting needs and ensure they are getting the most value and insights from their data.

There are several opportunities available. The successful candidate(s) must be highly skilled in Excel and a subject matter expert in one or more: Analytics, Data Visualisation or Report Automation.

Responsibilities:
• Working with the Senior Analyst and business stakeholders to scope and document needs.
• Applying SQL to query databases, cleanse, test and align data from disparate sources.
• Designing and producing effective dashboards which promote data driven decision-making.
• Ensuring data integrity, accessibility and documentation is upheld across your portfolio.
• Supporting the Service Desk to troubleshoot and resolve issues with reporting.

Analytics
• Data mining, statistical analysis, trend analysis, forecasting, predictive modelling.
• Identifying opportunities, risks and recommend corrective actions.
• Monitoring existing and develop new KPIs and metrics to identify correlations and root causes.

Data Visualisation
• Identifying the business use case(s) and 'telling the story' through data.
• Simplifying analysis using effective Power BI data visualisations and usability features.

Automation
• Ensuring data models, queries and processes are optimised and automated.
• Modernising legacy Excel reporting into insightful Power BI reports and dashboards.

Qualifications
• A highly analytical background within a Business Intelligence, Analytics or Data Team.
• Working with Human Resources, Finance, Sales, or Operations Management data.
• Data wrangling, mining and modelling large datasets from different sources.
• Developing visually stunning dashboards in Power BI that provide actionable insights.
• Automating processes using SQL, Microsoft's Power Suite, VBA/Macros.
• Excellent communication, relationship-building and stakeholder management skills.
• Experience in AGILE tooling (JIRA /Confluence) and AGILE processes.
• Working with Cloud based analytics, Azure, Google, AWS (desirable).

Skills:
• Expertise in Microsoft Power BI, Power Automate, Power Apps, Power Query/Pivot, VBA, DAX.
• Proficiency in MS SQL Server, PostgreSQL, desirable R, Python.
• Proficient in Microsoft Office 365 Excel, Word, PowerPoint, SharePoint

Jobcode: Reference SBJ-rjvp92-216-73-216-180-42 in your application.