Business Systems Analyst

Joe Johnson Equipment Innisfil; Innisfil; Hybrid; CAD 70,000 - 90,000; Full time

Job summary

A leading equipment distribution company in Innisfil seeks a Business Systems Analyst to support various business projects. The role includes designing BI solutions, analyzing performance, and improving KPIs. Ideal candidates have a degree in Finance or Computer Science, 3+ years of relevant experience, and proficiency in tools like Power BI and Microsoft Fabric. Join a dynamic team focused on innovation and teamwork.

Benefits

Base Salary + Annual Bonus Opportunity

100% Company Paid Group Benefits

Vacation & Paid Personal days

Employer Matching Retirement Savings Plan

Qualifications

• 3+ years of experience developing BI solutions, preferably in a Microsoft environment.
• Hands-on experience with Microsoft Fabric and Power Platforms.
• Strong understanding of ERP and CRM systems is essential.

Responsibilities

• Design and deliver business intelligence solutions and dashboards.
• Define data strategies aligning with business priorities.
• Enhance data integrity, accessibility, and governance.

Skills

Analytical skills

Collaboration skills

Communication skills

Problem-solving skills

Education

Post-Secondary Degree in Finance or Computer Science

Tools

Power BI

Smartsheet

Microsoft Fabric

Dynamics 365

API development

Job description

Business Systems Analyst

The Business Systems Analyst will support a variety of business projects across Joe Johnson Equipment’s Aftermarket business units through the project life cycle, contribute to the planning process, track KPI’s, analyze project performance and provide insight and recommendations for improvement. This position will support business information systems across the organization and will be responsible for researching, collecting and analyzing business data and transforming data into resources and analytical solutions that will contribute to the Company achieving desired business goals.

BRANCH: Innisfil, Ontario

WORK ENVIRONMENT: Office

EMPLOYMENT TYPE:

• 1 New Opportunity
• Permanent
• Monday-Friday
• 4 days in-office, 1 day work from home (following training)

TOTAL REWARDS OVERVIEW:

• Base Salary + Annual Bonus Opportunity
• Annual Performance Review with Increase Opportunity
• Group Benefits that are 100% paid for by the Company – inclusive of Health, Dental, Life, Disability and Travel coverage
• Vacation & Paid Personal days
• Employer Matching Retirement Savings Plan

POSITION RESPONSIBILITIES:

• Design and deliver business intelligence solutions and dashboards, with Power BI and Smartsheet as key tools.
• Define data strategies that align with business priorities, identifying performance drivers and KPIs
• Build and maintain scalable data infrastructure to answer high-impact business questions
• Translate data into compelling narratives and visuals to inform senior leadership
• Lead efforts to enhance data integrity, accessibility, and governance across the business units
• Integrate new data sources and maintain reporting reliability
• Provide guidance on data structure best practices and scalable architecture
• Investigate root causes of data and process issues, identifying short-term fixes and long-term solutions
• Manage change requests and documentation of enhancements
• Maintain an organized log of requests and resolutions to ensure transparency and accountability
• Other duties and projects as assigned

POSITION REQUIREMENTS/QUALIFICATIONS:

• Post-Secondary Degree in Finance, Computer Science, a related program OR equivalent experience
• Certifications in MS Fabric, Power BI, Dynamics, and Azure.
• Must be able to pass a pre-employment background check.

Experience:

• 3+ years of experience developing BI solutions, preferably in a Microsoft environment.
• Hands-on experience with Microsoft Fabric, Power Platforms, and DAX.
• Experience and sound knowledge of MS Fabric features.
• Strong understanding of ERP and CRM systems
• Experience integrating data from multiple enterprise systems such as Dynamics 365, Smartsheet, or ERP platforms.
• Experience with API development and integration with 3rd-party software.

ABOUT YOU:

• Strong analytical, problem-solving, and collaboration skills.
• Excellent communication skills, able to work and manage teams.
• Experience with leading discussions with counterparts, stakeholders and operations.
• Self-motivated, proactive, and with a strong desire to continuously learn and adapt to new technologies.
• Familiarity with data Lakehouse concepts and modern ETL/ELT tools
• Excellent interpersonal and communication skills – both verbal and written
• Ability to plan and execute assignments with general guidelines and work independently
• Ability to collaborate and work well with individuals within and outside of the organization
• Strong critical thinking, proven analytical and problem-solving skills
• Exceptional attention to detail and accuracy of reporting

Our Core People Values: Leadership, Customer Excellence, Integrity, Inspiration, Teamwork, Innovation and Ambition

WHO WE ARE:

As the foremost distributor of public works equipment, Joe Johnson Equipment (JJE) supplies mobile infrastructure maintenance solutions to municipalities and contractors throughout Canada and the US. Through our extensive branch network, we offer sales, rentals, leases, servicing, and support for vacuum trucks, refuse and recycling collection vehicles, street sweepers, sewer cleaners, and inspection cameras.

JJE is a proud subsidiary of Federal Signal Corporation.

We welcome applications from all qualified persons. If you are contacted for an interview and require any accommodation, please notify Human Resources in advance and we will provide applicable accommodation.