Sr. Data Engineer

Propel Holdings, Inc.; Toronto; On-site; CAD 100,000 - 130,000; Full time

Benefits offered by this job

Growth opportunities

Health benefits

RRSP program

Diversity & inclusion

Job summary

Propel Holdings, Inc. is seeking a Senior Snowflake Data Engineer in Toronto to design, implement, and optimize analytics and finance data platforms. You will build scalable Snowflake schemas, ELT pipelines, and governance controls to support decision-making.

The role emphasizes collaboration with Finance and Data teams, emphasizes secure, efficient data delivery, and requires strong SQL and scripting skills, with experience in cloud data platforms.

Qualifications

• 5+ years designing and troubleshooting SQL-based data solutions.
• 3+ years building Snowflake production workloads.
• Deep Snowflake knowledge: databases, schemas, warehouses, caching.
• Advanced Snowflake SQL, semi-structured data, and optimization.
• Design ELT pipelines with Snowflake features.
• Model data for analytics/finance; SCD handling.
• RBAC governance, auditing, data classification basics.
• Python scripting for automation; Git-based workflows.

Responsibilities

• Design, develop, and maintain Snowflake databases, schemas, and data-sharing for analytics and finance.
• Translate business needs into Snowflake data models and technical designs.
• Develop and troubleshoot Snowflake SQL, Snowflake Scripting, SPs, UDFs, and components.
• Build ELT pipelines using Snowflake stages, COPY INTO, Snowpipe, Streams, and Tasks.
• Create dimensional and semi-structured data models using VARIANT and FLATTEN.
• Optimize workloads via profiling, clustering, and caching; manage costs.
• Implement access controls, masking, and data governance with RBAC.
• Collaborate with Finance, Data Eng, Analytics to improve data definitions.

Skills

Snowflake SQL

ELT pipelines

Data modeling

Python scripting

GitHub/GitLab

Snowflake architecture

SQL-based data engineering

Query optimization

Tools

Snowflake

Snowflake Scripting

Snowpipe

dbt (Nice to have)

Job description

Propel (TSX: PRL) is the fintech company building a new world of financial opportunity by facilitating access to credit for consumers underserved by traditional financial institutions. Through its AI-driven platform, Propel evaluates customers in a more comprehensive way than traditional credit scores can. Our revolutionary fintech platform has already helped consumers access over one million loans and lines of credit and over one billion dollars in credit.

To build a new world of opportunity we bring together the brightest talent to help us build opportunities. We are entrepreneurs and believe in measuring success through results and growing within; talent and hard work never goes unnoticed. At Propel, we are here to change the way employees, customers and shareholders succeed together.

We are a team of passionate entrepreneurs, who foster curiosity and growth in our employees. Our culture is why we have been so successful and why our employees choose Propel to build their careers. It is also why we are one of North America's fastest growing companies and a Best Place to Work.

Join us as we change the way employees, customers and shareholders succeed together.

About You:

You thrive in a vibrant, entrepreneurial organization where your ideas are valued. You are motivated by goals, a self-starter, and enjoy wearing multiple hats in a fast-growing fintech environment.

You are a talented professional looking for a career, not a job. Reporting to the Director, Data Platform, you will be responsible for developing and troubleshooting Stored Procedures, SQL, and SQL-based strategy for various teams. Much of your work will focus on Finance-related concepts and you will work closely with our Finance team, so ideally you already have some of this knowledge or you are highly motivated and autonomous when learning.

Responsibilities

• Design, develop, and maintain secure, scalable Snowflake databases, schemas, warehouses, and data-sharing solutions for analytics, reporting, and finance use cases
• Translate business and Finance requirements into well-defined Snowflake data models, technical designs, data contracts, and implementation plans
• Develop and troubleshoot advanced Snowflake SQL, Snowflake Scripting, stored procedures, user-defined functions, and reusable data-platform components
• Build and maintain reliable ELT pipelines using Snowflake stages, file formats, COPY INTO, Snowpipe, Streams, Tasks, Dynamic Tables, and appropriate integration or orchestration tools.
• Create and evolve dimensional, relational, and semi-structured data models using Snowflake capabilities such as VARIANT, FLATTEN, and schema evolution where appropriate
• Optimize Snowflake workloads by using Query Profile and query history to improve pruning, warehouse sizing, clustering, concurrency, caching, and overall execution performance
• Establish cost-efficient warehouse and workload-management strategies, including sizing, auto-suspend, resource monitors, and usage monitoring
• Implement and maintain Snowflake security and governance controls, including role-based access control, least-privilege permissions, masking policies, row access policies, tagging, auditing, and data classification
• Support reliable development and release practices across environments through Git-based version control, code review, automated testing, CI/CD, and repeatable deployment processes
• Develop monitoring, reconciliation, quality checks, and operational dashboards to identify pipeline failures, data freshness issues, query regressions, and unexpected Snowflake consumption
• Apply Snowflake capabilities such as Time Travel, zero-copy cloning, secure data sharing, and environment isolation to support recovery, testing, and controlled access
• Partner with Finance, Data Engineering, Analytics, and application teams to resolve data issues, improve definitions, and increase trust in critical business data
• Document data models, lineage, operational procedures, security decisions, and performance or cost-tuning recommendations
• Contribute to technical standards and mentor team members on Snowflake engineering best practices

