Business/Market Data Analyst Apprentice - 69893

Overall Team Objective:

To provide data that can be used by the company externally and internally by the management team and present to the client base and marketplace.

Relationships and Personal Activities:

Directly responsible to:

Commercial Director

Responsible for:

Providing performance, client and product data to the business in easy to interpret, suitable formats.

Relationships with:

FAUN Zoeller personnel in general, customers and suppliers including ECOTEC Group.

This is a fantastic opportunity to be part of this fast growing company and to undertake a Level 4 Data Analyst Apprenticeship.

This is a technical role, which is revolved around data analytics.

Duties include:

• You will be using multiple data analysis tools (not just Excel)
• To collect and compile data from different sources within the company including the SAP database
• To Process, cleanse, analyse (including statistical analysis) and present data
• Run ad-hoc and standard data analysis reports and performance dashboards
• Perform data mining and forecasting
• Processing large amounts of data on a regular basis

Objectives and Key Tasks you will be working towards:

• Identify, collect and migrate data to/from a range of internal and external systems
• Collect and compile data from different sources
• Interpret and apply the organisations data and information security standards, policies and procedures to data management activities
• Work with the organisations data architecture
• Manipulate and link different data sets as required
• Perform database queries across multiple tables to extract data for analysis
• Perform routine statistical analysis and ad-hoc queries
• Use a range an analytical techniques such as data mining, time series forecasting and modelling techniques to identify and predict trends and patterns in data
• Assist with data quality checking and cleansing
• Assist production of performance dashboards and reports
• Apply the tools and techniques for data analysis, data visualisation and presentation
• Assist with the production of a range of ad-hoc and standard data analysis reports
• Summarise and present the results a data analysis to a range of stakeholders making recommendations

Requirements and prospects

Desired skills

Desired experience: [able to use and understand]

• The range of data protection and legal issues
• Data life cycle
• The different types of data, including open and public data, administrative data and research data
• The difference between structured / unstructured data
• The fundamentals of data structures, database system design, implementation and maintenance
• The importance of the domain context for data analytics
• The quality issues that can arise with data and how to avoid and/or resolve these
• The importance of clearly defining customer requirements for data analysis
• The processes and tools used for data integration
• The steps involved in carrying out routine data analysis tasks
• How to use and apply industry standard tools and methods for data analysis

Desired skills and qualities:

• Logical and creative thinking skills
• Analytical and problem solving skills
• Ability to work independently and to take responsibility
• Can use own initiative
• A thorough and organised approach
• Ability to work with a range of internal and external people
• Ability to communicate effectively in a variety of situations
• Maintain productive, professional and secure working environment
• Comfortable looking at detailed and complex information
• As well as a good working knowledge of Microsoft Excel
• Experience/knowledge of SQL, Power Bi and Python advantageous

Personal qualities

Behaviours:

• A desire to learn and improve upon skill set
• Punctual and reliable
• Happy to work as part of a team
• Willing to build and work upon relationships with customers and colleagues

Desired qualifications

• Strong English and maths skills
• A-Levels in ICT/Business/Computing
• Or an Apprenticeship in a similar subject (this must be at least the level below the planned programme)
• Or an International Baccalaureate at level 3 in ICT

Future prospects

92% of QA Apprentices secure permanent employment after finishing their apprenticeship. Additionally there may be opportunities to undertake further apprenticeship training as many of our programs offer on-going development tracks.

Things to consider

Other requirements:

• Valid passport
• Willing to travel in UK and abroad

Benefits:

• Busybees (retail, gym discounts etc)
• Employee Assistant Programme
• 26 days holiday per annum (Jan-Dec)

Important Information:

QA's apprenticeships are funded by the Education & Skills Funding Agency (ESFA), an executive agency of the Department for Education.

To be eligible for a Government funded apprenticeship you must have lived in the UK or European Economic Area (EEA) for the last 3 consecutive years.