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

This position is responsible for acting as a Capital Markets’ data analyst and subject matter expert on reporting deliverables. By having a comprehensive understanding on Capital Markets’ processes and policies, and with knowledge of all other aspects of the complete reporting cycle within CM, this role implements through technical know-how to ensure all ongoing initiatives are championed to benefit Capital Markets processes.

• This role will work with other business units as required to consolidate and deliver requirements.
• Build data pipelines to support complex reporting structures and process flows that support daily trades, hedging processes, operations, and management reports
• Assist enterprise level projects teams with user testing and analyzing large scale data output validating data accuracy, timeliness and resulting output
• Produce business ability to draw out insights from analytical output and work with team leads to generate business recommendations
• Automate recurring tasks to free up capacity and find efficient ways of developing streamlined / self-service dashboards and reporting
• Support analytic work through the entire engagement life cycle including requirements specification, analysis, design, development, implementation and consulting efforts.
• Develop and monitor Key Performance Indicators (KPI) or Key Risk Indicators (KRI) that adhere to capturing performances on daily trades, system issues, pipeline delays and other ad-hoc processes.
• Manage stakeholders, reporting on progress and incorporating new input: managing expectations, driving agreement on prioritization/sequencing, shaping the data requirements
• Assist IT architect lead(s) design and implement all requests, not limited to user access management, database designs, server management and data inventory.
• Leverage internal and external training peers and other sources to continue to grow capabilities
  
  

Technical Knowledge

• Bachelor’s degree in a quantitative discipline or equivalent work experience
• Knowledge of handling, manipulating and analyzing data and creating analytical reports using leading analytical and visualization tools (i.e. R, Python, Tableau or PowerBI, Alteryx)
• Good working knowledge of basic data warehousing concepts
• Superior communication and writing skills and the ability to effectively package and present information to business leaders
• Ability to deal with ambiguity, organize and accomplish objectives independently and proactively
• Strong project management skills, knowledge of change management strategies and ability to develop supporting tools and materials
• Working knowledge on Excel, Access and VBA
• Strong influencing and negotiating skills
• Curious and growth mindset
• Previous knowledge and/or experience automating processes
• Knowledge on MS SQL Server building complex functions, stored procedures, and views
• Experience working in the mortgage industry, finance and/or consulting
  
  

What You Bring To The Team

• 2-3 years’ experience in finance or mortgage industry
• Knowledge of MCAP’s servicing system and origination system is an asset
• Superior attention to detail and strong analytical skills
• Excellent verbal, and written communication skills with all levels of the organization.
• Must have strong, time management and organization skills
• Must be comfortable taking minimal direction from managers to action requirements
• Must be proficient in MS applications (Microsoft Outlook, Word and Excel) and VBA
• Must be proficient with database applications including T-SQL; knowledge of No-SQL is an asset.
• Knowledge Business Intelligence tools such as PowerBI or Tableau is an asset
• Basic programming skills in Python or R is an asset
• Ability to multi-task in a fast-paced environment
• Ability to pull resources together to meet deadlines
• Ability to work effectively in a diverse work group
• Excellent problem-solving and conflict resolution skills
• Excellent planning and project management skills
• Carries out duties with integrity and takes ownership for deliverables
• University Degree in Computer Science, Math or Business
  
  

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 #: req2054

Employment Status: Permanent Full Time

Location: Toronto; Ontario

Number Of Openings: 1

Department: Capital Markets

Internal Job Title: Data Analyst

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.