Reporting Consultant

Job Information
Job Title: Reporting Consultant 
Job Requisition ID: 62710
Ministry: Public Service Commission
Location: Edmonton
Full or Part-Time: Full Time
Hours of Work: 36.25 hours per week
Permanent/Temporary: Permanent
Scope: Open Competition
Closing Date: September 26, 2024.
Classification: Program Services 3E MA
Salary: $2,705.70 to $3,552.20 bi-weekly ($70,618 - $92,712/year)
 

The Government of Alberta is committed to a diverse and inclusive public service that reflects the population we serve to best meet the needs of Albertans. Consider joining a team where diversity, inclusion and innovation are valued and supported. For more information on diversity and inclusion, please visit: https://www.alberta.ca/diversity-inclusion-policy.aspx

The Public Service Commission (PSC) ensures Alberta has a professional, non-partisan and diverse public service that proudly serves Albertans. The expertise and talent that PSC staff bring to their work is critical to our overall success, as our Ministry is responsible for delivering HR services in all HR functional areas, internal communications, and employee engagement to the Government of Alberta.

To learn more about the work that we do, please visit: https://www.alberta.ca/public-service-commission.aspx

You will be a member of the Workforce Reporting and Analytics (WRA) team in PSC which supports the PSC and client departments with human capital Management (HCM) reporting and analytics services to make evidence-based decisions and to align the workforce with business priorities.  
 
Through provision of a full spectrum of data services (operational to strategic discussions), the team is responsible for partnering within the PSC and client ministries to understand business drivers and transform information into knowledge, leading to actionable insights.  This work is critical to the strategic decision-making capacity of the Alberta Public Service, and it interfaces with every Department.

Role Responsibilities

We live in a fast-paced world where things are ever-changing. While this can feel overwhelming to some, others thrive in this environment, enjoying the challenge of change. Within the Workforce Reporting and Analytics (WRA) unit lies the HCM Operational Reporting team. Our team provides HCM reporting and analytic services to assist our clients with evidence-based decision making.  With the needs of our clients evolving, we find ourselves requiring a more diverse skill set on our team. We need a versatile and well-rounded individual to help us help our clients.

Your experience with data extraction tools to retrieve data from our ERP is a definite must have and is crucial to the success of our team.  Your use of data visualization tools and other relevant HCM data products will help paint a more relatable and robust picture for your clients.  Melding together both of those abilities is foundational to success in this role. As a subject matter expert, proficiency in these areas is key as it will enable you to build and maintain customized query solutions for our team and also enable you to relate a story to the client in a meaningful and relevant manner. You will also use your knowledge and skills to lead project teams to collaborate with stakeholders to address their business problems. 

As part of a creative, fast-paced, and highly collaborative environment, you will:

• Apply your business acumen and technical skills to independently build, update, and maintain customized 1GX query solutions in SAP Query Manager and SuccessFactors Report Center.
• Identify data issues and independently work with appropriate functional areas to make recommendations and come to a resolution, including resolving issues and problems users are experiencing with query solutions.
• Leverage your strong knowledge of data reporting, analysis, research, and consultation skills to address clients' HCM business challenges effectively.Compile, summarize, and analyze HCM data from different data sources (1GX, the Workforce Reporting Platform, IMAGIS) into meaningful reports that provide insight and enable evidence-based decision-making.
• Design and present compelling narratives, including data visualizations, to communicate the implications of workforce trends and patterns to various APS audiences (Ministers, Deputy Ministers, Senior Leaders etc.), APS people leaders and external clients.
• Apply your technical expertise to develop and automate processes, enhancing efficiency and streamlining reporting workflows.
• Experience the best of both worlds by working independently and in a team environment.

Having an understanding of government structures, policies and procedures, as well as a working level knowledge of HR Directives, Policies and legislation will also be beneficial to you in this role.

If this sounds like the role for you, apply today!

Please click on this link to view the job description.

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.

Drive for Results - Knowing what outcomes are important and maximizing resources to achieve results that are aligned with the goals of the organization, while maintaining accountability to each other and external stakeholders.

Systems Thinking – Anticipate outcomes and potential impacts across inter-related areas and factors this into planning.

Creative Problem Solving – Having the ability to assess options and implications in new ways to achieve outcomes and solutions.

Agility – Must be able to anticipate, assess, and readily adapt to changing priorities, maintain resilience, and work effectively in changing environments.

Develop Networks – Must be able to proactively build networks, connecting and building trust in relationships with stakeholders.

Qualifications

Requirement:
University Degree or college diploma in Data Analytics, Statistics, Commerce, Computer Science, or a related field, plus a minimum of 2 years' experience with basic SQL, data analysis and SAP Query Manager tools, report building and extraction. Experience with SAP S/4HANA query building is preferred.

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.

 
Also required:

• Demonstrated ability to use Microsoft Excel as a data amalgamation and presentation tool.

Assets include:

• Experience in the integration of multiple data sources.
• Experience in development and maintenance of regular and ad-hoc data reporting via PowerBI, Excel, or other reporting tools.
• Working level knowledge of HR operational functions, programs and processes.
• Familiarity with database management and system architecture.
• Familiarity with data visualization tools such as PowerBI or Tableau.
• Understanding of PeopleSoft.
• Experience in documenting processes.
• Working level knowledge of related legislation, regulations, regulations, directives and policies to deliver HCM reporting services to stakeholders.
• An understanding of the principal concepts of the project management discipline.  
• A basic understanding of modern programming languages (e.g. SQL, Python, R). 
• Familiarity with different data extraction methods.

Please include a cover letter outlining your qualifications including any of the above preferences and/or assets that you may have.

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 competition is used to fill more than one vacancy and future opportunities at the same level or at the lower classification.

Hours of Work: 
7.25 hours per day / 36.25 hours per week - Monday to Friday, 8:15 am to 4:30 pm.

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

How To Apply
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.
 

Candidates are required to apply for a job online. Please visit https://www.alberta.ca/job-application-resources#before for more information. Please visit Recruitment Principles, for more information.
 

It is recommended applicants who have completed post-secondary studies from outside of Canada obtain an evaluation of their credentials from the International Qualifications Assessment Service (IQAS)(https://www.alberta.ca/international-qualifications-assessment.aspx) or from a recognized Canadian Credential Evaluator; please visit the Alliance of Credential Evaluation Services of Canada for more information (https://canalliance.org/en/default.html).

It is recommended that applicants include the assessment certificate from IQAS or any other educational assessment service as part of their application.


Closing Statement
This competition may be used to fill future vacancies, across the Government of Alberta, at the same or lower classification level.

We thank all applicants for their interest. All applications will be reviewed to determine which candidates' qualifications most closely match the advertised requirements. Only individuals selected for interviews will be contacted.

If you require any further information on this job posting or require an accommodation during the recruitment process, please contact Zooha Baig at Zooha.Baig@gov.ab.ca