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:

• 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.