Data Integration Specialist - ETL Development - Snowflake - (Pharma / Life Science Domain)

Cygnus Professionals Inc; Canada; Remote; CAD 80,000 - 100,000; Full time

Job summary

A leading company in the Pharma and Life Science domain is seeking a Mid-Senior Level ETL Developer to design and implement ETL processes using Snowflake. The role focuses on ensuring data accuracy and optimizing ETL performance, with an emphasis on strong analytical and communication skills. This is a long-term contract opportunity based in Canada, ideal for individuals with significant experience in ETL development within the pharma domain.

Qualifications

• 3+ years of experience in ETL development and data integration, preferably in life sciences.
• Hands-on experience with Snowflake and ETL tools.
• Strong problem-solving and analytical skills.

Responsibilities

• Design, develop, and implement ETL processes using Snowflake.
• Collaborate with architects and analysts to gather requirements.
• Perform data cleansing, validation, and quality checks.

Skills

SQL

Data Integration

ETL Development

Analytical Skills

Communication

Education

Bachelor's degree in Computer Science

Advanced degrees (a plus)

Tools

Snowflake

Informatica

Tableau

Power BI

Job description

Data Integration Specialist - ETL Development - Snowflake - (Pharma / Life Science Domain)

1 week ago Be among the first 25 applicants

Direct message the job poster from Cygnus Professionals Inc

Title: ETL Developer - Snowflake (Life Science / Pharma Domain)

Location: India (Remote Role)

Employment Type: Long Term Contract

Role Description

Key Responsibilities:

• Design, develop, and implement ETL processes using Snowflake to extract, transform, and load data from sources such as Rx, call-activity, formulary, and sales databases.
• Collaborate with data architects and business analysts to gather requirements and create ETL workflows aligned with business needs.
• Perform data cleansing, validation, and quality checks to ensure data accuracy and consistency.
• Implement and maintain business rules and calculations within ETL processes for analysis and reporting.
• Create and maintain documentation for ETL processes, data models, and workflows.
• Work closely with downstream process owners to understand data needs and support data consumption.
• Monitor and optimize ETL performance for efficient data processing in Snowflake.

Qualifications

• Bachelor's degree in Computer Science, Information Technology, Data Science, or related field; advanced degrees are a plus.
• 3+ years of experience in ETL development and data integration, preferably in the life sciences industry.
• Hands-on experience with Snowflake and ETL tools (e.g., Informatica).

Technical Skills

• Proficient in SQL and database design.
• Experience with data modeling, metadata, and BI concepts.
• Familiarity with programming languages and dashboards like Tableau, Power BI, and Strategy.

Industry Knowledge

• Understanding of life sciences data domains (Rx, call-activity, formulary, sales) and regulatory requirements is a plus.

Problem-Solving

• Strong analytical skills for troubleshooting and resolving data issues.

Communication

• Excellent written and verbal communication skills; ability to convey technical concepts to non-technical stakeholders.

Seniority level

• Mid-Senior level

Employment type

• Contract

Job function

• Consulting

Industries

• IT Services and IT Consulting