M I Analyst
The MI analyst will operate as one of the core pillars to the businesses IT/Data function. Our primary objective is to leverage value adding insight from the wealth of data available.
You will take a proactive role in ensuring all business functions are provided with decision enabling information through period reporting and ad hoc exercises. You will also adhere to strict requirement from the end user and deal with competing projects and deadlines. This is an opportunity to drive the businesses analytical reports and work closely with Operations and managing Directors to create a reporting suite that enables critical decision to be made to enhance future forecast planning and to produce bespoke visual reports with our clients.
Main Responsibilities
Development of financial models to assist management in decision making and reporting.
Responsible for the ongoing business performance forecasting style.
Investigation of modelling and forecast assumptions to improve output accuracy.
Development and maintenance of the company's reporting capability, including the building of data architecture.
Preparation of financial and non-financial analyses.
Analyse and report in KPI's.
Assist with the development and improvement of business systems.
Production of reports from business systems using Power BI to deliver meaningful insights into business performance.
Identify gaps in our data collection processes and deliver requirements for change to.
Become a champion/master user on the various tools and software we use to collect and store our data, including and not limited to:
SQL
Excel
Power BI
Microsoft Dynamics
Assist colleagues in using the reports and tools that have been developed as part of the roll out process.
Other Ad Hoc responsibilities will be given as the role evolves.
Skills and Attributes
High level of commercial acumen.
Ability to handle multiple projects and deadlines.
Excellent analytical skills with supplementing experience.
Experience using Power BI, DAX, and Power Query is essential.
Good Knowledge of MO suite especially MS Excel.
Fundamental understanding of database language (TSQL).
Good communication skills with experience in maintaining good working relationships with stakeholders from a variety of functions and backgrounds.
Proven ability to deliver and work as a team and towards a group objective.
ETL processes understanding, basic knowledge of how to extract, transform and load data from various sources.
Batchelors degree (or equivalent) in a related field: Data Science, Business Analytics, Economics, Mathematics or similar fields.
Desirable
Programming Skills - basic experience in Python or R for more advanced data manipulation and statistical analysis.
Experience with big data tools, such as Hadoop, Spark or BigQuery.
Experience with data warehousing
Data governance and compliance: awareness of data governance and legal compliance (e.g. GDPR within the UK)