Power BI and SQL define this Data Analyst role in Ottawa, supporting dashboards, reporting, and business insights within a collaborative technology team.

This junior-to-mid-level Data Analyst designs and maintains analytical solutions for a complex operational environment. You will use Power BI, Microsoft Fabric, Azure data technologies, SQL, and Python/Pandas. The position also requires clear stakeholder communication and translating business requirements into useful reporting solutions.

Key Responsibilities

- Design and maintain Power BI dashboards, reports, and performance metrics
- Develop SQL queries for multi-system data analysis
- Build dimensional and semantic models for reporting
- Translate stakeholder requirements into analytical solutions




- Communicate actionable findings from complex datasets

Requirements:
- Three-plus years in data analysis or related analytical roles
- Three-plus years developing Power BI reports and dashboards
- Strong SQL skills for querying and transforming large datasets
- Experience with dimensional data modelling
- Post-secondary education or equivalent education and experience

Apply Power BI, SQL, Microsoft Fabric, and communication skills to deliver explicit analytical solutions for Ottawa stakeholders.

📌 Power BI Data Analyst Ottawa (Canada)
🏢 Myticas Consulting
📍 Canada