Database Audit Analyst

Role Responsibilities

The Ministry of Primary and Preventative Health Services has an exciting opportunity for you to join our team!

Reporting to the Manager, The Database Audit Analyst is a critical role necessary to ensure the integrity, confidentiality, and appropriate use of sensitive health and financial information within Primary and Preventative Health Services database systems. This position is essential for conducting data access audits, monitoring database activity, identifying inappropriate access through Database Access Monitoring (DAM) alerting, and ensuring compliance with Primary and Preventative Health Services Information Security Management Directives and the Health Information Act (HIA).

This position will be responsible for the following duties: 

• Develop and update security audit methodology and criteria for health information within databases at Primary and Preventative Health Services.
• Report database activity to the appropriate levels within the Ministry.
• Review database configurations to ensure alignment to policy and best practices (“gap analysis”).
• Monitor and set up appropriate alerts indicating potential cases of inappropriate access, including linking to enterprise level SIEM logging repositories.
• Engage with program areas regarding questions concerning data access.
• Develop information seminars as required and create and distribute information circulars.
• Become a subject matter expert in the application of Primary and Preventative Health Services database auditing tools.
• Develop, review and update database tools and understand database audit tool intricacies to ensure the quality of the reports.
• Work with program areas to understand where and when (deployment, configuration) the highly sensitive applications are at risk.
• Develop and maintain mandatory database auditing standards related to application development or procurement.

Please click on this link to view the job description for this position.

APS Competencies

Competencies are behaviors that are essential to reach our goals in serving Albertans. We encourage you to have an in depth understanding of the competencies that are required for this opportunity and to be prepared to demonstrate them during the recruitment process.

This link will assist you with understanding competencies:

https://www.alberta.ca/system/files/custom_downloaded_images/psc-alberta-public-service-competency-model.pdf.

• Agility: Sees the need and readily steps in to help others on the team; anticipates change and adapts behaviour accordingly, open to changes; takes advantage of opportunities to improve program development and implementation processes.
• Build Collaborative Environments: Creates opportunities for project teams and stakeholder to share information; respects others' point-of-view; encourages or facilitates conflict resolution; recognizes performance of all groups involved.
• Creative Problem Solving: Helps manage projects with multiple stakeholders simultaneously and can use planning skills, analytical and creative thinking to arrive at innovative solutions. 
• Develop Networks: Builds relationships by following through on commitments, demonstrating integrity and respect for others; informs key stakeholders of relevant information in a timely manner; seeks and applies the perspectives and needs of colleagues and stakeholders.
• Drive for Results: Sets and accomplishes goals and priorities; factors in complexity of issues and aligns plans based on government direction; removes barriers to collaboration; provides informed advice.
• Develop self and others: Manages a team and provides effective guidance, support, and professional development. Must provide timely and constructive feedback to ensure strong performance and leverage strengths when assigning roles. 
• Systems Thinking: Anticipate outcomes and potential impacts across interrelated areas and will factor this into planning.

Qualifications

Minimum Recruitment Standards

Requirements:

• University graduation (Computer Science, Information Management) or in a related field plus 2 years progressively responsible related experience; or equivalent as described below
• For your application to be considered, a cover letter explaining your qualifications and suitability for this role must be attached with your application.

Equivalencies: Directly related experience or education considered on the basis of: 

• 1 year of education for 1 year of experience; or
• 1 year of experience for 1 year of education.

The following knowledge or experiences are considered as assets:

• In-depth understanding of legislation and regulations (i.e. Health Information Act, and it's associated Regulations), business policies and procedures, user guides, manuals, and training materials.
• Strong writing, editing, speaking and interpersonal skills are necessary to provide accurate response.
• Strong conflict-resolution skills to effectively manage sensitive audit-related communications.
• Proficient in computer software and application including MS Excel, Outlook, MS Word, and MS PowerPoint to support audit documentation, data analysis, reporting, and stakeholder communication.
• Experience monitoring and analyzing database access activity to identify unauthorized or unusual behavior. Knowledge of and experience in cybersecurity principles, tools, and practices, particularly as they relate to data access and protection.
• Effective communications skills (written and oral) to collaborate effectively with colleagues and with internal and external stakeholders.
• Organization and prioritization skills to balance multiple ongoing projects at one time and ability to meet tight timelines.

Minimum recruitment standards outline the minimum education and experience required for appointment to a job classification. Refer to https://www.alberta.ca/alberta-public-service-minimum-recruitment-standards.

Notes

This competition is a permanent full-time position working 36.25 hours per week, Monday to Friday.

This position is located in Edmonton, Alberta.

An additional written assignment may be used as part of the recruitment process.

In your resume, please include dates (including months and years) associated with all education and work experience. Also, please indicate whether your work experience is casual, part time or full time.

The final candidates may be required to undergo pre-employment checks (Reference check/Criminal record and/or academic).

Candidates with lesser qualifications may be considered at a lower classification and salary. This competition may be used to fill future roles at the same or lower classifications.

Any costs associated with obtaining the required documents/checks as noted or interview travel expenses, will be the responsibility of the candidate. Out-of-province applicants can obtain the required documents/checks from the province they currently reside in.

Links and information on what the GoA has to offer to prospective employees.

• Working for the Alberta Public Service - https://www.alberta.ca/advantages-working-for-alberta-public-service.aspx.
• Public Service Pension Plan (PSPP) - https://www.pspp.ca.
• Alberta Public Service Benefit Information - https://www.alberta.ca/alberta-public-service-benefits.
• Professional learning and development - https://www.alberta.ca/professional-development-support-directive.
• Research Alberta Public Service Careers tool – https://researchapscareers.alberta.ca.
• Positive workplace culture and work-life balance.
• Opportunity to participate in flexible work arrangements such as working from home up to two days per week and modified work schedule agreement.
• Leadership and mentorship programs.