Role Responsibilities

Are you a highly skilled and proactive Senior Systems Analyst eager to optimize performance and ensure the data integrity and security of large, complex IT systems? You will serve as our technical expert, driving operational stability and continuous improvement.

In this role, you will:

• Lead IT Initiatives: Play a major role in the development, maintenance, and enhancement of complex application systems.
• Analyze & Visualize Data: Perform advanced data analysis and create insightful visualizations using tools such as advanced Excel, Power BI, and Tableau.
• Drive Risk Assessment: Manage an extensive risk assessment project, integrating multiple data sources to generate risk scores used for visit prioritization and response.

In this pivotal role, you will perform comprehensive senior-level database administration, guaranteeing secure, reliable, and efficient data access across the organization. This means you will not only provide robust support for online systems and associated services to maintain operational stability but also meticulously review database systems to ensure full compliance with design specifications, branch standards, and departmental policies.

Furthermore, you will act as a senior technical lead on major system enhancement projects, offering crucial expert guidance throughout the entire project lifecycle. You will proactively consult with maintenance and development teams to promote optimal use of existing database environments and software, tirelessly ensuring peak performance of branch application systems through planned monitoring, performance tuning, and proactive issue resolution. Your contributions will be vital in strategic planning for long-term database and system improvements.

As a Senior Systems Analyst, your robust analytical skills will be critical in transforming raw data into actionable, strategic insights. You will leverage Power Query to efficiently extract, clean, and shape complex datasets from multiple sources. Utilizing advanced Excel formulas and basic statistical analysis, you will identify key trends, anomalies, and performance metrics. Furthermore, you will bring this data to life by designing intuitive dashboards and compelling visualizations in tools like Power BI and Tableau, empowering our team to make informed, data-driven decisions.

Roles Responsibilities Cont'd

Your responsibilities will include but will not be limited to:

• Transform complex datasets into actionable insights using Power Query, advanced Excel, basic statistical analysis, Power BI, and Tableau.
• Oversee Database Administration: You will perform comprehensive senior-level database administration tasks, ensuring secure, reliable, and efficient data access across the organization.
• Ensure System Compliance and Optimization: You will review database systems for full compliance with design specifications, branch standards, and departmental policies, and optimize existing database environments.
• Evaluate New Technologies: You will evaluate new database products, tools, and technologies to identify opportunities for cost-effective service improvements and modernization.
• Lead Technical Projects: You will act as a senior technical lead on major system enhancement projects, providing expert guidance throughout the project lifecycle.
• Provide Multi-Functional System Support: You will serve as a senior technical resource, addressing ongoing operational requirements and ensuring the operational stability of online systems.
• Drive Performance Tuning: You will ensure peak performance of branch application systems through planned monitoring, performance tuning, and proactive issue resolution.
• Collaborate and Consult: You will consult with maintenance and development teams to promote optimal use of database environments and contribute to their ongoing success.
• Contribute to Strategic Planning: You will assist with major project initiatives and contribute to long-term strategic planning for database and system improvements.

As our successful candidate, you will:

• Exhibit Expert Technical Leadership: You will provide authoritative technical guidance, mentorship, and senior-level expertise on complex database systems and projects.
• Demonstrate Proactive Problem-Solving: You will anticipate and resolve complex technical issues, implementing proactive solutions to ensure system stability and performance.
• Possess Strong Analytical and Evaluation Skills: You will critically assess existing systems and new technologies to identify opportunities for improvement and modernization.
• Communicate and Collaborate Effectively: You will consult confidently with various teams, translating complex technical information into clear, actionable advice.
• Apply Strategic Thinking: You will contribute to long-term planning, envisioning future system needs and aligning technical solutions with organizational goals.
• Ensure Meticulous Compliance: You will rigorously uphold design specifications, branch standards, and departmental policies in all database administration activities.

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

Qualifications

Requirements:

• University graduation (4 years) in computer science or a related discipline plus two (2) years of related experience; or equivalent as described:
  A related two-year diploma in computer technology or a related discipline from a recognized postsecondary institution and four (4) years of related experience; or a related one-year certificate from a recognized post-secondary institution and five (5) years related experience.
• A cover letter is required along with your application. Applications without a cover letter will not be considered.
  In your cover letter, please outline your suitability for the role and highlight how your experience aligns with the position's requirements.

Assets:

• Information Technology (IT) experience with complex computer systems including system architecture, technological system requirements and support.
• Proficiency in advanced data analysis and visualization tools (Power Query, advanced Excel, Power BI, Tableau) alongside a solid foundation in basic statistical analysis
• Previous experience with new software configuration and implementation for a large organization.
• Previous experience in continuing care or health sectors.
• Previous experience with compliance inspections and monitoring, licensing, complaints, incidents and reporting.

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

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

As the Senior Systems Analyst, in addition to your education and experience, you will demonstrate well-honed competencies in the following areas:

• Systems Thinking Understands how work contributes to the achievement of departmental goals. Anticipates changes in own area based on activities in other areas
• Build Collaborative Environments Leads and contributes to the conditions and environments that allow people to work collaboratively and productively to achieve outcomes.
• Drive for Results Sets goals and prioritizes work to accomplish them. Follows through on duties and tasks and reports on progress.
• Develop Networks Proactively builds networks, foster connections, and establishes trust in relationships with diverse stakeholders.
• Agility Must be able to anticipate, assess, and readily adapt to changing priorities, maintain resilience, and work effectively in changing environments.

Notes

Hours of work 36.25 hours per week, Monday to Friday, 8:15 to 4:30.

Available positions There is one (1) full-time temporary position up to March 31, 2028.
This job ad might be used to fill similar opportunities in the future as well.

Location ATB Place North, 10025 Jasper Avenue, Edmonton.

Assessments The applicants selected for the assessment step will be invited to complete an in-person technical written test and attend an in-person interview in Edmonton.

Final candidates will be required to undergo a security screening.

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 have 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
• Management Employees Pension Plan (MEPP) - https://www.mepp.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.
• Leadership and mentorship programs.