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.

Systems Administrator

Organizational 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:

The System Administrator will serve as a technical steward for hybrid Microsoft environments, overseeing infrastructure, security, and application administration across on-premises and Azure platforms. This role includes managing Microsoft Dynamics 365 and Microsoft Fabric components, ensuring seamless data integration, analytics, and system performance. Responsibilities span network operations, VoIP systems, cybersecurity compliance, and disaster recovery planning, with a strong emphasis on collaboration, documentation, and support for enterprise-wide digital transformation initiatives.

Reporting to the Manager of IT Infrastructure or designate, this position is located at the Guelph office at 104 Cooper Drive, Guelph. Ontario One Call has a hybrid work model with staff dividing their workweek between in-office and at-home work per company policy.

Primary Responsibilities:

• Administer and maintain hybrid Microsoft environments (on-premises and Azure).
• Support and configure Microsoft Fabric components for data integration and analytics.
• Monitor and manage network infrastructure, including switches, firewalls, and wireless access points.
• Administer and maintain Microsoft Dynamics 365 environments, including user provisioning, role-based access controls (RBAC), workflows, plugins, and integrations with third-party systems.
• Monitor and manage network infrastructure (switches, firewalls, wireless access points, VPNs, load balancers) ensuring uptime, redundancy, and performance optimization.
• Manage Windows Server, Active Directory, Azure AD, DNS, DHCP, and Group Policy configurations.
• Implement and maintain automated backup and recovery procedures across systems.
• Implement and maintain firewall rules and security policies across multiple platforms.
• Administer VoIP phone systems for call center operations, ensuring high availability and performance.
• Provide system administration for Microsoft Dynamics 365 CRM, ensuring seamless integration with contact centre platforms (e.g., Genesys Cloud CX).
• Collaborate with business and data teams to support data ingestion, transformation, and analytics pipelines within Microsoft Fabric and Power BI environments.
• Support integrations between Dynamics, Azure, and corporate systems such as FMS (Financial Management System).
• Maintain system documentation, architecture diagrams, change management logs, and runbooks.
• Maintain accurate system documentation, configuration baselines, and CMDB updates.
• Prepare regular reports on system availability, incident metrics, and cybersecurity posture.
• Participate in IT audits, ensuring alignment with internal control frameworks and IT policies.
• Act as an accountable technical steward for hybrid infrastructure and Dynamics environments, ensuring alignment with organizational risk appetite and digital transformation goals.
• Collaborate with vendors and internal teams to troubleshoot and resolve system issues.
• Maintain system documentation, procedures, and change management records.
• Participate in disaster recovery planning and execution.
• Implement and maintain firewall rules, endpoint protection, and multi-factor authentication (MFA) across all systems.
• Conduct regular vulnerability scans, patch management, and threat detection activities using Microsoft Defender, Sentinel, or equivalent tools.
• Support security compliance with NIST, ISO 27001, CIS, and Ontario’s cybersecurity directives.
• Manage and monitor user access controls, ensuring least privilege and adherence to DOFMA and Segregation of Duties (SoD) principles.
• Respond to security incidents and coordinate root cause analysis and post-incident reporting.
• Maintain audit logs and participate in internal/external security and compliance audits.
• Provide Tier 2/3 technical support for escalated infrastructure, VoIP, and Dynamics-related incidents.
• Collaborate with internal teams, vendors, and managed service providers to resolve complex issues and optimize performance.
• Participate in disaster recovery (DR) and business continuity (BCP) planning, testing, and execution.
• Ensure proactive monitoring and alerting for system health using tools such as Azure Monitor, Sentinel, or equivalent.
• Support onboarding, offboarding, and access provisioning in alignment with HR and IT policies.

Qualifications:

• Experience with Intune, Conditional Access Policies, and asset management
• Strong understanding of networking principles, firewall configurations, and security best practices.
• Experience managing VoIP systems in a call center environment.
• Familiarity with Windows Server, Active Directory, DNS, DHCP, and Group Policy.
• Strong problem-solving and analytical skills.
• Excellent communication and documentation abilities.
• Ability to work independently and as part of a team.
• Customer-focused mindset with a commitment to service excellence
• Experience with Genesys Cloud contact center platform an asset.
• Knowledge of HPE Aruba networking solutions is an asset.
• Familiarity with HPE Alletra storage systems is an asset.
• Experience with Palo Alto Networks firewalls and security appliances is an asset.
• Relevant certifications (e.g., Microsoft Certified: Azure Administrator, CCNA, Palo Alto PCNSA).

Education & Experience:

• College Diploma or University degree in IT, Computer Science, or a related field preferred; or a relevant discipline or combination of post-secondary education and experience.
• 2-3 years of experience in systems administration within a Microsoft hybrid environment.
• Hands-on experience with Microsoft Azure and Microsoft Fabric.

Rewards:

• Starting salary of $75,000 - $85,000/annum dependent on qualifications and experience, with room to grow
• A comprehensive company paid benefit plan through Desjardins Life (at 3 months of service)
• CAAT DBPlus Pension Plan with Contribution Choice and Company Match (at 3 months of service)
• 3 weeks paid vacation
• 10 personal emergency days per year
• 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.