Data Analyst

POSITION TITLE: Data Analyst

LOCATION: Sudbury, Collingwood, Barrie or Waterloo Ontario; Querétaro, Mexico

At MacLean Engineering, we're not just building machines – we're pioneering innovations, that redefine industry standards. We are looking for a Data Analyst who is passionate about pushing the boundaries of engineering excellence and wants to be at the forefront of technological advancements in the mining industry. We prioritize safety, integrity, and teamwork in everything we do by ensuring that every member of our team feels respected, heard, and inspired to excel. Join us in building a brighter future together at MacLean Engineering

The Position: As a Data Analyst within our Telematics Automation and Controls division, you'll play a key role in transforming data into meaningful insights that guide business decisions and improve operational efficiency. Collaborating closely with cross-functional teams of engineers, you'll design and execute clear, accurate analyses that capture the essence of complex problems while remaining flexible to evolving business needs. This role offers an exciting opportunity to apply your analytical expertise and technical skills to deliver high-impact insights in a dynamic, fast-paced environment.

The Telematics group is shaping how data is collected, transformed, and leveraged across our connected fleet of underground and surface mining equipment. As a Data Analyst II, you'll play a key role in building the analytical foundation that powers our cloud-based insights platform. You'll develop and maintain reliable data models, dashboards, and reporting pipelines that turn complex vehicle and operational data into actionable intelligence for our engineering and field teams, and key stakeholders.

Working closely with software developers within the Cloud Interface team, you'll ensure data integrity, optimize query performance, and design analyses that scale across multiple product lines and data sources. This role sits at the intersection of analytics, cloud technology, and heavy industry, offering a unique opportunity to deliver measurable impact in one of the most data-rich and demanding environments in the world.

Responsibilities and Duties:

• Design and implement medium-sized analytical projects and data solutions that deliver reliable insights across the cloud analytics platform.
• Write clean, efficient, and well-documented queries and transformations across multiple data environments, including SQL, time-series databases, and non-SQL databases.
• Develop and maintain datasets, dashboards, reports and visualization tools that transform complex telematics and equipment data into actionable insights for engineering, operations, and leadership teams.
• Collaborate closely with developers, customer support and product stakeholders to clarify data requirements and ensure analyses align with business and technical objectives.
• Apply best practices in data modeling, validation, and reproducibility to ensure analytical outputs are accurate, interpretable, and easy to maintain.
• Participate actively in code and query reviews, incorporating feedback to improve analytical performance and maintainability.
• Build and monitor key data quality metrics, ensuring data accuracy, completeness, and timeliness across connected systems and cloud interfaces.
• Identify and resolve inconsistencies or scaling issues across datasets, documenting data lineage, logic, and assumptions for team reference.
• Support the design, testing, and validation of new data pipelines or integrations that connect machine-generated data with cloud services and analytics tools.
• Write clear, useful documentation, including data dictionaries, analytical design notes, and usage guides for dashboards and reusable datasets.
• Act on mentorship and feedback from senior analysts and engineers, contributing to a culture of continuous learning and improvement.
• Proactively flag data risks, inconsistencies, or dependency issues to ensure smooth delivery of high-quality analytical outputs.

Qualifications: The ideal candidate will possess strong communication skills, leadership abilities, and problem-solving capabilities. They will demonstrate organizational skills, discipline, an aptitude for proactive learning, and a positive attitude. Additionally, they should meet the following qualifications:

• Bachelor's degree or higher in Data Science, Computer Science, Engineering, or a related technical field.
• Minimum 5 years of professional experience in data analysis, analytics engineering, or software development involving data systems and cloud-based platforms.
• Strong proficiency in SQL for data querying, transformation, and performance optimization.
• Proficiency in Python for data analysis, scripting, and automation.
• Experience working with time-series databases (e.g., InfluxDB) and non-SQL databases (e.g., MongoDB) is a strong asset.
• Familiarity with data visualization and monitoring tools such as Grafana, Power BI, or similar.
• Solid understanding of data modeling, ETL/ELT processes, and best practices for data validation and reproducibility.
• Experience with at least one major cloud platform (AWS, Azure, or GCP).
• Understanding of cloud-native data architectures, REST APIs, and data ingestion frameworks.
• Awareness of batch vs. streaming data collection and how each applies to telemetry and IoT systems.
• Comfortable working in cross-functional, agile teams and managing deliverables with limited supervision.
• Familiarity with containerized environments (Docker, Kubernetes) and CI/CD pipelines.
• Knowledge of mining, industrial automation, or IoT systems is an advantage.
• Fluency in English is required; proficiency in additional languages is considered an asset.

First Year Goals:

• Develop a strong understanding of the current and future state of MacLean Engineering's cloud data ecosystem, including data sources from connected underground mining equipment, backend systems, and existing analytics workflows.
• Navigate the learning curve to align with the team's development pace, internal tools, and operational processes for data management, validation, and deployment.
• Gain deep familiarity with existing data pipeline, from on-machine telemetry to cloud ingestion, storage, and reporting layers, while identifying opportunities to improve performance and consistency.
• Collaborate with software engineers to redesign and optimize backend structures and APIs to enable more efficient, accurate, and scalable data querying and analysis.
• Contribute to grouping raw data into logical "data bricks" that support robust data modeling, contextualization, and canonical frameworks, improving downstream analytics and dashboard efficiency.
• Support the transition of legacy scripts and code into more scalable, maintainable, and high-performing solutions aligned with data best practices.
• Begin developing reusable datasets and validated pipelines that serve as reliable foundations for dashboards, performance metrics, and advanced analytics.
• Participate in query and code reviews, documentation efforts, and validation processes to strengthen data reliability and team-wide analytical standards.

Closing: Inspired by over 50 years of pioneering excellence, MacLean Engineering continues to lead the way in underground mining equipment solutions. Rooted in our founder's unwavering commitment to safety, productivity, and enduring quality, we are driven by innovation and expansion. With facilities strategically located across Ontario in Collingwood, Owen Sound, Barrie, and Sudbury, and across the globe in Mexico, South Africa, and Australia, our dedicated workforce of skilled tradespeople collaborates in a safety-centric environment to deliver superior components and equipment to the underground mining, municipal, environmental, and industrial sectors. Join us at MacLean Engineering and be part of a legacy built on innovation, quality, and lasting impact

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.

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.

This position will be located in any of our Sudbury, Collingwood, Barrie or Waterloo Ontario; Querétaro, Mexico

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

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.