BI Engineer

Fred Perry; Greater London; Hybrid; GBP 65,000 - 95,000; Full time

Benefits offered by this job

Annual bonus

Private healthcare

Pension scheme

Hybrid/remote flexibility

25 days annual leave

Job summary

Fred Perry is seeking a data engineer to lead the development and optimisation of our BI infrastructure. You will consolidate data from core systems into a single view to support strategic decision-making.

You will own data pipelines, warehouse schemas and semantic models, with a focus on quality, governance and agile delivery. The role combines office-based collaboration in London with flexible remote work.

Qualifications

• Strong experience in data engineering with ETL/ELT and cloud data platforms.
• Deep knowledge of data warehousing, dimensional modelling and Kimball principles.
• Advanced SQL/T-SQL with optimization and debugging.
• Proficiency in Python or PySpark for data manipulation.
• Experience integrating data from APIs, databases and files.
• Experience with data quality, monitoring, and troubleshooting.
• Experience with CI/CD and DevOps practices.
• Experience building semantic models using Power BI or SSAS.
• Hands-on BI tool experience, preferably Power BI, in an Agile environment.

Responsibilities

• Develop, maintain and optimise data pipelines and ETL/ELT processes to a cloud Data Warehouse (Microsoft Fabric).
• Own reliability, monitoring and performance of data pipelines and data quality improvements.
• Design and maintain data warehouse structures within a medallion architecture.
• Integrate internal and external data sources via APIs, databases and files.
• Work across the Data Delivery Lifecycle – Define, Design, Develop & Deploy.
• Document solutions per Data & Analysis standards and governance policies.
• Support BI Manager and analysts with data engineering, architecture and modelling best practices.
• Upskill the BI team and promote consistent data/BI practices across the organisation.

Skills

ETL/ELT pipelines

Cloud data platforms

SQL/T-SQL

Python/PySpark

Data quality monitoring

CI/CD & DevOps

Semantic models (Power BI/SSAS)

Agile development

Tools

Microsoft Fabric

Power BI

SSAS

Job description

Triple Wimbledon champion Fred Perry founded his brand in 1952. He was the son of a cotton spinner, who played and fought his way through, always with style – and despite the establishment. Today, Fred Perry is a global community of over 370 employees, all inspired by the Laurel Wreath and what it represents

Purpose

This is a key role in the Business Insight team responsible for the delivery and development of the organisation wide BI infrastructure, bringing together data from our core systems to provide a single view of the business and its strategic partners.

Key Responsibilities

• Develop, maintain and optimise data pipelines and ETL/ELT processes between source systems and the cloud-based Data Warehouse (Microsoft Fabric)
• Take ownership of the reliability, monitoring and performance of data pipelines, resolving issues and improving data quality
• Design, build and maintain data warehouse structures and schemas within our medallion architecture
• Integrate internal and external data sources using APIs, databases, files and other ingestion methods
• Work across the data Delivery Lifecycle – Define, Design, Develop & Deploy – including data processes, data models and semantic models
• Document technical solutions in accordance with Data & Analysis standards
• Ensure compliance with company data governance, risk and security policies
• Support the BI Manager and BI Analysts with data engineering, architecture, modelling and best practices
• Help upskill the BI team and promote consistent data and BI practices across the organisation

Essential Skills And Experience

• Strong experience in data engineering, including ETL/ELT, data pipelines and modern cloud data platforms
• Strong understanding of data warehousing, dimensional modelling, Kimball principles and data architecture
• Advanced SQL/T-SQL skills, including query development, optimisation and troubleshooting
• Strong Python, PySpark or similar programming skills for data manipulation and automation
• Experience integrating data from APIs, databases, files and other sources
• Experience with data quality, pipeline monitoring and troubleshooting
• Experience working with CI/CD, source control and DevOps practices
• Experience developing and maintaining semantic models using Power BI, SSAS or similar
• Hands-on experience with modern BI tools, preferably Power BI
• Experience working in an Agile development environment

Desirable Skills And Experience

• Hands-on experience with Microsoft Fabric
• Experience working with ERP or other large enterprise source systems

The Person

• Excellent problem solver.
• Numerical and analytical mindset.
• Organised, delivery focused and comfortable working on own initiative.
• Collaborative and team orientated.
• Desire and passion for continuous learning.
• Comfortable with working to agile principles.
• A clear communicator that is comfortable with working with all departments and levels of seniority.

Hours

We actively encourage our teams to have a good work/life balance and so we are pleased to offer flexible working shifts at Fred Perry HQ. Our core shift hours are from 10am – 4.30pm and so employees can choose to start and finish early, or start and finish late. (i.e. work 8:00am-4:30pm, or 10:00am-6:30pm etc). We also have 30-minute early finish on Fridays.

As we continue to work in a more flexible way, the Head Office acts a brand hub, where we can all connect and collaborate with one another. This role is a mix of office based (London) and remote working. We will expect the employee to come into the office regularly for face-to-face meetings and to work alongside their team on collaborative projects.

Benefits

We are proud to offer a wide range of benefits to all our staff, and continue to reassess what our community needs from us to thrive. We don’t want to be a good company to work for, we want to be a great one. Here are some things we currently offer:

• Annual performance-related bonus
• Competitive salary
• Generous staff discount and regular sample sales
• Generous pension scheme with 8.5% company contribution
• Option to buy an extra 5 days holiday annually
• Enhanced maternity and paternity packages
• Life insurance
• Private healthcare
• Cycle to work scheme
• Early finish Fridays
• Season ticket loan
• Additional benefits with long service
• 25 days annual leave plus Bank Holidays
• Annual Birthday vouchers
• EAP
• Social Events

We actively welcome applications from people of all different backgrounds. Your CV will be submitted to hiring managers with all personal details hidden to ensure anonymity.