Program Solutions Analyst

Role Responsibilities

Are you passionate about leveraging data analytics to drive impactful business solutions and do you thrive in a collaborative environment where innovation and problem-solving are key?

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.

Responsibilities:

System and Process Development Life-cycle Support:

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

System Testing Support:

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

Role Responsibilities Continued

Operational Support:

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

Facilitate Consultation and Collaboration:

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

Knowledge Management:

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

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.

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 stakeholders to address issues by seeking root causes, improving complex systems, and encouraging debate and idea generation while addressing risks.

DRIVE FOR RESULTS: Takes 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.

Qualifications

Required Education:

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

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.

Required Technical Skills:
SQL Skills:

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

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.

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.

Assets:
Certifications:

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

Equivalency:

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

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 is a permanent, full-time position working 36.25 hours per week, Monday to Friday.

This position will be located in Downtown Edmonton.

Final candidates for this position will be asked to undergo a Level 1 & Level 2 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. 

Applicants are advised to provide information that clearly and concisely demonstrates how their qualifications meet the advertised requirements, including education, experience and relevant examples of required competencies

In your resume, please include dates (including months and years) associated with all education and work experience. Please also indicate whether your work experience was part-time or full-time.

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.
• 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.
• Leadership and mentorship programs.