Snowflake Data Engineer

ZS; Toronto; Hybrid; CAD 80,000 - 120,000; Full time

Job summary

A leading management consulting and technology firm is seeking a Snowflake Data Engineer in Toronto. In this role, you will design and implement data solutions, partner with stakeholders, and contribute to the development of data solutions in the healthcare sector, focusing on optimizing performance and ensuring compliance with regulatory standards.

Benefits

Flexible work options

Health and well-being benefits

Professional development opportunities

Collaborative culture

Qualifications

• 2-5 years of data engineering experience.
• Hands-on experience with Snowflake cloud data warehouse.
• Advanced SQL, Matillion, and DBT programming skills.

Responsibilities

• Design and implement solutions in Snowflake and Matillion.
• Ensure a clear understanding of business and technical needs.
• Participate in regular implementation reviews to ensure quality.

Skills

ETL

Data Modeling

Data Warehouse Design

SQL

Python

Agile Methodology

Data Analysis

Education

Bachelor's degree in Computer Science or related field

Tools

Snowflake

Matillion

DBT

Job description

ZS is a place where passion changes lives. As a management consulting and technology firm focused on transforming global healthcare and beyond, our most valuable asset is our people. Here you’ll work side-by-side with a powerful collective of thinkers and experts shaping solutions from start to finish. At ZS, we believe that making an impact demands a different approach; and that’s why here your ideas elevate actions, and here you’ll have the freedom to define your own path and pursue cutting-edge work. We partner collaboratively with our clients to develop products that create value and deliver company results across critical areas of their business including portfolio strategy, customer insights, research and development, operational and technology transformation, marketing strategy and many more. If you dare to think differently, join us, and find a path where your passion can change lives.

Our most valuable asset is our people.

At ZS we honor the visible and invisible elements of our identities, personal experiences and belief systems—the ones that comprise us as individuals, shape who we are and make us unique. We believe your personal interests, identities, and desire to learn are part of your success here. Learn about our diversity, equity, and inclusion efforts and the networks ZS supports to assist our ZSers in cultivating community spaces, obtaining the resources they need to thrive, and sharing the messages they are passionate about.

Role : Snowflake Data Engineer

What You’ll Do?

1. Partner closely with leads (development / product owner / stakeholders / etc.) to ensure a clear understanding of business and technical needs; assisting in selecting the best strategy and translating them into effective data solutions daily during US hours.
2. Design and implement solutions in Snowflake / Matillion / DBT using industry-leading best practices for life sciences data while ensuring optimal performance, efficient operations, security, and compliance with regulatory standards.
3. Work closely with the leads to develop and maintain a right-sized data catalog and data lineage for commercial and medical affairs applications.
4. Identify, test prototypes, and proof of concepts. Support testing teams with identifying the optimal test strategy.
5. Review designs to ensure consistency with architectural best practices; participate in regular implementation reviews to ensure quality and standards adherence.
6. Work in an agile team to implement data quality checks, setup process orchestrations, mitigate vulnerabilities, devise testing strategies, and automate repeatable tasks along with participating and assisting in root cause analysis activities.
7. Ensure technical standards and architectural best practices are consistently followed. Govern complete architecture and implementation of the project module.

What You’ll Bring?

1. 2-5 years of data engineering experience with proven track record in ETL, data modeling, data warehouse design, development, and ingesting data from diverse data sources (databases or APIs) using Matillion and Snowflake technologies.
2. Hands-on experience developing and optimizing within the Snowflake cloud data warehouse environment. Snowpro certification is a plus.
3. Advanced SQL / Matillion / DBT programming skills with the ability to perform ELT optimization for performance. Knowledge / experience with cloud technologies (Lambda, S3, AWS policies, etc.) and Python programming.
4. Ability to handle end-to-end Matillion / Snowflake ETL process integrations, customization, and deployment of solutions that serve as the source of truth for reports, dashboards, and data visualizations.
5. Experience in defining and implementing quality standards for ELT, SQL, Snowflake, and DBT as well as documenting and training teammates on these standards.
6. Experience working in agile teams with short release cycles and strong verbal, written, and team presentation communication skills.
7. Data-driven mindset with high analytical capability and a history of leveraging data and techniques to optimize business decisions.

Additional Skills :

• Understanding of the pharmaceutical domain, with experience analyzing and working with patient data, call activity data from CRM systems, and marketing data such as web traffic, email campaign metrics, and consent management.
• Experience in data aggregation of channel sales (SP / SD) data, 3PL data, etc.
• Experience working with data from Veeva CRM, Marketing CRM, Salesforce ServiceCloud, and HealthCloud.

ZS offers a comprehensive total rewards package including health and well-being, financial planning, annual leave, personal growth, and professional development. Our robust skills development programs, multiple career progression options, internal mobility paths, and collaborative culture empower you to thrive as an individual and global team member.

We are committed to giving our employees a flexible and connected way of working. A flexible and connected ZS allows us to combine work from home and on-site presence at clients / ZS offices for the majority of our week. The magic of ZS culture and innovation thrives in both planned and spontaneous face-to-face connections.