Senior Analytics Engineer
This job is brought to you by Jobs/Redefined, the UK's leading over-50s age inclusive jobs board.
About Fresha
Fresha is the leading marketplace platform for beauty & wellness trusted by millions of consumers and businesses worldwide.
Fresha is used by 110,000+ businesses and 450,000+ stylists and professionals worldwide, processing over 1 billion appointments to date.
The company is headquartered in London, United Kingdom, with 12 global offices located across North America, EMEA and APAC.
Fresha allows consumers to discover, book and pay for beauty and wellness appointments with local businesses via its marketplace, while beauty and wellness businesses and professionals use an all-in-one platform to manage their entire operations with an intuitive subscription-free business software and financial technology solutions.
Fresha's ecosystem gives merchants everything they need to run their business seamlessly by facilitating appointment bookings, point-of-sale, customer records management, marketing automation, loyalty, beauty products inventory and team management.
The consumer marketplace unlocks revenue potential for partner businesses by leveraging the power of online bookings and automated marketing through mobile apps and advanced integrations with major tech brands including Instagram, Facebook and Google.
Role overview
Given our exciting and progressive growth plans, we are looking for an exceptional Senior Analytics Engineer to come and join our global business.
Reporting to the VP Analytics, and working collaboratively with Product Managers, Engineers, Analysts and Commercial leadership, you will be accountable for modeling data to provide clean, accurate datasets to empower internal and external stakeholders with reliable data. This entails transforming, testing, and validating data from a wide variety of sources to create a comprehensive view of Fresha.
This is a great opportunity for someone looking to work in a fast-paced and changing environment, who likes to work autonomously, enjoys a challenge and wants to make an impact.
What you will be doing:
- Develop, test, and maintain robust dimensional data models from diverse data sources, including first-party data, data from third-party APIs, SFTPs, and other external data sources
- Enhance the efficiency and performance of data models, focusing on improving ease of use, increasing accessibility of data, reducing runtimes, and eliminating waste
- Establish and maintain ELT pipelines for our Snowflake Data Warehouse, adhering to the best practices in data integration, management, and governance
- Advise product development on analytical requirements with new feature releases, and ensure data warehouse incorporates development changes from new feature releases effectively
- Coach other engineers and analysts to get the most from our data models and build dependencies in the optimal way
- Use your knowledge of Fresha's product and data models to analyse the performance of features and support product operations - through analytical queries and dashboards
- Develop comprehensive data documentation to maintain consistency in understanding and communication across the team.
This list is not exhaustive and there may be other activities you are required to deliver.
>
Skills, experience & qualifications required:
- Excellent knowledge of SQL and a firm understanding of data modeling concepts
- Deep familiarity with mature dbt projects across the full lifecycle of development and deployment
- Understanding of data warehousing systems, cost drivers, configurations, security and best practices
- Exposure to or familiarity with streaming and batch data ingestion systems
- Demonstrable experience in improving the performance, efficiency and usability of data models
- Experience translating business requirements from non-technical data users and downstream analytical teams into data pipelines
- Enjoyment in collaborating broadly with a range of different people and abilities, including coaching more junior engineers in their practices
- A desire to contribute to product development decisions through data architecture best practices and analytical insights
- Creative thinking and problem-solving abilities, with a proactive and autonomous approach to work
Bonus points:
- Familiarity with the following systems: Fivetran, Airflow, Snowflake, dbt and Periscope Data
- Experience in writing ELT pipelines with SQL and Python
- Experience working in fast-paced companies
- Screen call - Video-call with a member from the Talent Team - 30m
- 1st Stage - Video-call with Hiring Manager - 45m
- 2nd Stage - Video-call with Hiring Team - 45-60m
- Presentation - In-person with Hiring Team - 60-90m
We aim to finalise the entire interview process and deliver feedback within 3 weeks.
Every job application received is reviewed manually by our talent team. While we strive to assess applications within 7 days, the sheer volume of talented individuals expressing interest may occasionally extend this timeframe.
>
Inclusive workforce
At Fresha, we are creating a culture where individuals of all backgrounds feel comfortable.
We want all Fresha people to feel included and truly empowered to contribute fully to our vision and goals. Everyone who applies will receive fair consideration for employment.
We do not discriminate based on race, colour, religion, sex, sexual orientation, age, marital status, gender identity, national origin, disability, or any other applicable legally protected characteristics in the location in which the candidate is applying.
If you have any accessibility requirements that would make you more comfortable during the interview process and/or once you join, please let us know so that we can support you.