Senior Analytics Developer - Residential Lending Analytics

• 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

• 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, * 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

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.