Business Intelligence (BI) Analyst & Developer - RFA Bank of Canada at RFA

Toronto, Ontario, Canada -

Full Time

Start Date

Immediate

Expiry Date

17 Sep, 26

Salary

0.0

Posted On

19 Jun, 26

Experience

2 year(s) or above

Remote Job

Yes

Telecommute

Yes

Sponsor Visa

Skills

Power BI, SQL, Data Modeling, Business Requirements Gathering, Relational Databases, Data Warehousing, ETL Processes, Metadata Management, Stakeholder Management, Data Governance, Dashboard Design, Technical Documentation

Industry

Financial Services

Description

Business Intelligence (BI) Analyst & Developer – RFA Bank of Canada Date: June 19, 2026 Location: Toronto, ON Company: RFA Bank of Canada Job Type: Permanent Closing Date: July 10, 2026 About RFA Founded in 1996, RFA (Realty Financial Advisors) is a leading Canadian-owned real estate firm. Through RFA Bank of Canada and RFA Mortgage Corporation, RFA offers mortgage brokers a complete range of Prime and Alternative mortgage solutions. RFA Bank of Canada, a division of RFA (Realty Financial Advisors), is a federally regulated Schedule I Bank. Our goal is to be a long-term leader in the residential lending market by offering more than just competitive rates and compensation. At RFA Bank of Canada, we focus on delivering a unique value proposition in the Alternative mortgage space, committed to innovation and exceptional service to meet a diverse range of borrower needs. The Opportunity We’re looking to fill a BI Analyst & Developer position at RFA Bank of Canada! This role will go beyond traditional report development and play a critical part in bridging business requirements, dashboard design, and reporting delivery. As the BI Analyst & Developer, you will: BI & Reporting Delivery: Work with business stakeholders (Data Stewards and Data Owners) as well as analysts, and business subject matter experts to design, develop, and maintain Power BI reports and dashboards. Collaborate with business users to understand data requirements and translate them into well-designed reporting solutions, ensuring alignment with technology (scalability, quality, security, maintainability) and business goals. Work with the IT team to monitor and review performance of the reports addressing any issues. Ensure data security and compliance with relevant standards and regulations, including maintaining user access controls and ensuring data privacy. Implement SQL queries, stored procedures, and functions as required to support the reports. Stay current with industry trends and emerging technologies in reporting tools and data management to continually improve processes and systems. Maintain documentation of report creation and maintenance processes. Adhere to the Bank’s control processes to implement reports into production. Business Requirements & Process improvements: Lead end-to-end requirements gathering across business units (Finance, Risk, Operations etc.) for reporting and data needs. Translate business needs into clear, structured documentation, including: Business requirements Functional requirements Data requirements (sources, granularity, refresh frequency) Business rules and logic Facilitate discussions and workshops to clarify business objectives, KPIs, and decision-making requirements. Translate business requirements into Data Models, technical specifications, and reports/dashboard designs. Identify opportunities to simplify and standardize the business process with a focus on continuous, incremental improvements. Develop and maintain technical documentation and data lineage to support auditability and governance. Ensure all requirements are aligned with enterprise data governance standards and definitions. Datamart & Data Collaboration: Work closely with IT development and data architecture teams to support the design and implementation of centralized datamarts for enterprise reporting. Define and document data requirements, structures, and business logic to enable effective datamart development. Translate business needs into clear technical specifications for implementation by development teams. Review and validate data outputs to ensure alignment with business requirements, logic, and definitions. Support testing, reconciliation, and issue resolution across source systems, datamarts, and reporting layers. Collaboration & Documentation: Participate in the Data Governance Working Group (DGWG). Support enterprise initiatives related to data standardization, reporting consistency, and metadata management (Dataedo). What You’ll Need to Succeed Bachelor's degree in Computer Science, Information Technology, or a related field. 3-5 years of experience with PowerBI development and report/dashboard creation (experience with SSRS or similar tools is an asset). 2-4 years of experience working with SQL and relational databases, including writing queries, developing data models, and understanding data structures. Experience gathering and documenting business, functional, and data requirements. Experience working with or contributing to Data Warehouse or datamart solutions. Strong understanding of data modeling concepts, including data structures, relationships, and transformations. Experience with metadata management and data catalog tools (e.g., Dataedo or similar platforms) to support data documentation, lineage, and governance. Familiarity with cloud-based data and reporting solutions. Knowledge of data warehousing concepts, ETL processes, and reporting best practices. What Sets You Apart Strong understanding of SQL and database design best practices. Ability to translate business requirements into technical specifications, data models, and reports. Strong analytical and problem-solving skills, with the ability to troubleshoot data and reporting issues. Excellent communication and stakeholder management skills, with the ability to work across business. Ability to work in structured, governed environments with a focus on data quality, consistency, and auditability. Ability to work in a cross-functional environment with developers, architects, and business stakeholders. Understanding of data governance principles, including data quality, consistency, and control. Our Values and What We Offer at RFA At RFA, we live by our core values. These values guide our daily actions and shape our work culture: Accountability: You take ownership of your work & its consequences. You always consider risk & make informed decisions. Selflessness: You share info & teach others. You’re able to put your ego aside & understand that the best idea wins. Inclusivity: You value differing viewpoints & experiences. You understand how this can drive growth & innovation. Innovation: You seek opportunity & embrace change. You see tech as a way to enhance productivity & drive profitability. Courage: You make tough decisions in our best interest. You see opportunity when faced with challenge or adversity. Impact: You value results & your contributions. You rise to the occasion and never settle for sub-par. Performance: You embody a competitive spirit, desire to win and strive for executional excellence. Along with a strong work culture, RFA offers a comprehensive benefits package, including: Health & Dental Care Vision Care RRSP Match Health & Wellness Spend Vacation & Personal Days Hybrid working environment Ready to take the next step? If this opportunity excites you and aligns with your skills and aspirations, we’d love to hear about how you can contribute to our team at RFA. Accessibility Accommodation is available upon request for applicants and employees with disabilities. If you are contacted for a job opportunity, please advise us of any accommodations needed to ensure you have access to a fair and equitable process. Any information received relating to accommodation will be addressed confidentially.

Responsibilities

The role involves designing, developing, and maintaining Power BI reports and dashboards while bridging the gap between business requirements and technical delivery. It also includes leading requirements gathering across business units and collaborating with IT to implement centralized datamarts.