Requirements

Must Have:

• 5+ years of professional experience designing, developing, and troubleshooting SQL-based database or data-engineering solutions
• 3+ years of hands-on experience building and operating production workloads on Snowflake
• Strong knowledge of Snowflake architecture, including databases, schemas, virtual warehouses, micro-partitions, storage/compute separation, caching, and workload isolation
• Advanced Snowflake SQL skills, including complex transformations, window functions, semi-structured data, query optimization, and data reconciliation
• Practical experience designing ELT pipelines with Snowflake stages, file formats, COPY INTO, Snowpipe, Streams, Tasks, Dynamic Tables, or comparable Snowflake-native features
• Proven ability to model data for analytics and Finance, including dimensional modeling, facts and dimensions, slowly changing dimensions, and appropriate normalization or denormalization decisions
• Demonstrated experience diagnosing and improving Snowflake performance using query history, Query Profile, warehouse configuration, partition pruning, clustering, and workload/concurrency analysis
• Experience managing Snowflake access and governance through RBAC, custom roles, grants, masking policies, row access policies, tags, and audit or usage monitoring
• Experience with Python and scripting for data engineering, automation, testing, or Snowflake administration; Snowpark experience is an asset
• Experience with GitHub or GitLab and collaborative software-development practices, including pull requests, code review, and automated deployment
• Experience using generative AI tools such as ChatGPT, Claude, or Copilot is an asset, along with the ability to adopt AI tools responsibly in day-to-day engineering work

Nice To Have:

• Experience with dbt, Airflow, Dagster, or another modern transformation and orchestration framework integrated with Snowflake
• Experience with Snowflake governance, observability, cost-management, data-quality, or catalog tools
• Experience with Snowflake account replication, failover groups, secure data sharing, or other business-continuity capabilities
• Knowledge of Finance, accounting, lending, risk, or regulatory reporting concepts and data requirements
• Experience migrating workloads from MySQL, Oracle, or other legacy database platforms to Snowflake
• Development experience in Java or another application programming language
• Experience with infrastructure-as-code or automated cloud deployment practices
• Experience working with APIs, event-driven ingestion, REST services, or cloud storage integrations

Benefits to Joining Propel

• Growth and opportunity – we pride ourselves on promoting from within
• Incredible company culture
• Competitive salary and health benefits
• Group health and dental benefits
• Group RRSP program
• Support for new parents
• Diverse and inclusive workplace

Salary Range

$100,000 - $130,000

Final compensation is determined by market conditions, location, and the candidate’s experience, skills, and education. This role may also be eligible for performance-based incentive programs and total compensation may include variable incentives, such as bonuses and commissions.

This posting is for an existing vacancy within our organization.

Our Culture

Propel brings together the brightest talent to build opportunities. We are entrepreneurs who measure success through results and growth from within; talent and hard work never go unnoticed. Our team fosters curiosity and growth, making Propel one of North America's fastest-growing companies and a Best Place to Work.

Commitment to Diversity & Inclusion

Propel welcomes and encourages applications from all groups, including Indigenous peoples, women, visible minorities, persons with disabilities, people from gender and sexually diverse communities, and those with intersectional identities. Should you require accommodation throughout any stage of the recruitment and selection process, please specify your requirements when submitting your application and we will work with you to meet your needs.

AI Disclosure

We use AI to assist in reviewing applications and assessing candidates. These tools support our recruitment team, however, all hiring decisions are made by our trained hiring managers and recruitment professionals, not AI.