Sr. Data Analyst

MCAP; Toronto; On-site; CAD 80,000 - 87,000; Full time

Job summary

MCAP in Toronto is seeking a Sr. Data Analyst to lead Single Family Operations data analytics and reporting efforts.

You will serve as the primary data analyst and report developer, transforming raw data into meaningful dashboards using SQL, Excel, and Power BI. You will collaborate with business units and IT to document requirements, automate reporting, and provide timely insights to support leadership in improving operational efficiency and strategic decision-making.

Qualifications

• 3+ years in data roles preferred.
• Strong SQL for data extraction, manipulation, and aggregation.
• Proficiency in Power BI or other visualization tools.
• Experience in Financial Services is a plus.
• Experience with data automation and reporting processes.

Responsibilities

• Develop, maintain and automate reporting to improve efficiency and data accessibility.
• Translate business needs into clear reporting and system requirements.
• Collaborate with business units and IT to develop solutions and address impacts.
• Extract, integrate, and analyze data from multiple sources using SQL.
• Develop automated reporting solutions (SSIS, SSRS) and optimize data processes.
• Document reporting procedures and ensure data quality and integrity.

Skills

SQL

Power BI

Azure DevOps

Agile

Data analysis

Reporting

Data transformation

Education

University Degree/College Diploma or equivalent

IIBA/PMI certifications

Tools

SSIS

SSRS

Azure DevOps

Excel

Job description

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.
• Strong 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

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!