MI Analyst

Newcastle/Hybrid Remote
Home Vacancies MI Analyst

An exciting opportunity has arisen for an MI Analyst to join the Finance team  This a full-time role based on 40 hours per week Monday-Friday.

Role Summary

The role involves working with multiple data sources and departments to produce both periodic and ad hoc reports using Microsoft Excel. The ideal candidate should be capable of maintaining data security, performing data analysis and have an excellent understanding of Excel to present the data in a meaningful way as well as the competency to analyse the various data points to advise of possible new reporting requirements and have the skills to implement new reports.

Responsibilities
Handling multiple data sources and updating reports to meet the business needs based on a prescribed list of reports currently being distributed.
Organising data sources effectively to make the data available in a summarised and efficient manner.
Providing timely updates based on the performance of the various departments.
Analysing the business trends based on existing reporting formats and producing insights at regular intervals.
Building new reports based on the requirements from various departments across the business.
Create reports for new marketing channels based on raw data to present to various departments.
Writing and validating complex excel formulas to continuously maximise the efficiency of the reporting schedule.
Testing the existing reports and continuous track of reporting system for data accuracy.
Regular liaison with the management team to ensure reporting needs are met.
Using existing reports to explain key trends in an efficient and effective manner.
Monitoring the reporting timelines and tracking the incidents/issues and correcting them.
Skills & Experience
2+ years of proven experience in a data analysis/management information role.
Strong knowledge of MS Excel.
Ability to build interactive dashboards in Excel.
Power BI desirable but not essential.
Competency in Microsoft packages such as Word, Outlook & PowerPoint.
Knowledge of Google Analytics an advantage but not essential.
Excellent numerical and problem solving skills with a keen eye for detail.
Excellent verbal and written communication skills.
Excellent planning and organisational skills including the ability to work to meet deadlines & prioritise workload.
Ability to train the non-technical members on the reporting eco system.
Ability to work on own initiative & as a member of a team.