Reporting Analyst

The Alberta School Employee Benefit Plan (ASEBP); Edmonton; Hybrid; CAD 70,000 - 85,000; Full time

Job summary

A leading organization is seeking a Reporting Analyst to enhance their data reporting capabilities. This full-time, 18-month contract role involves developing operational reports, analyzing data, and supporting business processes. The ideal candidate will have strong analytical skills, experience with SQL Server, and a customer service orientation. The position offers a hybrid work environment, requiring in-office presence in Edmonton on designated days.

Qualifications

• Three to five years of relevant experience.
• Strong understanding of relational databases.

Responsibilities

• Create complex queries and stored procedures for reporting solutions.
• Manage daily report requests via a service request system.
• Monitor and improve performance of MS SQL Server Reporting Services.

Skills

Analytical

Problem Solving

Customer Service

Education

Two-year technical or community college certificate in Computer Science

Tools

Microsoft SQL Server

Reporting Services (SSRS)

PowerBI

Microsoft Office Suite

Job description

Join to apply for the Reporting Analyst role at The Alberta School Employee Benefit Plan (ASEBP)

Reporting Analyst, Business Intelligence Services

Full-Time 18-Month Contract - Competition #25-32

Position Summary

As a member of the Business Intelligence Services department, the Reporting Analyst plays a crucial role in enhancing ASEBP's ability to fulfill its mandate. This position is responsible for developing ad hoc and operational reports across various data sources, conducting thorough analysis, and communicating findings to support business processes and strategic initiatives. The role involves working closely with internal clients and managing workload through a ticketing system along with ongoing projects.

Your Key Responsibilities

Report Development :

• Create complex queries and stored procedures for reporting solutions.
• Respond to reporting requests from different business areas.
• Provide advice and interpretation of corporate data to solve business problems.
• Analyze information needs and develop reports for internal and external clients.
• Develop and support automated data extraction and scheduled reporting processes.
• Document procedures and automated processes.

Report Administration

• Manage daily report requests via a service request system, ensuring timely and standard-compliant responses.
• Monitor, troubleshoot, and improve performance of MS SQL Server Reporting Services environment.
• Create and deploy external reports on an ad-hoc basis through the customer portal.
• Maintain report metadata catalogs and user access permissions.
• Update queries and reports regularly to reflect evolving business processes.
• Identify and resolve data issues within data warehouse and source systems.

Your Education and Experience

• Completion of a two-year technical or community college certificate in Computer Science, Business, or related field.
• Three to five years of relevant experience.
• Experience working with:
• Microsoft SQL Server and Reporting Services (SSRS)
• Data Modeling and Database Design
• Microsoft Office Suite
• PowerBI and dimensional modeling (asset)

Your Abilities

• Strong understanding of relational databases and their implementation.
• Ability to work effectively with large data volumes across business lines.
• Excellent analytical, attention to detail, and problem-solving skills.
• Proficiency in T-SQL, writing efficient queries and stored procedures.
• Experience in query profiling, data filtering, and cleansing.
• Ability to work independently, managing workflow and priorities.
• Strong customer service orientation and communication skills.
• Demonstrates flexibility, initiative, perseverance, and integrity.
• Effective time management for multiple projects.

This position is eligible for a hybrid work environment. Candidates must be located in the Edmonton area, with in-office presence on designated days to promote collaboration.

If qualified and interested, please submit your resume by 4PM on Thursday, May 15, 2025.

No phone inquiries. Only shortlisted candidates will be contacted. ASEBP is an equal opportunity employer.

Employment is conditional upon background and reference checks, including possible criminal record, education, and employment verification.