Business Intelligence Data Engineer
Role details
Job location
Tech stack
Job description
The BI Data Engineer has a pivotal role in transforming Data & Analytics practices across Henderson Group by leveraging the Databricks platform.
This role will focus on designing, building, and maintaining the data infrastructure and pipelines to ensure efficient, reliable ETL processes.
As a key member of the Data Team, you will help the business deliver modern, high-impact analytics and AI-driven insights, driving competitive advantage and innovation.
Working as Business Intelligence Data Engineer you will:
ETL & Data Pipeline Responsibilities
- Implement efficient ETL processes using Databricks and AWS Glue
- Automate data ingestion from cloud, on-prem, API, and streaming sources.
- Develop scalable data architecture aligned with business needs.
- Standardise master data for a single source of truth.
Data Modelling & Analytics Responsibilities
- Build data models (e.g., star schema) for BI and analytics.
- Use Delta Lake for scalable, reliable storage.
- Maintain Databricks notebooks, jobs, and workflows.
- Enforce data integrity, security & compliance.
- Support advanced analytics and machine learning initiatives.
- Share knowledge with the team and contribute to continuous learning.
Database & Performance Optimisation Responsibilities
- Optimise Spark jobs and Databricks workflows for efficiency
- Monitor performance metrics and troubleshoot bottlenecks proactively.
- Plan scalability to handle increasing data volumes and user demand.
Requirements
- Minimum of 2 years experience in a similar data engineer role
- Experience in Python (PySpark) or Databricks notebooks
- Strong understanding of Delta Lake, data warehousing, and big data concepts.
The Attributes youll need include:
- Excellent analytical and communication skills
- Excellent attention to detail
- Capable of planning,coordinating and prioritizing multiple tasks
- Strong team player, ensuring a positive and collaborative work environment
- Creativity to deliver impactful business insights
- Ability to communicate well with both IT and business staff
- Self-motivated and reliable
- Aptitude for teaching, mentoring and knowledge sharing
- Ability to troubleshoot and resolve issues
It is Desirable if you have:
- Third level Degree in Computer Science, Engineering, Data, or related qualification
- Experience in Retail Sector
- Knowledge of advanced analytics, including AI, Machine Learning etc
- Experience of integrations e.g. APIs
- Experience using AWS Glue
- Experience working within a SCRUM environment
Benefits & conditions
The impact you can make with Henderson Group goes far beyond your day to day. You will be part of a business supporting defibrillator installations and school sports days. In the last year Henderson group staff and retail stores raised over £1 million for charity partners.
You will have the balance necessary to enjoy your job and your life. We will help you to feel proud of what you do and achieve. And we will be here to celebrate your success.
Our business has been recognised externally for delivering excellence in employment. We value employee development and heavily invest in our people.
Benefits include market competitive salary, contributory pension scheme, healthcare, life assurance, employee assistance programme, social club, Reward Gateway Employee Recognition & Discount Scheme throughout UK/Ireland , staff discount (grocery/fuel) at SPAR/EUROSPAR Henderson Group company-owned stores and many more.
This is a full-time position working 36.5 hours per week. Working hours will be 8:45am-4:45pm Monday to Thursday and 8:45am-3:45pm Friday. Hybrid and flexible working arrangement available. (Must reside within daily commuting distance)