Business Analyst

Job summary

The Business Analyst will design, develop, and maintain reports and dashboards to transform branch data into actionable business insights. They will collaborate with various teams to analyze functional requirements, ensure data integrity, and provide technical support for business systems.

Job details

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. KNOW HOW & EXPERIENCE * 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. #HP

What you’ll do

The Business Analyst will design, develop, and maintain reports and dashboards to transform branch data into actionable business insights. They will collaborate with various teams to analyze functional requirements, ensure data integrity, and provide technical support for business systems.

Requirements

Candidates should have 2-4 years of related experience, with a preference for proficiency in SQL and advanced visualization tools like Tableau or Power BI. A bachelor's degree in Business, Accounting, Computer Science, or IT is preferred, along with strong analytical and communication skills.

Benefits

• Medical insurance • Dental insurance • Vision insurance • Long term disability • Short term disability • Life insurance • Pension plan • Professional development • Educational allowance

Listed skills

• Power BI · Preferred
• SQL · Preferred
• Tableau · Preferred
• Problem solving · Preferred
• Financial Reporting · Preferred
• Data analysis · Preferred
• Communication · Preferred
• Reporting · Preferred
• Microsoft Office · Preferred
• Technical Support · Preferred

Other relevant skills

Identified from the job description. Confirm important requirements above.

• SQL
• Data analysis
• Business intelligence
• Reporting
• Dashboard development
• Data integrity
• Tableau
• Power BI
• SSRS
• Microsoft Office
• Analytical skills
• Problem-solving
• Communication
• Technical support
• Financial reporting
• Aftermarket Sales
• Talent Management
• Business Objectives
• Data Access
• Microsoft Excel
• Accounting
• Artificial Intelligence
• Data Analysis
• Dashboard
• Management
• Business Requirements
• Business Systems
• Computer Science
• Data Integrity
• Financial Statements
• Forklift Truck
• Functional Requirement
• Leadership
• Interpersonal Communications
• Problem Solving
• Material Handling
• Operations Management
• Operations
• Microsoft PowerPoint
• SQL (Programming Language)
• SQL Server Reporting Services
• Business Strategies
• Tableau (Business Intelligence Software)
• Coordinating
• Reporting Tools

Job areas

• Data & Analytics
• Logistics
• Technology
• Finance & Accounting
• Management & Leadership
• Business Analyst
• Business Analyst (General)
• Management and Organization Analysts
• Management Analysts