Data Analyst

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

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

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

Employment Status : Permanent Full Time

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.

#J-18808-Ljbffr