Client Business Analyst I

Jobtailor; Toronto; On-site; CAD 65,000 - 90,000; Full time

Job summary

Jobtailor in Toronto is seeking a data analyst to collect, cleanse, transform and model complex data sets, and to report findings to the team.

You will design research methods such as surveys and market testing, stay informed on data trends, and use Power BI, Tableau, SQL, R, and Python to support data-driven decisions.

Qualifications

• Bachelor’s degree or equivalent practical experience.
• 1-3 years of relevant professional experience.
• Intermediate Microsoft Excel skills including formulas, pivot tables and V-lookup.
• Intermediate knowledge of data cleansing and data visualization using Power BI, Tableau, SQL, and R/Python.

Responsibilities

• Collect, inspect, cleanse, transform, model and diagram of complex data sets
• Daily use of various business intelligence and analytical software tools
• Interpret data, formulate reports and make recommendations to the team
• Design and build specific research methods such as surveys and market testing
• Remain fully informed on latest data trends, practice and process
• Other duties as assigned, such as managing systems access and tracking assets

Skills

Data Collection

Data Transformation

Data Modeling

Statistical Analysis

Report Formulation

Survey Design

Market Testing

Microsoft Excel

Data Visualization

Power BI

Tableau

SQL

R

Python

Education

Bachelor’s degree in Marketing, Statistics, Computer Services, Geography or related quantitative field, or equivalent practical experience

Tools

Power BI

Tableau

SQL

R

Python

Job description

• Collect, inspect, cleanse, transform, model and diagram of complex data sets
• Daily use of various business intelligence and analytical software tools
• Interpret data, formulate reports and make recommendations to the team
• Design and build specific research methods such as surveys and market testing
• Remain fully informed on latest data trends, practice and process
• Other duties as assigned, such as managing systems access and tracking assets

Requirements

• A Bachelor’s degree in Marketing, Statistics, Computer Services, Geography or related quantitative field, or equivalent practical experience
• 1-3 years of relevant professional experience
• Intermediate Microsoft Excel skills including formulas, pivot tables and V-lookup
• Intermediate knowledge of data cleansing and data visualization using systems such as Power BI, Tableau, SQL, and R/Python

Core Competencies

Proficient in data collection, cleansing, and visualization, with strong analytical skills to interpret complex data sets and generate actionable insights. Experienced in utilizing business intelligence tools and statistical methods to support data-driven decision-making.

Highest-signal resume keywords

• Data Cleansing
• Data Visualization
• Microsoft Excel
• Power BI
• Tableau

ATS Optimization Keywords

Hard Skills

• Data Collection
• Data Transformation
• Data Modeling
• Statistical Analysis
• Report Formulation
• Survey Design
• Market Testing
• SQL
• R
• Python

Soft Skills

• Analytical Thinking
• Communication
• Team Collaboration

Industry Keywords

• Marketing
• Statistics
• Quantitative Analysis
• Data Trends

Tools & Technologies

• Business Intelligence Software
• Analytical Software