Business Analyst

Crown Equipment; Mississauga; On-site; CAD 63,000 - 76,000; Full time

Benefits offered by this job

Competitive compensation

Medical/dental/vision insurance

Pension plan

Advancement opportunities

Educational allowance

Job summary

Crown Lift Trucks is seeking a data analytics professional to transform branch data into actionable insights. You will design reports, dashboards, and ad-hoc queries to support business strategy and decision-making across multiple stakeholders in Canada.

The role requires 2–4 years of related experience, strong SQL skills, and experience with SSRS/Tableau/Power BI. Occasional travel may be required; comprehensive benefits and education allowances are included.

Qualifications

• 2–4 years of related experience.

Responsibilities

• Design, develop, implement, and maintain reports and ad-hoc queries providing actionable information to personnel.
• Provide data analysis for requests from branch personnel, management, and corporate stakeholders.
• Develop performance dashboards to enable staff to gauge results.
• Ensure data integrity and credibility by understanding business requirements and reconciling results with financial reporting.

Skills

SQL

Analytical thinking

Communication

Excel

Problem solving

Education

Bachelor’s degree in Business, Accounting, Computer Science, IT, or equivalent experience

Tools

SSRS

Tableau

Power BI

Job description

Salary Range: $63,200.00 To $75,800.00 Annually

Crown Lift Trucks is the premier material handling dealer in Canada. We are a leader in the industry and are considered a one-stop shop for all material handling needs. Crown Lift Trucks Canada operates eight full-service branches in both Ontario and Quebec offering complete service solutions including maintenance programs, parts supply, and training.

PERKS AND BENEFITS

• Competitive compensation
• Comprehensive benefits such as: medical insurance, dental, vision, long term/short term disability, life insurance and more
• Pension plan
• Opportunities for advancement and ongoing professional development
• Educational allowance

POSITION SUMMARY

Support Branch Operations by transforming the company’s data into meaningful and useful information for business purposes. Understand branch business data, processes, and systems to build analytics that support business strategy. This position reports to the General Manager , Aftermarket sales.

POSITION DESCRIPTION

• Design, develop, implement, and maintain reports and ad-hoc queries providing actionable information to personnel.
• Provide data analysis for requests from branch personnel, management, branch operations management, and corporate stakeholders.
• Develop performance dashboards to enable staff to accurately gauge results.
• Ensure data integrity and credibility by understanding business requirements, qualifying data, and reconciling results with financial reporting where appropriate.
• Collaborate with different teams to analyze functional requirements.
• Interpret results and communicate status reports and important findings to management and decision-makers.
• Communicate project expectations and status to team members and stakeholders clearly and concisely.
• Test changes in business systems or reporting tools that could impact report quality and provide documented test results.
• Provide support to users of existing and new systems through training and documentation.
• Make decisions regarding systems’ security related to financial information and master data access.
• Monitor technological changes in the Company IT environment to achieve efficiencies and reporting from collected data.
• Provide technical support to Branch Operations and other departmental personnel as needed.
• Increase productivity by developing automated applications and coordinating information requirements.
• Assist in special financial and business-related studies and cooperate with other departments in preparing analyses.
• Provide input for programming changes requested from Branch Operations.
• Assist management with special projects as needed.
• Perform other duties as assigned.
• 2-4 years of related experience. Two plus years of experience developing complex queries in SQL is preferred.
• Bachelor’s degree in Business, Accounting, Computer Science, IT, or equivalent experience is preferred.
• Occasional travel (0-5%) and overnight stays (0-5%).
• Experience with advanced visualization tools such as SSRS, Tableau, or Power BI.
• Strong written, verbal, analytical, and interpersonal skills.
• Keen understanding of business objectives and ability to recommend and implement analytics development.
• Good analytical and problem-solving skills with the ability to handle multiple tasks simultaneously.
• Proficient with Microsoft Office applications (Excel, PowerPoint, Word).
• Demonstrated ability to create executive-level information from complex data sets.

At Crown Lift Trucks, we believe in fairness and transparency. While most of our hiring decisions are made by people, we may use technology, including AI-based tools, to assist with parts of the process such as screening or assessments. If this happens, it is always supported by human review.

We welcome applicants with diverse backgrounds and do not require Canadian work experience for this role.

This job posting is for an existing vacancy (not for a future candidate pool).

Please note that we currently require all new hires to complete a criminal reference check to be eligible for employment.

We are an equal opportunity employer. In accordance with the Accessibility for Ontarians with Disabilities Act, 2005 and the Ontario Human Rights Code, Crown Lift Trucks will provide accommodations throughout the recruitment and selection process to applicants with disabilities. If selected to participate in the recruitment, selection, and/or assessment process, please inform Human Resources of the nature of any accommodation(s) that you may require to ensure your equal participation.