Power BI Analyst

Power BI Analyst

Government approved Reliability Status security clearance required. Support enterprise reporting and analytics initiatives. Transform complex data into clear, actionable insights that support strategic decision-making across the organization. Work closely with business stakeholders, data engineers, and senior leadership to enable data-driven operations within a secure, compliant environment.

Key Responsibilities

Design, develop, and maintain interactive Power BI dashboards, reports, and data models.

Translate business requirements into technical specifications and scalable BI solutions.

Optimize Power BI datasets (DirectQuery, Import Mode, dataflows) for performance and governance.

Ensure consistency and standardization in metrics, KPIs, and data definitions across teams.

Perform advanced data analysis using DAX, Power Query (M), and SQL.

Build robust semantic models and star schemas aligned with enterprise data architecture.

Conduct data validation, reconciliation, and quality checks for accuracy and integrity.

Partner with product owners, actuaries, finance, operations, and IT to deliver meaningful insights.

Present data findings clearly to nontechnical audiences, including leadership teams.

Provide training, documentation, and support to business users on BI tools and governance.

Ensure compliance with Government of Canada Reliability Status requirements, including secure handling of sensitive but unclassified information.

Follow client data governance, privacy, and cybersecurity standards.

Maintain audit‑ready documentation, access controls, and data lineage tracking.

Identify opportunities to improve reporting automation and data quality.

Stay current with Microsoft Fabric, Power BI updates, and industry best practices.

Contribute to modernization initiatives and enterprise data strategy projects.

Required Skills

Microsoft Power BI

Essential Skills

Power BI Analyst with government approved Reliability Status security clearance to support enterprise reporting and analytics initiatives.

Transform complex data into clear, actionable insights that support strategic decision making across the organization.

Work closely with business stakeholders, data engineers, and senior leadership to enable data-driven operations within a secure, compliant environment.

Experience: 8-10 years

Seniority Level: Mid‑Senior level

Employment Type: Full‑time

Job Function: Information Technology

Industries: IT Services and IT Consulting

Location: Toronto, Ontario, Canada

#J-18808-Ljbffr