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.
- Other info: Exciting projects with potential for career advancement and skill development.
- 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.
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
Join a leading science and technology company in the pharmaceutical industry, where innovation meets opportunity. As a Junior Snowflake Data Engineer, you'll thrive in a collaborative work culture that prioritises employee growth and development, offering access to cutting-edge technologies and projects. With a commitment to modernising data infrastructure and a focus on AWS, AI, and data engineering, this role provides a unique chance to contribute to impactful initiatives while enjoying a supportive environment that values your contributions.
StudySmarter Expert Advice🤫
We think this is how you could land Junior Snowflake Data Engineer
✨Unlock Networking Opportunities
Dive into industry-specific events like pharmaceutical conferences and seminars, where you can meet hiring managers from companies like Luxoft. These are goldmines for making connections and learning about job openings before they hit the mainstream job boards.
✨Join Relevant Professional Bodies
Get involved with organisations such as the Royal Pharmaceutical Society or your local pharmaceutical professionals' network. Being an active member can boost your credibility and may even lead to job referrals in top organisations like Luxoft.
✨Leverage Internships for Full-time Roles
If you can, consider pursuing internships in the pharmaceutical industry, especially with companies like Luxoft. These opportunities often pave the way for full-time positions and allow you to demonstrate your capabilities firsthand.
✨Tailor Your Approach
When you're applying for roles, don't rush it! Take the time to customise your applications for specific positions, showcasing relevant skills and experiences that align with what Luxoft is looking for. A tailored application can really make you stand out!
We think you need these skills to ace Junior Snowflake Data Engineer
Some tips for your application 🫡
Showcase Your Relevant Experience:When applying for a role in the pharmaceutical industry, it's crucial to highlight any relevant experience you have. Whether that's internships, lab work, or even related coursework, make sure to weave this into your CV and cover letter. We want to see how your background aligns with the role you're applying for at Luxoft!
Emphasise Your Understanding of Regulations:The pharmaceutical industry is heavily regulated, so it's important to indicate your familiarity with industry standards and regulations. In your cover letter, mention any training or certifications you've received that are relevant, or discuss projects where you’ve navigated compliance. This will show Luxoft that you're not just a fit for the job but also a safety-conscious candidate!
Tailor Your CV to Be Result-Driven:Craft your CV to highlight quantifiable achievements, especially if you have previous roles in pharmaceuticals or related fields. Use metrics to demonstrate your impact, such as improved processing times or successful project completions while working on trials. This analytical approach will resonate well with hiring managers at Luxoft!
Convey Your Passion for the Industry:In your cover letter, express why you are passionate about working in the pharmaceutical sector. Whether it’s your desire to contribute to groundbreaking drug research or improve patient outcomes, let it shine through! At Luxoft, we value candidates who are truly enthusiastic about their work—you might just stand out from the crowd.
How to prepare for a job interview at Luxoft
✨Understand the Science
Make sure you brush up on key pharmaceutical concepts and recent developments in the industry. You might get asked some technical questions during the interview at Luxoft that show your grasp of drug development processes or regulatory requirements, so be ready to discuss them clearly.
✨Showcase Relevant Experience
If you have any hands-on experience or internships in a laboratory setting, be sure to highlight these in your responses. Think about the projects you worked on, the methodologies you used, and the impact you made. It's all about telling a story that connects your background to the role you're applying for.
✨Know Their Products
Take some time to familiarise yourself with Luxoft’s product range and recent breakthroughs. Understanding their portfolio not only shows your enthusiasm for the role but also allows you to ask insightful questions that demonstrate your interest in actively contributing to their projects.
✨Be Ready for Regulatory Scenarios
In a full-time pharmaceutical role, understanding the regulatory landscape is crucial. Prepare for situational questions that may test your problem-solving skills concerning compliance and safety standards. You could be asked how you'd handle a hypothetical issue regarding a drug’s market release, so think through your approach.
