Business Systems and Data Specialist (Business Systems Support Specialist)

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

Reporting to the Program Manager, Systems Solution and Data Management is responsible for providing support to Community and Health Services Department (C&HS) and AccessYork through automating case management, inspection/investigation management, partner management, event/activity management and other business services/functions using various platforms; assessing business and technology capabilities of systems, business needs and processes, systems design, development and implementation; working in collaboration with Information Technology Services (ITS) and other Departments and Branches relative to data integrity, security, system integration, regulatory compliance needs and ongoing systems maintenance to ensure that business needs of stakeholders are met; and implementing new projects and processes in coordination with ITS Branch staff;  analyzing and integrating systems to link Department systems for client/asset management and other business requirement; providing business solutions to clients by applying technology solutions and tools; providing GIS analysis and solutions in the development of Department GIS applications, including database development, as well as creation and maintenance of spatial data. 

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.
•    Defines business rules, data fields, user interaction interfaces required based on workflow design and reporting requirements.
•    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.
•    Researches new technologies, future systems, software, and hardware components for the Department’s systems and other technology applications and makes system recommendations.
•    Ensures quality management within technology applications through implementation of QA/QC procedures, the development of new standards and procedures, and performance monitoring.
•    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.
•    Works in cooperation with ITS and IAM to ensure that services delivered meet ITS and IAM policies, procedures and standards.

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.