Business Data Analyst

LanceSoft Inc; Toronto; Hybrid; CAD 75,000 - 95,000; Full time

Job summary

A prominent consulting firm is looking for a Business Analyst in Toronto. The role involves data analysis, managing CRM platforms like Salesforce, and performing root cause analysis. The ideal candidate has over 5 years of experience and a background in SQL and PowerBI. This hybrid position allows for exposure to high-profile projects within the commercial banking sector.

Qualifications

• 5+ years as a Business Analyst with experience in root cause analysis.
• 3-5 years experience in data analysis using SQL and Excel.
• Strong knowledge of PowerBI for data visualization.

Responsibilities

• Perform analysis, design, and implementation of applications.
• Gather requirements and translate to programmers and developers.
• Supporting complex business processes across multiple projects.

Skills

Root cause analysis

Data analysis using SQL

Data visualization with PowerBI

Survey management and analysis

Education

Bachelor’s degree

Tools

Salesforce

SQL

PowerBI

Job description

Overview

Location Address: Hybrid - 40 King Street West, 13th Floor, 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

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.

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

Candidate Requirements / 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

• 2-3 years hands-on experience with this CRM platform strongly preferred: Salesforce
• Working across multiple teams and stakeholders (business, data and IT)
• Experience with MDM (master data management) tools
• 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.