All jobs within 50 km around Bedford Park-Nortown in IT & Telecoms

Status: Full Time, Permanent 

Education Level: 4-year University education in computer science, computer/software engineering or other relevant programs within data engineering, data analysis, artificial intelligence, or machine learning.

Location(s):  Pickering, ON

Travel: 10%

Deadline to Apply: September 18, 2024.

Salary Range: $1,651.02 - $2,832.86 Per Week

Ontario Power Generation (OPG) is looking for dynamic, strategic, and results-drivenprofessional to join our team in the role of a Data Developer.   

Reporting to the Senior Manager, IT Programs, the Data Developer is primary responsible for building and supporting the data driven applications which enable innovative, customer centric digital experiences. You will be working as part of a cross-discipline agile team who help each other solve problems across all business areas. You will build reliable, supportable & performant data lake & data warehouse products to meet the organization’s need for data to drive reporting analytics, applications, and innovation. You will employ best practice in development, security and accessibility to achieve the highest quality of service for our customers.

KEY ACCOUNTABILITIES

• Build and productionize modular and scalable data ELT/ETL pipelines and data infrastructure leveraging the wide range of data sources across the organization
• Implement curated common data models that offer an integrated, business-centric single source of truth for business intelligence, reporting, and downstream system use, in collaboration with Data Architect
• Work closely with infrastructure and cyber teams to ensure data is secure in transit and at rest
• Clean, prepare and optimize datasets for performance, ensuring lineage and quality controls are applied throughout the data integration cycle
• Support Business Intelligence Analysts in modelling data for visualization and reporting, using dimensional data modeling and aggregation optimization methods
• Troubleshoot issues related to ingestion, data transformation and pipeline performance, data accuracy and integrity
• Collaborate with business analysts, data scientists, data engineers, data analysts, solution architects and data modelers to develop data pipelines to feed our data marketplace
• Assist in identifying, designing, and implementing internal process improvements: automating manual processes, optimizing data delivery, re-designing infrastructure for greater scalability, etc.
• Work with tools in the Microsoft Stack; Azure Data Factory, Azure Data Lake, Azure SQL Databases, Azure Data Warehouse, Azure Synapse Analytics Services, Azure Databricks, Microsoft Purview, and Power BI
• Work within the agile SCRUM work management framework in delivery of products and services, including contributing to feature & user story backlog item development, and utilizing related Kanban/SCRUM toolsets
• Assist in building data catalog and maintenance of relevant metadata for datasets published for enterprise use
• Develop optimized, performant data pipelines and models at scale using technologies such as Python, Spark and SQL, consuming data sources in XML, CSV, JSON, REST APIs, or other formats
• Document as-built pipelines and data products within the product description, and utilize source control to ensure a maintainable code-base
• Implement orchestration of data pipeline execution to ensure data products meet customer latency expectations, dependencies are managed, and datasets are as up-to-date as possible, with minimal disruption to end-customer use
• Create tooling to help with day to day tasks, and reduce toil via automation wherever possible
• Work with Continuous Integration/Continuous Delivery and DevOps pipelines to automate infrastructure, code delivery and product enhancement isolation and proper release management and versioning
• Monitor the ongoing operation of in-production solutions, assist in troubleshooting issues, and provide Tier 2 support for datasets produced by the team, on an as-required basis
• Implement and manage appropriate access to data products via role-based access control
• Write and perform automated unit and regression testing for data product builds, assist with user acceptance testing and system integration testing as required, and assist in design of relevant test cases
• Participate in peer code review sessions, and approve non-production pull requests
• Other Duties as Required

EDUCATION

• 4-year University education in computer science, computer/software engineering or other relevant programs within data engineering, data analysis, artifical intelligence, or machine learning

QUALIFICATIONS

• Minimum 6 years experience with Data Engineering 
• Experience as a Data Engineer building data pipelines.
• Fluent in creating data processing frameworks using Python, PySpark, SparkSQL and SQL
• Experience with Azure Data Factory, ADLS, Synapse Analytics and Databricks
• Experience building data pipelines for Data Lakehouses and Data Warehouses
• Good understanding of data structures and data processing frameworks
• Knowledge of data governance and data quality principles
• Effective communication skills to translate technical details to non-technical stakeholders

What Makes a Career at OPG Different? 

As Ontario’s largest clean energy generator, we’re building, expanding, and innovating the equipment and technology that keeps Ontario powered with clean, reliable energy.  

At OPG, our values are our strengths. They are fundamental truths about our organization that don’t change:  

Safety – it’s our business 
Integrity – always lead with integrity 
Excellence – never satisfied with good enough  
Inclusion – working together for powerful outcomes 
Innovation - creativity accelerates possibility. 

Here's why OPG might just be the ideal workplace for you: 

• Exceptional range of opportunities province-wide 
• Long-term career growth and development opportunities 
• Electricity is vital to the province and OPG’s clean electricity is helping decarbonize other sectors. 

Our promise to you: 

• We care about the safety and the well-being of our employees. It is our utmost priority. 
• A supportive work environment where you can be your best every day. 
• Opportunities to stretch and develop. 

• Offer different ways for you to give back to communities where we operate. 
• Partner with Indigenous communities and support local businesses. 
• We support employment equity, diversity and inclusion. 

