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.
