Program Solutions Analyst

at  Government of Alberta

JOB INFORMATION

Job Requisition ID: 65963
Ministry: Treasury Board & Finance
Location: Edmonton
Full or Part-Time: Full Time
Hours of Work: 36.25 hours per week
Permanent/Temporary: Ongoing
Scope: Open Competition
Closing Date: January 28, 2025
Classification: Program Services 2
Salary: $2,345.14 to $ 3,076.28 bi-weekly ($61,208- $80,291/year)

KNOWLEDGE MANAGEMENT:

• Assist in the development, planning, and facilitation of internal training programs for staff, focusing on technology-related topics identified by the group or management.
• Support the update and development of comprehensive technical procedures to ensure compliance with policy requirements, including security expectations and FOIP legislation
  Please

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:
The following competencies are essential for the position:
SYSTEMS THINKING: Takes a holistic, long-term approach to organizational objectives, anticipating outcomes, seeking stakeholder perspectives, aligning actions with APS values, and collaborating with others.
CREATIVE PROBLEM SOLVING: Engages the community and resources to address issues by seeking root causes, improving complex systems, employing resources from other areas, and encouraging debate and idea generation while addressing risks.
DRIVE FOR RESULTS: Takes and delegates responsibility for outcomes by monitoring performance standards, acknowledging indirect responsibility, committing to the good of Albertans, and reaching goals aligned with APS direction.
BUILDING COLLABORATIVE ENVIRONMENTS: Facilitates open communication and leverages team skills by valuing and learning from others, resolving conflicts respectfully, and recognizing and appreciating contributions.
AGILITY: Ability to anticipate, assess, and readily adapt to changing priorities, maintain resilience in times of uncertainty and effectively work in a changing environment

REQUIRED EDUCATION:

• Bachelor’s degree in Information Technology, Business, Data Management, or a related field no experience required;

REQUIRED EXPERIENCE:

• Familiarity with agile project management tools and techniques, such as creating and managing sprints, user stories, and backlog items.
• Beginner - Intermediate knowledge of Power BI, Power Query, Power Automate, SharePoint Online.

SQL SKILLS:

• Proficiency in writing SQL queries to retrieve and manipulate data.
• Understanding of relational database concepts such as tables, joins, and indexes.
• Experience with data filtering, aggregation, and grouping.
• Ability to write and use stored procedures and functions.

POWER BI SKILLS:

• Experience in importing and transforming data from various sources.
• Proficiency in data modeling and creating relationships between tables.
• Ability to write DAX formulas for calculated columns and measures.
• Skilled in creating interactive dashboards and visualizations.
• Familiarity with Power BI Service for publishing and sharing reports.

IF YOU HAVE A KNACK FOR INTEGRATING TECHNOLOGY AND BUSINESS PROCESSES TO ACHIEVE STRATEGIC GOALS AND YOU ARE READY TO TAKE ON THE CHALLENGE OF MODERNIZING SERVICE DELIVERY AND ENHANCING OPERATIONAL EFFICIENCY, THEN THIS ROLE IS FOR YOU!

Reporting to the Manager of Business Services, the Program Solutions Analyst plays a crucial role in coordinating and providing technical support and analyzing complex business processes across all portfolios in the branch. This position involves developing and coordinating solutions with both internal and external stakeholders.

A COVER LETTER OUTLINING HOW YOUR EXPERIENCE RELATES TO THE QUALIFICATIONS OF THIS ROLE IS REQUIRED. THE COVER LETTER MAY BE USED TO ASSESS YOUR COMMUNICATION.

Minimum recruitment standards outline the minimum education and experience required for appointment to a job classification.
Refer to