Business Intelligence Analyst - Toronto, Canada - MCAP
Description
Business Intelligence 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
As a member of BI team in our Data Management & Analytics Function (DMAF), the person will be accountable for meeting day-to-day data/reporting/dashboarding needs of business users with a high degree of accuracy and timeliness.
- Develop a clear understanding of strategic business imperatives and issues to frame requirements for reporting/dashboarding or performance measurement solutions
- Working as a trusted business partner, develop and execute BI artifacts aligned with business priorities
- Develop BI solutions (data sets, reports, dashboards, descriptive analytics, etc.) within a complex and fastpaced environment using various BI technologies
- Manage ad hoc requests from business leaders/users with appropriate prioritization
- Build and manage report catalog with welldefined SLAs and regular compliance reporting
- Follow the standard reporting process/workflow and other BI standards and best practices (including solid documentation of schedules and queries)
- Transform reports/dashboards into "BI products" with a standard and consistent design and look & feel for enhanced user experience
- Regularly identify usability problems and make suggestions for improvement (e.g., automation) in BI products delivered
- Help automate various reports/processes using tools such as PowerAutomate, VBA macros, etc.
- Through continuous learning, enhance your knowledge of organization's IT systems and data
What You Bring To The Team
- 3+ years of financial services experience desirable
- 3+ years of experience with SQL, SSIS, SSRS, Power BI
- 3+ years of experience Excel, Word, and PowerPoint
- 1+ years of PowerAutomate and/or VBA macros experience
- Experience working with and creating models, databases and dashboards using all relevant data to inform decisions
- Strong problem solving, quantitative and analytical abilities
- Strong ability to plan and manage numerous processes, people, and projects simultaneously
- Excellent communication, collaboration, and delegation skills
- Bachelor's Degree in Business Analysis, Computer Science/Computer Engineering is desirable
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.
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 #:
req1659
Employment Status:
Permanent Full Time
Location:
Toronto; Ontario
Number Of Openings:1
Department:
Corporate Gov/Legal/IA/RIsk
Internal Job Title:
Business Intelligence 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.
More jobs from MCAP
-
Funding Officer
Calgary, Canada - 3 weeks ago
-
Bilingual Customer Service Representative
Waterloo, Canada - 3 weeks ago
-
Bilingual (French/english) Customer Service
Toronto, Canada - 2 weeks ago
-
Network Engineer
Waterloo, Canada - 2 weeks ago
-
Bilingual Inside Sales Representative
Waterloo, Canada - 1 week ago
-
Compensation & Benefits Analyst
Toronto, Canada - 3 days ago