Reporting & Analytics Analyst

Role Responsibilities

Are you a detail-oriented individual with a discerning eye for accuracy, a passion for delivering top-notch client service, and the ability to thrive in an analytical environment? Do you excel at providing support to innovative and dynamic teams while maintaining an upbeat attitude?

If so, we invite you to consider joining the Information Excellence team as a Reporting and Analytics Analyst, where no day is the same, and your dedication to accurate data and exceptional client service will drive inquiry and progress. We are committed to excellence in data management and innovation.

We're looking for talented and detail-oriented data focused Reporting and Analytics Analysts to join our dynamic team. If you have a passion for data, a client-driven mindset, and a knack for problem-solving, this role is perfect for you. This role will also support enterprise data visualization, reporting, and Cloudera based dashboard functions.

Join us in our mission to optimize data processes and support our clients in achieving their goals.

Responsibilities:

The Primary responsibilities of this position include but are not limited to:

Cloudera & Enterprise Dashboard Support:
•    Collaborate with business stakeholders to understand their reporting needs and requirements.
•    Developing and maintaining dashboards using Cloudera Data Visualization
•    Working with Oracle SQL queries and converting them to Hue/Impala SQL for CDV compatibility.
•    Using JavaScript to build custom CDV dashboards and enhance interactivity.
•    Understand the impacts of system changes, then review existing dashboards and reports to ensure remain accurate, functional, and aligned with current data structures

Data Analysis:
•    Collaborate with business stakeholders to understand their reporting needs and requirements.
•    Extract and transform data from various sources with a primary focus on 1GX through the use of tools such as Query Manager 4, SAP Analytics Cloud (SAC), SAP Datasphere and SuccessFactors

Story Reporting.
•    Perform in-depth data analysis to identify data trends, patterns and anomalies.
•    Review data dictionaries to understand the impacts of system changes.

Report Development:
•    Design and develop comprehensive reports and dashboards using industry-standard reporting tools.
•    Ensure that reports are accurate, timely and easy to understand.
•    Create interactive visualizations to effectively communicate and present data insights.
•    Receive and complete Service Requests relating to developing or enhancing reports.
•    Maintain and update existing reports to align with business or system needs and document changes to reports.

Data Governance:
•    Help the Master Data Management team maintain data quality and integrity.
•    Implement data governance standards and best practices.

Collaboration:
•    Work closely with cross-functional teams, including finance, supply chain management, human capital management and payroll.

Role Responsibilities continued

AI-Enabled Work Practices:
•    Apply AI enabled tools (such as Microsoft Copilot, SAC AI functions, or data assisted analytics features) to enhance analysis, quality checks, documentation, and visualization.
•    Demonstrate openness to learning and integrating emerging AI‑supported capabilities into daily work. 

To be successful in this position, you will demonstrate:

•    Strong problem diagnosis and resolution skills. 
•    Strong analytical and organizational skills to follow through on issues.
•    Strong interpersonal and communication skills.
•    Outstanding client relations skills to develop and maintain an effective working relationship with the stakeholders. 
•    Proven time management skills and ability to manage multiple priorities and stakeholder groups.

AI-First Mindset:

While prior experience with AI is not required, we are seeking candidates who are curious about new technologies, eager to learn AI-enhanced testing tools, and enthusiastic about automation, efficiency, and continuous improvement. 

In this role, AI may support automated testing, performance analysis, defect detection, and data-driven decision-making. Training and mentorship will be provided.

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.

Some of the competencies critical for this position are:

• Agility: You will work in a fast paced, dynamic environment and adapt to changing priorities. Identifies alternative approaches and anticipates obstacles and stays focused on goals. and support others to do the same. Ability to adapt to new tools and approaches, including evolving AI‑supported reporting technologies.
• Drive for Results: You will have the ability to quickly understand an issue based on and present knowledge and experience and follows through until the issue is resolved.
• Develop Self and Others: You will develop self and others –Identifies learning and knowledge-sharing opportunities and willingly shares knowledge with others.
• Build Collaborative Environments: Fostering collaboration across functional areas, proactively resolving conflicts, promoting innovative thinking on projects, removing obstacles to progress, facilitating seamless communication and collaboration, pre-emptively addressing, and mitigating conflicts, and ensuring due recognition for talented individuals.
• Develop Networks: You will seek out input from a wide range of internal and external stakeholders to solve complex problems and provide the best solutions.
• Systems Thinking: Takes a long-term view towards organization’s objectives and achieving them
• Creative Problem Solving: Engages the community and resources at hand to address issues. Engages perspective to seek root causes. Finds ways to improve complex systems. Employs resources from other areas to solve problems. Engages others and encourages debate and idea generation to solve problems while addressing risks.

