About us
Club L London is the next-generation online fashion retailer for the forward-thinking woman. Conceptualised and crafted in-house and abroad, we specialise in accessible luxury and unique designs of unrivalled quality to flatter all figures. From prom to occasion, am to pm, maternity, bridal and more, we deliver an engaging customer experience that connects our global community of diverse consumers, international fashion influencers and content creators with new and exciting collections dropping each week.
Responsibilities
Design, build, and maintain data pipelines from operational systems into BigQuery
Implement and manage ELT workflows using tools such as or custom Python, dbt, and Airflow/Prefect
Develop data models and transformation layers in dbt, including staging, intermediate, and mart layers
Ensure data quality, reliability, and observability with testing, monitoring, and alerting
Collaborate with data analysts to deliver clean, documented datasets for Power BI dashboards
Manage data infrastructure as code, including Git-based version control, CI/CD for dbt, and environment management
Handle schema evolution, incremental data loading, and performance optimization in BigQuery
Advise on data architecture and best practices as the company scales its analytics footprint
Requirements
Strong SQL and Python skills
Experience building pipelines with BigQuery or other cloud warehouses
Familiarity with MongoDB or other NoSQL data sources
Experience using dbt for transformations (incremental models, tests, documentation)
Experience with orchestration tools (Airflow, Prefect, or Dagster)
Familiarity with ELT best practices and data modeling techniques
Strong understanding of Git-based workflows and CI/CD
Comfortable working cross-functionally with analysts and developers
What's on offer?
Bi-annual bonus scheme
25 days of annual leave (plus bank holidays)
1 day a week WFH
Extra day off for your birthday
Flexible working hours around core hours of 10-4
40% staff discount across Club L and Lavish Alice products
A collaborative and mission-driven team culture
Cycle to work scheme
Healthcare Cashplan
Free onsite gym
Enhanced pension contribution
Enhanced maternity and sick pay
Free snacks, drinks \& treats
Social events