Employee Records
Data Engineer
Butcombe Brewery
Full Time
Hybrid remote
1 Year Experience
Coins Icon £40000 - £45000 / Year
Data Engineer
Butcombe Brewery

Full Time
Hybrid remote
1 Year Experience
Coins Icon £40000 - £45000 / Year
Skills
Data
Systems
IT
Description

We are seeking a Data/SQL Engineer to join our IT team here at The Butcombe Group during a pivotal phase of our business analytics journey. This role is foundational focused on integrating diverse data sources such as Navision, S4 Labour, Acteol CRM, and Procure Wizard into our central SQL Server warehouse.

You’ll be responsible for building and maintaining ETL pipelines using SSIS, developing semantic models in SSAS, and supporting report delivery through SSRS and Power BI.

As part of a collaborative and forward-thinking team, you’ll help shape the structures that enable data-driven decision-making across the business. From designing efficient schemas to enabling API-based data flows and supporting advanced reporting, your work will directly contribute to strategic outcomes and operational excellence.

Key Responsibilities

This role is varied with a wide range of responsibilities, the main responsibilities are: 

Data Integration & ETL

  • Assist in building and maintaining ETL pipelines using SQL Server, Azure Data Factory, and Databricks
  • Connect and ingest data from operational systems (Navision, S4 Labour, Acteol CRM, Procure Wizard)
  • Build and maintain ETL pipelines using SQL Server Integration Services (SSIS)
  • Develop and manage API integrations for external data sources and services
  • Ensure data quality, consistency, and reliability across ingestion workflows
Data Modelling & Warehousing

  • Design and maintain star/snowflake schemas in SQL Server
  • Develop semantic models using SQL Server Analysis Services (SSAS)
  • Implement business logic and aggregations to support reporting and analytics
Reporting Infrastructure

  • Support the development and delivery of reports using SQL Server Reporting Services (SSRS) and Power BI
  • Enable advanced analytics through calculated columns, measures, and DAX logic
Collaboration & Documentation

  • Work closely with developers, analysts, and stakeholders to understand data needs.
  • Document data flows, schema definitions, and transformation logic.
  • Participate in workshops and feedback sessions to refine reporting capabilities.
  • Analyse competitor loyalty programs and market trends to ensure our programs remain competitive and innovative.
Qualifications and Skills

  • Bachelor’s degree in a related field. Master’s degree preferred.
  • Ability to design and maintain SQL data warehouses
  • Knowledge of SQL Stored Procedures, Indexing, script management & windows functions
  • 1+ years’ experience working with a self-service reporting tool
  • Good knowledge of Microsoft Data Analytics Stack: Power BI, SSAS, SSIS, SSRS
  • Experience of Integrating 3rd Party Solutions via an API/Data Transformation process
  • Hands-on experience of secondary tools: Microsoft Azure, Visual Studio, Active Directory
  • Hospitality or Retail sector experience or exposure to systems such as:
  • EPOS (Zonal), Labour Management, Table & Events (Collins), Customer Loyalty program (Zonal)
  • Proficiency in data analysis tools and software such as Excel, Tableau, and other BI tools.
  • Strong analytical and problem-solving skills, with the ability to interpret complex data sets and derive actionable insights.
What do you get, working for us?
Perks & discounts

  • Day-1 access to the Benefits Bar, our one stop shop for Highstreet discounts, cashback and savings on everything from groceries to getaways.
  • Extra holiday? Yes please – buy more with our annual leave purchase scheme.
  • Enjoy team parties, exclusive employee rewards and 30% off at all Butcombe Pubs & Inns (plus 50% off food while on shift).
Surprise & Delight

  • Celebrate work anniversaries with a gift – our way of saying thanks
  • Your birthday off – because cake tastes better when you’re not at work.
Wellbeing

  • We’re proud to support mental health through The Burnt Chef Project, with 24/7 Employee Assistance available to everyone.
  • Invest in your hobbies with our Cycle to Work Scheme.
  • Enjoy flexibility – our people have autonomy to shape their working week and create balance.
  • Family-friendly policies including enhanced maternity and paternity pay.
  • Access to financial advisors to help you plan and manage your money.
Go Further with Us

We don’t just talk development – we live it. From award-winning training plans and personalised apprenticeships to bespoke progression pathways, we’ll help you grow your career with us.

Our Values – From the Heart

At Butcombe, we care deeply about our people. We lead with kindness, set the bar high, and take pride in raising the spirits of everyone who walks through our doors. We celebrate individuality, champion community, and work together to create memorable experiences – every time. Whether you’re growing your career or looking for your next exciting challenge, we’ll support you with the tools, training, and trust to be your best. Come and be talk of the town, like us.  

What else do you need to know?

  • Head Office Location: Wrington, Bristol
    • Occasional visits to the Channel Islands
  • Hybrid Working: Flexible office/home
    • Weekly Teams calls for the whole department
    • Quarterly Team meetings at one of our excellent Pubs & Inns
  • Contract Type: Full Time
  • Working Hours: 9 to 5 (flexible)
  • Dress-Code: Business casual
About Us

At The Butcombe Group, our newly formed Growth team is driving a transformation in how we use data to support decision-making and customer engagement. As a Database Developer, you’ll be part of a collaborative environment focused on building robust data infrastructure and delivering actionable insights. We’re integrating systems like Navision, S4 Labour, Acteol CRM, and Procure Wizard into a central SQL Server warehouse to power our reporting and analytics. Your work will directly support our mission to create seamless, data-driven experiences across our pubs, hotels, and retail operations - helping us serve our customers better and grow smarter.

