Power BI & Microsoft Fabric Data Analyst – Dashboards

Myticas Consulting Inc.

Ottawa

On-site

CAD 90,000 - 107,000

Full time

3 days ago

Be an early applicant

Application generator

A complete application in a minute — tailored resume and cover letter, ready to send.

Get past ATS filters

Benefits offered by this job

Full benefits

Job summary

Myticas Consulting Inc. is seeking a data analyst in Ottawa to design and maintain dashboards and data models using Power BI, Microsoft Fabric and Azure data services. This role focuses on turning data into business insights for operational and executive audiences.

You will build SQL queries, integrate APIs/JSON, and translate business requirements into analytical solutions while ensuring data governance and quality. This is a stakeholder-facing, onsite position in Ottawa.

Qualifications

Post-secondary degree/diploma in Computer Science, Data Analytics, Mathematics, Statistics, Business or related field, or equivalent education and experience.
3+ years of experience in data analysis, BI, reporting or related analytical roles.
3+ years developing Power BI reports and dashboards.
Strong SQL skills for large data sets and data modelling.
Experience with Microsoft Fabric (Lakehouse/Warehouse) and Azure Data Services.
Experience with Python/Pandas and data integration via APIs/JSON.

Responsibilities

Design, develop and maintain Power BI dashboards and reports for operational and executive audiences.
Develop and optimize SQL queries to extract, transform and analyze data from multiple systems.
Build and maintain dimensional and semantic data models for reporting.
Develop data solutions using Microsoft Fabric and related Azure services.
Integrate data from APIs, JSON, files and relational databases.
Translate business requirements into analytical and reporting solutions.
Analyze complex datasets and present clear, actionable insights.
Support data quality, governance, privacy and security requirements.
Collaborate with business users, stakeholders and external vendors.