Reporting Analyst
Reporting Analyst
Employer Active
Job Alert
You will be updated with latest job alerts via email
Share
Job Alert
You will be updated with latest job alerts via email
Job Description
Reporting Analyst Business Intelligence Services
FullTime 18Month Contract Competition #2532
Position Summary
As a member of the Business Intelligence Services department the Reporting Analyst plays a crucial role in enhancing ASEBPs 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 daytoday 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 daytoday 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 adhoc 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 twoyear 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 problemsolving abilities.
- Proficiency in TSQL 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 problemsolving 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 inoffice 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.
Required Experience:
IC
Employment Type
Contract
