The Sr. Data Analyst is responsible for acting as Single Family Operations’ primary data analyst and report developer for Single Family Operations. This role involves collaborating closely with Single Family Operations’ business units, utilizing advanced SQL and Excel skills to extract and manipulate data from multiple sources, and leveraging visualization tools to transform raw data into meaningful reports and dynamic dashboards that address specific business needs.

The Sr. Data Analyst (SF Ops) is a key contributor to enhancing operational efficiency and strategic decision-making through accurate and timely reporting.

This role provides timely and thorough analysis, as well as sound and prudent feedback on major projects and business opportunities identified by Single Family Operations’ senior leadership team. It ensures all relevant business requirements are met, risks are mitigated, alternative options are explored, and costs are managed. This role works together with business units, and internal technology teams to document processes and solutions, present and explore new methods to enhance operations, test and validate results, implement appropriate process and technology solutions, and provide information and support to the training team.

Provide subject matter expertise and impact analysis on projects and business opportunities.

- Develop, maintain and automate reporting to improve efficiency and data accessibility
- Translate business needs into clear reporting and system requirements, ensuring proper documentation
- Collaborate with business units and IT to develop solutions, resolve issues, and assess impacts
- Extract, integrate, and analyze data from multiple sources using SQL while ensuring accuracy and data integrity
- Develop automated reporting solutions (e.g., SSIS, SSRS)



and support data optimization initiatives
- Review and validate analysis outputs, providing feedback and supporting sign-off processes
- Build and maintain effective cross-functional relationships across the organization while handling sensitive information with confidentiality
- Document reporting procedures and contribute to data optimization and streamlining initiatives
- Operates with high independence, proactively identifies opportunities, influences business strategy, and provides recommendations directly to leadership
- Identify data gaps, risks, and cross-functional impacts, and support issue resolution with IT and stakeholders
- Support business case development and communicate findings through reports and presentations
- Apply extensive business background and working knowledge of systems to identify options, impacts and issues affecting other business units not initially included in the project scope

Collaborate with Stakeholders, the Leadership Team, and IT team to implement appropriate data and reporting solutions.

- Document report specifications and changes for impacted business units
- Assist in providing end user testing and signoff on test results
- Anticipate and communicate risks as well as propose associated mitigation strategies
- Identify opportunities for report automation and optimization to enhance the efficiency of report generation




- Keep current on industry best practices and emerging tools for data analysis and reporting
- Integrate data from various systems and databases to create comprehensive datasets for analysis
- Perform data cleansing and transformation to ensure the quality and reliability of the data used in reports
- Effectively communicate and provide progress updates
- Escalate immediately relevant problems with recommended action plans
- Recognize opportunities to increase efficiency by combining similar requests

What You Bring To The Team

- Minimum 3 years’ experience in data role preferred
- Extensive industry knowledge and understanding of Information Technology concepts
- Experience in the Financial Services industry
- Expert proficiency in SQL for data extraction, manipulation, and aggregation.
- Solid proficiency in Microsoft Power BI and visualization tools
- Experience with Azure DevOps and working in an Agile environment
- Experience in Cross Departmental Impact Analysis
- Experience in Business Case Development
- Experience with report automation through SSIS packages and SSRS
- Extensive knowledge of core application system
- Industry Knowledge
- Subject matter expert in Core Application Systems
- Extensive Knowledge of Test Case analysis, definition and
- Development
- University Degree/College Diploma or equivalent work experience
- Certification(s) from IIBA, PMI etc. preferred

Position #: req2257

Employment Status: Permanent Full Time

Location: Toronto; Ontario

Number Of Openings: 1

Department: Residential

Internal Job Title: Sr Data Analyst (SF Ops)

Salary Range: $80,000-$87,000

If this sounds like you and you are looking to be a part of one of Canada’s largest independent mortgage finance companies, then we want to hear from you!

📌 Sr. Data Analyst (Toronto)
🏢 MCAP
📍 Toronto