Skip to content
mimi

Data Engineer

York Region

Rouzerville · Hybrid Full-time CA$64 – CA$69/hr 3w ago

About the role

Job Title

Data Engineer

Employment Type

  • Status: Permanent Full-Time
  • Temporary: Approximate length of assignment, in months
  • Type of Position: a Replacement
  • Start Date: Immediate

Salary

  • Per hour
  • Salary Grade: $63.51 - $69.04

Department

York Region → Public Works → Digital & Process Transformation

Location

17250 Yonge Street, Newmarket, ON L3Y 6Z1, Canada (Primary)
Hybrid work opportunities may apply – Canada

What We Offer

  • Defined Benefit Pension Program – With the Ontario Municipality Employees Retirement System (OMERS) defined benefit pension plan, you can confidently retire knowing that you will have income for life. Eligibility from date of hire as a full‑time employee and includes employer‑matched contributions.
  • Employer of Choice – Recognized as the highest‑ranking government employer in Canada and fourth overall among 300 organizations.
  • Benefits and Wellness – Employees and their loved ones have access to a comprehensive employer‑paid benefits plan that includes extended health, dental and life insurance, access to a 24/7 Employee and Family Assistance Program and corporate discounts and purchase plans for day‑to‑day products and services.
  • Inclusive and Diverse Workforce – We’re committed to fostering an environment that celebrates all dimensions of diversity and ensures everyone can develop to their full potential, participate freely in society and live with respect, dignity and freedom from discrimination. Our robust Inclusion, Diversity, Equity and Accessibility program continues to grow, and has been recognized by the United Nations and many other organizations for our leadership.

Position Purpose

Reporting to the Program Manager, Data Management & Business Intelligence, the Data Engineer is responsible for full‑lifecycle design and development, implementation of new data platforms/solutions, production support, performance tuning of reporting environments including Extract Transform Load (ETL) batch and streaming data processes, and for supporting the integration of those systems with other applications. The role works with internal and external stakeholders, Corporate IT and Data Analytics and Visualization Branch, to provide technical leadership in the analysis, design, implementation, management and support of data‑driven business systems following various departmental technology plans and utilizing approved IT solutions; designs and builds end‑to‑end solutions that enable business stakeholders to self‑serve their business intelligence needs; consults with stakeholders to steer any new or enhancement‑related requirements to ensure stakeholder business needs are met; develops solution alternatives used to ingest and process data; works with multiple cross‑functional teams within IT and the business on developing solutions.

Major Responsibilities

  • Works with ITS and vendors to design, develop and provide solutions to support the data needs of applications, analysis and support of the department’s data management initiatives and related Master Data Management (MDM) processes.
  • Assists in developing data‑centric strategy and department roadmap and obtains stakeholders approval.
  • Analyzes business requirements, suggests alternative approaches to reporting systems design working in collaboration with data and information architects, and prepares a proof of concept for user consultation.
  • Translates complex functional and technical requirements into detailed architecture, designs logical data models, physical databases, and high‑performing software solutions.
  • Maintains business systems documentation, user licenses and renewal procedures.
  • Manages complex data management and reporting projects and leads project teams, ensuring timely delivery of products and services; tracks project activities, timelines and project deliverables.
  • Liaises with internal staff, providing systems expertise and support; share information regarding initiatives and other best practices with Branch, Department and Corporate staff.
  • Performs other duties as assigned, in accordance with Branch and Department objectives.

Qualifications

  • Successful completion of a University Degree in Computer Science, Computer Engineering, Information Technology, or approved equivalent combination of education and experience.
  • Minimum five (5) years demonstrated experience as a technology solutions architect/developer/specialist or similar position/capacity.
  • Must have experience in working with data modeling and analyzing large volume of data. Fluent in relational database, streaming data processing concepts, knowledge of current data management practices.
  • Demonstrated experience in writing complex, highly‑optimized SQL queries across large datasets.
  • Demonstrated knowledge and experience of software solutions development lifecycles/methodologies i.e. agile or other rapid application development methods.
  • Experience providing project implementation analysis and support in data management systems, data integrity and security as it relates to environmental business systems.
  • Experience in unified data modelling for relational and NoSQL database and physical database design; programming languages (e.g., PL/SQL, Visual Basic, SQL, JavaScript, PHP, Node.JS and other open source languages).
  • Web‑based user interface design and development experience using advanced DHTML, CSS, JavaScript, AJAX, jQuery and Bootstrap; knowledge of ETL and visualization tools; Machine Learning concepts and tools (R, Python and JavaScript, FME and SSIS).

