Job Information Job Title: Program Solutions Analyst Job Requisition ID: 82657 Ministry: Treasury Board & Finance Location: Edmonton Full or Part-Time: Full Time Hours of Work: 36.25 hours per week, Monday to Friday Permanent/Temporary: Permanent Scope: Open Competition Closing Date: May 11, 2026 Classification: Program Services 2 Salary: $2,562.61 - $3,361.54 bi-weekly ($66,884 - $87,736 annually)Organization Treasury Board and Finance (TBF), Edmonton – Tax and Revenue Administration (TRA) is responsible for the collection of revenue and the administration of Alberta’s tax, revenue, and related benefit programs. Our focus is to ensure a fair, efficient, and effective provincial tax and revenue system while offering a balance between work and home life with flexible work arrangements.Role Overview The Program Solutions Analyst works within the Collections and Recoveries branch to modernize service delivery. The analyst coordinates and provides technical support, analyzing complex business processes across all portfolios. The role involves developing solutions with both internal and external stakeholders.Responsibilities System and Process Development Life‑cycle SupportAssist in integrating various collection and recovery systems to create comprehensive debt profiles.Develop and maintain new performance measures that monitor the efficiency and effectiveness of collection and recovery strategic initiatives.Utilize various software applications effectively in support of business operations.Ensure the extraction and transformation of data into reliable and accurate information for decision‑making and operational performance improvement.Assist in creating and sustaining a branch‑level integrated reporting and analytical system.Optimize and leverage connected GoA or service delivery partner information management systems.System Testing SupportAssist in the development and execution of comprehensive test plans, ensuring the scope, objectives, resources,



and schedule for testing activities are well‑defined.Support and organize testing efforts by ensuring effective communication between all available resources.Execute test cases to validate system functionality and performance, providing support and guidance as needed.Identify, document, and track defects or issues found during testing, and assist in working with development teams to ensure they are resolved.Operational SupportProvide technical assistance to teams, ensuring smooth operation and troubleshooting issues as they arise in all applications that support branch operations.Support the management and maintenance of integrations with external applications, including monitoring system performance and troubleshooting integration issues.Assist in managing user access and permissions, ensuring compliance with security policies.Prepare and generate reports for internal and external stakeholders and conduct data analysis to support decision‑making and strategic planning.Participate in process improvement initiatives and technical solution identification, providing recommendations to management and stakeholders.Assist in the development, planning, and facilitation of internal training programs for staff related to technology.Facilitate Consultation and CollaborationContribute to process improvement and technical solution identification, while providing data‑driven recommendations to management and stakeholders.Coordinate and facilitate knowledge sharing opportunities across the branch to align understanding and practices on common functions.Create and distribute pulse surveys to regularly gather insights and feedback from team members to identify areas for improvement, measure employee satisfaction, and track the effectiveness of initiatives.Knowledge ManagementAssist in the development, planning, and facilitation of internal training programs for staff, focusing on technology‑related topics such as Artificial Intelligence (AI)



that are 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 the Protection of Privacy Act (POPA) and Access to Information Act (ATIA) legislation.Qualifications Required EducationBachelor’s degree in Information Technology, Business, Data Management, or a related field.Required ExperienceFamiliarity 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.Required Technical SkillsSQL SkillsProficiency writing Oracle SQL queries to retrieve and manipulate data from an Oracle‑based ERP workplace.Understanding of relational database concepts (tables, joins, indexes) and how they apply in Oracle.Experience with data filtering, aggregation, and grouping (e.G., WHERE, GROUP BY, HAVING).Ability to develop or maintain PL/SQL components such as stored procedures, functions, and packages (as applicable).Power BI SkillsExperience 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.AssetsCertified Data Management Professional (CDMP) – validates expertise in data management and is recognized globally.Microsoft Certified: Power Platform Fundamentals – core capabilities of Power Platform, including Power BI, Power Apps, and Power Automate.Equivalency1 year of education for 1 year of experience; or1 year of experience for 1 year of education.Company Location This position will be located in Downtown Edmonton.Security Screening Final candidates for this position will be asked to undergo a Level 1 & Level 2 security screening.BenefitsPositive workplace culture and work-life balance.Leadership and mentorship programs.#J-18808-Ljbffr

📌 Program Solutions Analyst - C$66,884 - C$87,736 A Year (Edmonton)
🏢 Treasury Board & Finance
📍 Edmonton