At a Glance
- Tasks: Design and optimise data solutions on our cloud platform using Snowflake.
- Company: Join a forward-thinking tech company focused on data innovation.
- Benefits: Competitive salary, flexible working options, and opportunities for professional growth.
- Other info: Collaborative environment with excellent career advancement potential.
- Why this job: Be at the forefront of data technology and make a real impact.
- Qualifications: Strong SQL and Python skills, with experience in ETL/ELT tools.
The predicted salary is between 60000 - 80000 £ per year.
We are seeking a Snowflake Senior Developer to design, develop, and optimise data solutions on our cloud data platform. You will work closely with data engineers, analysts, and architects to deliver high-quality, scalable data pipelines and models. Strong expertise in Snowflake, ETL/ELT, data modelling, and data warehousing is essential.
Responsibilities
- Snowflake Development: Build and optimise Snowflake objects (databases, schemas, tables, views, tasks, streams, resource monitors).
- ETL/ELT Pipelines: Develop and maintain robust data pipelines using tools like dbt, Airflow, Azure Data Factory, or similar.
- Data Modelling: Implement dimensional models (star/snowflake schemas), handle SCDs, and design efficient structures for analytics.
- Performance Tuning: Optimise queries, manage clustering, caching, and warehouse sizing for cost and speed.
- Data Quality: Implement testing frameworks (dbt tests, Great Expectations) and ensure data accuracy and freshness.
- Security & Governance: Apply RBAC, masking policies, and comply with data governance standards.
- Collaboration: Work with BI teams to ensure semantic alignment and support self-service analytics.
- Documentation: Maintain clear technical documentation for pipelines, models, and processes.
Qualifications
- Matric or GCSE (General Certificate of Secondary Education) and a Degree in IT.
- Strong SQL skills (complex queries, performance tuning) and proficiency in Python for data processing.
- Experience with ETL/ELT tools (dbt, Airflow, ADF, Informatica, Matillion).
- Solid understanding of data warehousing concepts (Kimball, Data Vault, normalization).
- Familiarity with cloud platforms (Azure preferred; AWS/GCP acceptable).
- Knowledge of data governance, security, and compliance (GDPR).
- Excellent problem-solving and communication skills.
Skills
- Experience with Snowpark, UDFs, dynamic tables, and external tables.
- Exposure to streaming/CDC (Kafka, Fivetran, Debezium).
- BI tool integration (Power BI, Tableau, Looker).
Certifications: SnowPro Core or Advanced.
Snowflake Tech Lead employer: Salt Digital Recruitment
As a leading employer in the tech industry, we offer an innovative work environment where collaboration and creativity thrive. Our commitment to employee growth is evident through continuous learning opportunities and access to cutting-edge technologies, particularly in our cloud data platform. Located in a vibrant area, we provide a supportive culture that values diversity and encourages meaningful contributions, making us an excellent choice for those seeking a rewarding career as a Snowflake Tech Lead.
StudySmarter Expert Advice🤫
We think this is how you could land Snowflake Tech Lead
✨Network Like a Pro
Get out there and connect with folks in the industry! Attend meetups, webinars, or even just grab a coffee with someone who’s already in the Snowflake game. You never know when a casual chat could lead to your next big opportunity.
✨Show Off Your Skills
Don’t just tell them what you can do; show them! Create a portfolio of your projects, especially those involving Snowflake and data pipelines. Having tangible examples of your work can really set you apart from the crowd.
✨Ace the Interview
Prepare for those technical interviews by brushing up on your SQL and Python skills. Be ready to discuss your experience with ETL/ELT tools and data modelling. Practice common interview questions and maybe even do some mock interviews with friends!
✨Apply Through Us!
We’ve got your back! Make sure to apply through our website for the best chance at landing that Snowflake Tech Lead role. We’re always on the lookout for talented individuals like you, so don’t miss out!
We think you need these skills to ace Snowflake Tech Lead
Some tips for your application 🫡
Tailor Your CV:Make sure your CV highlights your Snowflake expertise and relevant experience. We want to see how your skills align with the role, so don’t be shy about showcasing your best projects!
Craft a Compelling Cover Letter:Your cover letter is your chance to shine! Use it to explain why you’re passionate about data solutions and how you can contribute to our team. Keep it engaging and personal – we love a good story!
Showcase Your Technical Skills:Don’t forget to mention your SQL prowess and any experience with ETL/ELT tools. We’re looking for someone who can hit the ground running, so highlight those skills that make you a perfect fit for the role.
Apply Through Our Website:We encourage you to apply directly through our website. It’s the easiest way for us to keep track of your application and ensures you don’t miss out on any important updates from our team!
How to prepare for a job interview at Salt Digital Recruitment
✨Know Your Snowflake Inside Out
Make sure you brush up on your Snowflake knowledge before the interview. Be ready to discuss your experience with building and optimising Snowflake objects, as well as your understanding of ETL/ELT processes. Prepare specific examples of how you've tackled challenges in previous projects.
✨Show Off Your Data Modelling Skills
Since data modelling is a key part of the role, be prepared to explain your approach to implementing dimensional models. Bring along examples of star or snowflake schemas you've designed, and be ready to discuss how you handle slowly changing dimensions (SCDs) in your work.
✨Demonstrate Performance Tuning Expertise
Performance tuning is crucial for this position, so come armed with examples of how you've optimised queries and managed warehouse sizing. Discuss any tools or techniques you've used to improve cost and speed, and be ready to answer technical questions on these topics.
✨Highlight Collaboration and Documentation Skills
Collaboration with BI teams is essential, so share experiences where you've worked closely with others to ensure semantic alignment. Also, emphasise your commitment to maintaining clear technical documentation, as this will show your attention to detail and organisational skills.
