Senior Business Analyst with data analytics and power bi experience to work on a CRM/Data Hygiene Project with one of our major banking clients- 38465

Senior Business Analyst with data analytics and power bi experience to work on a CRM/Data Hygiene Project with one of our major banking clients- 38465

Location Address: Hybrid - Toronto, ON - 3 days/week (Monday, Tuesday, Wednesday - subject to change)

Contract Duration: ASAP to end of March, approx 4.5 months (Possibility of extension & conversion to FTE)

Schedule Hours: 9am-5pm Monday-Friday; standard 37.5 hrs/week

Story Behind the Need

• Business group: Data Strategy & Governance - Provides customer insights, data, and analytics for commercial banking.
• Project: Multiple projects - data governance, CRM, data hygiene projects - Data issues that require looking for root cause and resolving issues, need to clean up issues and then find root cause and resolve with application owners

Typical Day in Role:

• Performs the analysis, design, implementation, modification, and daily functional support of all applications.
• Works with key stakeholders within all business functions to align technology solutions with business strategies.
• Gathers requirements from business units and translates those to programmers and developers. • Prepares cost-benefit and return-on-investment analyses to aid in decisions on system implementation.
• Demonstrates an informed knowledge of business functions to resolve problems and capitalize on improvement opportunities.
• Supports one or more highly complex business processes.
• Works on multiple projects as a project team member.
• Serves as a liaison between the business community and the IT organization in order to provide technical solutions to meet user needs.
• Working on CRM platforms such as Salesforce
• Creating, managing, and analyzing surveys
• Performing data analysis using SQL and Excel to profile data and identify data inconsistencies.
• Using PowerBI for visualizing insights
• Conducting root cause analysis and business documentation to track issues
• Working across business, data and IT stakeholders.

Must Have Skills:

1) 5+ years as a Business Analyst, with demonstrated experience conducting root cause analysis and creating business documentation to track issues

2) 3-5 years data analysis experience using SQL and Excel to profile data and identify data inconsistencies.

3) Demonstrated experience creating, managing, and analyzing surveys

4) 3-5 years’ experience with PowerBI for visualizing insights

Nice-To-Have Skills:

1) 2-3 years hands-on experience with this CRM platform strongly preferred: Salesforce

2) Working across multiple teams and stakeholders (business, data and IT)

3) Experience with MDM (master data management) tools

4) Experience with building data solutions and gathering requirements for those types of projects

Education:

Bachelor’s degree

Best VS. Average Candidate:

Ideal candidate has strong SQL and data experience, able to speak to the technical pieces (specifically with data and applications); recent Salesforce experience will set them apart. Scrubbed CV of previous candidate has been attached to this JP for reference.

Candidate Review & Selection

1 round - in person at 40 King West - 13th floor - Mondays- Wednesdays - 45 minutes - with HM - presentation to be delivered by candidate on their portfolio and skillset, relevancy of experience, and how it relates to job description and skillset, high level explanation of their projects/roles - to be sent to HM 24 hours before the interview date + time - bring their laptops to present in person