174609 - Clinical Information System Data Architect - Treasury Board Secretariat - Permanent

The Treasury Board Secretariat is committed to Equity, Diversity, Inclusion and Accessibility. Our goal is to build a public sector workforce that reflects the diverse communities we serve and to promote welcoming, diverse, inclusive, respectful workplaces that are accessible to all. We welcome all interested individuals including Indigenous People, persons with disabilities, Black, racialized, ethnic and culturally diverse groups, as well as people regardless of their sexual orientation, gender identities, and gender expressions. Those looking for more information are invited to visit our Equity, Diversity, and Inclusion Policy.

Our Vision: Forward-looking people, service, and technology.

Our Mission: Our Team proudly delivers quality IT expertise and advice with our partners to make citizen and business-centric service possible.

The Clinical Information System (CIS) Data Architect role meets the immediate and long-term information needs of Health PEI through the strategic development and maintenance of information infrastructures for CIS. The role supports administrative and patient care activities across the broad spectrum of health care services, supported by the CIS, through the use of new and existing databases, data warehouses and applications. The incumbent must maintain a good working knowledge of the Cerner suite of applications; will be responsible for small/medium projects as well as portions of large projects; and will work in both an operational and project context with minimal supervision.

Duties will include but are not limited to:

• Provide leadership and direction to the Clinical Information System / Health PEI for:
  • short- and long-term planning of data mining/analysis projects and initiatives (e.g. data marts, data warehouses, Report Delivery Methods).
  • design and architecture of databases, data marts, flat files and data warehouse(s)
• Assess, validate, develop, test and deploy:
  • Complex data extracts and operational and ad hoc reports with data from the Clinical Information System (CIS) as it pertains to information which will
    • support Health PEI in achieving their strategic direction
    • support the operation of Prince Edward Islands health care facilities and contribute to overall patient care and safety and minimize clinical risk
• Provide maintenance and operational support for all areas mentioned above as well as Canned Cerner reports, queries, exports and rules as well as other specialized information systems and tools as necessary. (Enhancement, troubleshooting, performance tuning, etc)
• Work with the CIS IT Consultant - Reporting to collaborate with the CIS Clinical Analysts, Health PEI managers and staff as well as other stakeholders to gather programming and reporting/data requirements and parameters and assist in the data validation of data extracts and report design.
• Lead groups in technical processes related to Interfaces and Business Intelligence within the Clinical Information System environment, setting and clarifying objectives, encouraging innovation and change, and resolving conflicts relative to the Clinical Information System environment and related technologies.
• Work with the CIS IT Consultant - Reporting to direct, organize and lead projects, in the implementation and use of new Business Intelligence (Reporting) and Interface tools and systems.

Minimum Qualifications:

• University degree in Computer Science with extensive experience in the IT field and considerable experience in business intelligence and/or data mining/analysis environment OR diploma in Business Information Technology or Information Management with extensive experience in the IT field and extensive experience in business intelligence and/or data mining/analysis environment;
• Demonstrated equivalencies will be considered
• Considerable experience developing/working with Structured Query Language (SQL), Oracle Databases, stored procedures and custom functions preferably in a PL/SQL developer environment;
• Experience managing projects, prioritizing and managing multiple tasks simultaneously and working in a team environment;
• Experience with Crystal reports or other similar report development software is required;
• Knowledge of Data Warehouses and Data Marts, Online Analytical Processing (OLAP), Advanced Structured Query Language (SQL) and data mining and analysis tools;
• Experience working with Cerner Millennium suite of Applications or Cerner’s CCL programming language and development tools would be a preferred;
• Excellent interpersonal, verbal and written communication skills, initiative and ability to work without supervision;
• Applicants must have a good previous work and attendance record. The successful applicant must provide a satisfactory Criminal Records Check prior to beginning employment;

This competition may be used to fill future job vacancies.

Please Note: Please ensure the application clearly demonstrates how you meet the noted qualifications as applicants will be screened based on the information provided. We would like to thank all applicants for their interest; however, only those who are selected for an interview will be contacted.

Where possible, submitting an electronic resume or job application is preferred. Otherwise, please return forms to PEI Public Service Commission, P.O. Box 2000, Charlottetown, Prince Edward Island, C1A 7N8. Applications may be sent by fax to (902) 368-4383.

IT IS THE RESPONSIBILITY OF THE APPLICANT TO CONFIRM RECEIPT OF THE APPLICATION, BY TELEPHONE OR IN PERSON PRIOR TO THE CLOSING DATE.

Please ensure that the appropriate Posting ID number is stated on all application forms. You can apply online or obtain an application form by visiting our web site at www.jobspei.ca. Forms may also be obtained by contacting any PEI Government office, ACCESS PEI Centre, Regional Services Centre, or by telephone (902) 368-4080.

Voted as one of Forbes' top 45 Best Employers in Canada for 2026

The Public Service is inspired to make a positive impact and proud to shape the future of our Island Community.