Job Description Our client, a Top 5 Canadian bank, is seeking a Senior BI Developer to join their Lending & Portfolio Management group on a 6-month contract.
This is a highly data-focused role supporting complex lending and credit risk initiatives across areas such as Business Banking, Small Business, Commercial Banking, Mortgages, and Unsecured Lending.
This is not a traditional Power BI/dashboard development position. The successful candidate will have an advanced data analytics engineering background and will be responsible for investigating complex data issues across multiple data warehouses, reconciling discrepancies, validating business rules, and ensuring the underlying data is accurate and reliable.
The team already has the broader framework in place and needs a senior resource who can come in, navigate extremely large and complex datasets, and independently investigate why data isn't reconciling across systems.
Key Responsibilities Perform complex data investigation, analysis, and reconciliation across multiple data warehouses and source systems. Investigate situations where numbers across databases do not reconcile and identify the underlying root cause. Proactively collaborate with business and technical teams to understand data discrepancies and determine appropriate solutions. Define, test, and validate business rules using sample data to ensure consistency across systems. Work with extremely large datasets of 200M+ records. Develop, enhance, and troubleshoot data models and data pipelines. Navigate multiple data warehouses and systems to understand the complete flow and lineage of data. Support lending and portfolio management data across Business Banking,



Small Business, Commercial Banking, Mortgages, and Unsecured Lending. Work with data from a Credit Risk perspective, rather than strictly product analytics. Use Python to support data investigation, engineering, validation, and automation. Leverage AI capabilities to improve productivity in data engineering, including investigation, development, testing, and documentation. Use Power BI for visualization and reporting where required. Clearly communicate findings and data issues to technical and business stakeholders. Work independently and manage competing priorities within a fast-paced banking environment.
Skills and Requirements Advanced experience as a Senior BI Developer, Data Analytics Engineer, Data Engineer, or similar data-focused position. Robust experience with data analytics engineering, data modelling, data pipelines, and data warehousing. Advanced data investigation, reconciliation, and root-cause analysis capabilities. Proven ability to work across multiple databases and data warehouses to investigate inconsistencies. Experience working with very large datasets, ideally 200M+ records. Strong Python experience. Experience with Power BI. Strong financial services or banking experience. Strong understanding of Credit Risk data and concepts. Experience within Business Banking,



Small Business, or Commercial Banking. Knowledge of Mortgages and Unsecured Lending products. Strong critical thinking and problem-solving skills. Excellent written and verbal communication skills, with the confidence to proactively engage different teams to resolve issues. Ability to work independently in a fast-paced environment. Experience supporting customer 360 / consolidated customer credit views. Experience across multiple lending products, including mortgages, personal lines of credit, unsecured credit, and commercial lending. Exposure to AML or other financial risk data. Hands‑on experience incorporating AI tools into data engineering workflows to accelerate analysis and productivity.
We are a company committed to creating diverse and inclusive environments where people can bring their full, authentic selves to work every day. We are an equal employment opportunity/affirmative action employer that believes everyone matters. Qualified candidates will receive consideration for employment without regard to race, color, ethnicity, religion, sex (including pregnancy), sexual orientation, gender identity and expression, marital status, national origin, ancestry, genetic factors, age, disability, protected veteran status, military or uniformed service member status, or any other status or characteristic protected by applicable laws, regulations, and ordinances. If you need assistance and/or a reasonable accommodation due to a disability during the application or the recruiting process, please send a request to [email protected].

#J-18808-Ljbffr

📌 Senior Power BI Developer (Ontario)
🏢 Insight Global (United States)
📍 Ontario