Qualifications

Requirements:

• University graduation in a related field such as Business Administration, Human Resources, Finance, Business Analysts or Data Analytics.
• 2 years of progressively responsible related experience.
• Experience / Knowledge working with data across multiple systems.
• Experience in and an understanding of Finance data, Human Resources data or other sensitive data types.
• Experience with data quality practices (testing, reconciliation, change impact checks).
• Experience working with relational and non-relational databases.
• Experience with advanced SQL (joins, window functions, CTEs) used in production reporting/analytics.
• Hands‑on experience building interactive dashboards in an enterprise BI platform (e.g., Cloudera Data Visualization, Tableau, Power BI, SAC, Looker, or Qlik).
• Experience in Scripting for analytics/report automation or dashboard logic (JavaScript preferred, Python acceptable).
• Experience with data modeling for analytics (star/snowflake, KPIs, validation).

Equivalencies: 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: 

• Experience with Cloudera Data Visualization (CDV) or similar enterprise data visualization platforms.
• Experience writing and converting queries across SQL dialects, including Oracle SQL, Hue SQL, and Impala SQL.
• Experience with JavaScript for enhancing dashboard interactivity or implementing custom logic.
• Experience using enterprise BI tools such as SAP Analytics Cloud (SAC), SuccessFactors Story Reporting, Power BI, Tableau, Looker, or Qlik.
• Knowledge of data modeling concepts (star/snowflake schemas, semantic layers, KPI definition).
• Experience working with distributed SQL engines or large data environments (e.g., Impala, Hive, Presto, Spark SQL, cloud data warehouses).
• Experience in data quality assurance, regression testing of dashboards, and validating data after system or schema changes.
• Experience with version control tools (e.g., Git) and basic scripting for automation or analytics (e.g., Python).
• Experience working with ERP systems/applications such as 1GX and the integration between HCM, Payroll, SCM, and Finance modules.
• Experience in data compliance, confidentiality requirements, and secure handling of sensitive data.
• Excellent communication and presentation skills, with the ability to clearly explain technical concepts to non-technical audiences. Proficient in both oral and written communication to deliver presentations and conduct training for diverse clients.
• Experience with project planning and management methodologies, including change and issues management.
• Familiarity with the Government of Alberta business environment, ministry operations, and corporate service processes.

• Ability to use or learn AI‑enabled tools (e.g., Microsoft Copilot, AI features in SAC) to support documentation, analysis, and quality assurance workflows.

Minimum recruitment standards outline the minimum education and experience required for appointments to a job classification. 
Refer to https://www.alberta.ca/alberta-public-service-minimum-recruitment-standards.

Notes

Term of Employment: Permanent full-time position
Hours of Work:  36.25 hours per week/ Monday to Friday
Location: 

• Greater Edmonton Area: This position requires 100% in-office work for candidates residing within the Greater Edmonton Area. The position is based at the Terrace Building, 9515 – 107 Street NW, Edmonton, AB, T5K 2C1.
• Remote within Alberta: Candidates located outside the Greater Edmonton Area may be considered for remote work arrangements within Alberta. You must reside in Alberta to work remotely.

Final candidates may be required to undergo security screening.

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

Note:

Applicants are advised to provide a cover letter summarizing information that clearly and concisely demonstrates how their qualifications meet the advertised requirements, including education, experience, and relevant examples of required competencies.

Additional Information:

In your resume, please include dates (including months and years) associated with all education and work experience. As well, please indicate whether your work experience is casual, part-time, or full-time. For example, January 15, 2006 – June 25, 2009: Assistant (PT three 8 hrs. shifts/week).

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.