
MCAP Group of Companies
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