Job Description

Position Title: Data Analyst

Duration: 4 Months

Remote/Hybrid: Hybrid (1 to 2 days at the Toronto office per week) Every Monday and 2nd Friday of each month

Office Location: 81 Bay 29th Floor

Responsibilities:

• Conduct detailed quantitative analysis work to support the development and execution of business rules testing within the existing decision engine.

• Monitor the integrity and interpretation of all data analysis output provided to ensure accuracy.

• Generate ad-hoc reports, queries and post-analysis to monitor system decision.

• Work with Sr. Managers and the Director to conduct analysis and/or draw pertinent information needed to make strategy changes.

• Develop strategies for prioritization and segmentation of delinquent or high-risk accounts using statistically valid champion/challenger methodology.

• Participate in the monitoring of the portfolio/scorecards to detect any signs of degradation

• Provide analytics support for ad-hoc requests to provide deeper insight into credit risk exposure for the mortgages and personal lending portfolios

• Apply combination of computer skills, credit knowledge and creative problem-solving skills to meet internal client needs.

• Monitor the integrity and interpretation of all data analysis output provided to ensure accuracy.

• Develop a sound understanding of the retail lending and mortgages portfolio data, system master files - to ensure that data sourced for analytics may be relied upon

Must Have Requirement:

- 8+ Years of experience coding as a Data Analyst

- Can operate independently using a data dictionary and data warehouse technology documentation.

- SAS experience

- SQL experience

- Excel pivot tables experience

Nice to Have:

- Real Estate Secured or Financial Lending knowledge

- Tableau or other database query tools

Ideal Candidate

• Expert knowledge of SAS. Knowledge of SQL, Tableau or other database query tools used for analytics an asset.

• Excellent PC skills. Knowledge of MS Office software, especially advanced MS Excel is required

• Knowledge of retail credit, credit risk, portfolio performance drivers and strategies. Understanding of the residential mortgage and secured/unsecured lines and loans business preferred

• Well-developed analytical skills. Able to conceptualize, research, compile and translate analytical findings into meaningful strategies or recommendations

• Understanding in understanding reporting variables and changes to data environments.

• Good understanding of Credit Bureau data and its uses in risk management strategies or scoring.

• Expertise in evaluating complex data relationships; able to develop strategies based on the knowledge gained though analysis of the data.

• Proactive self-starter: Ability to prioritize and highly committed to meeting deadlines

• Communication: ability to convey technical information in understandable terms - both written and verbal

• Flexibility to adapt to an evolving environment with shifting priorities. Team player.

• Project management skills sufficient to plan and complete initiatives, given frequent multiple deadlines.

S.i. Systems