Business Intelligence BI Analyst & Developer - RFA Bank of Canada - RFA Bank of Canada, RFA Mortgages Corp.

Key Responsibilities

• Design, develop and maintain Power BI dashboards and reports for internal stakeholders and external partners.
• Extract, transform and load data from multiple source systems using SQL and Python scripts.
• Model data in a dimensional warehouse to support reporting and analytics needs.
• Collaborate with business users to translate requirements into technical specifications.
• Ensure data quality, integrity and compliance with regulatory standards.

Requirements

• Proven experience in Business Intelligence development, preferably in a financial or banking environment.
• Strong SQL skills and experience with relational databases (e.g., SQL Server).
• Hands‑on expertise with Power BI, DAX, and data visualization best practices.
• Programming proficiency in Python for data extraction and automation.
• Knowledge of ETL processes, data modeling, and data governance.