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 energetic 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!
#J-18808-Ljbffr
📌 Sr. Data Analyst (Winnipeg)
🏢 MCAP
📍 Winnipeg