Client Business Analyst I

Mosaic North America; Toronto; On-site; CAD 55,000 - 75,000; Full time

Job summary

Mosaic North America is seeking a Client Business Analyst I to support client operations, reporting, and data collection in Toronto. The role focuses on designing standardized reports, automating data processes, and data administration to drive sales and marketing objectives.

The analyst will implement surveys and research methods, leverage Power BI/Tableau/SQL/R, and collaborate across teams to evolve data-driven practices within Mosaic. Strong Excel and communication skills are essential.

Qualifications

• Bachelor’s degree in Marketing, Statistics, CS, Geography or related quantitative field.
• 1–3 years of relevant professional experience.
• Intermediate Excel skills including formulas, pivot tables and VLOOKUP.
• Intermediate data cleansing and data visualization using Power BI, Tableau, SQL, and R/Python.

Responsibilities

• Collect, inspect, cleanse, transform, model and diagram complex data sets.
• Daily use of business intelligence and analytical software tools.
• Interpret data, prepare reports and provide recommendations to the team.
• Design and build research methods such as surveys and market testing.
• Stay informed on latest data trends, practices, and processes.

Skills

Excel

Power BI

Tableau

SQL

Python

R

Education

Bachelor’s degree in Marketing/Statistics/CS/Geography

Tools

Power BI

Tableau

SQL

Python

R

Excel

Job description

Mosaic is a leading North American Integrated Agency, specialized in connecting with consumers through Experiential Marketing, Sales & Merchandising, and Shopper Marketing. At Mosaic, we are never satisfied with the status quo and are in constant search for new ideas and new ways to help our clients build their brands amidst the evolving dynamics of empowered consumers and leveraging new technologies.

The Client Business Analyst I position is responsible for the operational support of a client, including responsibility for reporting, data collection, survey setup, and other adhoc requests. The Analyst will lead standardized report design, automation and data administration. They will leverage business and market relevant information to make data‑driven decisions that allow Mosaic to achieve its sales and marketing objectives and quickly adapt tactics. They will play a key role in evolving and growing the data‑driven discipline within our team and contribute to our shared success.

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

Values and Qualities

• People Minded – Must show dignity and respect to all people
• Integrity – Must exemplify the highest degree of ethical behavior
• Results Oriented – Must show passion, pride and commitment to succeed
• Trust – Must be honest, sincere and confident
• Teamwork – Must build trusting relationships
• Innovation – Must progress through a combination of creativity, common sense and vision
• Balance – Must maintain an optimistic attitude and keep perspective on what is important in life

Minimum Qualifications

• 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

Preferred Qualifications

• Excellent communication skills, with the ability to interact comfortably with peers and leadership both internally and externally
• Ability to execute standard measurement strategies within a project
• Strong analytical and critical thinking with the ability to disseminate insight from large datasets
• Meet tight deadlines, prioritize workloads and achieve results in a fast‑paced, dynamic environment
• Develop understanding of all areas of Mosaic business to find new opportunities for measurement
• Proven ability to timely complete projects and achieves results in ambiguous work environment

Mosaic North America is an Equal Opportunity Employer. The above statements are intended to describe the general nature and level of work being performed by people assigned to this classification. They are not intended to be construed as an exhaustive list of all responsibilities, duties, and skills required of personnel so classified. Mosaic reserves the right to modify all or part of any job descriptions at its discretion in order to meet and or exceed the needs of the business. We are committed to providing accommodations for persons with disabilities. If you require accommodation, we will work with you to meet your needs, to the extent required by law.