Program Solutions Specialist

Role Responsibilities

Are you passionate about leveraging technology to drive impactful change in public service and do you have a knack for integrating complex systems and ensuring seamless data flow?

We have an exciting opportunity if you want to pursue a role in modernizing information systems and support government operations.

Reporting to the Manager of Business Services, the Program Solutions Specialist plays a crucial role in supporting operational systems and delivering evolving reporting and analytical requirements for diverse GoA client ministry programs. This role leverages technology and process expertise to enhance support for the Collections and Recoveries teams and collaborates closely with application developers, enterprise architects, database administrators, business analysts, and stakeholders to ensure the effective integration and modernization of systems. This position is essential for achieving the branch's goals by supporting the Collections and Recoveries teams and working with various technical and business stakeholders.

Key Responsibilities:

Information Systems Integration: Lead the integration of various collection and recovery systems to create comprehensive debt profiles. This involves:
 

• Conducting thorough assessments of existing systems and identifying integration opportunities.
• Leveraging advanced data integration and analysis skills to utilize various software applications effectively in the support of business operations.
• Designing and implementing integration solutions that ensure seamless data flow and system interoperability.
• Collaborating with technical teams to ensure the data integration infrastructure is robust, scalable and maintains protocols and standards.
• Monitoring and evaluating the effectiveness of integration efforts and making necessary adjustments to improve performance. 
  
  

Data Management: Oversee the extraction and transformation of data into reliable and accurate information for decision-making. This includes:

• Developing and maintaining the technical requirements and documentation needed to build and sustain a branch-wide integrated reporting and analytics system.
• Designing and implementing data validation processes to ensure data quality and integrity.Organizing and integrating branch data into clear fact‑and‑context groupings to ensure a consistent and trusted source of truth for reporting/analysis and decision‑making.
• Creating and optimizing database queries to improve data retrieval and processing efficiency.
• Ensuring data is accessible and usable for various stakeholders, including management, analysts, and other departments.
• Overseeing the development of comprehensive technical procedures to ensure compliance with policy requirements, including security expectations, Protection of Privacy Act (POPA) and Access to Information Act (ATIA) legislation.

Role Responsibilities Continued

Technical Support: Support the ongoing technical requirements of creating and sustaining a branch-level data integration system. This involves:

• Leading the execution of user stories, providing support and guidance to validate system functionality and performance, ensuring high-quality outcomes.
• Providing expert technical assistance for data integration-related issues and supporting teams to ensure smooth operation and availability of resources for troubleshooting issues in all branch applications.
• Managing and maintaining core SQL information systems such as CRM systems, as well Oracle or other cloud application that support operations across the branch.
• Partnering with the TRA division to build shared semantic models and streamlined data integration pipelines that ensure consistent, trustworthy information is available across the branch.
• Ensuring systems meet the needs of the branch and aligns with overall TBF Ministry, TRA, and GoA information management standards.

System Modernization: Ensure our information systems keep pace with the upcoming major information management system modernization initiative. This includes:

• Participating in the planning and implementation of new technologies and systems, including the responsible adoption of emerging capabilities such as Artificial Intelligence (AI)‑supported workflows.
• Migrating legacy systems to modern platforms and ensuring compatibility with existing infrastructure.
• Developing and implementing strategies to ensure a smooth transition to new systems, incorporating opportunities where automation or AI‑enabled features can improve efficiency and service delivery.
• Providing training and support to staff to help them adapt to new technologies and processes, including foundational AI literacy where appropriate.

Collaboration: Collaborate with other teams, branches and various departments to identify efficiency and effectiveness gains through the implementation of innovative solutions. This involves:

• Facilitating cross-functional meetings to gather requirements and develop solutions.
• Working with stakeholders to identify and prioritize process improvement opportunities.
• Developing and implementing solutions that streamline processes and improve efficiency.
• Ensuring effective communication and collaboration between departments to achieve common goals.
  
  

Coaching and Mentorship: Provide support to members and teams across the branch to increase awareness and development of skillsets. This includes:

• Collaborating with supervisors to create and offer directed guidance and training to developing team knowledge and skillsets. 
• Encouraging a culture of continuous learning and professional development within the branch.
  
  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: Integrates broader context into planning by considering trends, political environment, and risks, supporting organizational vision and goals, and addressing behaviors that challenge progress.

CREATIVE PROBLEM SOLVING: Works in open teams to share ideas and process issues by using diverse techniques to break down problems, encouraging creative thinking, bringing the right people together, and identifying new solutions for the organization.

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: Proactively incorporates change into processes by creating opportunities for improvement, adapting to changing priorities, remaining objective under pressure, supporting others, explaining the impact of change, and readily adapting plans and practices.

Qualifications

Required Education:

• Bachelor’s degree in information technology, Business, Data Management, or a related field.
  
  

Required Experience:

• Minimum of 4 years of experience: This includes extensive experience in data management, database design, querying, and information systems integration, preferably within a government or public sector environment. This experience should encompass database design, querying, data and semantic modeling, as well as data validation, processing, analysis, and reporting.
  
  

Required Technical Skills:

• Advanced knowledge of SQL: Proficiency in SQL and experience with SQL-based systems, including custom-built information management systems, is crucial for managing and querying data effectively.
• Expertise in Microsoft suite of products: This includes Power BI, Power Query, DAX, MDX, Power Automate, SharePoint Online, and Microsoft Excel. These tools are essential for data analysis, visualization, automation, and collaboration.
• Familiarity with data integration tools and techniques: Understanding and utilizing data integration tools and techniques are essential for ensuring seamless data flow and system interoperability.
  
  

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.

Qualifications Continued

Assets for this role include:

Strong Analytical and Problem-Solving Skills: 

• The ability to interpret complex data and provide actionable insights is critical for making informed decisions and improving business processes.

Foundational Artificial Intelligence Knowledge:

• Understanding modern AI concepts, including structured prompting frameworks (e.g., RICECO), the fundamentals of developing AI agents and agentic workflows, and prompt verification techniques (such as TRUST). These skills support the effective and responsible use of AI within GoA environments.

Excellent Verbal and Written Communication Skills: 

• Effective collaboration with cross-functional teams and the ability to present technical information to non-technical stakeholders are essential for successful project execution.
  
  

Familiarity with Agile Project Management Tools and Techniques:

•  This includes creating and managing sprints, user stories, and backlog items, which are crucial for efficient project management and delivery.
  
  

Ability to Work Independently and Part of a Team: 

• Being adaptable in a fast-paced and dynamic environment is important for handling various tasks and challenges.
  
  

High level of Accuracy and Attention to Detail:
 

• Ensuring precision in data analysis and reporting is vital for maintaining data integrity and reliability.
  
  

Commitment to Continuous Learning and Professional Development: 

• Staying updated with the latest trends and advancements in data management and information systems is essential for career growth and effectiveness.
  
  

Certifications:

• Microsoft Certified: Data Analyst Associate
• Certified Data Management Professional (CDMP)
• Certified SCRUM Master (CSM)
  
  

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