Senior Power BI Developer

Insight Global (United States); Toronto; On-site; CAD 90,000 - 140,000; Part time

Job summary

Insight Global invites applications for a Senior BI Developer to join a major Canadian bank's Lending & Portfolio Management group on a 6-month contract. The role focuses on advanced data analytics, data reconciliation across data warehouses, and ensuring data accuracy.

You will leverage Python and Power BI for data investigation, modeling, and reporting within a banking context. Candidates should navigate large datasets, validate business rules, and communicate findings to technical and

Qualifications

• Senior BI Developer or equivalent with strong data analytics focus.
• Experience with data warehouses, data pipelines, and data warehousing architectures.
• Strong Python and Power BI skills with ability to work across large datasets.

Responsibilities

• Perform complex data investigation and reconciliation across multiple data warehouses.
• Investigate non-reconciling numbers and identify root causes with stakeholders.
• Define, test, and validate business rules using sample data to ensure consistency.
• Work with extremely large datasets (200M+ records) and data pipelines.
• Develop and troubleshoot data models and data flows, including lineage tracing.
• Provide data-driven insights to lending, credit risk, and related business units.

Skills

Python

Power BI

Data modeling

Data analysis

Root cause analysis

Job description

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. Strong 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 [e-mail].