Snowflake Data Engineer

We seek professionals who combine strong Pharma/Lifesciences domain expertise with an AI-ready mindset, leveraging AI, GenAI, Data, and Digital Technologies to transform business processes, accelerate outcomes, and unlock new opportunities for innovation.

Role overview:

We are seeking a skilled Snowflake Data Engineer with a strong background in designing and implementing scalable data solutions. The ideal candidate will have experience working with Snowflake as a cloud data platform and a solid understanding of data modelling, ETL processes, and performance optimization.

Responsibilities:

1. Snowflake Development:

• Design and implement data pipelines and workflows on Snowflake.
• Develop and optimize Snowflake databases, schemas, and tables.
• Manage Snowflake features like virtual warehouses, shared data, and materialized views.

2. Data Integration:

• Build and maintain ETL/ELT pipelines using tools like Talend, Informatica, Matillion, or equivalent.
• Integrate data from various sources such as APIs, databases, and flat files.

3. Performance Optimization:

• Monitor and optimize query performance in Snowflake.
• Implement partitioning, clustering, and caching strategies to enhance performance.

4. Data Modeling:

• Design logical and physical data models based on business requirements.
• Ensure data accuracy, consistency, and security across pipelines.

5. Collaboration:

• Work closely with data analysts, business stakeholders, and other engineers to deliver data solutions.
• Document processes, workflows, and architecture.

Required Skills:

1. Technical Proficiency:

• 4+ years of experience in data engineering with at least 2 years working on Snowflake.
• Strong experience with SQL for querying and scripting.
• Knowledge of data warehousing concepts and methodologies.

2. Cloud Expertise:

• Familiarity with cloud platforms such as AWS, Azure, or GCP.
• Hands-on experience with Snowflake utilities like SnowSQL and SnowPipe.

3. ETL/ELT Tools:

• Experience with ETL tools like Matillion, Talend, or Informatica.
• Scripting experience in Python, Java, or Scala for custom ETL pipelines.

4. Other Tools:

• Proficiency with tools like DBT (Data Build Tool) is a plus.
• Experience with CI/CD pipelines for deploying data solutions.

5. Soft Skills:

• Strong problem-solving and analytical abilities.
• Excellent communication and teamwork skills.

Preferred Qualifications:

• SnowPro Certification or equivalent credentials.
• Experience in Agile/Scrum development methodologies.
• Knowledge of data governance and compliance standards (e.g., GDPR, HIPAA)