Summary
The Apprentice will be involved with analysing financial data, identifying trends and creating models that present results in an informative and visual way. You will develop database skills to be able to interpret and relay data confidently and clearly to others. You will become an expert in the use of Power BI, Power Query and SQL knowledge.
Wage
£17,000 a year
The salary will range from £17,000 up to £20,000 per annum.
Training course
Data analyst (level 4)
Hours
Days and shifts to be confirmed.
37 hours 30 minutes a week
Possible start date
Monday 21 April
Duration
1 year 6 months
Positions available
1
Work
Most of your apprenticeship is spent working. You’ll learn on the job by getting hands-on experience.
What you’ll do at work
Key duties / Business and Financial Results:
* Develop skills in the use of Microsoft Power BI to create reports that provide solutions to clients’ challenges.
* Attain a detailed understanding of the cloud-based financial software and applications in our portfolio, in order to build some basic reports that look for trends and present key data to be shared with clients.
* Observe and participate with database management in data warehouses and data lakes for consolidation of client systems and data.
* Handle client support queries on their data issues and participate in scoping meetings with clients to ascertain their needs.
* Observe and support with software launches and integrations and learn the process of moving data from source to warehouse via middleware and API.
* Analyse and interpret data and statistics.
* Input into reviewing processes in order to increase efficiency and automate processes.
Where you’ll work
Schott House
Drummond Road
Stafford
ST16 3EL
Training
Apprenticeships include time away from working for specialist training. You’ll study to gain professional knowledge and skills.
College or training organisation
QA LIMITED
Your training course
Data analyst (level 4)
Equal to higher national certificate (HNC)
Course contents
* Use data systems securely to meet requirements and in line with organisational procedures and legislation including principles of Privacy by Design
* implement the stages of the data analysis lifecycle
* apply principles of data classification within data analysis activity
* analyse data sets taking account of different data structures and database designs
* assess the impact on user experience and domain context on data analysis activity
* identify and escalate quality risks in data analysis with suggested mitigation or resolutions as appropriate
* undertake customer requirements analysis and implement findings in data analytics planning and outputs
* identify data sources and the risks and challenges to combination within data analysis activity
* apply organizational architecture requirements to data analysis activities
* apply statistical methodologies to data analysis tasks
* apply predictive analytics in the collation and use of data
* collaborate and communicate with a range of internal and external stakeholders using appropriate styles and behaviours to suit the audience
* use a range of analytical techniques such as data mining, time series forecasting and modelling techniques to identify and predict trends and patterns in data
* collate and interpret qualitative and quantitative data and convert into infographics, reports, tables, dashboards and graphs
* select and apply the most appropriate data tools to achieve the optimum outcome
* Use data systems securely to meet requirements and in line with organisational procedures and legislation including principles of Privacy by Design
* implement the stages of the data analysis lifecycle
* apply principles of data classification within data analysis activity
* analyse data sets taking account of different data structures and database designs
* assess the impact on user experience and domain context on data analysis activity
* identify and escalate quality risks in data analysis with suggested mitigation or resolutions as appropriate
* undertake customer requirements analysis and implement findings in data analytics planning and outputs
* identify data sources and the risks and challenges to combination within data analysis activity
* apply organizational architecture requirements to data analysis activities
* apply statistical methodologies to data analysis tasks
* apply predictive analytics in the collation and use of data
* collaborate and communicate with a range of internal and external stakeholders using appropriate styles and behaviours to suit the audience
* use a range of analytical techniques such as data mining, time series forecasting and modelling techniques to identify and predict trends and patterns in data
* collate and interpret qualitative and quantitative data and convert into infographics, reports, tables, dashboards and graphs
* select and apply the most appropriate data tools to achieve the optimum outcome
Your training plan
The principles of data analytics are being applied across just about every industry. Using past-event data, analysts are making important insight-based business decisions and driving customer value across every team and function, including operations, finance, sales and marketing.
At QA we have deep-rooted expertise in Data, Analytics and AI. Our solutions transform the way that individuals use data and enable organisations to make more data-driven business decisions.
QA's Data Analyst Level 4 apprenticeship programme enables your organisation to:
* Build the skills and capabilities you need throughout your organisation to analyse, interrogate and present technical data, providing informed and valuable business insights to a range of stakeholders.
* Upskill or reskill your existing workforce with data skills and create analysts for the modern day workplace.
* Recruit and harness a new talent pathway: QA can help you cost-effectively recruit diverse, ambitious talent into your business and help you build a pipeline of data literacy talent.
* Delivered by industry experts with real-world experience, the programme’s content has been designed around real-life skills and includes the additional PL-300 Microsoft Power BI Data Analyst certification.
The technical content aligns to and is relevant to employers and the market.
Requirements
Essential qualifications
GCSE or equivalent in:
* 5 including Maths & English (grade Grade 4 (C) or above)
Desirable qualifications
A Level or equivalent in:
* Relevant subject (grade Any)
BTEC or equivalent in:
* Relevant subject (grade Level 3)
Other in:
* Apprenticeship in similar subject (grade Level 3)
Let the company know about other relevant qualifications and industry experience you have. They can adjust the apprenticeship to reflect what you already know.
Skills
* IT skills
* Attention to detail
* Problem solving skills
* Administrative skills
* Team working
* Initiative
* Non judgemental
* Passion for data analytics