Senior Data Analyst

Senior Data Analyst

MCAP at a Glance

Joining MCAP means you will be a part of our diverse workforce of highly talented individuals who are recognized for their expertise and success! At MCAP, your professional expertise, commitment to teamwork and passion for service excellence are recognized and rewarded with competitive total rewards offering, a career with continuous learning and development (formal & informal training), and exciting opportunities in a dynamic, entrepreneurial environment.

The Role

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

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!

Be A Part Of Something Great

MCAP is Canada’s largest independent Mortgage Finance company with over $150 billion in assets under management providing mortgage solutions for residential and commercial properties. For over 35 years, MCAP originates, trades, securitizes and services mortgages in offices across Canada. MCAP originates residential mortgages exclusively through the mortgage broker channel as we believe that a professional mortgage broker is a consumer's best option and MCAP actively promotes the services of mortgage brokers across the country. MCAP is also a leader in the Canadian residential construction lending market with over 25 years in the business. Our teams of dedicated professionals serve a variety of developer, construction and lender clients across Canada.

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

The above information in this description has been designed to indicate the general nature and level of work performed by employees in the position.  It is not designated to contain a comprehensive inventory of all duties, responsibilities, and qualifications required of employees assigned to this job.

MCAP provides equal opportunities for all applicants and is committed to fostering an inclusive, accessible environment, where all employees feel valued, respected and supported throughout the recruitment and employment process. If you require accommodation, we will work with you to meet your needs.