Snowflake Engineer | AAVantgarde Bio

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

On behalf ofAAVantgarde Bio GT is looking for Snowflake Data Engineerinterested in designing implementing and optimizing Snowflake solutionsto 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 processesto 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:

• Bachelors degree in Computer Science Information Technology or related field.

• Proven experience as a Snowflake Engineer or similar role withhands-on experience in designing implementing and optimizing Snowflake solutions.

• Strong understanding ofdata warehousing concepts ETL processes and data modeling principles.

• Сlinical trial experience

• Proficiency in SQLand experience with database performance tuning and optimization.

• Experience with cloud platforms such asAWS 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 clients 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 clients 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.

Required Experience:

IC