Analyst

Role Responsibilities

Are you self-motivated, a team-player, passionate about innovation, business intelligence, and operational improvement? Do you love challenging work and coming up with creative solutions? Here is a chance to reveal your talent! We are fast paced, involved in many exciting projects, and interact with multiple project teams, management teams, and senior management teams.

Reporting to the Modernization Projects Supervisor, in the Business Modernization and Transformation (BMT) unit of the Modernization Office Branch (MOB), you will work independently, and collaboratively, in various branches, divisions, and partnered ministries.
As an Analyst, you will support the departmental needs of Seniors, Community and Social Services (SCSS) and its stakeholders. You will play a leading role in our data analytics efforts and the optimization of our business processes. Your primary responsibilities will include analyzing business data to provide actionable insights and developing and maintaining BI reports and dashboards. Additionally, you will oversee the configuration, maintenance, and support of SharePoint sites, and design and develop Power Apps to enhance business workflows.

Responsibilities: 

Business Intelligence

• Design, develop, and maintain comprehensive BI solutions, including data models, reports, and dashboards.
• Collect, analyze, and interpret complex data sets from various public sector sources to support business decisions and strategy formulation.
• Ensure data integrity and accuracy across all reporting platforms by performing regular data quality checks.
• Collaborate with business units to understand their data needs, gather requirements, and provide appropriate solutions.
• Present findings and recommendations to management, senior management, executive management, and other stakeholders.
• Provide training and support to end-users on BI tools and data interpretation.

Power Apps Development

• Design, develop, and implement custom Power Apps to automate and improve business processes.
• Maintain and optimize existing Power Apps, ensuring they align with organizational needs.
• Collaborate with stakeholders to gather requirements and translate them into functional Power Apps solutions.
• Integrate Power Apps with other Microsoft 365 services and data sources.
• Provide training and support to end-users on Power Apps functionalities.

SharePoint Administration

• Manage and administer SharePoint sites, ensuring optimal performance and security.
• Configure and maintain SharePoint features, including libraries, lists, workflows, and web parts.
• Monitor SharePoint usage and activity, and troubleshoot issues as they arise.
• Implement and enforce SharePoint governance policies and best practices.
• Provide training and support to end-users on SharePoint functionalities.

Business Process Design

• Analyze current business processes and identify areas for improvement.
• Develop and implement process improvement strategies to enhance efficiency and effectiveness.
• Design and implement key performance indicators (KPIs) to measure the success of process improvements.
• Document and standardize new processes to ensure consistency and compliance.

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.

Qualifications

Requirements:

• Bachelor’s degree in Computer Science, Information Technology, Business, or another related field. 
• Minimum two (2) years of relevant experience as a Business Intelligence Analyst or similar role. 
• Proficiency in BI tools (Power BI preferred). 
• Strong SQL skills and experience with data modeling. 
• Familiarity with data warehousing concepts. 

Equivalency: Directly related education or experience considered on the basis of:

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

Assets:

• Hands-on experience with SharePoint administration and customization. 
• Experience with Microsoft Power Apps development. 
• Knowledge of Power Automate and Power Apps. 
• Excellent analytical and problem-solving skills. 
• Strong communication and interpersonal skills. 
• Ability to work independently and as part of a cross-functional team. 
• Demonstrated experience in the public sector. 

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

Hours of work: 36.25 hours per week, Monday – Friday

In your resume, please include dates (including months and years) associated with all education and work experience. Also, please indicate whether your work experience is casual, part time or full time.

A cover letter is encouraged. Your cover letter and resume will be used as a screening tool to assess your written communication. An additional written assignment may be used as part of the screening process.

Final candidates will be required to undergo a 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. 

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