Program Solutions Analyst

Government of Alberta • Edmonton, AB

11d • $66,884 - $87,736 • Onsite

About The Position

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. The organization focuses on ensuring a fair, efficient, and effective provincial tax and revenue system, offering a balance between work and home life with options for flexible work arrangements. The Collections and Recoveries (C&R) branch aims to modernize service delivery through enhanced methodologies, technology, data analytics, and best practices to increase debt collection and recoveries across all portfolios and client ministries. Business Solutions within C&R provides a diverse scope of services to the Branch and to Alberta Government Ministries, in the support of Collections and Recoveries activities. The Program Solutions Analyst reports to the Manager of Business Services and 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, leveraging data analytics to drive impactful business solutions, and integrating technology and business processes to achieve strategic goals, ultimately modernizing service delivery and enhancing operational efficiency.

Requirements

• Bachelor’s degree in Information Technology, Business, Data Management, or a related field
• 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.
• Proficiency writing Oracle SQL queries to retrieve and manipulate data from an Oracle-based ERP environment.
• 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).
• Experience in importing and transforming data from various sources (Power BI).
• Proficiency in data modeling and creating relationships between tables (Power BI).
• Ability to write DAX formulas for calculated columns and measures (Power BI).
• Skilled in creating interactive dashboards and visualizations (Power BI).
• Familiarity with Power BI Service for publishing and sharing reports (Power BI).

Nice To Haves

• Certified 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.

Responsibilities

• Assist 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.
• Assist 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.
• Provide 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.
• Contribute 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.
• Assist in the development, planning, and facilitation of internal training programs for staff, focusing on technology-related topics like 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 Protection of Privacy Act (POPA) and Access to Information Act (ATIA) legislation.

Benefits

• Balance between work and your home life and provides options for flexible work arrangements.
• 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.
• Positive workplace culture and work-life balance.
• Leadership and mentorship programs.

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level
• Number of Employees: 5,001-10,000 employees