Job Summary:
We are seeking a highly skilled and experienced Data Analyst to join our team as we continue to expand our data-driven decision-making processes.
Green Motion is a franchised car rental company based on the UK operating in over 65 countries and over 650 operational locations.
As our Data Analyst, you will play a crucial role in extracting valuable insights from our databases, providing accurate reports and visualizations using Power BI, and utilizing your strong SQL skills to manipulate and analyse large datasets. The ideal candidate will have a proven track record of building and managing database tables in MariaDB and MySQL, along with a deep understanding of data analysis techniques and best practices.
Responsibilities:
- Design, build, and maintain database tables in MariaDB and MySQL, ensuring data integrity and optimal performance.
- Consolidate Data from several different sources including Azure and AWS
- Develop and optimize SQL queries to extract, transform, and load (ETL) data from various sources into our databases.
- Collaborate with cross-functional teams to identify and understand data requirements and translate them into actionable insights.
- Perform data cleansing, validation, and enrichment to ensure high data quality and accuracy.
- Use Power BI & Yellowfin to create visually appealing and interactive dashboards and reports that effectively communicate key metrics and trends.
- Analyse large datasets to identify patterns, trends, and anomalies, and provide meaningful recommendations based on the findings.
- Monitor and track data quality metrics, and proactively identify and address any data-related issues.
- Stay up to date with industry trends and best practices in data analysis, database management, and visualization tools.
Requirements:
- Bachelor's degree in Computer Science, Statistics, Mathematics, or a related field.
- Proven experience in building and managing database tables in MariaDB and MySQL.
- Strong SQL skills, with the ability to write complex queries and optimize query performance.
- Proficiency in using Power BI to create interactive dashboards and reports.
- Solid understanding of data analysis techniques and best practices.
- Experience with data cleansing, validation, and enrichment techniques.
- Strong analytical and problem-solving skills, with the ability to translate complex data into actionable insights.
- Excellent attention to detail and a strong commitment to data accuracy and integrity.
- Ability to work collaboratively in a team environment and effectively communicate complex concepts to both technical and non-technical stakeholders.
- Familiarity with other data analysis and visualization tools is a plus.
Benefits
· Salary: £35,000 - £40,000 per annum.
· 20 days holiday per year (pro rata), plus bank holidays, increasing by 1 day for every year of service
· Flexible and Hybrid working that works for you and the wider team
· To allow you to celebrate properly, each year we'll give you a paid day to take your birthday off
· Family friendly policies including enhanced maternity and paternity leave
· Annual Eye Test Scheme
· We offer a pension scheme where you can contribute at least 5% of your annual salary (or more if you like) and we will also make a contribution
· Regular team building events such as company BBQs / activities and our annual Christmas party
· Casual dress code on most days
· Every year we'll review your salary to ensure it fairly aligns with your responsibilities
· Free parking