Data Analyst

Vertu Motors plc; North East; On-site; GBP 35,000 - 40,000; Full time

Benefits offered by this job

25 days holiday

Online rewards platform

Preferential service rates

Colleague Purchase Scheme

Share Incentive Scheme

Pension

Enhanced Maternity & Paternity

Job summary

Vertu Motors plc, Gateshead, is seeking a Data Analyst to join the team and lead the rebuild of the data warehouse in the cloud using SQL, AWS Glue, and Power BI. The role involves working with stakeholders to identify data needs, ensuring data quality, and delivering insightful dashboards.

The position is based at our Gateshead head office in the North East with a salary of up to £40,000 depending on experience.

Qualifications

• Experience in a Data Analyst role.
• Strong experience with SQL and Python.
• Experience with AWS Glue or similar ETL tools.
• Experience with data visualization tools such as Power BI.
• Strong analytical and problem-solving skills.

Responsibilities

• Develop and maintain the Data Warehouse using SQL.
• Develop ETL processes using AWS Glue.
• Create reports and dashboards using Power BI
• Work with stakeholders to understand their data needs and provide solutions.
• Analyse large datasets to identify trends and patterns.
• Ensure data accuracy and integrity.
• Develop and maintain documentation for data processes and procedures.
• Stay up-to-date with the latest data analysis tools and techniques.

Skills

SQL

Python

Power BI

Data analysis

Communication

Teamwork

Tools

AWS Glue

GitHub

Job description

Vertu Motors, Gateshead

As one of the largest automotive retail groups in the UK, Vertu Motors is proud to represent 30 of the World's most popular vehicle manufacturers from over 190 sites nationwide. Our two brands include Due to our continued growth and success, we have a unique opportunity for a Data Analyst to join our team.

Vertu Motors, Gateshead

As one of the largest automotive retail groups in the UK, Vertu Motors is proud to represent 30 of the World's most popular vehicle manufacturers from over 190 sites nationwide. Our two brands include Due to our continued growth and success, we have a unique opportunity for a Data Analyst to join our team.

We are currently engaged in an ambitious strategic project to rebuild our data warehouse in the cloud using Redshift and AWS Glue, including integration of our Customer Data Platform, and a roll out of our new BI platform. This is an exciting opportunity to be involved in this project and to learn new skills in cloud technology, whilst applying your previous experience of SQL.

As Our Data Analyst Your Key Responsibilities Will Be

• Develop and maintain the Data Warehouse using SQL.
• Develop ETL processes using AWS Glue.
• Create reports and dashboards using Power BI
• Work with stakeholders to understand their data needs and provide solutions.
• Analyse large datasets to identify trends and patterns.
• Ensure data accuracy and integrity.
• Develop and maintain documentation for data processes and procedures.
• Stay up-to-date with the latest data analysis tools and techniques.

For this role we are looking for you to have:

• Experience in a Data Analyst role.
• Strong experience with SQL and Python.
• Experience with AWS Glue or similar ETL tools.
• Experience with data visualization tools such as Power BI
• Strong analytical and problem-solving skills.
• Excellent communication and collaboration skills.
• Ability to work independently and as part of a team.
• Understanding of source control via GitHub

This is based at our Head Office in Gateshead, so we are looking for the successful candidate to be based within the North East. We are able to offer a salary of up to £40,000 depending on experience.

Benefits

We are proud to be the Motor Retailer who invests more in our colleague's personal development than any other, so if you are successful, you can look forward to on-going training opportunities that provide you with the right career path, career progression and a range of benefits you would expect from an employer of choice which includes:

• 25 days holiday rising with length of service plus bank holidays
• Access to our online rewards platform giving you cash back and discounts for multiple retailers
• Preferential Service Rates
• Colleague Purchase Scheme
• Share Incentive Scheme
• Pension
• Enhanced Maternity & Paternity

If your application is successful, we will need to complete employment checks prior to you starting with us. Your role will include us verifying your recent employment, credit history and a criminal record check.