Senior Analytics Developer – Residential Lending Analytics

BMO is currently sourcing for a Senior Analytics Developer, to support the SAS to Python migration for Residential Lending Analytics.This is a remote or hybrid contract role. Role Overview BMO is retiring SAS and moving its analytics, reporting, ETL and automation processes to Python in an enterprise Anaconda environment. This is a hands-on technical delivery role. The developer analyzes existing SAS processes, rebuilds them as modular Python code and validates the migrated outputs against the legacy results. The work supports BMO’s SAS decommissioning effort while keeping reporting reliable for the business throughout the transition.

Key Responsibilities

Analyze and document existing SAS reporting packages, analytic processes, ETL and automation processes Design and develop modular, reusable Python replacements within the Anaconda environment Optimize Python code and SQL queries for large datasets without changing approved business logic Validate migrated outputs against legacy source systems through reconciliation and testing Support validation sessions and business acceptance testing with internal stakeholders Create process documentation, report specifications and data mappings Escalate unclear business logic or technical constraints to process owners and project leads

Must-Have Skills

5+ years of experience in reporting, analytics, business intelligence, data management or data engineering Advanced Python for analytics, reporting, ETL and automation on large, complex datasets, including pandas and related data-processing libraries Modular, maintainable, production-ready Python code SAS programming sufficient to read, troubleshoot and reconstruct legacy processes, including PROC SQL, DATA Steps, macros, Unix batch and automated processes, ODS, Proc Tabulate and Proc Summary Experience converting SAS programs or comparable legacy analytical processes into Python Strong SQL, including complex joins, transformations, query optimization and data validation Reconciliation and testing of migrated outputs against legacy source systems

Nice to Have Skills

Banking, lending, financial services or other regulated industry experience Enterprise-managed Anaconda environments Mortgage, home equity, consumer lending or portfolio analytics data Microsoft Power BI or other visualization tools Data governance and reporting controls in regulated environments GitHub and GitHub Copilot

Ideal Candidate

Has worked on a SAS decommissioning or platform migration program within a bank or other regulated financial institution Has supported production reporting packages for a lending or portfolio analytics team Has worked with project leads and process owners through validation and business acceptance of migrated processes

Benefits provided include Basic Life/AD&D insurance, Short- and Long-Term Disability, and EAP at no cost to eligible employees after a waiting period. Medical and dental coverage (employee premium contributions), a non-matching 401(k) plan, and additional voluntary coverage are also available. This role includes legislatively required paid leave; no bonus, commission, or equity compensation applies.