At a Glance
- Tasks: Build and maintain dbt models to transform raw data into high-quality datasets.
- Company: Join a dynamic EdTech unicorn with a focus on engineering excellence.
- Benefits: Enjoy 32+ days of annual leave and a hybrid work model.
- Other info: Great opportunity for career growth in a collaborative team.
- Why this job: Make an impact in a high-growth environment while working with cutting-edge data technologies.
- Qualifications: 2+ years of SQL experience and expertise in data warehouse design.
The predicted salary is between 50000 - 60000 £ per year.
Jack & Jill is seeking an Analytics Engineer to build and maintain dbt models that power analytics across the business. You will be responsible for transforming raw data into high-quality datasets on Snowflake, ensuring accessibility and trust.
The ideal candidate has 2+ years of SQL experience and deep expertise in data warehouse design. Joining a dynamic EdTech unicorn, you will work in a high-growth environment that values engineering excellence, with 32+ days of annual leave and a hybrid work model.
Analytics Engineer - Snowflake, dbt & AI-Ready Data employer: Jack & Jill
Jack & Jill is an exceptional employer that fosters a culture of innovation and collaboration, making it an ideal place for an Analytics Engineer to thrive. With a commitment to employee growth, you will benefit from extensive professional development opportunities, generous annual leave, and a flexible hybrid work model that promotes work-life balance. Join a forward-thinking EdTech unicorn where your contributions directly impact the future of education technology.
StudySmarter Expert Advice🤫
We think this is how you could land Analytics Engineer - Snowflake, dbt & AI-Ready Data
✨Tip Number 1
Network like a pro! Reach out to current employees at Jack & Jill on LinkedIn. A friendly chat can give us insider info and might just get your foot in the door.
✨Tip Number 2
Show off your skills! Prepare a mini-project or case study that highlights your SQL expertise and dbt modelling. This will demonstrate your hands-on experience and passion for data engineering.
✨Tip Number 3
Ace the interview by practising common questions related to data warehousing and analytics. We can help you with mock interviews to boost your confidence and refine your answers.
✨Tip Number 4
Don’t forget to apply through our website! It’s the best way to ensure your application gets noticed. Plus, we love seeing candidates who take the initiative!
We think you need these skills to ace Analytics Engineer - Snowflake, dbt & AI-Ready Data
Some tips for your application 🫡
Show Off Your SQL Skills:Make sure to highlight your 2+ years of SQL experience in your application. We want to see how you've used SQL to transform data and create high-quality datasets, so don’t hold back on the details!
Talk About Your Data Warehouse Design Experience:If you've got expertise in data warehouse design, let us know! Share specific examples of projects you've worked on that demonstrate your ability to build and maintain robust data models.
Be Authentic and Personal:We love getting to know the real you! Don’t just stick to the formalities; add a personal touch to your application. Share why you're excited about joining our dynamic EdTech unicorn and how you can contribute to our mission.
Apply Through Our Website:To make sure your application gets the attention it deserves, apply directly through our website. It’s the best way for us to keep track of your application and get back to you quickly!
How to prepare for a job interview at Jack & Jill
✨Know Your SQL Inside Out
Make sure you brush up on your SQL skills before the interview. Be prepared to discuss your experience with SQL in detail, including specific projects where you've transformed raw data into high-quality datasets. Practising common SQL queries and being ready to solve problems on the spot can really impress the interviewers.
✨Familiarise Yourself with dbt and Snowflake
Since the role focuses on dbt models and Snowflake, it’s crucial to understand how these tools work together. Dive into some tutorials or documentation to get a solid grasp of their functionalities. Being able to discuss how you've used these technologies in past projects will show that you're not just familiar but also experienced.
✨Showcase Your Data Warehouse Design Skills
Prepare to talk about your experience with data warehouse design. Think of examples where you’ve implemented best practices or solved complex data challenges. This is your chance to demonstrate your engineering excellence and how you can contribute to the team’s success.
✨Emphasise Adaptability and Growth Mindset
In a high-growth environment like Jack & Jill, adaptability is key. Be ready to share examples of how you've embraced change or learned new skills quickly in previous roles. Highlighting your willingness to grow and adapt will resonate well with the company’s values.
