Role Overview
You will design, build, and optimise data pipelines that integrate complex work order histories, maintenance strategies, and production metrics. Working directly with reliability and operations teams, your data models will provide the foundation for predictive maintenance and asset criticality reporting across major industrial sites.
Responsibilities
- Design, build, and optimise data pipelines integrating work order histories, maintenance strategies, and production metrics
- Collaborate with reliability and operations teams to develop data models for predictive maintenance and asset criticality reporting
- Leverage Snowflake Dynamic Tables for automated, declarative data transformations and complex multi-dataset SQL joins
- Utilise Python (pandas, NumPy) for data wrangling, statistical analysis, and asset performance modelling
- Apply relational data modelling to connect hierarchical asset structures with high-volume transactional maintenance and production records
- Explore and apply Snowflake Cortex capabilities for AI-driven operational insights
Requirements
- Proven commercial experience in data engineering and Python analytics, with strong command of pandas and NumPy
- Advanced SQL capability, specifically writing complex joins across disparate datasets within Snowflake, including hands-on experience with Snowflake Dynamic Tables
- Solid grounding in relational data modelling for enterprise-scale environments
- Domain knowledge of maintenance and asset management data (work orders, maintenance plans, maintenance strategies, asset criticality, and production data)
- Exposure to Snowflake Cortex highly regarded
- Immediate availability or short notice period to commence ASAP through to end of June