Software Development Specialist (Technical 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 thats expected to grow to more than 2 million by 2041. Our geography which is comprised of about 1800 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 Canadas 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 - Were 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 is responsible for developing software testing enhancing and implementing technology solutions; providing technical support and maintenance for application solutions; creating and maintaining technical documentation; and coordinating development efforts with team members.

CORPORATE ITS GOVERNANCE
Departmental information technology functions work in close collaboration with Corporate Information Technology Services (ITS); consistent with the Information Technology vision and strategy; supporting the development and implementation of Information Technology initiatives programs processes policies and protocols. Corporate ITS provides strategic ITS planning direction and leadership across the Region.

WHAT YOULL BE DOING

• Conceptualizes designs and develops new business intelligencesolutions and applications according to specifications and business requirements.
• Participates in the collection documentation and validation of user requirements including the creation of design documents such as business process maps and user stories in collaboration with Department staff and ITS Branch.
• Participates in the creation of delivery timelines and coordinates these with Regional release schedules and processes.
• Defines develops and documents technical requirements objectives deliverables and specifications in collaboration with internal teams and clients.
• Leverages appropriate documentation standards develops technical and training documentation as well as videos and other multimedia support for applications.
• Establishes advanced ETL data warehousing data modeling reporting/dashboards in/out of applications to encourage user experience feedback to inform continued enhancement direction.
• Collaborates with peers and clients on process improvements and enhancements through a technical perspective and to improve customer experience.
• Participates in multi-branch/department collaborative development teams participates in client meetings related to requirements gathering and attend developers forums and education events.

WHAT WERE LOOKING FOR

• Successful completion of a College Degree in Information Technology Computer Science Computer Programming or technical school or approved equivalent combination of education and experience.
• Minimum 3 years experience with Object Oriented Programming and Server Side Programming and in leading and architecting software solutions using modern software development platforms and integration technologies.
• Data modelling experience using database software and tools (e.g SQL Server Management Studio(SSMS) Oracle SQL Developer / Data Modeller TOAD).
• Demonstrated experience in developing applications using relational databases as MS SQL MySQL NoSQL databases as MongoDB Redis Couchbase and data modelling experience using database software and tools like SQL Developer Data Modeller TOAD Visio UML.
• Understanding of industry security practices such as database codebase and operational security.
• Demonstrated experience in integrating separate systems and technologies and machine to machine communication standards.
• Demonstrated experience conceptualizing and designing applications based on user feedback leveraging an agile development methodology.
• Thorough knowledge of application software development lifecycle.
• Data management skills experience with enterprise integration tools and extract transformation and load (ETL and ESB) tools.
• Proficiency in Relational Database Management System (RDBMS) concepts and advanced experience in creating and using database objects.
• Knowledge and demonstrated ability in corporate core competencies including communication innovation teamwork and collaboration and personal ownership.