Additional Information

  • Council Approval Date:
  • Scheduled Weekly Hours: 35
  • Scheduled Shifts: 8:30 am to 4:30 pm
  • Operational Hours:
  • Close Date: November 17, 2025
  • Number of Hires Needed: 1
  • Union: CUPE Local 4900

Please apply online by 5:00 PM EST of the closing date indicated above.

All employment opportunities are recorded on a 24‑Hour Career Line and may be accessed by calling 1‑877‑464‑9675 ext. 75508. We thank all candidates for their interest; however, only those selected for an interview will be contacted. Please be advised, York Region uses email as the primary means of communication with candidates and does not use AI technology in any part of the recruitment process. Please ensure your email address is up to date, checked frequently (including your spam folder), and accepts messages from unknown users.

York Region is an equal opportunity employer committed to an inclusive, barrier‑free recruitment and selection process. We respect, encourage and celebrate our diversity, aiming to build a qualified workforce that reflects the population we serve. Should you require an accommodation under the Human Rights Code during the recruitment and selection process, including accessible formats and communication supports, please email careers@york.ca or call 1‑877‑464‑9675 extension 75506. Accommodations for applicants with disabilities are available upon request during recruitment processes and throughout employment.

Click here for more details on Benefits and Perks.

Requirements

  • Successful completion of a University Degree in Computer Science, Computer Engineering, Information Technology, or approved equivalent combination of education and experience.
  • Minimum five (5) years demonstrated experience as a technology solutions architect/developer/ specialist or similar position/capacity.
  • Must have experience in working with data modeling and analyzing large volume of data.
  • Fluent in relational database, streaming data processing concepts, knowledge of current data management practices.
  • Demonstrated experience in writing complex, highly-optimized SQL queries across large datasets.
  • Demonstrated knowledge and experience of software solutions development lifecycles/methodologies i.e. agile or other rapid application development methods.
  • Experience providing project implementation analysis and support in data management systems, data integrity and security as it relates to environmental business systems.
  • Experience in unified data modelling for relational and NOSQL database and physical database design; programming languages (e.g. PL/SQL, Visual Basic, SQL, JavaScript, PHP, Node.JS and other open source languages).
  • Web-based user interface design and development experience using advanced DHTML, CSS, JavaScript, AJAX, JQuery and Bootstrap; knowledge of ETL and visualization tools; Machine Learning concepts and tools (R, Python and JavaScript, FME and SSIS).

Responsibilities

  • Works with ITS and vendors to design, develop and provide solutions to support the data needs of applications, analysis and support of the department’s data management initiatives and related Master Data Management (MDM) processes.
  • Assists in developing data centric strategy and department roadmap and obtains stakeholders approval.
  • Analyzes business requirements, suggests alternative approaches to reporting systems design working in collaboration with data and information architects, and prepares a proof of concept for user consultation.
  • Translates complex functional and technical requirements into detailed architecture, designs logical data models, physical databases, and high performing software solutions.
  • Maintains business systems documentation, user licenses and renewal procedures.
  • Manages complex data management and reporting projects and leads project teams, ensuring timely delivery of products and services; tracks project activities, timelines and project deliverables.
  • Liaises with internal staff, providing systems expertise and support; share information regarding initiatives and other best practices with Branch, Department and Corporate staff.
  • Performs other duties as assigned, in accordance with Branch and Department objectives.

Benefits

Defined Benefit Pension Programextended health insurancedental insurancelife insuranceEmployee and Family Assistance Programcorporate discountspurchase plans

Skills

AJAXBootstrapCSSDHTMLETLFMEJavaScriptJQueryMachine LearningNode.JSNOSQLPHPPL/SQLPythonRSQLSSISVisual Basic

Don't send a generic resume

Paste this job description into Mimi and get a resume tailored to exactly what the hiring team is looking for.

Get started free