[CO983] Cloud Data Engineer - Snowflake

Indegene; España; Presencial; EUR 50.000 - 70.000; Jornada completa

Descripción de la vacante

A leading global consultancy in healthcare is seeking an experienced Snowflake engineer. The role involves designing and optimizing high-performance ETL/ELT pipelines and ensuring data quality. Candidates must possess in-depth Snowflake knowledge, with skills in SQL and data integration. The company promotes Inclusion and Diversity, ensuring equal opportunities for all applicants.

Formación

• In-depth knowledge of Snowflake’s data warehousing capabilities.
• Understanding of Snowflake’s virtual warehouse architecture.
• Experience with dbt for database object modeling.

Responsabilidades

• Monitor and troubleshoot performance issues in Snowflake.
• Design and build high-performance ETL/ELT pipelines.
• Ensure data quality and governance standards are met.

Conocimientos

Proficiency in using Snowflake's data sharing features

Experience with data modeling techniques

Ability to design and maintain ETL/ELT pipelines

Skill in developing complex SQL scripts

Ability to work with data analysis teams

Experience ensuring data quality and governance

Capability to integrate data from various sources

Monitoring and troubleshooting performance issues

Experience with ETL/ELT tools

Proficiency in transforming data using SQL

Herramientas

DBT

Azure DevOps

AWS Glue

Descripción del empleo

Who are we? Indegene is a global consultancy at the forefront of driving innovation in the Pharmaceutical and Life Sciences industry, through combining medical and commercial expertise with innovative digital and AI technologies. We enable global healthcare organizations to address complex challenges and drive better health and business outcomes by seamlessly integrating analytics, technology, operations, and medical expertise. Find out more at indegene.com.

Who are you?

We are looking for experienced Snowflake engineers with in-depth knowledge of Snowflake’s data warehousing capabilities. The ideal candidate should have an understanding of Snowflake’s virtual warehouse architecture and how to optimize performance and cost.

1. Proficiency in using Snowflake’s data sharing and integration features for seamless collaboration.
2. Experience in implementing data modeling techniques, including OLTP, OLAP, and Data Vault 2.0 methodologies.
3. Ability to design, build, and maintain scalable and high-performance ETL/ELT pipelines using Snowflake on cloud platforms (AWS).
4. Skill in developing and optimizing complex SQL scripts, stored procedures, and data transformations.
5. Ability to work closely with data analysts, architects, and business teams to understand requirements and deliver reliable data solutions.
6. Experience in implementing and maintaining data models, dimensional modeling for data warehousing, data marts, and star/snowflake schemas to support reporting and analytics.
7. Capability to integrate data from various sources including APIs, flat files, relational databases, and cloud services.
8. Ensuring data quality, data governance, and compliance standards are met.
9. Monitoring and troubleshooting performance issues, errors, and pipeline failures in Snowflake and associated tools.
10. Participating in code reviews, testing, and deployment of data solutions in development and production environments.

Required knowledge:

• 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, Informatica cloud 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 with version control tools, particularly Azure DevOps.
• Good documentation and coaching practices.

Equal Opportunity

Indegene is proud to be an Equal Employment Employer and is committed to the culture of Inclusion and Diversity. We do not discriminate on the basis of race, religion, sex, colour, age, national origin, pregnancy, sexual orientation, physical ability, or any other characteristics. All employment decisions, from hiring to separation, will be based on business requirements, the candidate’s merit and qualification. We are an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, colour, religion, sex, national origin, gender identity, sexual orientation, disability status, protected veteran status, or any other characteristics.