BI Engineer

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.