Reporting Consultant

Role Responsibilities

The Reporting Consultant supports evidence-based workforce decisions across the Government of Alberta by turning complex HCM data into clear, reliable insights for leaders. This role combines technical SAP expertise with strong consulting and communication skills to help clients understand workforce trends and take action.

Workforce Reporting & Analytics

• Consult with ministries and internal partners to clarify business questions and reporting needs.
• Compile, analyze, and interpret HCM data from multiple systems (1GX, Workforce Reporting Platform, SAS/Python, IMAGIS).
• Design clear reports, dashboards, and visualizations that explain workforce trends and patterns.
• Prepare briefing materials for senior and executive leadership, including Deputy Ministers and Ministers.
• Ensure all reports are accurate, consistent, and aligned with data standards and definitions.
  
  

Product Development & Enhancement
    

• Build, update, and maintain customized 1GX queries using SAP Query Manager and SuccessFactors Report Center.
• Lead or contribute to projects that develop new reporting solutions where no standard products exist.
• Gather and document business and technical requirements through stakeholder consultation.
• Translate technical needs into clear documentation, prototypes, and mock-ups.
• Develop and execute testing plans to ensure solutions meet business and system requirements.
• Identify data issues and work with functional teams to resolve data quality or system problems.
• Provide subject matter advice on HCM data, data sharing policies, and data integrity.

Team Collaboration & Continuous Improvement
 

• Provide guidance to Senior Reporting Specialists on query design and data structures.
• Maintain documentation for customized reporting solutions.
• Recommend improvements to business intelligence products, including Power BI dashboards.
• Participate in user acceptance testing and support alignment between ERP and BI tools.
• Represent the unit in cross-functional meetings and share information back to the team.
  
  

Client Support & Education

• Promote and support self-service reporting options for clients where appropriate.
• Develop new self-service solutions when gaps are identified.
• Provide walkthroughs and training to help clients use dashboards and queries effectively.
• Present reporting options at client and HR Business Partner meetings.
  
  

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 competencies that are determined to be essential for this position are:

AGILITY – this role will continuously have multiple deadlines and priorities.  The ability to move seamlessly between them is required, including those required urgently by high profile stakeholders. Asks questions, seeks clarification and assesses how things will be different when change is introduced or anticipated.

DEVELOPING NETWORKS - by being part of the central hub for HCM workforce reporting and data analytics in the APS this position will require strong communication and the ability to maintain collaborative partnerships within the Public Service Commission and with other departments. Seeks to understand the perspectives and needs of colleagues, clients and stakeholders.

CREATIVE PROBLEM SOLVING – many of the requests taken on by this role will require additional probing to determine the key business question to maximize business alignment.  A variety of potential solutions may be available, so determination of the most appropriate one will also require problem-solving skills.  Constructively questions and challenges the way things have always been done, when there is a clear opportunity for improvement. Explores how others or other work units have used a new approach to gain perspective.

DRIVING RESULTS - by leading the development of query solutions that take into account the changing business environment, and thus information and data that is provided to the people leader and executive levels, this role is an integral member of a high performing team and contributes to a culture of continuous improvement. Takes past experiences into consideration when making plans and adjusts plans based on past learning.

SYSTEMS THINKING – by always considering the entire APS and its workforce, along with the various processes used by different areas, and ensure a consistent approach to customized query solutions is applied.  Asks questions to understand broader goals and objectives. Works with others to align activities.

Qualifications

Requirement:
A University degree or college diploma in Data Analytics, Statistics, Commerce, Computer Science, or a related field plus a minimum of 2 years of experience with data analysis, reporting, and extraction tools (SQL, SAS/Python, SAP Query Manager).

Experience & Technical Skills

• Strong experience building reports and working with large datasets.
• Advanced Excel skills for data analysis and presentation.
• Working knowledge of HR operational processes and HCM data.
• Strong written and verbal communication skills.
• Ability to explain complex data in a clear, meaningful way for decision-makers.
  
  

Assets

• Experience with SAP S/4HANA query building.
• Experience integrating multiple data sources into cohesive reports.
• Familiarity with database design, system architecture, and BI tools such as Power BI.
• Knowledge of GoA legislation, directives, and policies related to HR data.
• Experience supporting executive-level briefings or workforce planning initiatives.
• An understanding of the principal concepts of the project management discipline.  
• A basic understanding of programming languages (e.g. SAS, Python, R).  

Please note that all dates listed on the resume must include both a month and a year to ensure inclusion towards noted experience during the screening process.

A cover letter outlining what makes you the ideal fit is required and will be used to help assess your written communication skills.

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 position is a permanent, full-time position working 36.25 hours per week, Monday to Friday.

Location: 
Park Plaza Building, 10611 – 98 Ave NW, Edmonton, Alberta, T5K 2P7

Candidates with lesser qualifications may be considered at a lower classification and salary. This competition may be used to fill future roles at the same or lower classifications.

Candidates may be asked to participate in a written assessment. Final candidates for this position will be asked 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.
• Leadership and mentorship programs.