Snowflake Data Engineer

AAVantgarde Bio is seeking a Snowflake Data Engineer to design, implement, and optimize Snowflake solutions for their clinical programs. The role involves managing clinical trial data, including anonymizing patient data and understanding deep data patterns. The engineer will collaborate with data management, biostatistics, analytics, and infrastructure teams to integrate Snowflake seamlessly within their ecosystem, ensuring high availability, reliability, and security.

Must Have

• Design, implement, and maintain Snowflake data warehouses and data lakes using clinical trial data.
• Develop ETL processes to ingest data into Snowflake from various sources.
• Optimize Snowflake performance through query optimization, resource management, and workload tuning.
• Monitor and troubleshoot Snowflake environments to ensure high availability, reliability, and security.
• Strong understanding of data warehousing concepts, ETL processes, and data modeling principles.
• Clinical trial experience.
• Proficiency in SQL and experience with database performance tuning and optimization.
• Experience with cloud platforms such as AWS, Azure, or Google Cloud Platform.

Good to Have

• Snowflake certifications (e.g., SnowPro Core, SnowPro Advanced)

Perks & Benefits

• Health insurance
• Psychotherapy coverage
• Sport coverage
• Learning budget
• Paid vacation days
• Paid sick leaves
• All public holidays are paid days off

GT was founded in 2019 by a former Apple, Nest, and Google executive. GT’s mission is to connect the world’s best talent with product careers offered by high-growth companies in the UK, USA, Canada, Germany, and the Netherlands.

On behalf of AAVantgarde Bio, GT is looking for a Snowflake Data Engineer interested in designing, implementing, and optimizing Snowflake solutions to support the needs of their clinical programs.

About the Client

AAVantgarde is a clinical-stage, international biotechnology company that has developed two proprietary adeno-associated viral (AAV) vector platforms to address the DNA cargo capacity limitations of AAV vectors. They are developing gene therapies for inherited retinal disorders. The founder, Professor Alberto Auricchio, is a highly recognized scientist and a pioneer in the field of gene therapy.

• HQ: Milan, Italy
• Founded: 2021
• Series A startup

About the Role

AAVantgarde team are looking for a data engineer that understands the complexities of managing a clinical trial including the processes and needs to anonymize patient data and to be able to understand deep data patterns around the outcomes of clinical trials

The new member will collaborate closely with their data management, biostatistics, analytics, and infrastructure teams to ensure the seamless integration of Snowflake within their ecosystem.

Responsibilities:

• Design, implement, and maintain Snowflake data warehouses and data lakes using clinical trial data.
• Develop ETL processes to ingest data into Snowflake from various sources.
• Optimize Snowflake performance through query optimization, resource management, and workload tuning.
• Monitor and troubleshoot Snowflake environments to ensure high availability, reliability, and security.
• Work closely with data engineers and data analysts to understand data requirements and design appropriate Snowflake solutions.
• Stay up-to-date with the latest Snowflake features, best practices, and industry trends.
• Provide technical guidance and support to internal teams and clients on Snowflake-related issues.

Essential knowledge, skills & experience:

• Bachelor's degree in Computer Science, Information Technology, or related field.
• Proven experience as a Snowflake Engineer or similar role, with hands-on experience in designing, implementing, and optimizing Snowflake solutions.
• Strong understanding of data warehousing concepts, ETL processes, and data modeling principles.
• Сlinical trial experience
• Proficiency in SQL and experience with database performance tuning and optimization.
• Experience with cloud platforms such as AWS, Azure, or Google Cloud Platform.
• Excellent problem-solving skills and attention to detail.
• Strong communication and collaboration skills, with the ability to work effectively in a team environment.
• Snowflake certifications (e.g., SnowPro Core, SnowPro Advanced) are a plus.

We go beyond usual perks… By working with us, you will get:

• Health insurance
• Psychotherapy coverage
• Sport coverage
• Learning budget
• Paid vacation days & sick leaves
• All public holidays are paid days off.

GT working model:

You will work directly with a client through our Extended Team model. We try to do things differently and put our efforts into integrating you as deeply as possible into the client’s team. You work with the same tools and technologies as they do and are managed directly by the client without any intermediary in between. We help you build relationships and create an environment where you genuinely feel like a member of the client’s team. We also encourage trips to a client and join teambuilding and after-work activities. Our Extended Team model is focused on long-term projects that last over several years.