Senior Power BI Developer

New Opening

6-months contract with extensions

$64/h T4A $57/h T4

3x days a week on site

Required Skills & Experience

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.

Nice to Have Skills & Experience

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.

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.

Artificial intelligence tools are used to assist in screening and assessing applicants for this position.