Business Systems and Data Specialist (Business Systems Support Specialist)

York Region (The Regional Municipality of York); Newmarket; On-site; CAD 90,000 - 120,000; Full time

Job summary

York Region (The Regional Municipality of York) is seeking a skilled Data Solutions professional to lead data warehousing, BI, and enterprise data initiatives. You will plan, develop, and implement data platforms that support reporting, analytics, and decision-making across the organization.

The role requires five years of experience, proficiency in SQL-based tools, and a strong foundation in data governance, visualization, and collaboration with diverse stakeholders.

Qualifications

• Completion of a post-secondary diploma in IT/CS/Statistics/GIS or related field required.
• Minimum five years of experience in project/solution implementation and data management systems.

Responsibilities

• Lead and architect data warehousing, BI, and enterprise data solutions from concept to delivery.
• Collaborate with stakeholders to determine business requirements and translate them into technical solutions.
• Develop data pipelines, data models, and reporting environments; ensure data quality and security.
• Provide guidance on data acquisition, transformation, and integration with internal systems.
• Research best practices and emerging technologies to improve data platforms and analytics.

Skills

Big Data

Data Science

Analytics

Data Visualization

SDLC Knowledge

Project Management

Communication

Collaboration

Customer Focus

Ownership

Education

Community College Diploma in IT/CS/Statistics/GIS or related field

Tools

MS Office

SharePoint

Salesforce CRM

PowerBI

Tableau

SQL

ArcGIS (ArcMap/ArcInfo/ArcSDE)

SQR

ESB/SOA

Crystal Reports

Job description

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 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.