Data Analyst – Power BI Microsoft Fabric (35903)
Role Overview
Data Analyst role on a collaborative technology and data team supporting a complex operational environment in Ottawa.
Described as junior-to-mid-level, stakeholder-facing work reporting to a senior technology leader and collaborating with a Data Architect.
On-site in Ottawa, Ontario; 40 hours per week, eight hours per day; start ASAP.
Key Skills for This Role
Full Job Posting
Role overview
Data Analyst role on a collaborative technology and data team supporting a complex operational environment in Ottawa.
Described as junior-to-mid-level, stakeholder-facing work reporting to a senior technology leader and collaborating with a Data Architect.
On-site in Ottawa, Ontario; 40 hours per week, eight hours per day; start ASAP.
Responsibilities
- Design and maintain Power BI dashboards, reports, visualizations, and metrics for operational and executive audiences.
- Optimize SQL queries; build dimensional and semantic models; develop Microsoft Fabric Lakehouse and Warehouse solutions.
- Integrate data from APIs, JSON, file exchanges, relational databases, and other structured or semi-structured sources.
- Use Python/Pandas for preparation, automation, and analysis; translate stakeholder requirements into analytical solutions.
- Communicate actionable insights and support data quality, documentation, governance, privacy, security, and reporting automation.
- Collaborate with technical teams, business stakeholders, and external vendors.
Requirements
- Related post-secondary degree or diploma, or equivalent education and experience.
- At least three years in data analysis, BI, reporting, or a related analytical role, including at least three years developing Power BI reports and dashboards.
- Strong SQL, dimensional modeling, Python/Pandas, data integration, and experience with Microsoft Fabric, Azure Data Services, or comparable cloud analytics platforms.
- Ability to analyze complex data, translate business requirements, and present findings clearly to technical and non-technical audiences.
- Strong communication and listening skills; comfortable working directly with business users and stakeholders.
- Eligible to successfully complete required background and security screening.
Assets
- Microsoft Fabric Analytics Engineer Associate or Power BI Data Analyst Associate certification.
- Tableau; Qlik, Looker, SSRS, or advanced Excel; Snowflake, AWS, or GCP.
- Aviation, transportation, or other complex 24/7 operational environment; governance, privacy, and information security knowledge.
- English and French communication is an asset.
Compensation and benefits
- Compensation stated as CAD 90,000–CAD 106,740; the description does not specify pay cadence.
- Full benefits.
Apply for this job in 1 click
Skip the repetitive application forms
Install the Base Career Chrome Extension and autofill job applications across major job boards with your profile.
Trusted by over 500,000 job seekers on Base Career
More from this employer
More jobs at Myticas Consulting
Data Analyst – Power BI Microsoft Fabric (35903)
Ottawa, CAN
The employer is seeking a junior-to-mid-level Data Analyst to build dashboards, data models, and analytical solutions using Power BI, Microsoft Fabric, SQL, and related tools. Candidates need 3+ years in data analysis or
Google Cloud Data & Software Solutions Manager (35087)
Toronto, CAN
Myticas Consulting is seeking a manager to grow its Google Cloud practice and lead enterprise and mid-market cloud solution delivery. The role combines technical architecture and team leadership with client consulting, b
Business Analyst Finance Operations SME – Wealth Management (35773)
Ottawa, CAN
A banking client seeks an experienced Business Analyst and Finance Operations subject-matter expert for a Wealth Management transformation. The consultant will assess finance processes and support testing; applicants nee
Data Analyst – Power BI Microsoft Fabric (35903)
Ottawa, CAN
The employer is seeking a junior-to-mid-level Data Analyst to build reporting and analytical solutions using Power BI, Microsoft Fabric, SQL, and related Azure technologies. The role combines data modeling, integration,
Product Manager (35213)
Ottawa, CAN
A connectivity product organization seeks a Product Manager to evolve network offerings and own value-added services. The role spans product requirements, roadmaps, partner coordination, commercial frameworks, and enterp
Data Analyst – Power BI Microsoft Fabric (35903)
Ottawa, CAN
The employer is seeking a junior-to-mid-level Data Analyst to build dashboards, models, and analytics solutions using Power BI, Microsoft Fabric, SQL, and related tools. Candidates need at least three years of relevant e
Manager – Banking Cloud & Platform Engineering (35857)
Toronto, CAN
The employer is seeking a manager to lead complex cloud transformation and platform engineering programs for banking clients. The role combines technical guidance, program delivery, stakeholder leadership, and client eng
Principal Embedded Software Firmware Engineer (35837)
Ottawa, CAN
A one-year contract seeks a Principal Embedded Software/Firmware Engineer to own embedded architecture for advanced optical devices. You will deliver MCU, RTOS, bare-metal, security, and hardware-integrated solutions whi
Data Analyst – Power BI Microsoft Fabric (35903)
Ottawa, CAN
Google Cloud Data & Software Solutions Manager (35087)
Toronto, CAN
Business Analyst Finance Operations SME – Wealth Management (35773)
Ottawa, CAN
Data Analyst – Power BI Microsoft Fabric (35903)
Ottawa, CAN
Product Manager (35213)
Ottawa, CAN
Data Analyst – Power BI Microsoft Fabric (35903)
Ottawa, CAN
Manager – Banking Cloud & Platform Engineering (35857)
Toronto, CAN
Principal Embedded Software Firmware Engineer (35837)
Ottawa, CAN