Junior Data Analyst

Junior Data Analyst Permanent Location: Lichfield (Own vehicle & Transport is essential) Hybrid working Salary: Circa £30,000
The Company
I am working with a client based just outside of Lichfield who the last 20 years have provided an outstanding level of service and client care to high profile, large scale clients all over the UK. As well as a commitment to providing the very best level of service for their clients they are passionate about creating a working environment where people thrive and careers grow.
They are a business with a strong social conscience who do a number of work to support local charities, environmental initiatives and are currently working towards a NetZero strategy.
There is now an exciting opportunity to join their team as a Junior Data Analyst and play a pivotal road in an extensive project that will have a positive impact on their client base (both new and existing) as well as the wider business.
The Role
You will play a crucial role in supporting the creation of strategic recommendations, delivery of growth strategy and the analysis of large quantities of MI and data to drive performance. The data you’ll be working with consists of market trends, campaign performance and service delivery all of which will play a critical role in business decisions
This role plays an important role in pricing strategy, business planning and reporting and you will be working very closely with the Senior Analyst and other stakeholders to ensure that the wider, large scale project is successful.
You will be supporting the Senior Analyst in:

• Defining and aiding the implementation of revenue operational controls
• Defining KPIs and monitor performance across the business and marketing campaigns
• Producing growth forecasts
• Leading on analysis and reporting (weekly monthly, quarterly and annually)
  • Traffic
  • Revenue
  • Service
  • Product
  • Pricing
  • Channels
  • Frequencies
  • Market Penetration
  • Low & High Value customer segments
  • Competitor strategy
  • Market Trends
• Developing annual traffic forecasts and scenarios
• Preparing business presentations
• Customer Analysis

Essential Skills

• Minimum Intermediate level Excel (Comfortable with writing formulas, using VLookup, Pivot Tables, sort & Filter functions and the ability to extract, interprate and understand large quantities of data)
• Good working knowledge of SQL as you will be extracting data from the various SQL databases used by the business
• Outstanding written, verbal and presentation skills
• High level of accuracy and attention to detail
• Demonstrable experience in extracting, analysing and presentating large quantities of data
• Full UK Driving Licence & Access to Transport