Power BI Analyst

Astra-North Infoteck Inc. ~ Conquering today’s challenges, achieving tomorrow’s vision!; Toronto; On-site; CAD 80,000 - 100,000; Full time

Job summary

A leading IT consultancy firm in Toronto, Ontario, is seeking a Power BI Analyst. In this full-time role, you will design and maintain dashboards while transforming complex data into insights that drive strategic decision-making. Candidates should have 8-10 years of experience and possess a government-approved Reliability Status security clearance. The position requires collaboration with stakeholders across the organization to ensure compliance and maintain high standards of data governance and quality.

Qualifications

• 8-10 years of experience as a Power BI Analyst with government approved Reliability Status security clearance.
• Ability to transform complex data into clear, actionable insights.
• Experience enabling data-driven operations in a secure environment.

Responsibilities

• Design, develop, and maintain interactive Power BI dashboards.
• Translate business requirements into scalable BI solutions.
• Perform advanced data analysis using DAX, Power Query, and SQL.

Skills

Microsoft Power BI

Job description

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