Business Intelligence Analyst
Top Benefits
About the role
Page Break
POSITION TITLE: Business Intelligence (BI) Analyst
LOCATION: Collingwood
MacLean Engineering is looking for a talented and energetic Business Intelligence (BI) Analyst to add to the existing skills of our team. If you are passionate about turning data into actionable insights, enjoy working with advanced visualization tools, and want to grow your career with a world-renowned company in the design and manufacturing of mobile mining equipment, this position is for you!
About the Position: The BI Analyst plays a key role in delivering data-driven decision support across the organization. Using Microsoft Power BI as the primary tool, you will create meaningful and impactful reports, interactive dashboards, and key performance indicators (KPIs). You will source and integrate data from a variety of systems, including SQL databases, custom APIs, and OData feeds from Dynamics AX / Dynamics 365 Finance and Operations (F&O), to provide timely and accurate insights that drive operational efficiency, product performance, and strategic initiatives in our underground mining equipment business. The following proficiencies are required:
- Collaborate with stakeholders across to understand business requirements and translate them into data models, reports, and dashboards.
- Design, develop, and maintain interactive Power BI reports and dashboards that visualize key metrics, trends, and KPIs for manufacturing, equipment performance, sales, and operational processes.
- Extract, transform, and load (ETL) data using Power Query, SQL queries, custom APIs, and OData connections from Dynamics AX F&O and other enterprise systems.
- Build and optimize data models in Power BI, including relationships, calculated columns, measures using DAX, and hierarchies to support complex analysis.
- Ensure data accuracy, integrity, and security in all reporting solutions, including implementing refresh schedules and governance practices.
- Identify opportunities to automate reporting processes and improve data accessibility for end-users.
- Perform root-cause analysis on data discrepancies and provide recommendations for process improvements.
- Present insights and findings to technical and non-technical audiences, including executive leadership, to support decision-making.
- Stay current with Power BI features, best practices in BI, and industry trends in mining/manufacturing analytics.
- Perform other related duties as assigned.
About You**:** The successful candidate(s) must be willing to learn, open-minded and flexible, organized and detail oriented, team oriented, disciplined, and must have a positive attitude, along with the following qualifications:
- Diploma or Degree in Computer Science, Information Systems, Business Analytics, Data Science, Engineering, or a related discipline.
- Three or more (3+) years’ experience in a Business Intelligence, Data Analyst, or similar role, with proven expertise in Power BI.
- Strong proficiency in Microsoft Power BI (including Power Query, DAX, data modeling, and dashboard development).
- Solid SQL skills for querying and manipulating data from relational databases.
- Experience connecting to and integrating data from OData sources (especially Dynamics 365 Finance and Operations / Dynamics AX) and custom APIs.
- Familiarity with ETL processes and data integration techniques.
- Excellent analytical and problem-solving skills with the ability to interpret complex data sets.
- Strong communication skills, both written and verbal, to convey technical concepts to non-technical stakeholders.
- High level of computer literacy and proficiency with Microsoft Office suite (Excel advanced functions an asset).
- Proven ability to manage multiple priorities in a dynamic environment.
- High level of professionalism, honesty, and integrity.
- Bilingualism is an asset (French and/or Spanish are desirable).
- Experience in manufacturing, heavy equipment, or mining industry is beneficial but not required.
About Us*:*
Founded in 1973 in Ontario, Canada, MacLean Engineering is the world’s largest Canadian-based manufacturer of underground mining equipment. While continuing to expand both our product range and global footprint, we remain privately owned and committed to the founder’s original design principles: safety, productivity, and enduring quality. Our company delivers mobile equipment solutions for both underground and surface mining, supported by unit-of-one manufacturing expertise and a global service network.
Driven by a strong commitment to safety, productivity, and customer support, MacLean serves mining operations worldwide through branches in Canada, the United States, Mexico, Peru, South Africa, and Australia. We operate five manufacturing facilities located in Collingwood, Owen Sound, Barrie, North Bay, and Mexico, and employ over 1,000 people across six countries and four continents. The next chapters of MacLean’s mining innovation story are being written within the broad themes of electrification, automation, and digitalization of the global mining industry.
Our skilled tradespeople work in a safety‑first environment to build high‑quality components and equipment for the underground mining, municipal, environmental, and industrial sectors. Join MacLean and contribute to a legacy defined by innovation, craftsmanship, and meaningful impact.
We offer competitive wages and benefits including:
- 3 weeks' vacation annually
- Paid sick and family emergency time
- Paid overtime after 40 hours worked
- Free coffee!
- Flexible Group benefits Package (Once probationary period is completed)
- Employee and family assistance program
- Voluntary DPSP (Deferred Profit-Sharing Plan) and GRRSP (Group Registered Retirement Savings Plan) (Once probationary period is completed)
- Annual Employee Bonus
- $250 annual safety shoe allowance
- $200 biennial prescription safety glasses allowance
- Employee appreciation days, raffles/draws, BBQ’s and much more
If you are interested in being a part of an established and growing Canadian Company, we want to hear from you!
We thank all applicants in advance for their application and interest in MacLean Engineering & Marketing Co Limited. However, only those candidates selected for an interview will be contacted.
Please note that employment with MacLean Engineering is contingent upon the successful completion of a background check conducted by our third-party provider, Sterling Backcheck. This process may include verification of employment history, education, and a criminal record check, depending on the requirements of the position.
MacLean Engineering & Marketing Co. Limited is an equal opportunity employer and is committed to providing employment accommodation in accordance with the Ontario Human Rights Code and the Accessibility for Ontarians with Disabilities Act (2005).
MacLean Engineering & Marketing Co. Limited will provide accommodations to job applicants with disabilities throughout the recruitment process. If you require an accommodation, please notify us and we will work with you to meet your needs.
About MacLean Engineering & Marketing Co Limited
Great Things Happen Here
Equipping the mining world with innovative mobile equipment solutions is what we do at MacLean, but more importantly is the why. We aspire to be best-in-class leaders in the design, manufacturing, and support of engineered solutions that make mining safer, greener, and more productive. This brand promise is inextricably linked to our people.
We are building a diverse, top-performing employee base by hiring entrepreneurial, creative, hardworking, ethical, and safety focused candidates who want to make a lasting difference and build a career doing it. If this sound like you, dive in and join the MacLean innovation wave!
Join the MacLean innovation wave!
We are a global, family-owned company where we treat each other, our customers, and our host communities as if they were family. This is our competitive differentiator across the board when it comes to employee development, customer relationships, and business results.
Our production facility and branch footprint on four continents and market reach into six continents is in keeping with the scope of our ambition to develop paradigm-changing, tech-enabled mining vehicles the world over. This transformative vision requires a wide range of talent working together across the company’s manufacturing, engineering, product management, marketing, sales, aftermarket support, finance, and human resource functions.
Who we are
MacLean specializes in mobile equipment solutions based on underground mining experience, unit-of-one manufacturing expertise, and worldwide customer service and support.
We have been innovating for mining equipment safety and productivity for almost 50 years, supporting customers worldwide with branches across Canada as well as in the United States, Mexico, Peru, South Africa, and Australia.
Our Story
MacLean is the world’s largest Canadian-based underground mining vehicle manufacturer.
From modest beginnings retrofitting farm tractors out of an apple orchard barn in Southern Georgian Bay, Ontario, to today’s multi-national corporate network of some 1,000 employees across four continents and six countries, the next chapters of the MacLean mining innovation story are actively being written within the broad themes of the electrification, automation, and digitalization of the global industry.
The constant across the shifting sands of time and geography is the MacLean commitment to pursuing engineered solutions that make the underground environment safer and more productive.
The foundation for all of our work together is a shared culture of entrepreneurial innovation and customer focus. When we create what we call MacLean ‘Application Intelligence’ for the mining sector, we are leveraging multi disciplinary engineering expertise, continental manufacturing capacity, and decades of mining knowledge, to deliver safety and productivity enhancing solutions to the end-users who operate and maintain our products in underground mines around the globe.
We are a major employer in our host communities and, as such, we strive to be an employer of choice. On the leading edge of technological and manufacturing innovation, we never lose sight of the people behind the machines – the MacLean employees across our production facilities who work to create products of lasting value for the mining sector.
Our Values
The MacLean Way is our overarching vision, mission, and values statement. It is the embodiment of our history, present, and future: where we came from, who we are now, and where we are going.
Business Intelligence Analyst
Top Benefits
About the role
Page Break
POSITION TITLE: Business Intelligence (BI) Analyst
LOCATION: Collingwood
MacLean Engineering is looking for a talented and energetic Business Intelligence (BI) Analyst to add to the existing skills of our team. If you are passionate about turning data into actionable insights, enjoy working with advanced visualization tools, and want to grow your career with a world-renowned company in the design and manufacturing of mobile mining equipment, this position is for you!
About the Position: The BI Analyst plays a key role in delivering data-driven decision support across the organization. Using Microsoft Power BI as the primary tool, you will create meaningful and impactful reports, interactive dashboards, and key performance indicators (KPIs). You will source and integrate data from a variety of systems, including SQL databases, custom APIs, and OData feeds from Dynamics AX / Dynamics 365 Finance and Operations (F&O), to provide timely and accurate insights that drive operational efficiency, product performance, and strategic initiatives in our underground mining equipment business. The following proficiencies are required:
- Collaborate with stakeholders across to understand business requirements and translate them into data models, reports, and dashboards.
- Design, develop, and maintain interactive Power BI reports and dashboards that visualize key metrics, trends, and KPIs for manufacturing, equipment performance, sales, and operational processes.
- Extract, transform, and load (ETL) data using Power Query, SQL queries, custom APIs, and OData connections from Dynamics AX F&O and other enterprise systems.
- Build and optimize data models in Power BI, including relationships, calculated columns, measures using DAX, and hierarchies to support complex analysis.
- Ensure data accuracy, integrity, and security in all reporting solutions, including implementing refresh schedules and governance practices.
- Identify opportunities to automate reporting processes and improve data accessibility for end-users.
- Perform root-cause analysis on data discrepancies and provide recommendations for process improvements.
- Present insights and findings to technical and non-technical audiences, including executive leadership, to support decision-making.
- Stay current with Power BI features, best practices in BI, and industry trends in mining/manufacturing analytics.
- Perform other related duties as assigned.
About You**:** The successful candidate(s) must be willing to learn, open-minded and flexible, organized and detail oriented, team oriented, disciplined, and must have a positive attitude, along with the following qualifications:
- Diploma or Degree in Computer Science, Information Systems, Business Analytics, Data Science, Engineering, or a related discipline.
- Three or more (3+) years’ experience in a Business Intelligence, Data Analyst, or similar role, with proven expertise in Power BI.
- Strong proficiency in Microsoft Power BI (including Power Query, DAX, data modeling, and dashboard development).
- Solid SQL skills for querying and manipulating data from relational databases.
- Experience connecting to and integrating data from OData sources (especially Dynamics 365 Finance and Operations / Dynamics AX) and custom APIs.
- Familiarity with ETL processes and data integration techniques.
- Excellent analytical and problem-solving skills with the ability to interpret complex data sets.
- Strong communication skills, both written and verbal, to convey technical concepts to non-technical stakeholders.
- High level of computer literacy and proficiency with Microsoft Office suite (Excel advanced functions an asset).
- Proven ability to manage multiple priorities in a dynamic environment.
- High level of professionalism, honesty, and integrity.
- Bilingualism is an asset (French and/or Spanish are desirable).
- Experience in manufacturing, heavy equipment, or mining industry is beneficial but not required.
About Us*:*
Founded in 1973 in Ontario, Canada, MacLean Engineering is the world’s largest Canadian-based manufacturer of underground mining equipment. While continuing to expand both our product range and global footprint, we remain privately owned and committed to the founder’s original design principles: safety, productivity, and enduring quality. Our company delivers mobile equipment solutions for both underground and surface mining, supported by unit-of-one manufacturing expertise and a global service network.
Driven by a strong commitment to safety, productivity, and customer support, MacLean serves mining operations worldwide through branches in Canada, the United States, Mexico, Peru, South Africa, and Australia. We operate five manufacturing facilities located in Collingwood, Owen Sound, Barrie, North Bay, and Mexico, and employ over 1,000 people across six countries and four continents. The next chapters of MacLean’s mining innovation story are being written within the broad themes of electrification, automation, and digitalization of the global mining industry.
Our skilled tradespeople work in a safety‑first environment to build high‑quality components and equipment for the underground mining, municipal, environmental, and industrial sectors. Join MacLean and contribute to a legacy defined by innovation, craftsmanship, and meaningful impact.
We offer competitive wages and benefits including:
- 3 weeks' vacation annually
- Paid sick and family emergency time
- Paid overtime after 40 hours worked
- Free coffee!
- Flexible Group benefits Package (Once probationary period is completed)
- Employee and family assistance program
- Voluntary DPSP (Deferred Profit-Sharing Plan) and GRRSP (Group Registered Retirement Savings Plan) (Once probationary period is completed)
- Annual Employee Bonus
- $250 annual safety shoe allowance
- $200 biennial prescription safety glasses allowance
- Employee appreciation days, raffles/draws, BBQ’s and much more
If you are interested in being a part of an established and growing Canadian Company, we want to hear from you!
We thank all applicants in advance for their application and interest in MacLean Engineering & Marketing Co Limited. However, only those candidates selected for an interview will be contacted.
Please note that employment with MacLean Engineering is contingent upon the successful completion of a background check conducted by our third-party provider, Sterling Backcheck. This process may include verification of employment history, education, and a criminal record check, depending on the requirements of the position.
MacLean Engineering & Marketing Co. Limited is an equal opportunity employer and is committed to providing employment accommodation in accordance with the Ontario Human Rights Code and the Accessibility for Ontarians with Disabilities Act (2005).
MacLean Engineering & Marketing Co. Limited will provide accommodations to job applicants with disabilities throughout the recruitment process. If you require an accommodation, please notify us and we will work with you to meet your needs.
About MacLean Engineering & Marketing Co Limited
Great Things Happen Here
Equipping the mining world with innovative mobile equipment solutions is what we do at MacLean, but more importantly is the why. We aspire to be best-in-class leaders in the design, manufacturing, and support of engineered solutions that make mining safer, greener, and more productive. This brand promise is inextricably linked to our people.
We are building a diverse, top-performing employee base by hiring entrepreneurial, creative, hardworking, ethical, and safety focused candidates who want to make a lasting difference and build a career doing it. If this sound like you, dive in and join the MacLean innovation wave!
Join the MacLean innovation wave!
We are a global, family-owned company where we treat each other, our customers, and our host communities as if they were family. This is our competitive differentiator across the board when it comes to employee development, customer relationships, and business results.
Our production facility and branch footprint on four continents and market reach into six continents is in keeping with the scope of our ambition to develop paradigm-changing, tech-enabled mining vehicles the world over. This transformative vision requires a wide range of talent working together across the company’s manufacturing, engineering, product management, marketing, sales, aftermarket support, finance, and human resource functions.
Who we are
MacLean specializes in mobile equipment solutions based on underground mining experience, unit-of-one manufacturing expertise, and worldwide customer service and support.
We have been innovating for mining equipment safety and productivity for almost 50 years, supporting customers worldwide with branches across Canada as well as in the United States, Mexico, Peru, South Africa, and Australia.
Our Story
MacLean is the world’s largest Canadian-based underground mining vehicle manufacturer.
From modest beginnings retrofitting farm tractors out of an apple orchard barn in Southern Georgian Bay, Ontario, to today’s multi-national corporate network of some 1,000 employees across four continents and six countries, the next chapters of the MacLean mining innovation story are actively being written within the broad themes of the electrification, automation, and digitalization of the global industry.
The constant across the shifting sands of time and geography is the MacLean commitment to pursuing engineered solutions that make the underground environment safer and more productive.
The foundation for all of our work together is a shared culture of entrepreneurial innovation and customer focus. When we create what we call MacLean ‘Application Intelligence’ for the mining sector, we are leveraging multi disciplinary engineering expertise, continental manufacturing capacity, and decades of mining knowledge, to deliver safety and productivity enhancing solutions to the end-users who operate and maintain our products in underground mines around the globe.
We are a major employer in our host communities and, as such, we strive to be an employer of choice. On the leading edge of technological and manufacturing innovation, we never lose sight of the people behind the machines – the MacLean employees across our production facilities who work to create products of lasting value for the mining sector.
Our Values
The MacLean Way is our overarching vision, mission, and values statement. It is the embodiment of our history, present, and future: where we came from, who we are now, and where we are going.