> Markdown version of [/jobs/ext/4585520-senior-analytics-developer-residential-lending-analytics](https://www.wearedevelopers.com/jobs/ext/4585520-senior-analytics-developer-residential-lending-analytics). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md).

---

# Senior Analytics Developer - Residential Lending Analytics

- **Company:** BMO Harris Bank National Association
- **Location:** Chicago, IL, United States
- **Experience:** Expert
- **Contract:** Permanent contract
- **Skills:** Data Analysis, Business Logic, Big Data, Unix, Data Validation, Information Engineering, Data Governance, Extract Transform Load (ETL), Data Visualization, Github, Python (Programming Language), Pivot Tables, Query Optimization, Power BI, Standard Sql, SAS (Software), SQL Databases, Anaconda, Data Processing, Macros, GitHub Copilot, Data Management
- **Published:** November 5, 2026
- **Apply:** https://portal.procomservices.com/jobs?jobId=efe99b12-fe25-4fab-9449-68ad293d4c70

## About the Role

* 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

## Description

* 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