Are you ready to start a career that has the power to electrify life on and off the job? Apply now. 

Reporting to the Manager, Cybersecurity, the Junior Cybersecurity Specialist role is pivotal in fortifying the organization's digital assets and information security by proactively monitoring, analyzing, and responding to security incidents.

The Junior Cybersecurity Specialist contributes to the development and enhancement of cybersecurity policies and procedures. This position focuses on staying ahead of evolving cyber threats to ensure the confidentiality, integrity, and availability of systems. The primary goal is to strengthen defense mechanisms, conduct thorough risk assessments, and provide timely insights to maintain a resilient and secure IT environment.

Responsibilities:

• Assist in the design, deployment, and maintenance of monitoring and network security systems
• Review and perform maintenance on existing server policy and process configurations
• Assist in deploying and configuring new servers within security and monitoring silos
• Participate in planning, developing, and deploying notification systems for performance, security, and health of systems
• Monitor security logs of servers and devices for risks, errors, or intrusions.
• Collaborate in responding to security events as necessary
• Thoroughly document details of cybersecurity incidents, including the nature of the incident, actions taken, and lessons learned. Maintain incident response documentation for post-incident analysis and reporting
• Contribute to the documentation of cybersecurity policies and procedures, ensuring clarity and adherence to industry standards. Assist in keeping documentation up-to-date to reflect changes in security practices and compliance requirements
• Document findings and results from regular security monitoring, generating reports for management and relevant stakeholders. Maintain records of security metrics and key performance indicators
• Collaborate with cross-functional teams to ensure documentation aligns with overall IT and cybersecurity objectives. Document collaborative efforts and knowledge-sharing within the cybersecurity team
• Enforce and maintain security policies across network devices, updating firewall rules and access controls
• Assist with Managing and configuring security appliances, while troubleshooting issues to ensure proper functioning
• Act as initial escalation point for other staff for Cybersecurity issues

Requirements:

• Four (4) year University degree in Computer Science with a networking, server infrastructure, or cybersecurity focus, or equivalent professional experience
• Certified in Cybersecurity ISC2 (CC) is preferred, or willingness to complete
• Willing to consider current students and recent graduates from post-secondary educational institutions
• CompTIA Security+ certification is preferred
• Knowledge of Deployment Models in a Microsoft Server environment
• Knowledge of Active Directory and Domain Administration is an asset
• Network protocol and firewall knowledge
• Understanding of VLAN and tunneling configurations
• Relevant training in security related technology, risk mitigation and techniques

This position is eligible for hybrid work.

As a condition of employment, the City of Oshawa will require successful candidates to undergo a Criminal Records and Judicial Matters Check.

The Cybersecurity Specialist role is pivotal in fortifying the organization's digital assets and information security by proactively monitoring, analyzing, and responding to security incidents.

The Cybersecurity Specialist contributes to the development and enhancement of cybersecurity policies and procedures. This position focuses on staying ahead of evolving cyber threats to ensure the confidentiality, integrity, and availability of systems. The primary goal is to strengthen defense mechanisms, conduct thorough risk assessments, and provide timely insights to maintain a resilient and secure IT environment.

Responsibilities:

• Assist in the design, deployment, and maintenance of monitoring and network security systems
• Review and perform maintenance on existing server policy and process configurations
• Assist in deploying and configuring new servers within security and monitoring silos
• Participate in planning, developing, and deploying notification systems for performance, security, and health of systems
• Monitor security logs of servers and devices for risks, errors, or intrusions.
• Collaborate in responding to security events as necessary
• Thoroughly document details of cybersecurity incidents, including the nature of the incident, actions taken, and lessons learned. Maintain incident response documentation for post-incident analysis and reporting
• Contribute to the documentation of cybersecurity policies and procedures, ensuring clarity and adherence to industry standards. Assist in keeping documentation up-to-date to reflect changes in security practices and compliance requirements
• Document findings and results from regular security monitoring, generating reports for management and relevant stakeholders. Maintain records of security metrics and key performance indicators
• Collaborate with cross-functional teams to ensure documentation aligns with overall IT and cybersecurity objectives. Document collaborative efforts and knowledge-sharing within the cybersecurity team
• Enforce and maintain security policies across network devices, updating firewall rules and access controls
• Assist with Managing and configuring security appliances, while troubleshooting issues to ensure proper functioning
• Act as initial escalation point for other staff for Cybersecurity issues

Requirements:

• Four (4) year University degree in Computer Science with a networking, server infrastructure, or cybersecurity focus, or equivalent professional experience
• Certified in Cybersecurity ISC2 (CC) is preferred, or willingness to complete
• CompTIA Security+ certification is preferred
• Knowledge of Deployment Models in a Microsoft Server environment
• Extensive knowledge of Active Directory and Domain Administration
• Extensive network protocol and firewall knowledge
• Firewall manufacturer’s certification
• Extensive understanding of VLAN and tunneling configurations
• Relevant training in security related technology, risk mitigation and techniques

Posting End Date: 2024/04/16

This position is eligible for hybrid work.

As a condition of employment, the City of Oshawa will require successful candidates to undergo a Criminal Records and Judicial Matters Check.