Summary
Overview
Work history
Education
Skills
Timeline
Generic

Ian Horlick

Chippenham,United Kingdom

Summary

Knowledgeable individual seeks opportunity in specialist role to deliver subject insight for improved team understanding. Adaptable and reliable with a robust foundation in problem-solving and communication skills, transferring technical knowledge and analytical abilities to new challenges

An accomplished and dedicated Data Analyst professional highly effective in undertaking administrative and programme management tasks. Manages complex data with extensive expertise in using various Market Research platforms. Skilled in data extraction and analysis, utilising advanced Excel techniques and analytical tools to optimise Sector and Business insights. Adept at stakeholder management and project management, ensuring effective communication and collaboration across teams.

Motivated to achieve Organisational and Team goals and objectives through prompt communication and a helpful approach.

Experienced in building relationships with vendors to impart product knowledge to employees regarding insights and analysis and ensure purchasing and compliance standards are met. Educates and engages using interpersonal skills for informed decision-making. Coordinates resources and organises workflows to meet operational needs whilst remaining under budget.

Engages cross-functional teams with improvement activity to achieve key metrics. Plans and prioritises strategically for alignment with project timelines.


Overview

29
29
years of professional experience
7
7
years of post-secondary education

Work history

Market Insight Specialist

InnovateUK
02.2018 - 05.2025
  • Company Overview: Innovate UK is the UK’s innovation agency. Its main aim is to work in collaboration with people, companies, and partner organisations to find and drive science and technology innovations that will grow the UK economy - delivering productivity, new jobs, and exports. It fosters Innovation within the UK and its aim is to keep the country globally competitive in the race for future prosperity.
  • I help to ensure best practice in market analysis is embedded across Innovate UK as a critical capability to underpin decision-making.
  • I develop frameworks for monitoring the use of market intelligence resources (including access to external Market Research platforms) across Innovate UK and I gather feedback on the functionality and content provided.
  • I Manage contractual relationships with vendors of information resources, making vendors aware of Innovate UK’s strategic needs, ensuring subscription payments are processed promptly and act as point of contact for any queries regarding these resources, ensuring effective Governance and Compliance.
  • I undertake Market Research and Web Analysis to determine the viability of future investment. Using various statistical techniques including Times Series analysis and regression analysis.
  • Within our Team I access the Market Research platforms to extract and analyse Sector/Industries and Market (e.g. Healthcare, Automotive, Fintech, Defence, Computing, Advanced Material and Manufacturing) data to understand current trends and potential growth areas.
  • I also assess Patent and Publication data to understand potential developments across various Sectors.
  • Innovate UK is the UK’s innovation agency. Its main aim is to work in collaboration with people, companies, and partner organisations to find and drive science and technology innovations that will grow the UK economy - delivering productivity, new jobs, and exports. It fosters Innovation within the UK and its aim is to keep the country globally competitive in the race for future prosperity.
  • Facilitated productive team meetings, fostering a collaborative work environment.
  • Maintained up-to-date industry knowledge through continuous professional development.
  • Streamlined operational procedures with innovative system improvements.
  • Conducted comprehensive market research, resulting in informed strategic planning.
  • Analysed complex datasets for improved decision-making processes.
  • Collaborated effectively with cross-functional teams for successful project completion.
  • Optimised resource allocation for maximised operational efficiency.
  • Coordinated supplier relationships, ensuring timely delivery of products.
  • Led training sessions for staff skill improvement.
  • Negotiated favourable terms with vendors, securing cost-effective deals for the company.
  • Gathered information, created charts and produced reports for staff.
  • Tracked metrics with [Software] spreadsheets and modelled data for staff.

Insight and Intelligence Analyst

Capita
07.2017 - 01.2018
  • Company Overview: Based within the Insight and Intelligence Unit.
  • I Analysed large data sets to determine key trends and KPIs for the National recruitment for the ARMY across all Divisions and Brigades.
  • I created Business Models for Senior Management and Senior Officers to assess the type of person who is best suited to join, (enabling for effective marketing campaigns) and how to recruit and retain them, as well as understanding the reasons for why and when candidates leave the process.
  • Due to the cost of recruiting and training great focus is placed on recruiting the right people and ensuring as much as possible that they are equipped to complete the recruitment process.
  • A new SQL system had been installed to help with the vast variety of reports that are needed.
  • I used seasonal and correlation analysis to determine demand rates which helped to determine costs for Market Campaigns and recruitment.
  • Based within the Insight and Intelligence Unit.
  • Collaborated closely with other analysts to ensure consistency in reporting.
  • Collated information, improved the accuracy of intelligence reports.
  • Utilised advanced software to analyse and interpret sensitive data.
  • Identified trends, contributed to proactive risk management strategies.
  • Conducted deep research into trends related to Recruitment policies to inform decision-making.

