Senior Data Engineer - Snowflake AI Pipelines & Cloud

Morningstar Credit Ratings, LLC; Toronto; Hybrid; CAD 90,000 - 133,000; Full time

Benefits offered by this job

Hybrid work model

Incentive plan

Job summary

Morningstar Credit Ratings, LLC is seeking a Senior Data Engineer to design and implement scalable, end-to-end data engineering solutions. The candidate should have 5+ years of experience with Snowflake, modern data pipelines, cloud platforms, and AI-enabled data solutions.

Key responsibilities include building Snowflake pipelines, Medallion Architecture, Python/Informatica data ingestion, data modeling, and deploying CI/CD for data pipelines.

Qualifications

• Minimum 5+ years of experience in data engineering or related roles.
• Strong hands-on experience with Snowflake, including data modeling and production workloads.
• Proven experience in building end-to-end data pipelines.
• Strong proficiency in Python for data processing and automation.
• Experience with Informatica or similar ETL tools.
• Advanced SQL skills with solid data warehousing knowledge.
• Hands-on Snowflake AI/ML capabilities (Cortex/LLM) exposure is a plus.
• Experience using Git/Bitbucket for version control in teams.
• Basic to intermediate understanding of CI/CD pipelines and deployment workflows.
• Hands-on experience with AWS cloud services and cloud-based data architectures.

Responsibilities

• Design, build, and maintain end-to-end data pipelines with Snowflake as the primary data warehouse.
• Implement and support Medallion Architecture within Snowflake for scalable data management.
• Develop data ingestion pipelines using Python and/or Informatica to load data into Snowflake.
• Build scalable data models and transformation logic within Snowflake.
• Leverage Snowflake AI/ML capabilities to enable advanced analytics and data-driven insights.
• Manage SQL scripts, Python code, and Snowflake objects in a structured way.
• Use Git/Bitbucket for version control of Snowflake scripts, Python code, and deployment artifacts.
• Support CI/CD and deployment processes for data pipelines and database changes.
• Monitor, troubleshoot, and optimize data pipelines across environments.
• Ensure data quality, consistency, and performance across pipelines.

Skills

Snowflake

Python

SQL

Data modeling

Data pipelines

Tools

Informatica

Git/Bitbucket

CI/CD tooling

AWS

Job description

Morningstar Credit Ratings, LLC is seeking a Senior Data Engineer to design and implement scalable, end-to-end data engineering solutions. The candidate should have 5+ years of experience with Snowflake, modern data pipelines, cloud platforms, and AI-enabled data solutions.

Key responsibilities include building Snowflake pipelines, Medallion Architecture, Python/Informatica data ingestion, data modeling, and deploying CI/CD for data pipelines.