Senior Systems Analyst / Lead Programmer

---

Would you like to apply your technical expertise in Business Intelligence (BI) development with the Business Intelligence/Business Analytics Unit, Integrated Health Solutions Branch?

We are in search of an expert to provide technical expertise with respect to Business Intelligence and Data analytics for the overall analysis, design and architecture of large complex I&IT projects and systems solutions for the Ministry of Health and Long Term Care, Ontario.

If this sounds like your next career move, then consider this exciting opportunity with us.

---

About the job

As a Senior Systems Analyst/Lead Programmer, you will:

• Provide team leadership on small to medium sized projects or on larger projects as a member of the team, in the development of solution approach resulting in a cost effective information technology solutions and services.
• Provide technical consulting expertise in the design, development and maintenance of health Business Intelligence and Data analytics applications being implemented to improve information management, processing and reporting.

---

What you bring to the team

TECHNICAL KNOWLEDGE AND SKILLS:

• You have demonstrated knowledge in conducting feasibility studies, cost benefit and risk analyses on complex business systems initiatives and in implementing systems solutions.
• You have demonstrated knowledge and experience in business and systems analysis including use of process and data modelling techniques.
• You have the ability to lead teams through development and testing phases within waterfall and/or iterative methodologies.
• You have demonstrated knowledge of and experience in application development including testing, troubleshooting and documentation.
• You have knowledge of the principles/techniques of large-scale business intelligence and data warehouse / database design, data modelling and information management concepts.
• You have experience in the design and development of BI solutions using IBM Cognos and Cognos Framework Manager or equivalents.
• You have knowledge and experience in Extraction, Transformation and Load (ETL) architecture, design and processes and tools such as Informatica.
• You have knowledge and experience using relational DBMS systems such as Oracle.
• You have knowledge of structured methodologies for the development, design, implementation and maintenance of BI solutions.
• You have experience in Unix/Windows scripting, and other programming languages, and other development tools, architecture and design patterns.

LEADERSHIP AND PROJECT MANAGEMENT KNOWLEDGE AND SKILLS:

• You have knowledge of team leadership techniques and practices.
• You have knowledge of standard project management methodologies and tools to work with project plans, schedules, cost and resource estimates and ensure project team meet deliverables.

COMMUNICATION SKILLS:

• You have oral and written communication skills to explain detailed technical information and make recommendations.
• You have interpersonal skills to deal with complaints, provide clarification and secure consensus for a course of action

ANALYTICAL AND PROBLEM SOLVING SKILLS:

• You have analytical and problem solving skills to identify issues, conduct research and respond appropriately.

---

Additional information:

Note:

• T-HL-110208/17

---

Language requirements and assessment:
All external Ontario Public Service (OPS) job ads are posted in English and French. Check the "position(s) language" section at the top of each job ad for the language requirements. For all roles, candidates are assessed in English, the business language of the OPS. If the position is bilingual (English/French), you'll also need to pass a French-language proficiency test.

Exigences en matière de langue et évaluation:
Toutes les offres d'emploi externes de la fonction publique de l'Ontario (FPO) sont affichées en français et en anglais. Consultez la section « Langue du ou des postes » en haut de chaque offre d'emploi pour connaître les exigences linguistiques. Pour tous les postes, les candidats sont évalués en anglais, la langue d'affaires de la FPO. Si le poste est bilingue (anglais/français), vous devrez également passer un test de compétences linguistiques en français.