Market Analyst

Novum Law (National Solicitors)
04.2016 - 10.2016
  • Based within Company’s Finance team. Creating and devising new Business Forecast models to predict future expenditure and revenue streams for Legal cases (Matters) specialising in Industrial diseases.
  • Many Matters take over 5 years before a settlement is agreed so effective financial forecasts are vital to ensure costings budgets are correct.
  • Part of the role includes presenting the data models in a meaningful way to Senior Managers so that they can make informed decisions on when to raise finance to cover Matter activity.
  • Extensive use of Microsoft Excel and Access to create Business Models.
  • Other software that used was in this procedure included qlikview and Business Objects.
  • I used correlation analysis to help identify client profiling and for checking the demographics of clients.
  • Kept abreast of industry trends for informed strategy development.
  • Fostered informed decision making through accurate forecasting and risk assessment analyses.
  • Produced detailed reports to aid strategic planning and forecasting.

Investment Analyst

St. James Place (Wealth Management Company)
11.2015 - 04.2016
  • Employed within their Business Analytics hotline team to determine who out of their clients and Advisors will be invited to their Annual Conference event at the 02 in January 2016 in front of a 5,000 attendees.
  • Attendees are invited on the wealth they generate within the last calendar year and well as their predicted scores for next.
  • Part of the role is to invite those that have generated most by means of a league table.
  • Each client and Advisors type of investments are scrutinised to understand which schemes are the profitable and effective for marketing.
  • Software used included the Excel (Advanced Formulas), Business Objects, and Access.
  • Similar to InnovateUK I was using Times series analysis to understand growth rates within investment sectors.

Project Estates Analyst Manager

UKSBS
09.2013 - 02.2014
  • Company Overview: Employed within a newly formed Government department to deliver a £100 million pound saving across all Government departments where property is leased or owned.
  • The project is known as the Property Asset Management directorate.
  • The purpose of this Project is to assess the data and management information requirements of PAM and to identify how the mandated Government Property Unit (GPU) estates database ePIMS (electronic Property Information Mapping System), Microstrategy and existing UK SBS systems can be configured and adapted to facilitate storage of that data without the need for a new data storage system or IT solution.
  • Review and determine the current mandated/MI requirements.
  • Identify the data/MI requirements of PAM.
  • Identify the data/MI requirements of the partner organisations under the management of the PAM (utilising the Operating Model).
  • Establish a working relationship with GPU to assess how e-pims and Micro strategy can be configured, and data analysed in a way that will help with those requirements.
  • Employed within a newly formed Government department to deliver a £100 million pound saving across all Government departments where property is leased or owned.

Campaign and Demand Forecast Analyst

Nisbets
09.2012 - 11.2012
  • Company Overview: UK and European Catering Supplier.
  • Market and customer intelligence Analysis.
  • Analysing database to determine buying and product trends.
  • Investigation into monthly promotional campaign.
  • Devising and building Business models to determine campaign’s commercial success.
  • Building and creating business information systems to review performance.
  • UK and European Catering Supplier.

Database Analyst

Wiltshire Wildlife Trust
01.2012 - 08.2012
  • Collated and analysed data to assess trends in rural and urbanization areas.
  • Studying where costs have increased or decreased to determine return on investment.
  • Creating information system for long term appraisal of farming patterns and urban growth.

Analyst

Alzheimer’s Society
02.2011 - 11.2011
  • Devised a marketing Database Campaign for awareness and fund raising.
  • Planning large fundraising events, assessing costs, demand and resource management.

Business Reporting Advisor and Computer Course

North Wiltshire Training and WEA
01.2008 - 01.2011
  • Advising and training unemployed in career changes and computer software including advanced Excel, Access Power-Point and MS project.
  • Helped to devise training programs and training material.
  • Worked in conjunction with Learning direct and Brunel University to update skills In SAS programming, Information systems, WEB design and project Management.

Financial reporting analyst

Capita
10.2007 - 11.2008
  • Created and built measurement tools to study and predict future business performance.
  • Monitored operational and project costs to assist Financial Controller and Director in making decisions where resources should be allocated.

Business Intelligence Analyst

Wiltshire County Council
01.2007 - 09.2007
  • Introduced and managed KPIs and Business Score Carding system.
  • Investigated cost and resource effectiveness across Wiltshire.
  • Built demand forecasting measuring tool to assess effectiveness of Council services within the community so Council could adjust services accordingly.

Demand Management Reporting Analyst

