Business Analyst (Power BI & Data Analytics) with legal background
Location Hybrid, (Alberta)
Compensation:
CAD $60-$85/hr pay rate, based experience.
About the Opportunity
We are seeking a highly analytical and technically skilled Business Analyst to lead enterprise reporting, business intelligence, and data analytics initiatives. This role is ideal for a professional who enjoys transforming complex operational and financial data into meaningful insights that drive strategic decision-making.
Reporting to the Business Operations Manager, you will be responsible for delivering accurate, timely, and trusted reporting solutions for leadership teams through Power BI, SQL, and the broader Microsoft Power Platform. Success in this position is measured by the quality, reliability, and business value of the information delivered.
Key Responsibilities
Business Intelligence & Reporting
- Develop, maintain, and enhance Power BI dashboards, reports, datasets, and visualizations.
- Deliver recurring and ad hoc reporting that supports business operations, financial management, and executive decision-making.
- Design reporting solutions that answer critical business questions while eliminating redundant or low-value reporting.
- Ensure reporting accuracy, consistency, and data integrity across all deliverables.
Data Analytics & Database Management
- Build and maintain data models, SQL views, stored procedures, and DAX measures.
- Analyze large, complex datasets to identify trends, risks, opportunities, and operational insights.
- Troubleshoot and optimize SQL queries and reporting performance.
- Validate, reconcile, and investigate data discrepancies across multiple systems and sources.
Power BI Administration & Governance
- Administer the Power BI environment, including:
- Workspace and application management
- Row-Level Security (RLS)
- Data gateway administration
- Dataset refresh scheduling
- Governance and access controls
- Capacity and performance management
- Partner with technical teams to maintain secure, scalable, and reliable reporting solutions.
Process Automation & Continuous Improvement
- Design and implement workflow automation solutions using Power Automate and Power Apps.
- Streamline manual processes and improve operational efficiency through automation initiatives.
- Identify opportunities for process improvement and recommend practical, data-driven solutions.
Application & Systems Support
- Support business-critical applications and data systems that serve as reporting data sources.
- Perform incident triage, root cause analysis, troubleshooting, and issue resolution.
- Work closely with stakeholders, technical teams, and external vendors to resolve system and reporting challenges.
Stakeholder Engagement & Enablement
- Gather business requirements and translate them into scalable technical solutions.
- Partner with leaders and business stakeholders to understand reporting and analytics needs.
- Develop user documentation, training materials, and best practices.
- Promote data literacy and enable self-service reporting across the organization.
Project Leadership
- Lead assigned reporting, analytics, and system enhancement initiatives from requirements gathering through implementation.
- Monitor project progress, communicate status updates, and measure outcomes.
- Support organizational change management and user adoption activities.
Required Qualifications
- Bachelor's degree in Computer Science, Information Systems, Information Technology, Business Administration, Analytics, or a related field.
- Minimum of 4 years of progressive experience in business intelligence, reporting, analytics, data management, or related technical roles.
- Equivalent combinations of education and experience will be considered.
Required Technical Skills
- Advanced expertise in Power BI, including data modeling, DAX, report development, and dashboard design.
- Strong SQL development experience, including complex queries, views, stored procedures, performance tuning, and troubleshooting.
- Experience administering the Power BI Service, including governance, security, workspaces, applications, and gateway management.
- Proven experience validating and reconciling reporting data across multiple systems.
- Hands-on experience with Power Apps, Power Automate, and Microsoft Power Platform solutions.
- Experience supporting enterprise applications, troubleshooting issues, and coordinating resolutions with stakeholders and vendors.
- Strong analytical, problem-solving, and business process improvement capabilities.
Preferred Competencies
- Strategic and systems-thinking mindset.
- Strong root cause analysis and problem-solving abilities.
- Ability to build relationships with technical and non-technical stakeholders.
- Adaptability in a fast-paced, evolving environment.
- Experience training, mentoring, and supporting end users.
- Strong project management and organizational skills.
- Excellent verbal and written communication skills with the ability to present technical concepts to business audiences.
Ideal Candidate Profile
You are a data-driven professional who combines strong technical expertise with business acumen. You thrive in environments where data quality, reporting accuracy, and actionable insights directly influence organizational performance. You are equally comfortable developing complex Power BI solutions, solving data challenges, and partnering with leadership to support strategic decision-making.
