Data Architect

Data Architect

Department: Treasury Board Secretariat

Location: Charlottetown / Hybrid Options within PEI

Position: Full-Time 100% Position (Commencing immediately)

Employment Type: Classified (Permanent) - UPSE

Hourly Salary Range: $34.42 - $43.01

Annual Salary Range: $67,119 - $83,870

Pay Level: 17

Bi-Weekly Hours: 75.0 hours bi-weekly

Posting ID: 166056-1224TBPO

Closing Date: Thursday, January 9, 2025 5 p.m.

Open to: Public

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 sexual orientation, gender identities, and gender expressions. Those looking for more information are invited to visit our Equity, Diversity, and Inclusion Policy.

What we offer:

• Flexible working hours
• Hybrid options within PEI
• Health and dental benefits
• Pension Plan
• Up to $2,500 annual training funds
• 3 weeks paid vacation annually

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 role of the Data Architect is to expand the Government's use of data as a strategic enabler of corporate goals and objectives. This includes strategically designing, developing, and implementing data models for enterprise-level applications and systems. The incumbent also acts as the primary advocate of data processing best practices.

The incumbent is expected to work without supervision and supervise other staff on a project basis. As well, the incumbent may be responsible for small to medium projects or portions of medium-large projects.

Duties will include but are not limited to:

• Develop and promote data management methodologies and standards.
• Conduct research, evaluate and make recommendations on data warehousing components,
• including hardware, database management systems, ETL (extract, transform, load) software,
• data mining tools, and meta data management tools in support of procurement and
• development effort.
• Provides Data Architecture planning, creation, modification, and testing services.
• Collaborate with project managers and business unit leaders for all projects involving enterprise data.
• Document the data architecture environment in order to maintain a current and accurate view of the larger data picture.
• Provide support for the data warehousing environment.
• Diagnose and resolve data warehouse access and performance issues.
• Develop, implement and maintain change control and testing processes for modifications to data systems.
• Act as a leader and advocate of data management, including coaching, training, and career development to staff.

Minimum Qualifications:

• Graduation from college or university with a diploma or degree in Computer Science, Business Information Technology, Information Management or a related field.
• Demonstrated equivalencies will be considered.
• Significant experience (5+ years} in the Systems Development area of Information Technology field; Considerable experience (3+ years) in a data architecture or data modeling.
• Hands-on experience with data architecture, data mining, large-scale data modeling, and business requirements gathering/analysis.
• Strong understanding of relational data structures, theories, principles, and practices.
• Hands on knowledge of enterprise repository tools, data modeling tools, data mapping tools, and data profiling tools.
• Demonstrated expertise with repository creation, and data and information system life cycle methodologies.
• Ability to manage data and metadata migration.
• Experience with database platforms, including Oracle, and MS.SQL.
• Experience in managing small projects or managing parts of medium to large projects.
• The successful applicant must provide a satisfactory Criminal Records Check prior to beginning employment.
• Applicants must have a good previous work and attendance record.

This competition may be used to fill future job vacancies.

Preference will be given to UPSE Civil Employees as per the UPSE Civil Collective Agreement.

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.

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.