Reporting Analyst

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

Job summary

An established industry player is seeking a Reporting Analyst to enhance their Business Intelligence Services. This role involves developing ad hoc and operational reports, analyzing data, and communicating findings to support strategic initiatives. The ideal candidate will have a strong background in SQL and reporting services, along with excellent analytical skills. This position offers a hybrid work environment, fostering collaboration and teamwork while allowing flexibility. If you're passionate about data and eager to contribute to impactful projects, this opportunity is perfect for you.

Qualifications

• 3-5 years of experience in reporting and data analysis.
• Strong understanding of relational database structures.

Responsibilities

• Create complex queries and stored procedures for reporting solutions.
• Manage day-to-day report requests through a ticketing system.

Skills

T-SQL

Analytical Skills

Problem-Solving

Data Cleansing

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)

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 will be responsible for developing ad hoc and operational reports across a wide variety of business data sources, conducting thorough analysis, and communicating findings to support various business processes and strategic initiatives. The Reporting Analyst will work closely with internal business customers and subject matter experts and balance a workload consisting of day-to-day management of service requests assigned through a ticketing system combined with some ongoing project work.

Your Key Responsibilities

Report Development:

• Create complex queries and stored procedures for use in reporting solutions.
• Respond to reporting requests from various 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 day-to-day report requests through a service request ticketing system, ensuring adherence to defined service standards and timely resolution of requests.
• Perform monitoring, troubleshooting, and performance improvements across the MS SQL Server Reporting Services environment.
• Create and deploy external facing reports on an ad-hoc basis through our customer portal.
• Establish, maintain, and review organizational report metadata catalogues and user access permissions.
• Regularly update queries and reports to ensure accuracy as business processes evolve.
• Identify and address data issues within the data warehouse and other source systems.
  
  

Your Education And Experience

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

Your Abilities

• Strong understanding of relational database structures and their implementation.
• Proven ability to work effectively with large volumes of data across business lines.
• Excellent analytical skills, attention to detail, and problem-solving abilities.
• Proficiency in T-SQL, including writing efficient queries and stored procedures
• Expertise in query profiling, data filtering, and data cleansing.
• Ability to work independently and manage workflow and priorities effectively.
• Strong customer service focus with the ability to meet diverse client needs.
• Demonstrates flexibility, initiative, perseverance, and integrity.
• Effective time management skills, capable of managing multiple projects with varying timelines.
• Strong communication, presentation, and interpersonal skills.
• Proven analytical and problem-solving skills.
  
  

This position is eligible to participate in the hybrid workforce program. Please note that while this position offers a hybrid work environment, successful candidates are required to be located in the Edmonton area, as in-office presence during specified days is essential to foster collaboration and team dynamics.

If you have the required qualifications and would like to become a member of our team, please submit your resume by 4PM on Thursday, May 15, 2025.

No phone calls please. We thank all interested individuals, but only those candidates being considered for an interview will be contacted. ASEBP is an equal opportunity employer.

All offers of employment for this position are conditional upon satisfactory background and reference checks, which may include a criminal record check, and/or education and employment verification.

Seniority level

• Seniority level

  Associate

Employment type

• Employment type

  Contract

Job function

• Job function

  Analyst and Information Technology

• Industries

  Wellness and Fitness Services and Insurance and Employee Benefit Funds

Referrals increase your chances of interviewing at The Alberta School Employee Benefit Plan (ASEBP) by 2x

Get notified about new Reporting Analyst jobs in Edmonton, Alberta, Canada.

Business Analyst – ERP (Dynamics 365 Finance & Operations)

Edmonton, Alberta, Canada CA$75,000.00-CA$75,000.00 3 hours ago

Sherwood Park, Alberta, Canada 3 weeks ago

Technical Analyst - Desktop Technology Specialist

Technical Analyst, Cyber Risk Management Reporting, Deloitte Global Technology

We’re unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI.