BI Engineer
London, England, United Kingdom Full-time Posted 4 hours ago
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
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:
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
- 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
- Hands-on experience with Microsoft Fabric
- Experience working with ERP or other large enterprise source systems
- 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.
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
