Business Data Analyst

Lancesoft; Toronto; Hybrid; CAD 80,000 - 100,000; Full time

Job summary

A leading technology solutions provider is seeking an experienced Business Analyst in Toronto. The ideal candidate has 5+ years of experience, strong skills in SQL and data analysis, and familiarity with Salesforce. This hybrid position requires excellent communication and analytical skills to collaborate across teams and enhance business processes.

Qualifications

• 5+ years as a Business Analyst with experience in root cause analysis.
• 3-5 years of data analysis using SQL and Excel.
• Proficiency in managing and analyzing surveys.
• 3-5 years of experience with PowerBI for insights visualization.

Responsibilities

• Perform analysis, design, implementation, and support of applications.
• Align technology solutions with business strategies.
• Gather requirements from business units and translate them to developers.
• Prepare analyses for decision-making on system implementations.
• Resolve problems and identify improvement opportunities.
• Work on multiple projects and support complex business processes.

Skills

Root cause analysis

Data analysis using SQL

Survey management and analysis

PowerBI visualization

Excellent communication skills

Presentation skills

Education

Bachelor's degree

Tools

Salesforce

PowerBI

SQL

Excel

Job description

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

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

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 :

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