Address
Form of work
SalaryOPS Commitment to Diversity, Inclusion, Accessibility, and Anti-Racism:
We are committed to build a workforce that reflects the communities we serve and to promote a diverse, anti-racist, inclusive, accessible, merit-based, respectful and equitable workplace.We invite all interested individuals to apply and encourage applications from people with disabilities, Indigenous, Black, and racialized individuals, as well as people from a diversity of ethnic and cultural origins, sexual orientations, gender identities and expressions.
Visit the OPS Anti-Racism Policy and the OPS Diversity and Inclusion Blueprint pages to learn more about the OPS commitment to advance racial equity, accessibility, diversity, and inclusion in the public service.
We offer employment accommodation across the recruitment process and all aspects of employment consistent with the requirements of Ontario's Human Rights Code. Refer to the "How to apply" section if you require a disability-related accommodation.
What can I expect to do in this role?
In this role, you will:• provide strategic data resource management, assess Branch requirements and develop data management strategies and plans;
• co-ordinate the development, maintenance and control of the Branch's Databases and Data Warehouse and related documented processes and procedures;
• ensure appropriate integration and connectivity of a number of emergency health systems and applications with the Branch's Databases and Data Warehouse;
• manage the development, maintenance and uninterrupted running of all interface processes feeding data to the Branch's Databases and Data Warehouse
• co-ordinate the development and provision of standard and ad hoc reports;
• monitor database performance, tuning the database environment, ensure best overall use of technology and optimum on-line systems performance;
• conduct capacity planning and system resource allocation;
• co-ordinate/provide technical support and resolve technical and operational problems;
• coordinate services with vendors and IT support specialists;
• provide expert advice on database, data warehousing and data management developments, technologies and methodologies;
• advise applications specialists/contractors regarding database design and data management issues;
• conduct cost/benefit analyses and feasibility studies, make recommendations and prepare business cases to support new or enhanced technologies
• lead projects for database design and development or to manage changes to hardware, software, applications or linkages; and
• conduct on-going liaison and consultation with clients, users and stakeholders regarding database and data warehouse needs, operations and changes.
How do I qualify?
Technical Knowledge and Skills
You have knowledge of the following:• current and emerging technologies, methodologies and tools associated with databases, data management, data warehousing, data modelling and design, the full systems life cycle, IT security, Internet applications and IT connectivity
• PC-based and server-based systems technologies, networks, and data management tools such as Microsoft Power BI
• systems and relational database analysis such as SQL Server databases
• disk architecture and expertise in tuning the database for performance
• user environments, client support issues and client data access tools
Leadership and Project Management Skills
• you have knowledge of project management methodologies and procurement policies and practices• you have project management and technical leadership skills to advise on technical requirements of the databases and data warehouse and lead database development and change management projects.
Analytical, Problem-Solving and Organizational Skills
• you have analytical skills in assessing the data management requirements of the Branch and clients• you can lead the development of standards and processes for the databases and data warehouse
• you can analyze user needs in a multi-client environment and develop client access systems, processes and procedures that support user requirements while protecting the security of the system and integrity of data.
• you have analytical and problem-solving skills to ensure the smooth running of all aspects of the databases and Data Warehouse by monitoring performance, tuning the environment and providing timely technical support to resolve problems
• you can provide advice and identify new technologies and tools on data management strategies and standards to branch management and applications developers
• you have organization, co-ordination and administration skills to guide and manage database and data warehouse administration
Communication and Interpersonal Skills
• you have oral communication skills to: liaise and consult extensively with clients regarding data management requirements in both technical and non-technical language, provide direction to staff and vendors, and provide training to clients• you have written communication skills to: prepare reports, technical analyses, and recommendations for Branch management; develop business cases; prepare systems documentation; and prepare informational materials for clients.
• you have consultation, negotiation and interpersonal skills to consult extensively with clients and stakeholders and to negotiate contracts with vendors of services, equipment and hardware/software within established
parameters
Other Essential Abilities and Knowledge:
• you have the ability to learn the policies, standards and objectives relating to information technology, and emergency health services• you have the ability to interpret policy and legislative requirements affecting data processing and freedom/privacy of information
• you have knowledge of training techniques to co-ordinate the development and delivery of training for Branch staff and clients.
