02 Sep
|
Propel Holdings
|
Toronto
02 Sep
Propel Holdings
Toronto
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. At Propel, we are here to change the way employees, customers and shareholders succeed together. Join us as we change the way employees, customers and shareholders succeed together.
The Database Application
Developer designs, develops, tests, deploys, and supports database code powering Propel’s financial data applications, ETL processes, and reporting solutions. The role converts business requirements into reliable schemas, queries, stored procedures, views, transformations, controls, and reporting datasets across MySQL/RDS and Snowflake. The ideal candidate combines solid SQL development skills with excellent logical and analytical reasoning, attention to detail, and a commitment to data quality, security, performance, and operational reliability.
Develop and maintain SQL, DDL, DML, views, stored procedures, functions, Streams, Tasks, and other database components Design and support staging, core, supporting, reporting, and analytical data structures Build ETL/ELT processes that extract, validate, transform, reconcile, and load data from upstream application systems Translate business rules, source-to-target mappings, and reporting requirements into accurate, testable database logic Implement data-quality checks, reconciliation controls, logging, error handling, auditability, and rollback procedures Diagnose and resolve data, SQL, pipeline, and performance issues using evidence-based root-cause analysis Tune queries, procedures,
data models, indexes, clustering, and workload patterns for performance and cost efficiency Apply secure development practices, including least privilege, access controls, masking, retention, and protection of sensitive data Deliver changes through GitHub, pull requests, peer review, testing, and controlled deployment processes Collaborate with application developers, data and analytics engineers, QA, platform engineering, security, risk, compliance, finance, and operations Contribute to database standards, documentation, modernization, production support, incident response, and continuous improvement Bachelor’s degree in a relevant technical discipline or equivalent practical experience ~5+ years of professional experience designing, developing, testing, deploying, and supporting database code powering financial data applications, ETL processes, and reporting solutions ~ Strong logical and analytical reasoning: able to break down complex problems, identify dependencies, test hypotheses, detect anomalies, and reach evidence-based conclusions ~ Snowflake, dbt, Streams, Tasks, dynamic tables, or other modern data-platform experience ~ Structured troubleshooting skills, including tracing data issues across source systems, transformations, database code, and reports ~ Professional experience developing production SQL and database applications ~ Strong understanding of relational database concepts, data modelling, joins, transactions, constraints, indexing, concurrency, and query optimization ~ Experience writing complex SQL, stored procedures, views, functions,
and data transformations ~ Experience with at least one relational database platform such as MySQL, PostgreSQL, SQL Server, or Oracle ~ Experience with version control, code review, testing, validation, and controlled deployments ~ Ability to translate ambiguous requirements into clear, maintainable, and testable technical solutions ~ Financial services, lending, payments, banking, reporting, or other regulated-data experience ~ Strong communication skills and attention to detail when working with financial, customer, or other sensitive data Amazon RDS, AWS, cloud database migration, or managed application-platform experience ETL/ELT pipelines, source-to-target mappings, incremental processing, and reconciliation frameworks Data governance, masking, row access policies, classification, retention, lineage, and audit controls CI/CD, infrastructure-as-code, observability, incident management, or automated testing Python, Java, APIs, or database-backed application development Competitive salary and health benefits Group health and dental benefits This role may also be eligible for performance-based incentive programs and total compensation may include variable incentives, such as bonuses and commissions. 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 ourtrained hiring managers and recruitment professionals, not AI. #
📌 Database Application Developer (Toronto)
🏢 Propel Holdings
📍 Toronto