Find a job 
Featured Companies 
Featured Universities 
For Companies At a Glance
- Tasks: Design and optimise scalable data pipelines using Snowflake and cloud technologies.
- Company: Join a leading science and technology company in the pharmaceutical industry.
- Benefits: Competitive salary, flexible working options, and opportunities for professional growth.
- Why this job: Be at the forefront of data innovation and AI solutions in a dynamic environment.
- Qualifications: 2+ years experience with Snowflake, SQL, and ETL tools; strong data governance knowledge.
- Other info: Exciting projects with potential for career advancement and skill development.
The predicted salary is between 36000 - 60000 £ per year.
Project description Overview The project is for one of the world's famous science and technology companies in the pharmaceutical industry, supporting initiatives in AWS, AI and data engineering, with plans to launch over 20 additional initiatives in the future. Modernizing the data infrastructure through the transition to Snowflake as a priority, as it will enhance capabilities for implementing advanced AI solutions and unlock numerous opportunities for innovation and growth.
We are seeking a highly skilled Snowflake Data Engineer to design, build, and optimize scalable data pipelines and cloud-based solutions across AWS, Azure, and GCP. The ideal candidate will have strong expertise in Snowflake, ETL Tools like DBT, Python, visualization tools like Tableau and modern CI/CD practices, with a deep understanding of data governance, security, and role-based access control (RBAC). Knowledge of data modeling methodologies (OLTP, OLAP, Data Vault 2.0), data quality frameworks, Streamlit application development and SAP integration and infrastructure-as-code with Terraform is essential. Experience working with different file formats such as JSON, Parquet, CSV, and XML is highly valued.
Responsibilities
- In-depth knowledge of Snowflake's data warehousing capabilities.
- Understanding of Snowflake's virtual warehouse architecture and how to optimize performance and cost.
- Proficiency in using Snowflake's data sharing and integration features for seamless collaboration.
- Develop and optimize complex SQL scripts, stored procedures, and data transformations.
- Work closely with data analysts, architects, and business teams to understand requirements and deliver reliable data solutions.
- Implement and maintain data models, dimensional modeling for data warehousing, data marts, and star/snowflake schemas to support reporting and analytics.
- Integrate data from various sources including APIs, flat files, relational databases, and cloud services.
- Ensure data quality, data governance, and compliance standards are met.
- Monitor and troubleshoot performance issues, errors, and pipeline failures in Snowflake and associated tools.
- Participate in code reviews, testing, and deployment of data solutions in development and production environments.
Must have
- 2+ years of experience.
- Strong proficiency in Snowflake (Snowpipe, RBAC, performance tuning).
- Ability to write complex SQL queries, stored procedures, and user-defined functions.
- Skills in optimizing SQL queries for performance and efficiency.
- Experience with ETL/ELT tools and techniques, including Snowpipe, AWS Glue, openflow, fivetran or similar tools for real-time and periodic data processing.
- Proficiency in transforming data within Snowflake using SQL, with Python being a plus.
- Strong understanding of data security, compliance and governance.
- Experience with DBT for database object modeling and provisioning.
- Experience in version control tools, particularly Azure DevOps.
- Good documentation and coaching practice.
Nice to have
- Cloud certifications is a plus.
Junior Snowflake Data Engineer employer: Luxoft
Contact Detail:
Luxoft Recruiting Team
StudySmarter Expert Advice 🤫
We think this is how you could land Junior Snowflake Data Engineer
✨Network Like a Pro
Get out there and connect with people in the industry! Attend meetups, webinars, or even just grab a coffee with someone who works in data engineering. Building relationships can lead to job opportunities that aren’t even advertised.
✨Show Off Your Skills
Create a portfolio showcasing your projects, especially those involving Snowflake and data pipelines. Use platforms like GitHub to share your code and demonstrate your expertise. This gives potential employers a clear view of what you can do!
✨Ace the Interview
Prepare for technical interviews by brushing up on SQL queries and Snowflake features. Practice common interview questions and be ready to discuss your past projects. Confidence and clarity can really set you apart from other candidates.
✨Apply Through Our Website
Don’t forget to check out our website for job openings! Applying directly through us not only shows your interest but also helps you stand out. Plus, we love seeing candidates who are proactive about their job search!
We think you need these skills to ace Junior Snowflake Data Engineer
Some tips for your application 🫡
Tailor Your CV: Make sure your CV is tailored to the Junior Snowflake Data Engineer role. Highlight your experience with Snowflake, SQL, and any relevant ETL tools. We want to see how your skills match what we're looking for!
Craft a Compelling Cover Letter: Your cover letter is your chance to shine! Use it to explain why you're passionate about data engineering and how you can contribute to our projects. Keep it concise but impactful – we love a good story!
Showcase Your Projects: If you've worked on any cool data projects, make sure to mention them! Whether it's a personal project or something from a previous job, we want to see your hands-on experience with data pipelines and cloud solutions.
Apply Through Our Website: Don't forget to apply through our website! It’s the best way for us to receive your application and ensures you’re considered for the role. Plus, it’s super easy – just follow the prompts!
How to prepare for a job interview at Luxoft
✨Know Your Snowflake Inside Out
Make sure you brush up on your Snowflake knowledge before the interview. Understand its architecture, data sharing features, and how to optimise performance and costs. Being able to discuss specific examples of how you've used Snowflake in past projects will really impress the interviewers.
✨Show Off Your SQL Skills
Prepare to demonstrate your SQL prowess during the interview. Be ready to write complex queries on the spot or explain how you've optimised SQL scripts in previous roles. Practising common SQL problems can help you feel more confident when it comes to showcasing your skills.
✨Familiarise Yourself with ETL Tools
Since experience with ETL tools like DBT and AWS Glue is crucial, make sure you can talk about your hands-on experience with these technologies. If you’ve worked with real-time data processing or have examples of successful data transformations, be sure to highlight those!
✨Understand Data Governance and Security
Data governance and security are key aspects of this role. Brush up on your knowledge of compliance standards and role-based access control (RBAC). Being able to discuss how you've ensured data quality and security in your previous work will show that you take these responsibilities seriously.
