CRM Business Data Analyst - Provides customer insights, data, and analytics for commercial banking. - 37901

Location Address: Hybrid - 40 King Street West, 13th Floor, Toronto, ON - 3 days/week (Monday, Tuesday, Wednesday - subject to change)

Contract Duration: 6 months

Possibility of extension & conversion to FTE

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

Candidate Value Proposition:

The successful candidate will have the opportunity to gain exposure to high profile projects in commercial banking, modern technologies such as GCP, getting details of technologies and client’s master data, working with Salesforce.

Responsibilities:

• 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

Soft Skills Required:

• Excellent communication skills

• Presentation skills - summarizing findings in a PPT format and presenting to varying levels of stakeholders

Education:

Bachelor’s degree

Best VS. Average Candidate:

Ideal candidate is a BA that has strong SQL and data experience, business resource with some IT experience to be able to speak to the technical pieces (specifically with data and applications); Salesforce experience will set them apart