Data Analyst Exeter, England
Job description
We are Lightfoot, a high-growth technology company based just outside Exeter that is focused on making a difference worldwide, one driver at a time.
We help businesses and private motorists improve performance and safety. Our technology has been proven to reduce fuel use and emissions rates by 10-20%, and at-fault accidents and wear and tear by 40-50%.
Our technology connects to your vehicle’s on-board computer and uses all the live data it produces to analyse how efficiently you are driving. It’s similar to how performance is analysed in Formula 1. Lightfoot turns that data into simple feedback for you – the driver – so you know when you’re pushing your vehicle too far and can bring it back to maximum efficiency.
We’re a fun-loving bunch who are growing at an astonishing rate. We’ve moved into a brand-new, state-of-the-art office near Exeter in the beautiful Southwest (which was voted Exeter’s ‘Best Workspace’). We are excited to keep growing the Lightfoot family with like-minded, passionate individuals who share our values;
· We care deeply.
· We are innovative.
· We deliver excellence.
· We are customer first.
· We are friendly and celebrate individuality.
Role overview
This role works as part of the data science team and reports to our Senior Data Analyst. The role is responsible for analysing complex data to support the delivery of projects and solutions. You’ll identify issues and opportunities, which will improve the way Lightfoot works and bring value to our customers. You’ll also be able to present data in a clear and engaging way for colleagues, stakeholders and customers, so it can be used to inform strategic decision making. You will be committed to continuous improvement and be passionate about delivering high quality work within a fast paced but highly exciting environment under the direction of the Senior Data Analyst.
Key responsibilities
· Run regular reports measuring business metrics/KPIs for directors and various departments
· Create external reports based on client driving data, fuel savings, etc.
· Quality Assurance checking reports completed by other members of the team
· Compiling and delivering on data requests received from clients
· Special/one-off reports, summarising data in a specified way as requested by the Company or client
· Writing/improvement of MySQL queries, Python, and Excel VBA code
· Gather and manipulate data from a variety of sources, e.g., Excel, MySQL Databases, Salesforce
· Provide insight on findings from gathered data and present to the business
· Continuously seek ways to automate reports and opportunities to improve report presentation, including new metrics, in order to communicate insight in a clear, eye-catching manner
Desired qualifications, skills and experience
· Experience in a similar role analysing data is essential
· The desire to learn new skills/software/programming languages is essential
· Excellent spoken and strong written communication skills are essential
· Comfortable working in fast-paced environment is essential
· The ability to use Excel to an intermediate level (formulas, pivot tables) is essential
· Experience using Python is beneficial.
· Experience using PowerPoint is essential.
· Experience of MySQL / SQL scripts and databases is essential
· Design skills (charts / graphs / reports is essential
· Experience using Excel VBA is beneficial.
· Experience using Power BI is beneficial.
Personal characteristics
· Be a positive advocate for our company values.
· A quick, agile learner
· A keen eye for detail
· Able to communicate confidently with all levels within the business.
· Driven to deliver positive business results.
· Problem solver who loves to tackle data challenges pro-actively.
· Personable and outgoing, with a good sense of humour
Salary & Benefits
· £30,000 to £35,000 pa
· Inclusion in company bonus scheme
· Free onsite parking
· 24 days holiday plus bank holidays
· Extra day off for your birthday
· Christmas closure – closed from Christmas eve at 5pm until the first working day in January.
· Holiday buy back scheme – The chance to buy up to an extra week’s holiday.
· Company pension
· Health & Dental plan plus additional discounts through our benefits platform
· A Lightfoot device for all employees
· Company social events and activities
· Company sick pay
Location
· There is the opportunity for Hybrid working (office & home working). Office space based on the outskirts of Exeter.
Due to a high volume of applicants we are unable to respond to everyone. If you have not heard from us within 14 days of your application you should assume you have been unsuccessful this time. Thank you for your interest in Lightfoot
Job Types: Permanent, Full-time
Salary: £30,000.00-£35,000.00 per year
Benefits:
- Additional leave
- Casual dress
- Company events
- Company pension
- Cycle to work scheme
- Employee discount
- Health & wellbeing programme
- Life insurance
- On-site parking
- Private dental insurance
- Private medical insurance
- Referral programme
- Sick pay
Schedule:
- Monday to Friday
- No weekends
Supplemental pay types:
- Yearly bonus
Ability to commute/relocate:
- Exeter, EX5: reliably commute or plan to relocate before starting work (required)
Experience:
- Data & Technical Business Analysts: 1 year (preferred)
- PowerPoint: 1 year (preferred)
- MySQL / SQL scripts and databases: 1 year (preferred)
- Excel VBA: 1 year (preferred)
- Design skills (charts / graphs / reports: 1 year (preferred)
Work Location: Hybrid remote in Exeter, EX5
