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

Qualifications

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.

Required Technical Skills:

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.

Assets:

Certifications:

• Microsoft Certified: Azure Fundamentals - demonstrates foundational knowledge of cloud services and how those services are provided with Microsoft Azure.
• 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.
• 2 Years related experience is considered an asset.

Equivalency:

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

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 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.
For example:
January 15, 2006 - June 25, 2009: Executive Director of Job Title (Full time)

Links and information on what the GoA has 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
• 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
• Opportunity to participate in flexible work arrangements such as working from home up to two days per week and modified work schedule agreement
• Leadership and mentorship programs