167768 - Junior CIS Data Architect- Finance - Permanant

The Department of Finance 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 ****** 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 Junior 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 the Clinical Information System (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 will obtain a good working knowledge of the Cerner suite of applications; under supervision, will be responsible for small projects and will work in both an operational and project context with minimal supervision.

Duties will include but are not limited to:

Assist with the Development of SQL queries, and information to support decision making and patient care
Under guidance and direction of the Senior Data Architect, assist with the short- and long-term planning of data mining/analysis projects and initiatives to the Clinical Information System / Health PEI for:
Data marts, data warehouses, Report Delivery Methods
Work with senior staff, determine data entry, retrieval, change and delete functions to meet business requirements for project completion.
Investigate Business Intelligence and technology trends to assist management align specialized information initiatives with business needs;
Leadership/Communications/Interpersonal
Participate in Clinical Information System technical group processes related to Business Intelligence, setting and clarifying objectives, encouraging innovation and change, and resolving system conflicts relative to the CIS environment and related technologies.
Development of Policies and Procedures
Assist with the development of policies and procedures as they relate to standardizing data management, adhoc reporting, sharing of information and results, security, communications, change, quality assurance, and risk management.;
Assist with Small/Medium Projects
Work with the Senior Data Architect and the CIS Health Information Specialist in the implementation and use of Business Intelligence (Reporting) methods
Minimum Qualifications:

University Degree in Computer Science OR diploma in Business Information Technology OR Information Management OR Data Analytics with courses in business intelligence and/or data mining/analysis.
Knowledge of developing/working with Structured Query Language (SQL), Oracle Databases, stored procedures and custom functions preferably in a PL/SQL developer environment usually acquired through programs/certifications and/or college/university courses.
Experience working in a team environment.
Knowledge of Data Warehouses and Data Marts, Online Analytical Processing (OLAP), Advanced Structured Query Language (SQL) and data mining and analysis tools.
Excellent interpersonal, verbal and written communication skills, initiative and ability to work with minimal 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.
Other Qualifications:

Experience with Oracle, PL/SQL and Crystal reports or other similar report development software would be considered an asset
Additional relevant education and experience will be considered an asset.
This competition may be used to fill future 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 (+02) 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 (+02) 368-4080.

No. 6 on Forbes’ list of Canada’s Best Employers 2024

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