ABOUT US
Almost 1.2 million residents call York Region home, making it one of the largest regions in Canada – and the fastest growing with a population that’s expected to grow to more than 2 million by 2041. Our geography, which is comprised of about 1,800 square kilometers over nine different municipalities, is as beautiful, interesting and diverse as our people. Local government is organized in a two-tier structure and we work together with our local municipalities to provide residents and businesses access to a broad selection of services and resources.
WHAT WE OFFER
Consistently named one of Canada’s Best Employers by Forbes, we offer a collaborative, progressive workplace that takes pride in our organizational culture and is committed to living The 13 Factors of Psychological Health and Safety in the Workplace – aligned with our vision to create strong, caring and safe communities both within and outside our walls.
- 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 an employee health care spending account, access to a 24/7 Employee and Family Assistance Program and corporate discounts and purchase plans for day-to-day products and services. Casual employees are eligible to receive payment in lieu of benefits and/or vacation.
- 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.
ABOUT THE ROLE
This position is responsible for the development and delivery of the data migration strategy and work-stream plan for the Region’s enterprise resource planning (ERP) system; establishing data governance, ensuring accurate data transfer, and maintaining data quality, integrity, and relevance through implementation.
WHAT YOU WILL BE DOING
- Develops data strategy and plan for the project ensuring alignment with business objectives and the Region’s overarching data strategy.
- Establishes data governance for the ERP, including data access controls, data ownership, and data stewardship.
- Leverages processes, templates materials as developed by DAVS and adheres to established policies / standards (i.e. Data Governance).
- Ensure all work activities associated with the identification cleansing, enrichment, extract, transform and load of data from legacy systems into new ERP system solution are auditable and accurate.
- Facilitates the development of data deliverables.
- Collaboratively works with project team in relation to preparation of project plan for data activities, cutover tasks, deployment activities, and risk management.
- Responsible for providing estimates and status reporting to the project manager(s) for data cleansing and migration related activities.
- Approves all data deliverables and work products.
- Ensures data quality and readiness prior to data migration cycles.
- Develops ETL (Extract, Transform, Load) processes to ensure data consistency and accuracy.
- Extracts and stages data from various Region systems for transformation and migration.
- Establishes data validation rules to capture technical and functional data validation results.
WHAT WE ARE LOOKING FOR
- Successful completion of a University Degree in Computer Science or approved equivalent combination of education and experience.
- Minimum five (5) years experience in large data conversion projects backed by strong understanding of ETL processes, data cleansing and data loading for master and transactional data, including a minimum two (2) years of direct supervisory experience.
- Demonstrated knowledge of relevant program development, applicable legislation and industry standards, and current practices.
- Demonstrated knowledge of relevant Standards, Acts and Regulations.
- Ability to demonstrate the Region’s core and leadership competencies for this level.
- Demonstrated report writing, analytical and project management skills to meet program objectives and work to tight deadlines.
- Demonstrated ability to plan, coordinate, implement and evaluate programs and services in assigned program area, and to develop and implement change management plans.
Demo
Street, PA
Full Time