Business Analyst

Role Responsibilities

In this role, you will help transform complex operational and financial data into meaningful insights that support decision-making across the Legal Services Division. Working closely with lawyers, business staff, directors, and executive leadership, you will play a key role in ensuring information is accurate, accessible, and actionable. Your work will help shape reporting practices, improve business processes, and support strategic decisions that contribute to the effective delivery of legal services across government.

Reporting to the Business Operations Manager, the Business Analyst is responsible for the Legal Services Division's reporting function. This is a technical role focused on delivering accurate, timely and trusted information to lawyers, directors and executive leadership - primarily through Power BI, supported by SQL Server Reporting Services (SSRS) and the Division's core business applications.

Our successful candidate turns complex operational and financial data into reporting that decision-makers rely on. Strong SQL, Power BI and DAX skills are essential to doing this well, but the measure of success in this role is the quality, reliability and usefulness of the information delivered - not the volume of code written.

Our Business Analyst’s responsibilities will include, but will not be limited to:

• Reporting Service Delivery: Ensure reliable, accurate, and timely delivery of all divisional management and client reporting (weekly, monthly, annual, ad hoc).
• Report & Dashboard Development: Design, build, and maintain Power BI and SSRS reports, dashboards, and datasets, ensuring relevance and consolidating/retiring outdated reporting.
• Power BI Administration: Administer the Power BI environment for availability, security, and performance, including workspace management, row-level security, data gateway, and refresh scheduling.
• Data Quality & Validation: Validate data quality, reconcile information across systems, investigate variances, and resolve discrepancies to ensure defensible reported figures.
• Data Model & Infrastructure Maintenance: Maintain underlying data models, SQL views, and DAX measures, applying sound design for scalability and performance.
• System Support & Automation: Support legal management systems (e.g., ProLaw), resolve escalated issues, perform root cause analysis, and automate processes using Power Automate and Power Apps to reduce manual effort.
• Stakeholder Consultation & Self-Service: Consult with staff and directors to understand reporting needs, recommend solutions, and enable self-service through training and documentation on Power BI.
• Initiative Leadership: Lead reporting and system initiatives from definition through to successful delivery and outcome reporting.

Our ideal candidate will demonstrate:

• Business Intelligence Expertise: Advanced hands-on experience delivering BI, operational, and executive reporting solutions with Power BI (data modelling, DAX, report/dashboard design).
• Strong SQL Proficiency: Ability to write, optimize, troubleshoot, and maintain complex SQL queries, views, and stored procedures against large relational databases.
• Power BI Service Administration: Experience administering the Power BI Service, including governance, security, and capacity management.
• Data Validation & Reconciliation: Proven ability to validate, reconcile, and defend reported data, investigating and resolving discrepancies across multiple source systems.
• Microsoft Power Platform: Experience designing and supporting automation solutions using Power Apps, Power Automate, and related Power Platform technologies.
• Application & System Support: Experience with incident triage, root cause analysis, and issue resolution for business applications, coordinating with technical teams and vendors.
• Analytical & Problem-Solving Skills: Strong ability to gather requirements, assess needs, and translate them into effective technical solutions.
• Communication & Collaboration: Excellent verbal and written communication skills to explain technical concepts to diverse audiences, and demonstrated ability to collaborate effectively with stakeholders at all levels.
• Organizational & Relationship Management: Strong skills in managing multiple priorities, delivering results in fast-paced environments, and building relationships.
• Change Management Support: Ability to facilitate discussions, document requirements, and support change management, user adoption, and process improvement.

The Job Description is provided for further details on 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.

Below are the most critical competencies required for this role:

• Agility: Must be able to anticipate, assess, and readily adapt to changing priorities, maintain resilience, and work effectively in changing environments.
• Develop Self and Others: Desire to invest in the development of the long-term capability of self and others.
• Develop Networks: Proactively builds networks, connects and build trust in relationships with different stakeholders.
• Systems Thinking: Understands how work contributes to the achievement of departmental goals. Anticipates changes in own area based on activities in other areas.
• Creative Problem Solving: Have the ability to assess options and implications in new ways to achieve outcomes and solutions.

Qualifications

Requirements:

• University graduation (4 years) in Computer Science, Information Technology, Information Systems, Business Administration or any other related fields.
• Plus 2 years of progressively responsible experience in a related technical area.; or equivalent as described below.
• Equivalency: 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 include experience with:

• Developing reports for executive decision-making, operational planning, and performance management.
• SQL Server Reporting Services (SSRS) or other enterprise BI platforms.
• Solution design and development within Microsoft 365, including SharePoint, Dataverse, and the Power Platform (Automate and Apps).
• Broader Microsoft 365 ecosystem (One Drive, Teams, Planner, SharePoint) and ability to recommend tools.
• Emerging AI technologies and the Microsoft AI ecosystem (Copilot, Azure AI Services), identifying practical business use cases with responsible AI principles.
• Identifying opportunities for business process improvement through automation and digital transformation.
• Legal case, records, document, timekeeping, or eDiscovery systems (e.g., ProLaw).
• Working within a government, regulatory, justice, or broader public sector environment.
   

Minimum recruitment standards outline the minimum education and experience required for appointment to a job classification.

Notes

Hours of work: Monday - Friday, 8:15 am - 4:30 pm (36.25 /week)

Positions Currently Available: One Permanent position is available. This posting might be used to fill similar opportunities in the future as well.

Location: Bowker Building, 9833 109 Street NW, Edmonton, Alberta.

Final candidates will be asked to undergo a criminal records check (CRC). Any costs associated with obtaining the required documents/checks as noted or interview travel expenses, will be the responsibility of the candidate. Out-of-province applicants can obtain the required documents/checks from the province they currently reside in.

Links and information on what we have to offer:

• Working for the Alberta Public Service.
• Public Service Pension Plan (PSPP).
• Alberta Public Service Benefit Information.
• Professional learning and development.
• Research Alberta Public Service Careers tool.
• Positive workplace culture and work-life balance.