Senior Data Analyst

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

Job summary

MCAP, Canada's leading independent Mortgage Finance company, seeks a Senior Data Analyst to serve as SF Ops' primary data analyst and report developer. You will extract and manipulate data using SQL, build dashboards with Power BI, and develop automated reporting solutions while collaborating with business units and IT.

You will partner with leadership to ensure data accuracy, document processes, and explore opportunities to optimize operations through data-driven insights.

Qualifications

• Minimum 3 years’ experience in data role preferred.
• 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 systems.

Responsibilities

• 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 cross-functional relationships and handle confidential information.

Skills

SQL

Power BI

Azure DevOps

Agile

Education

University Degree/College Diploma or equivalent

Certification(s) from IIBA, PMI

Tools

SSIS

SSRS

Job description

Senior Data Analyst

MCAP at a Glance

JoiningMCAP means you will be a part of our diverse workforce of highly talentedindividuals who are recognized for their expertise and success! At MCAP, yourprofessional expertise, commitment to teamwork and passion for serviceexcellence are recognized and rewarded with competitive total rewards offering,a career with continuous learning and development (formal & informaltraining), and exciting opportunities in a dynamic, entrepreneurialenvironment.

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

Be A Part Of Something Great

MCAPis Canada’s largest independent MortgageFinance company withover $150 billion in assets under management providing mortgage solutions forresidential and commercial properties. For over 35 years,MCAP originates, trades, securitizes and services mortgages in offices acrossCanada. MCAP originates residential mortgages exclusively through the mortgagebroker channel as we believe that a professional mortgage broker is aconsumer's best option and MCAP actively promotes the services of mortgagebrokers across the country. MCAP is also a leader in the Canadian residentialconstruction lending market with over 25 years in the business. Our teams ofdedicated professionals serve a variety of developer, construction and lenderclients 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.