At a Glance
- Tasks: Design and maintain data pipelines, ensuring data quality and reliability.
- Company: Join Club L London, a forward-thinking online fashion retailer.
- Benefits: Enjoy flexible working hours, generous leave, and a bi-annual bonus scheme.
- Why this job: Make an impact in a dynamic team while working with cutting-edge data technologies.
- Qualifications: Strong SQL and Python skills, experience with BigQuery and dbt.
- Other info: Collaborative culture with opportunities for personal and professional growth.
The predicted salary is between 36000 - 60000 £ per year.
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
#J-18808-Ljbffr
Data Engineer employer: Club L London
Contact Detail:
Club L London Recruiting Team
StudySmarter Expert Advice 🤫
We think this is how you could land Data Engineer
✨Tip Number 1
Network like a pro! Reach out to current employees at Club L London on LinkedIn. A friendly chat can give you insider info and maybe even a referral, which can really boost your chances.
✨Tip Number 2
Show off your skills in action! If you’ve got a portfolio or GitHub with projects that highlight your SQL and Python prowess, share it during interviews. It’s a great way to demonstrate what you can bring to the table.
✨Tip Number 3
Prepare for those technical interviews! Brush up on your data pipeline knowledge and be ready to discuss how you’d tackle challenges with BigQuery and dbt. Practice makes perfect, so run through some mock interviews with friends.
✨Tip Number 4
Don’t forget to apply through our website! It’s the best way to ensure your application gets seen by the right people. Plus, it shows you’re genuinely interested in joining the Club L London team!
We think you need these skills to ace Data Engineer
Some tips for your application 🫡
Tailor Your CV: Make sure your CV speaks directly to the Data Engineer role. Highlight your SQL and Python skills, and any experience with BigQuery or dbt. We want to see how your background aligns with our needs!
Craft a Compelling Cover Letter: Your cover letter is your chance to shine! Share your passion for data engineering and how you can contribute to our mission at Club L London. Be sure to mention any relevant projects or experiences that showcase your skills.
Showcase Your Projects: If you've worked on any cool data projects, don’t hold back! Include links to your GitHub or any other platforms where we can see your work. We love seeing practical examples of your skills in action.
Apply Through Our Website: We encourage you to apply through our website for a smoother process. It helps us keep track of applications and ensures you get all the updates about your application status. Plus, it’s super easy!
How to prepare for a job interview at Club L London
✨Know Your Data Tools
Make sure you’re well-versed in the tools mentioned in the job description, like BigQuery, dbt, and Airflow. Brush up on your SQL and Python skills, as these will likely come up during technical questions.
✨Showcase Your Projects
Prepare to discuss specific projects where you've designed and built data pipelines or worked with ELT workflows. Be ready to explain your thought process, the challenges you faced, and how you overcame them.
✨Understand the Company’s Vision
Familiarise yourself with Club L London’s mission and values. Think about how your role as a Data Engineer can contribute to their goal of delivering an engaging customer experience and be prepared to share your thoughts on this.
✨Ask Insightful Questions
Prepare some thoughtful questions to ask at the end of your interview. This could include inquiries about their data architecture, team dynamics, or future projects. It shows your genuine interest in the role and the company.