Natural Environment Agency
05.2006 - 12.2006
  • Demand and sales forecasting into the manufacturing of cost reducing engines including electric cars and wind Turbines.
  • Also projected supplier performance including lead times and quality issues as well as maintenance contracts.
  • Compiled reports to aid senior management to make informed decisions on viability of projects undertaken including wind turbines and their usage.

Forecast analyst / Logistics Analyst

MOD
02.2004 - 12.2005
  • Company Overview: Contract
  • Product Forecasting involving Cost, Inventory and Supplier analysis.
  • Customer profiling.
  • Introduction of KPI’s to monitor performance across all areas.
  • Contract

Forecasts / Customer intelligence Analyst

Tyco
04.2003 - 11.2003
  • Company Overview: Contract
  • Demand planning of products for customer requirements.
  • Used forecasting techniques to predict product buying trends for operations utilization.
  • Business process improvement.
  • Contract

Sales and Foresting Analyst

SCA
10.2002 - 02.2003
  • Company Overview: Contract
  • Worked closely with sales managers to ensure correct inventory levels were kept.
  • Gathered logistics data aid assist in customer service.
  • Contract

Demand and Sales planner

Motorola
01.1996 - 12.2002
  • Company Overview: Permanent
  • Managing the manufacturing system, MRP, to enable effective system functionality incorporating bill of material (BOM) structuring and management inventory strategy.
  • Forecasting and planning customer requirements.
  • Relating to £6,000,000 on certain product lines.
  • Developed and maintained forecasting database.
  • Permanent

Education

MSC - Management Science

Brunel University
01.1994 - 01.1995

B.A. - Business Studies

Brunel University
01.1991 - 01.1995

HND - Business Information Technology

Brunel University
01.1991 - 01.1993

Skills

  • Business reports
  • Business trend modeling
  • Forecast models
  • Market Insight
  • Statistical models
  • Econometric models
  • Market research
  • Marketing strategies
  • Pricing analysis
  • Promotional activities
  • Competitive analysis
  • Market/Industry insight reports
  • Quantitative analysis
  • Qualitative analysis
  • Data sourcing
  • Data extraction
  • Data analysis
  • Cost modeling
  • Budgetary requirement modeling
  • Statistics
  • Operational research
  • Transaction history analysis
  • Root cause analysis
  • Discrepancy report analysis
  • Regression analysis
  • Time-series analysis
  • Moving averages
  • Digital analytics
  • Web profiling
  • Trend analysis
  • Demand forecasting
  • Market segmentation
  • Customer behavior analysis
  • Predictive modeling
  • Project management
  • Effective communication
  • Interpersonal skills
  • Excel
  • Pivot Tables
  • Charts
  • Vlookups
  • Advanced formulas
  • Conditional formatting
  • Graphical analysis
  • Business Objects AOP
  • Access
  • Oracle
  • SAP
  • Web research
  • Design optimization
  • Analytical tools
  • Reporting tools
  • Key Performance indicators
  • Business Score Carding
  • Excel proficiency
  • Stakeholder management
  • Statistical modelling
  • Information analysis
  • Business process improvement
  • Invoice processing
  • Order processing

Timeline

Market Insight Specialist

InnovateUK
02.2018 - 05.2025

Insight and Intelligence Analyst

Capita
07.2017 - 01.2018

Market Analyst

Novum Law (National Solicitors)
04.2016 - 10.2016

Investment Analyst

St. James Place (Wealth Management Company)
11.2015 - 04.2016

Project Estates Analyst Manager

UKSBS
09.2013 - 02.2014

Campaign and Demand Forecast Analyst

Nisbets
09.2012 - 11.2012

Database Analyst

Wiltshire Wildlife Trust
01.2012 - 08.2012

Analyst

Alzheimer’s Society
02.2011 - 11.2011

Business Reporting Advisor and Computer Course

North Wiltshire Training and WEA
01.2008 - 01.2011

Financial reporting analyst

Capita
10.2007 - 11.2008

Business Intelligence Analyst

Wiltshire County Council
01.2007 - 09.2007

Demand Management Reporting Analyst

Natural Environment Agency
05.2006 - 12.2006

Forecast analyst / Logistics Analyst

MOD
02.2004 - 12.2005

Forecasts / Customer intelligence Analyst

Tyco
04.2003 - 11.2003

Sales and Foresting Analyst

SCA
10.2002 - 02.2003

Demand and Sales planner

Motorola
01.1996 - 12.2002

MSC - Management Science

Brunel University
01.1994 - 01.1995

B.A. - Business Studies

Brunel University
01.1991 - 01.1995

HND - Business Information Technology

Brunel University
01.1991 - 01.1993

Similar Profiles

Create profile
Ian Horlick