BI Engineer

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. Locations London Remote status Hybrid OUR COMPANY Our head office is located in the heart of London. It's where everything happens – design, product development, marketing, customer service, and operations. We have more than 200 stores worldwide, from Manchester to Brighton, as well as Paris, New York, Seoul, and Tokyo, to name just a few. We're an ambitious brand, working with some of the world's leading designers and partners. But our success is built on our people, which is why we're committed to attracting passionate individuals from diverse backgrounds with a wide range of experiences. Our commitment to Diversity, Equity and Inclusion (DE&I) is fundamental to who we are. We strive to develop, empower and inspire our people by reinforcing our mission, purpose and values as we continue building an iconic brand. Our commitment to empowerment goes beyond inclusion - we aim to recognise and make the most of the talent across our organisation. We are dedicated to creating an environment where everyone feels valued and respected, regardless of their background or identity. Applicant tracking system by Teamtailor