Posted about 1 month ago

Senior BI Developer - Analytics & Reporting Projects

Competitive Salary

Flexible hours
1-2 days at home per week
Employment type
Full time

You will be a critical part of Product Analytics & Insights team - who are already Looker developers and are partnered with the various clusters across Product - empowering teams across Farfetch to self serve to our powerful insights at scale. This means you’ll have lots of help and support, in a fun working environment, with plenty of high profile exposure & development opportunity.

Job details

Farfetch exists for the love of fashion. We believe in empowering individuality. Our mission is to be the global platform for luxury fashion, connecting creators, curators and consumers.

 

We’re a diverse and global community made up of Farfetchers, our partners and our customers, which we believe is at the heart of our success. Everything we do is centred around our values - Be Human, Think Global, Be Revolutionary, Todos Juntos, Be Brilliant, Amaze Customers - which define our beliefs and our actions. We welcome difference and foster a consciously inclusive environment for everyone. We are Farfetch For All. 

Product

We’re designing impactful products and experiences that fulfil all our customer and partner needs from fashion lovers to the brands, boutiques and start-ups that operate within our platform ecosystem. Our team covers the Farfetch.com website and apps, all our B2B products and in-store experiences. We’re passionate about what we can achieve together, continuously researching, testing, launching and refining new products to push the boundaries of what’s never been done before.

London

Our London office is located in Old Street, London’s tech hub, home to a broad range of teams including Commercial, Marketing, and Product. We have large open plan spaces and a feature staircase connecting our 3 floors, encouraging our collaborative and open culture. We also have a big outdoor terrace where we can have lunch and host social events when the sun comes out!

The Role

Farfetch has made significant investment in a BI tool called Looker.  Its built on top Google’s BigQuery technology, which enables fast, easy and scalable access to our big and powerful data. 

Product Analytics focuses on Farfetch’s biggest, most powerful, most widely used but also our most complex data set - our onsite tracking data from our website and apps.  We’re currently rebuilding this data from source to end user, redefining data at source, our control processes, implementing batch data quality checking, and improving our Core ETL definitions - to make the data accurate, easier to use, and more insightful.

As part of this project, we’ve completely redesigned our analytical ETL, data models and dashboards - and we’ve now got a list of further data models and dashboard developments to maximise the value we drive from our data. Your role will be to manage, develop, ensure performance and data quality and maximise usage and value-add on these data models and dashboards. 

You will be a critical part of Product Analytics & Insights team - who are already Looker developers and are partnered with the various clusters across Product - empowering teams across Farfetch to self serve to our powerful insights at scale. This means you’ll have lots of help and support, in a fun working environment, with plenty of high profile exposure & development opportunity.

What you'll do:

  • Based on requirements from our Analysts, and your expert solution design - develop our analytical ETL in Big Query to ensure a single version of the truth, and efficient access to business-useful data. 
  • Form a strong relationship with the Data Engineering team ensuring our data runs on time and accurately, has a great roadmap, and infrastructure is optimal for business use of Looker
  • Strong understanding of BigQuery slot usage and performance optimisation
  • Develop accurate and complex to a. provide valuable insight of customer behaviour over time, and b. optimise query performance (for both the ETL, but also for analysis and Looker dashboards on-demand with high concurrency)
  • Roll up in-page actions to view & visit level
  • Join to other existing data models such as item level conversion, post purchase data and customer segments
  • Add new dimensions & measures to our data model, to meet business requirements and make dashboards & self-service easy
  • Governance around naming conventions, approach & process, and generally making Product Looker an awesome scaleable, insightful and efficient solution
  • Run agile planning and value-based prioritisation of our backlog and roadmap
  • Develop and own our published dashboards, ensuring business users can easily self serve and then drill down from a single version of the truth. Examples include; Design efficient ways to add calculations such as year-on-year, rolling averages and confidence intervals. Install custom visualizations packages, and develop visualisations as Looker improve their product. Develop dashboard templates maximising use of parameters, and standard approach to filters, colour palettes etc. Based on requirements drafted by business users & analytics, create dashboards for key business areas to monitor their performance and understand user behaviour, such as personalisation, inspiration and our apps
  • Provide 1st line support to the Product org if something is broken, and run fortnightly best practice sessions with super users, other BI Developers and Analysts to drive actionable insight, and proactively identify tips and best practice we can share and all develop together

Who you are:

  • A professional with extensive experience developing data models and dashboards in a number of BI tools eg: Tableau, Qlikview, Business Objects, PowerBI, Excel etc.  Experience of Looker would be an advantage but is not necessary
  • A graduate of a Bachelor of Science program or a higher level post-secondary educational program in Computer Science, Math, Engineering, Operation Research, or quantitative disciplines
  • Expert in using SQL and BI tools to deliver insight on very large or complex datasets
  • Strong understanding of how to write performant and best practice code on large data sets in BigQuery
  • Expert in defining checks and setting alerts to ensure data is delivered on time and accurately
  • Dimensional modeling in relational/columnar databases, and expertise in NoSQL modeling is a big plusYou are detail-oriented with a demonstrably high standard for data accuracy and documentation
  • A strong communicator with presentation skills, both verbal and written
  • An excellent strategic thinker and with analytical skills, ideally developed in a commercial role preferably within an Internet or retail/consumer products business and/or management consulting
  • Strong professional work ethic - following up on actions, pushing projects forwards, and collaborating to deliver as a single effective team
  • Experienced in leveraging data and analytics to solve real-world problems and create new solutions
  • An individual that can change directions quickly to respond to new information and changing circumstances
  • Able to break work down to deliver in an agile fashion towards these holistic solutions, delivering value and iterating quickly
  • ‘Can do’ mindset, offering solutions rather than problems

Are you interested?

Want to get in touch? Contact us


About the company

F
Farfetch

Shop the World

211 Old Street
London
London
UK
EC1V 9NR

https://www.farfetch.com/uk