Equipment Data Analyst

MacLean Engineering; Southwestern Ontario; On-site; CAD 95,000 - 130,000; Full time

Job summary

MacLean Engineering invites a Data Engineer to join a new Data team building pipelines that transform telematics and operational data into trusted analytics and customer products. You will migrate from legacy telemetry to a cloud data warehouse, while shaping streaming data from connected vehicles.

You’ll work across ingestion, transforms, and data modeling to power dashboards, KPIs, and predictive maintenance, collaborating with Platform, Vehicle Interface, and product stakeholders.

Qualifications

• Minimum 3 years of experience in data engineering or related discipline.
• Bachelor’s degree or higher in computer science, software engineering, data engineering, or related field.
• Strong Go and SQL programming; Python is an asset.
• Hands-on experience with cloud data warehouses, Snowflake preferred.
• Experience building ingestion or streaming pipelines using Kafka, RabbitMQ, 0MQ, or NATS.
• Familiarity with industrial IoT protocols and data contracts is a plus.

Responsibilities

• Build and operate ingestion pipelines from vehicles and legacy systems into the cloud warehouse.
• Develop and maintain transforms unifying historical, batch, and streaming telemetry sources.
• Model data across raw, curated, and semantic layers for downstream dashboards and analytics.
• Support data science with reliable feature datasets for predictive maintenance and anomaly detection.
• Collaborate on observability platforms and migration to modern data tooling.
• Follow CI/CD, testing, and containerized deployment standards.

Skills

Go

SQL

Python

Communication skills

Education

Bachelor’s degree in CS/SE/Data Eng or related field

Tools

Snowflake

Kafka

RabbitMQ

NATS

Docker/Kubernetes

Job description

At MacLean Engineering, we’re not just building machines — we’re redefining the future of mining through innovation. 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 collaborates in a safety centric environment to deliver superior components and equipment to the underground mining, municipal, environmental, and industrial sectors.

The Position:

We’re seeking a Data Engineer to join a new Data team building the pipelines and datasets that turn telematics and operational data from MacLean’s vehicles into trusted analytics and customer-facing products. Reporting to the Team Lead – Data, you’ll be a hands-on contributor on the migration from our legacy telemetry platform to a modern cloud data warehouse, and on the streaming pipeline that lands next-generation field data from connected vehicles.

You’ll work across the full ingestion-to-consumption path: change-data-capture from legacy relational systems into the cloud warehouse, streaming consumers landing high-frequency vehicle data, and curated transforms that unify historical, batch, and streaming sources into a single schema defined by our vehicle data semantics contract. Downstream, your datasets power MacLean’s commercial telemetry products: fleet utilization reporting, fault and signal-health alerting, OEM KPI dashboards, and a roadmap toward predictive maintenance and anomaly detection.

This role sits within the Telematics, Automation, and Controls Division and partners closely with the Platform team, the Vehicle Interface team, and product stakeholders. You’ll write production Go and SQL day to day, operate at the intersection of industrial IoT and modern data platforms, and ship across MacLean’s 32+ vehicle types and global footprint.

Responsibilities and Duties:

• Build and operate ingestion pipelines from vehicles and legacy systems into the cloud warehouse — including change-data-capture from relational sources, streaming consumers writing high-frequency telemetry, and refactoring existing batch ingestion onto the new platform.
• Develop and maintain curated transforms that unify historical, batch, and streaming telemetry sources into a single schema aligned to our vehicle data semantics contract.
• Model data in the warehouse across raw, curated, and semantic layers, and build the certified datasets that downstream dashboards, alerts, and analytics products consume.
• Build the data flows behind MacLean’s commercial telemetry products — utilization reporting, hour meter-based dashboards, fault and signal-health alerting, OEM KPI dashboards, operator and shift analysis, and near-real-time data delivery for streaming use cases.
• Implement schema management, data contracts, data quality checks, and SLA monitoring across pipelines and datasets, including dual-read and dual-write validation during migration cutovers.
• Write production Go services and SQL transforms; contribute Python where appropriate for analytics tooling and ML feature pipelines.
• Partner with the Platform team on the messaging subject namespace, message envelope standards, and stream provisioning — consuming the platform’s governance model rather than defining it, and surfacing data-side requirements back to it.
• Partner with the Vehicle Interface team on signal definitions, since the vehicle data semantics contract is the structural source of truth for curated datasets.
• Support the data science workstream by building reliable feature datasets for predictive maintenance, root cause diagnostics, and anomaly detection, and by collaborating on production model pipelines.
• Contribute to the evaluation and integration of a modern observability and analytics platform against curated datasets, and help migrate existing portal use cases onto it.
• Follow team engineering standards for code quality, testing, CI/CD, containerized deployment (Docker/Kubernetes), and release governance for pipelines, datasets, and models.

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:

• Minimum 3 years of experience in data engineering or a closely related discipline, building and operating production data pipelines.
• Bachelor’s degree or higher in computer science, software engineering, data engineering, or a related field.
• Strong programming skills in Go and SQL; proficiency in Python is an asset.
• Hands-on experience with at least one modern cloud data warehouse — Snowflake preferred — and with multi-layer data modeling (raw → curated → semantic, or Bronze/Silver/Gold)..
• Experience building ingestion or streaming pipelines using technologies such as Kafka, RabbitMQ, 0MQ, or NATS. Familiarity with NATS JetStream and the Snowflake Streaming SDK is an asset
• Working knowledge of industrial or IoT protocols such as OPC UA and MQTT (including Sparkplug B), and a willingness to ramp on the OPC UA information model.

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.
• Practical experience with CDC, schema management, data contracts, and data quality frameworks.
• Experience with containerized deployment (Docker, Kubernetes) and CI/CD for data pipelines.
• Working knowledge of one or more BI or observability tools (e.g., Power BI, Grafana, Observe) sufficient to build and validate dashboards on top of curated datasets.
• Strong verbal and written communication skills in English.
• Proficiency in Spanish is an asset given cross-site collaboration with our Queretaro, Mexico office.
• Experience in mining, industrial, or heavy-equipment telematics is an asset.
• Exposure to MLOps practices or production ML feature pipelines is an asset.

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 (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.