We are seeking a Data/SQL Engineer to join our IT team here at The Butcombe Group during a pivotal phase of our business analytics journey. This role is foundational focused on integrating diverse data sources such as Navision, S4 Labour, Acteol CRM, and Procure Wizard into our central SQL Server warehouse.

You’ll be responsible for building and maintaining ETL pipelines using SSIS, developing semantic models in SSAS, and supporting report delivery through SSRS and Power BI.

As part of a collaborative and forward-thinking team, you’ll help shape the structures that enable data-driven decision-making across the business. From designing efficient schemas to enabling API-based data flows and supporting advanced reporting, your work will directly contribute to strategic outcomes and operational excellence.

Key Responsibilities

This role is varied with a wide range of responsibilities, the main responsibilities are: 

Data Integration & ETL

  • Assist in building and maintaining ETL pipelines using SQL Server, Azure Data Factory, and Databricks
  • Connect and ingest data from operational systems (Navision, S4 Labour, Acteol CRM, Procure Wizard)
  • Build and maintain ETL pipelines using SQL Server Integration Services (SSIS)
  • Develop and manage API integrations for external data sources and services
  • Ensure data quality, consistency, and reliability across ingestion workflows
Data Modelling & Warehousing

  • Design and maintain star/snowflake schemas in SQL Server
  • Develop semantic models using SQL Server Analysis Services (SSAS)
  • Implement business logic and aggregations to support reporting and analytics
Reporting Infrastructure

  • Support the development and delivery of reports using SQL Server Reporting Services (SSRS) and Power BI
  • Enable advanced analytics through calculated columns, measures, and DAX logic
Collaboration & Documentation

  • Work closely with developers, analysts, and stakeholders to understand data needs.
  • Document data flows, schema definitions, and transformation logic.
  • Participate in workshops and feedback sessions to refine reporting capabilities.
  • Analyse competitor loyalty programs and market trends to ensure our programs remain competitive and innovative.
Qualifications and Skills

  • Bachelor’s degree in a related field. Master’s degree preferred.
  • Ability to design and maintain SQL data warehouses
  • Knowledge of SQL Stored Procedures, Indexing, script management & windows functions
  • 1+ years’ experience working with a self-service reporting tool
  • Good knowledge of Microsoft Data Analytics Stack: Power BI, SSAS, SSIS, SSRS
  • Experience of Integrating 3rd Party Solutions via an API/Data Transformation process
  • Hands-on experience of secondary tools: Microsoft Azure, Visual Studio, Active Directory
  • Hospitality or Retail sector experience or exposure to systems such as:
  • EPOS (Zonal), Labour Management, Table & Events (Collins), Customer Loyalty program (Zonal)
  • Proficiency in data analysis tools and software such as Excel, Tableau, and other BI tools.
  • Strong analytical and problem-solving skills, with the ability to interpret complex data sets and derive actionable insights.
What do you get, working for us?
Perks & discounts

  • Day-1 access to the Benefits Bar, our one stop shop for Highstreet discounts, cashback and savings on everything from groceries to getaways.
  • Extra holiday? Yes please – buy more with our annual leave purchase scheme.
  • Enjoy team parties, exclusive employee rewards and 30% off at all Butcombe Pubs & Inns (plus 50% off food while on shift).
Surprise & Delight

  • Celebrate work anniversaries with a gift – our way of saying thanks
  • Your birthday off – because cake tastes better when you’re not at work.
Wellbeing

  • We’re proud to support mental health through The Burnt Chef Project, with 24/7 Employee Assistance available to everyone.
  • Invest in your hobbies with our Cycle to Work Scheme.
  • Enjoy flexibility – our people have autonomy to shape their working week and create balance.
  • Family-friendly policies including enhanced maternity and paternity pay.
  • Access to financial advisors to help you plan and manage your money.
Go Further with Us

We don’t just talk development – we live it. From award-winning training plans and personalised apprenticeships to bespoke progression pathways, we’ll help you grow your career with us.

Our Values – From the Heart

At Butcombe, we care deeply about our people. We lead with kindness, set the bar high, and take pride in raising the spirits of everyone who walks through our doors. We celebrate individuality, champion community, and work together to create memorable experiences – every time. Whether you’re growing your career or looking for your next exciting challenge, we’ll support you with the tools, training, and trust to be your best. Come and be talk of the town, like us.  

What else do you need to know?

  • Head Office Location: Wrington, Bristol
    • Occasional visits to the Channel Islands
  • Hybrid Working: Flexible office/home
    • Weekly Teams calls for the whole department
    • Quarterly Team meetings at one of our excellent Pubs & Inns
  • Contract Type: Full Time
  • Working Hours: 9 to 5 (flexible)
  • Dress-Code: Business casual
About Us

At The Butcombe Group, our newly formed Growth team is driving a transformation in how we use data to support decision-making and customer engagement. As a Database Developer, you’ll be part of a collaborative environment focused on building robust data infrastructure and delivering actionable insights. We’re integrating systems like Navision, S4 Labour, Acteol CRM, and Procure Wizard into a central SQL Server warehouse to power our reporting and analytics. Your work will directly support our mission to create seamless, data-driven experiences across our pubs, hotels, and retail operations - helping us serve our customers better and grow smarter.