Senior BI Analyst FTC

Job Description

FARFETCH exists for the love of fashion. Our mission is to be the global platform for luxury fashion, connecting creators, curators and consumers.

We're a positive platform for good, bringing together an incredible creative community made up by our people, our partners and our customers. This community is at the heart of our business success. We welcome differences, empower individuality and celebrate diverse skills and perspectives, creating an inclusive environment for everyone. We are FARFETCH for All.

DATA

We're a Data team that does it all: big data engineering, machine learning, and deep-dive analytics and insight. We're a diverse, global team who create Data solutions to provide an unrivalled customer experience. Whether it's churning gigabytes of ecommerce data, using AI to recommend the latest trends, or understanding our customers better than anyone else, we use data to promote FARFETCH's growth.

LONDON

Our office is located in Old Street, London's tech hub. Our open-plan space is ideal for collaborative working. When you're not doing what's never been done, you can enjoy a team lunch on our large outdoor terrace, or join a yoga class in our dedicated studio.

THE ROLE

The Reporting Solutions team is part of a vision to build a centralised Hub responsible for setting the standards for BI across Farfetch. You will actively work with diverse stakeholders like Marketing, Product and Commercial in order to define and implement best-practice reporting that will allow Farfetch to continue growing rapidly. This is the ultimate role for the detail-orientated analyst who enjoys manipulating vast amounts of data and loves the challenge of creating highly automated solutions for reporting data and insight! You have the ambition to make our reporting solutions best in class. You will be a person that thrives in solving complex problems in a fast paced environment, balancing tactical needs whilst strategically driving long term solution. You will work collaboratively as a team and with our business colleagues, both in London and across our other locations, to shape the technical direction of a critical part of Farfetch. Your opportunities to develop range from working directly with data engineers to grow technically, as well as working alongside Marketing and Finance to grow commercially.

WHAT YOU'LL DO

• You will have ownership of our BI reporting tool, Looker, currently being used by over 1500 users in the past 30 days - including defining its policies and best practices across Farfetch
• You will design and deliver best-in-class data products and reporting by building and evolving our a reporting infrastructure in Looker, DBT and BigQuery
• You will build a business case for new data sources/tools if necessary
• You will ensure a high level of data quality for core data sources and critical KPIs
• You will build robust solutions with checks and alerting across the data pipeline
• You will continuously optimise the performance of our ETLs and refactor SQL code for faster processing to ensure that dashboards are updated on a regular cadence
• You will embrace agile ways of working as part of a collaborative team environment
• You will work cross-functionally with other data disciplines on strategic initiatives
• You will lead on innovation and nextgen thinking for BI in Farfetch and the industry

WHO YOU ARE

• Essential
• You are advanced in SQL
• You are detail-oriented with a demonstrably high standard for data accuracy and documentation
• You are an expert in manipulating large data sets in a professional environment
• You are a strong communicator regardless of format (email, documentation, presentation, discussion)
• You are able to collaborate with both commercial and technical stakeholders (technical product managers, development leads)
• You have advanced developer experience with Looker
• You feel comfortable setting the visualisation standards for reporting and dashboarding in companies
• You are commercial with the ability to translate business needs to execute technically
• You have a product oriented mindset with a key focus on best practices and scalability
• Desirable
• You have a BS in computer science, engineering, information systems or other highly quantitative field
• Experience with BigQuery
• Experience rolling out Looker in large organisations, including training teams on how to use it
• You have working knowledge of Python
• Experience defining data governance principles surrounding sensitive datasets containing personal data
• Extensive experience with structuring and writing scalable ETLs utilising tools such as DBT and Airflow
• Experience with Linux/OSX command line and Git
• Experience developing enterprise dimensional model across the organisation
• Experience abiding by Data Governance best practices, including how to properly structure and document your code for easy re-use across teams

REWARDS & BENEFITS

• FARFETCH Equity plan and annual discretionary bonus
• Flexible benefits - Private Medical Insurance, Dental Insurance, Gym Memberships, Pension scheme and more
• Critical Illness Insurance and Life Assurance
• Access to Unmind: an independent and completely confidential digital mental health platform
• Flexible working environment and more!

EQUAL OPPORTUNITIES STATEMENT

• FARFETCH is an equal opportunities employer ensuring that all applicants are treated equally and fairly throughout our recruitment process. We are determined that no applicant experiences discrimination on the basis of sex, race, ethnicity, religion or belief, disability, age, gender identity, ancestry, sexual orientation, veteran status, marriage and civil partnership, pregnancy and maternity, or any other basis prohibited by applicable law. We continue to build our consciously inclusive culture as part of our Positively FARFETCH strategy throughout our business, partnerships and communities.

This is the ultimate role for the detail-orientated analyst who enjoys manipulating vast amounts of data and loves the challenge of creating highly automated solutions for reporting data and insight! You have the ambition to make our reporting solutions best in class.