Business Systems and Data Specialist (Business Systems Support Specialist)

York Region Transit; Newmarket; Hybrid; CAD 89,000 - 97,000; Full time

Job summary

York Region in Newmarket, Ontario, is seeking a Business Systems and Data Specialist (Business Systems Support Specialist) for a temporary full-time replacement. The role focuses on data warehousing, BI, and enterprise data solutions to support reporting, analytics, and decision-making.

Hybrid work opportunities may apply, with start date immediate and a six-month assignment. The incumbent will lead data pipelines, models, and reporting environments, while coordinating with internal staff and

Qualifications

• Minimum five years experience in data management systems and SDLC.
• Analytical skills to analyze user requirements and design solutions.
• Knowledge of trends in data management and analytics.
• Strong communication and collaboration with stakeholders.

Responsibilities

• Lead and implement data warehousing, BI, and data integration solutions.
• Develop data pipelines and optimize reporting environments.
• Provide systems expertise and guidance to internal staff and vendors.
• Collaborate with stakeholders to resolve issues and improve processes.
• Research best practices and document data acquisition and transformation processes.

Job description

Business Systems and Data Specialist (Business Systems Support Specialist) - (9985)

Job Title

Business Systems and Data Specialist (Business Systems Support Specialist)

Status

Temporary Full-Time

Temporary - Approximate length of assignment, in months

6

Type of Position

a Replacement

Start Date

Immediate

Per hour

Salary Grade

$64.81 - $70.45

Department

York Region -> Corporate Services -> Digital & Customer Experience

Location

Digital Data Technology and CX - 17150 Yonge Street - Newmarket, ON L3Y 8V3 CA (Primary)
Hybrid work opportunities may apply - CA

Job Description (E)

ABOUT US
Almost 1.3 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 2051. 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
Recognized by Forbes as one of Canada’s Best Employers, 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 Municipal 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.
• 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
Reporting to the Program Manager, System Solutions and Data Management, this position is responsible for researching, planning, developing, and implementing data warehousing, business intelligence, and enterprise data solutions that support organizational reporting, analytics, and decision-making. The role supports the maintenance and day-to-day performance of existing business technologies, enterprise systems, and data platforms, while leading or participating in projects related to data integration, data modelling, reporting, and analytics.
The incumbent provides technical leadership and guidance on department business technology initiatives and enterprise data management priorities, including the design, development, and optimization of data pipelines, data warehouses, business intelligence solutions, and reporting environments. The position researches, recommends, and implements solutions to ensure business objectives are met, with a focus on leveraging emerging technologies, cloud-based data platforms, intelligent automation, predictive analytics, and modern data engineering practices to deliver scalable and reliable information solutions.

WHAT YOU'LL BE DOING

• Leads, architects, designs, builds and implements customized solutions using various platforms to support C&HS and AccessYork service delivery improvement and automation initiatives/projects from start to finish and/or within pre-build/configured template.
• Determines business requirements in collaboration with stakeholders using the systems.
• Creates and maintains project life-cycle workflow and validates workflow with stakeholders.
• Creates predictive/prescriptive/statistical models/algorithms to analyze operational system data, spatial data and other process models data to identify patterns, to understand and provide insights into client and program operational behaviours using visual analytics and documents those results.
• Works with stakeholders to determine and resolve recurring issues related to functionality, systems integration and concerns identified by users.
• Monitors and analyzes business solutions/ processes and related systems interfaces and integration with external systems to ensure trouble free operation.
• Researches professional standard frameworks, models and business systems functionality and sector best practices to review and recommend process improvements.
• Researches, organizes, implements and documents data acquisition, transformation, creation and maintenance processes and ensures data meets Department’s quality requirements.
• Liaises with internal staff, providing systems expertise and support to ensure consistent and effective systems performance and utilization of systems to maximum functionality; shares information regarding initiatives and other best practices with Branch and Departmental staff.
• Liaises with external contractors, vendors, and suppliers on general troubleshooting, updates, maintenance and support contracts and to ensure system performance, as appropriate and in consultation with ITS and Geomatics Division.
• Performs other duties as assigned, in accordance with Branch and Department objectives.

WHAT WE'RE LOOKING FOR

• Successful completion of a Community College Diploma in Information Technology, Computer Sciences, Statistics, GIS or related field or approved equivalent combination of education and experience.
• Minimum five years experience in providing project/business solution implementation analysis, and support in data management systems, data integrity, security/privacy and understanding of programming development cycle (SDLC).
• Experience in project management and leading project teams.
• Experience and demonstrated ability on functional and technical levels of solution/data systems used with C&HS, GIS and other technology systems and in the use of relational databases.
• Understanding of Big Data, Data Science, Statistics, Analytics and Data Visualization technologies.
• Computer literacy and knowledge utilizing MS Office software and other applications/platforms such as relational database systems, Computerized Workflow Management Systems (BPM), SharePoint, Salesforce CRM, ActiveNet, SQL, SQR, Enterprise Service Bus (ESB) / Service Oriented Architecture (SOA), Analytics Tools (e.g. Tableau, PowerBI), ArcMap, ArcInfo, ArcSDE, relational database systems and Microsoft Access, and Crystal Reports tools.
• Knowledge of trends in the use of current technology as it relates to data management systems.
• Analytical skills to analyze user requirements, identify issues and to design, develop and implement applications and recommend solutions.
• Knowledge and demonstrated ability in corporate core competencies including customer focus, communication, collaboration and personal ownership.

Scheduled Weekly Hours

35

Scheduled Shifts

8:30 - 16:30

Operational Hours

Close Date

November 18, 2026

# of Hires Needed

1

Union

CUPE Local 4900

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 [e-mail] or call 1-877-464-9675 extension 75506. Accommodations for applicants with disabilities are available upon request during recruitment processes and throughout employment.