Data Engineer
Cullompton
(with Hybrid Working)
As a result of continued growth, we have a vacancy for a Data Engineer to join the Gregory Group Technology Team. This is an exciting opportunity to make your own within the Gregory Group.
The position of Data Engineer involves:
1. Creating and maintaining database schemas for use in our data warehouse, in-house applications and integrations.
2. Creating and maintaining existing and new ETL processes using SQL Stored Procedures and Azure Data Factory.
3. Contributing to the design, maintenance and development of a high quality, robust and performant centralised data source comprising data from multiple business systems, both cloud-based and on-premise – which supports business intelligence and analysis development.
4. Managing, monitoring and optimising both on-premises and Azure SQL servers including indexing, maintenance plans and query / performance optimisation.
5. Automating data retention policies and other housekeeping activities to optimise performance and meet compliance requirements.
6. Designing and delivering business intelligence and reporting solutions using both traditional (MS SQL, SSRS) and modern (BI) tools, technologies and methods.
7. Continuous improvement of data schemas, reports, dashboards and business intelligence solutions.
8. Maintaining accurate documentation of solutions and supporting cross-skilling across the wider Data Services team.
9. Delivering customer-specific requirements as part of an implementation / onboarding project or as part of business-as-usual.
10. Understanding our people and processes as well as business problems and opportunities and using this contextual knowledge to translate business requirements into technical solutions tailored and appropriate for the audience.
11. Consulting as part of project processes to define data, reporting and BI requirements, suggesting enhancements as appropriate.
12. Highlighting opportunities based on your understanding of the business and knowledge of our data for where data, analytics or BI solutions can help to improve business performance.
13. Working with the wider Group Technology team to ensure smooth running of systems and relevant dependent services such as integration and application development. This will include working with our infrastructure and security team to ensure data systems are secure and performant.
14. Working closely with our PMO function and assigned Project Manager’s, updating on task progress and escalating risks or dependencies where necessary.
15. Using our project and task management tool, JIRA, ensuring that tasks as prioritised and kept up to date for visibility across the team and PMO.
Essentials Skills required for a Data Engineer :
16. Minimum of 3 years’ experience in a similar data engineering / development type role.
17. Experience of Azure Data Factory or other similar cloud-based modern data tools.
18. High aptitude for data schema and ETL design and confident working with data.
19. High degree of proficiency with MS SQL, SSRS.
20. Experience of using Power BI or other similar BI tool desirable.
21. Experience of using modern cloud data platforms desirable.
22. Highly motivated with a curiosity to understand business process and problems to identify opportunities.
23. Critical thinking and analytical mindset to problem solving.
24. Excellent written and verbal communication skills.
25. Full UK driving licence as occasional travel between Gregory Group locations may be required.
Why Gregory Distribution?
26. Salary for Data Engineer is from £43,pa - £48,pa, dependant on experience
27. Hours of work are Monday to Friday 08:30hrs to 17:00hrs.
28. Opportunity to develop your career within an expanding business.
29. Additional holiday purchasing scheme*
30. Retail discounts with Hapi*
31. Retail Trust Wellbeing Support*
32. Opportunity to develop your career within an expanding business.
33. Excellent holiday allowance and company benefits.
34. Life assurance, pension and sickness scheme*
35. Christmas Savings Club*
36. Black Circle Tyre discount*
37. Leading industry qualifications*
38. Medical Reimbursement*
39. This vacancy is not entitled to the employee referral scheme.
40. Free Uniform.
41. Strong culture of teamwork.