Market Forecaster

Market Forecaster

Rate: £450 per day
Length: 4 months
IR35: Inside IR35
Location: Remote but flexible to travel to London when needed

You will have an opportunity to demonstrate your research skills in some of the most relevant issues affecting our clients, initiative and a flexible yet organised approach to forecasting across a range of different industry segments and subject areas in response to changing market dynamics.

For this role you will be expected to:

1. Take responsibility for forecast production work for assigned project deliverables across all phases, from Business Understanding through to Deployment.
2. Maintain existing data storage and physical data models as well as existing data flows to and from forecast models using Power query and Alteryx.
3. Collect and preprocess data from multiple sources to ensure data quality, accuracy, and consistency. Conduct analysis of time series, cross-sectional and panel data, carry out research.
4. Use complex and imperfect data together with mathematical and statistical techniques to update forecasts, making reasonable assumptions.
5. Apply statistical techniques to identify patterns and trends alongside the development of techno-economic models and tools, sensitivity analysis and scenario building to deliver enhanced insight and analysis.
6. Maintain and update Excel data model and DAX code that underpins forecast models, forecast review dashboards and outputs in Excel via pivot charts and pivot tables as well as PowerBI.
7. Produce clear and consistent documented methodologies and assumptions, effectively evaluate supporting macroeconomic data and demonstrate logical thinking to support analysis.
8. Liaise directly with subject matter experts, including analysts and pillar leads in the forecasted industries to build Business Understanding, refine forecasts and ensure quality.
9. Work directly with Project Management, taking responsibility for timeliness and quality of forecasts produced.

Key Skills and Competencies Required

1. High proficiency in Power BI and Excel Data Model - experienced user of Power Query and DAX
2. Proficiency with data modelling and visualisation, understanding of relational databases
3. Proficiency in using forecasting techniques and methodologies with successful track record of building market forecast models
4. 2.1 or higher in a business, economics, statistics or mathematics-based degree. Understanding of key economic concepts, such as exchange rates, inflation
5. Excellent problem-solving skills and ability to work independently. Proactive in identifying problems as well as investigating causes and researching solutions
6. Highly numerate with a strong working knowledge of statistical techniques.
7. Effective at communication with senior stakeholders across the business
8. Strong academic background in a relevant field (e.g. Economics, Mathematics, Statistics, Computer Science, Engineering)
9. Inquisitive attitude and excellent research skills for analysis and understanding of industry trends
10. Strong understanding and awareness of the influence of economic factors on market development
11. Experience with programming, working with Python
12. Knowledge of the Entertainment & Media industries
13. Experience of working with large amounts of data and data modelling
14. Highly literate to produce written research on topics such as trend analysis, forecasting assumptions and methodologies
15. Organised and methodological approach to work and attention to detail