{bc}
indeed

Business Analyst

Government Of Alberta
Edmonton, CAN
Full-time
Onsite
Discovered 1 weeks ago
Power BIDAXSQLSQL Server Reporting Services (SSRS)Business intelligence reportingData modeling

Full Job Posting

Job information

Ministry: Justice; Legal Services Division; location: Edmonton.

Full-time, permanent position with 36.25 hours of work per week.

Classification: Program Services 3 (023PSA).

Salary: $2,935.39 to $3,850.29 bi-weekly, or $76,613 to $100,492 per year.

Closing date: October 25, 2026.

About the division

Alberta Justice’s Legal Services Division provides legal and strategic services to government and describes itself as a learning organization.

Role

The Business Analyst supports the Legal Services Division reporting function, primarily using Power BI, with SSRS and core business applications.

The role turns complex operational and financial data into accurate, accessible, and actionable information for lawyers, business staff, directors, and executive leadership.

Responsibilities

  • Deliver reliable management and client reporting on weekly, monthly, annual, and ad hoc schedules.
  • Build and maintain Power BI and SSRS reports, dashboards, and datasets; consolidate or retire outdated reporting.
  • Administer Power BI availability, security, performance, workspaces, row-level security, data gateway, and refresh scheduling.
  • Validate data quality, reconcile information across systems, investigate variances, and resolve discrepancies.
  • Maintain data models, SQL views, and DAX measures for scalability and performance.
  • Support legal management applications, resolve escalated issues, perform root cause analysis, and automate work using Power Automate and Power Apps.
  • Consult with staff and directors, recommend reporting solutions, and support self-service through training and documentation.
  • Lead reporting and system initiatives from definition through delivery and outcome reporting.

Candidate qualifications

  • Advanced hands-on Power BI reporting experience, including data modeling, DAX, and report/dashboard design.
  • Strong SQL skills for complex queries, views, and stored procedures against large relational databases.
  • Power BI Service administration experience, including governance, security, and capacity management.
  • Experience validating and reconciling data across multiple source systems.
  • Experience designing and supporting Power Apps, Power Automate, and related Power Platform automation.
  • Application support experience covering incident triage, root cause analysis, issue resolution, and coordination with technical teams and vendors.

Apply for this job in 1 click

Skip the repetitive application forms

Install the Base Career Chrome Extension and autofill job applications across major job boards with your profile.

Sarah M.James T.Maya R.

Trusted by over 500,000 job seekers on Base Career

Start Free Today

More from this employer

More jobs at Government Of Alberta