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 critical 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 supporting the ongoing technical requirements of creating and sustaining a branch-level integrated reporting and analytical system.
•    Designing and implementing data validation processes to ensure data quality and integrity.
•    Aligning and integrating data using Kimball dimensional modeling to provide a single version of the truth for data-informed decisions.
•    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
     and FOIP legislation.

Role Responsibilities Continued

Technical Support: Support the ongoing technical requirements of creating and sustaining a branch-level data integration system. This involves:
•    Managing and maintaining core (SQL) information systems such as CRM systems, as well Oracle or other cloud application that support operations
     across the Branch.
•    Working with other branches within the Division that design data models and develop ETL (Extract, Transform, Load) processes to integrate data from
     various sources.
•    Leading the execution of test cases, providing support and guidance to validate system functionality and performance, ensuring high-quality outcomes.
•    Ensuring systems meet the needs of the Collection and Recovery branch and aligns with overall Ministry and Government of Alberta information
     management standards.
•    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.

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.
•    Migrating legacy systems to modern platforms and ensuring compatibility with existing infrastructure.
•    Developing and implementing strategies to ensure a smooth transition to new systems.
•    Providing training and support to staff to help them adapt to new technologies and processes.

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, Azure, Dynamics, DAX, MDX, Power Automate, SharePoint Online,
     and MS 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.

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

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
•    Microsoft Certified: Azure Data Engineer Associate
•    Certified Data Management Professional (CDMP)
•    Certified SCRUM Master (CSM)
•    5 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