Sr. Data Engineer
Senior Data Engineer at Propel Holdings, a fintech lender, building and troubleshooting Snowflake databases, data models, ELT pipelines, stored procedures, and SQL-based strategy — much of it Finance-focused — while partnering with Finance, Data Engineering, and Analytics teams. Core stack: Snowflake, SQL, Python, Git-based CI/CD.
- Compensation
- CA$110K–CA$150K / yr
- Location
- Toronto, Canada
- Work setup
- Not specified
- Seniority
- Senior
- Employment
- Not specified
- Experience
- 3+ years
- Category
- Data engineering
- Posted
Skills
Must have
- 8+ 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 (databases, schemas, virtual warehouses, micro-partitions, caching, workload isolation)
- Advanced Snowflake SQL skills, including complex transformations, window functions, semi-structured data, and query optimization
- Experience designing ELT pipelines with Snowflake stages, file formats, COPY INTO, Snowpipe, Streams, Tasks, or Dynamic Tables
- Proven ability to model data for analytics and Finance, including dimensional modeling, facts and dimensions, and slowly changing dimensions
- Experience diagnosing and improving Snowflake performance using query history, Query Profile, warehouse configuration, partition pruning, and clustering
- Experience managing Snowflake access and governance (RBAC, custom roles, grants, masking policies, row access policies, tags, audit monitoring)
- Experience with Python and scripting for data engineering, automation, testing, or Snowflake administration
- Experience with GitHub or GitLab and collaborative development practices (pull requests, code review, automated deployment)
Nice to have
- Experience using generative AI tools (ChatGPT, Claude, Copilot) and adopting them responsibly in day-to-day engineering
- Experience with dbt, Airflow, Dagster, or another modern transformation/orchestration framework integrated with Snowflake
- Experience with Snowflake governance, observability, cost-management, data-quality, or catalog tools
- Experience with Snowflake account replication, failover groups, or secure data sharing
- Knowledge of Finance, accounting, lending, risk, or regulatory reporting concepts
- Experience migrating workloads from MySQL, Oracle, or other legacy databases to Snowflake
- Development experience in Java or another application programming language
- Experience with infrastructure-as-code or automated cloud deployment practices
- Experience with APIs, event-driven ingestion, REST services, or cloud storage integrations
Full 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