Data Engineering Co-op
Top Benefits
About the role
Data Engineering Co-op
Company Overview:
Ontario One Call (OOC) is a Public Safety Administrative Authority; protecting Ontario by enabling safe digging. At OOC, public safety is at the heart of everything we do.
Since 2012, in Ontario, it's the law that any party planning to dig must contact OOC before they dig. OOC connects people planning to dig with the owners of underground pipes, cables, and other infrastructure to help prevent costly damages, service disruptions, and safety hazards. We also regulate an efficient locate system, foster industry wide collaboration, and promote safe, timely excavation across Ontario.
OOC is governed by a diverse Board of Directors, with experienced leaders representing underground infrastructure owners, excavators, ministry appointees and others dedicated to protecting Ontarians. Together, we work to shape a safer Ontario through collaboration, regulation, and education.
Safe Excavation starts with us.
Why Join Us?
Ontario One Call offers dynamic career opportunities in various areas such as operational services, compliance, regulatory affairs, communications, education, IT, finance and HR. When you join our team, you become an integral part of our mission-driven organization, dedicated to making Ontario safer, one dig at a time.
Core Values:
Caring…We invest in the success and safety for our team, communities and the environment.
Integrity...We are dedicated, honourable and honest.
Collaborative...We foster partnerships and work together to build a safer Ontario.
Inclusive...We are a leader in inclusivity and cultivate a foundation of respect and support within our industry.
Innovative...We strive for excellence with a willingness to learn, adapt and innovate.
Do you have what it takes to join our team?
Position Overview:
Reporting to the Development and Reporting Manager, the Data Engineering Co-op will drive data-driven decision-making within OOC by leveraging data analytics techniques. The Data Engineering co-op will be responsible for assisting in designing, building, and deploying comprehensive reporting and analysis solutions. This position requires a basic understanding of data engineering, databases, along with the ability to provide technical expertise to data engineers and other stakeholders.
This position is located at the Head Office in Guelph with the opportunity to work a hybrid model of splitting their time between work and the office as per company policy.
Learning Outcomes:
- Gain practical exposure to enterprise data environments and governance frameworks.
- Develop an understanding of modern data lifecycle practices from ingestion to analytics.
- Build technical and soft skills needed for careers in data engineering, governance, or analytics.
Primary Responsibilities
- Assist in the collection, validation, and organization of data from structured and unstructured sources.
- Support data profiling, cleansing, and standardization efforts to ensure high data quality and consistency.
- Help apply metadata tagging and classification to enhance discoverability and cataloging.
- Support development of data models and visualizations that align with business objectives and reporting needs.
- Collaborate on designing performance dashboards and reusable report templates.
- Ensure consistency and accuracy across data representations used in decision-making.
- Contribute to the design of scalable and modular data pipelines for staging, transformation, and consumption layers.
- Help implement incremental data loading strategies to optimize resource usage and reduce processing time.
- Participate in efforts to benchmark and monitor data pipeline performance, identifying areas for improvement.
- Assist in documenting data lineage, stewardship roles, and access controls.
- Support the implementation of data retention policies, quality frameworks, and audit readiness practices.
- Help align data handling processes with compliance and governance frameworks.
- Participate in cross-functional meetings to understand stakeholder needs and align data solutions accordingly.
- Provide status updates, raise risks, and contribute to planning discussions.
- Maintain clear and thorough documentation of work for knowledge sharing and continuity.
Qualifications:
- Familiarity with data modeling, query languages, scripting, and visualization techniques.
- Strong analytical thinking and ability to identify and resolve inconsistencies in data.
- Willingness to learn and apply best practices in data privacy, access management, and cataloging.
- Effective communicator who is proactive, collaborative, and eager to contribute to team success.
- Ability to manage tasks independently and deliver within set timelines.
Preferred Qualifications:
- Previous experience with data analysis or reporting is a plus.
- Knowledge of statistical methods
Education & Experience:
- Currently enrolled in a program related to Data Science, Computer Science, Information Systems, Business Analytics, or a closely related discipline.
- Must be eligible to complete a co-op placement through an accredited post-secondary institution.
Rewards:
- $21 - $24/hr dependent on qualifications and experience
- Highly engaged workforce and excellent workplace culture
- Diverse and inclusive environment
- Collaborative team
- New, clean and bright facility
Imagine a workplace where everyone feels valued and respected. At Ontario One Call, we are committed to making this a reality through our Inclusion, Diversity, Equity & Accessibility (IDEA) initiatives, policy and committee. To achieve this, OOC strives to create a supportive work environment and a culture that welcomes diversity and uniqueness and encourages equitable opportunities for employees. Every individual person deserves respect, dignity and a sense of belonging. We encourage applications from individuals of all backgrounds, including those who may be underrepresented in our industry.
In accordance with the Human Rights Code and the Accessibility for Ontarians with Disabilities Act, Ontario One Call is pleased to offer accommodations for job applicants with disabilities, if you require accommodations, please advise by contacting us. Application reviews are done by a human.
We thank all applicants for their interest; however only those candidates selected for an interview will be contacted.
We are currently recruiting for this open position.
About Ontario One Call
Established in 1996, Ontario One Call is a not-for-profit organization that acts as a communications link between buried infrastructure owners (our members) and individuals who are planning to dig in the province of Ontario. In 2012, the Ontario Underground Infrastructure Notification System Act was passed, which stipulates that by law, anyone in the province of Ontario must contact Ontario One Call before they dig.
Though Ontario One Call does not physically mark the lines, pipes, or cables, we relay all dig information to the buried infrastructure owners so they can mark (locate) based on the request you submit. Buried infrastructure owners will then deliver locates, by marking the property with paint and/or sending paperwork directly to you. Locates minimize the risk of infrastructure damage, loss of service, and injury.
Data Engineering Co-op
Top Benefits
About the role
Data Engineering Co-op
Company Overview:
Ontario One Call (OOC) is a Public Safety Administrative Authority; protecting Ontario by enabling safe digging. At OOC, public safety is at the heart of everything we do.
Since 2012, in Ontario, it's the law that any party planning to dig must contact OOC before they dig. OOC connects people planning to dig with the owners of underground pipes, cables, and other infrastructure to help prevent costly damages, service disruptions, and safety hazards. We also regulate an efficient locate system, foster industry wide collaboration, and promote safe, timely excavation across Ontario.
OOC is governed by a diverse Board of Directors, with experienced leaders representing underground infrastructure owners, excavators, ministry appointees and others dedicated to protecting Ontarians. Together, we work to shape a safer Ontario through collaboration, regulation, and education.
Safe Excavation starts with us.
Why Join Us?
Ontario One Call offers dynamic career opportunities in various areas such as operational services, compliance, regulatory affairs, communications, education, IT, finance and HR. When you join our team, you become an integral part of our mission-driven organization, dedicated to making Ontario safer, one dig at a time.
Core Values:
Caring…We invest in the success and safety for our team, communities and the environment.
Integrity...We are dedicated, honourable and honest.
Collaborative...We foster partnerships and work together to build a safer Ontario.
Inclusive...We are a leader in inclusivity and cultivate a foundation of respect and support within our industry.
Innovative...We strive for excellence with a willingness to learn, adapt and innovate.
Do you have what it takes to join our team?
Position Overview:
Reporting to the Development and Reporting Manager, the Data Engineering Co-op will drive data-driven decision-making within OOC by leveraging data analytics techniques. The Data Engineering co-op will be responsible for assisting in designing, building, and deploying comprehensive reporting and analysis solutions. This position requires a basic understanding of data engineering, databases, along with the ability to provide technical expertise to data engineers and other stakeholders.
This position is located at the Head Office in Guelph with the opportunity to work a hybrid model of splitting their time between work and the office as per company policy.
Learning Outcomes:
- Gain practical exposure to enterprise data environments and governance frameworks.
- Develop an understanding of modern data lifecycle practices from ingestion to analytics.
- Build technical and soft skills needed for careers in data engineering, governance, or analytics.
Primary Responsibilities
- Assist in the collection, validation, and organization of data from structured and unstructured sources.
- Support data profiling, cleansing, and standardization efforts to ensure high data quality and consistency.
- Help apply metadata tagging and classification to enhance discoverability and cataloging.
- Support development of data models and visualizations that align with business objectives and reporting needs.
- Collaborate on designing performance dashboards and reusable report templates.
- Ensure consistency and accuracy across data representations used in decision-making.
- Contribute to the design of scalable and modular data pipelines for staging, transformation, and consumption layers.
- Help implement incremental data loading strategies to optimize resource usage and reduce processing time.
- Participate in efforts to benchmark and monitor data pipeline performance, identifying areas for improvement.
- Assist in documenting data lineage, stewardship roles, and access controls.
- Support the implementation of data retention policies, quality frameworks, and audit readiness practices.
- Help align data handling processes with compliance and governance frameworks.
- Participate in cross-functional meetings to understand stakeholder needs and align data solutions accordingly.
- Provide status updates, raise risks, and contribute to planning discussions.
- Maintain clear and thorough documentation of work for knowledge sharing and continuity.
Qualifications:
- Familiarity with data modeling, query languages, scripting, and visualization techniques.
- Strong analytical thinking and ability to identify and resolve inconsistencies in data.
- Willingness to learn and apply best practices in data privacy, access management, and cataloging.
- Effective communicator who is proactive, collaborative, and eager to contribute to team success.
- Ability to manage tasks independently and deliver within set timelines.
Preferred Qualifications:
- Previous experience with data analysis or reporting is a plus.
- Knowledge of statistical methods
Education & Experience:
- Currently enrolled in a program related to Data Science, Computer Science, Information Systems, Business Analytics, or a closely related discipline.
- Must be eligible to complete a co-op placement through an accredited post-secondary institution.
Rewards:
- $21 - $24/hr dependent on qualifications and experience
- Highly engaged workforce and excellent workplace culture
- Diverse and inclusive environment
- Collaborative team
- New, clean and bright facility
Imagine a workplace where everyone feels valued and respected. At Ontario One Call, we are committed to making this a reality through our Inclusion, Diversity, Equity & Accessibility (IDEA) initiatives, policy and committee. To achieve this, OOC strives to create a supportive work environment and a culture that welcomes diversity and uniqueness and encourages equitable opportunities for employees. Every individual person deserves respect, dignity and a sense of belonging. We encourage applications from individuals of all backgrounds, including those who may be underrepresented in our industry.
In accordance with the Human Rights Code and the Accessibility for Ontarians with Disabilities Act, Ontario One Call is pleased to offer accommodations for job applicants with disabilities, if you require accommodations, please advise by contacting us. Application reviews are done by a human.
We thank all applicants for their interest; however only those candidates selected for an interview will be contacted.
We are currently recruiting for this open position.
About Ontario One Call
Established in 1996, Ontario One Call is a not-for-profit organization that acts as a communications link between buried infrastructure owners (our members) and individuals who are planning to dig in the province of Ontario. In 2012, the Ontario Underground Infrastructure Notification System Act was passed, which stipulates that by law, anyone in the province of Ontario must contact Ontario One Call before they dig.
Though Ontario One Call does not physically mark the lines, pipes, or cables, we relay all dig information to the buried infrastructure owners so they can mark (locate) based on the request you submit. Buried infrastructure owners will then deliver locates, by marking the property with paint and/or sending paperwork directly to you. Locates minimize the risk of infrastructure damage, loss of service, and injury.