Data Analyst – Power BI Microsoft Fabric (35903)
Role Overview
The Data Analyst joins a collaborative technology and data team supporting a complex operational environment in Ottawa.
The role is described as junior-to-mid-level and stakeholder-facing, with a focus on dashboards, reporting, and business insights.
The analyst reports to a senior technology leader and works closely with a Data Architect.
The posting specifies Ottawa, Ontario, on-site work; hours are 40 per week, 8 hours per day, with an ASAP start.
Compensation is CAD 90,000–CAD 106,740; full benefits are offered.
Candidates must be eligible to successfully complete the required background/security screening.
Key Skills for This Role
Full Job Posting
Opportunity
The Data Analyst joins a collaborative technology and data team supporting a complex operational environment in Ottawa.
The role is described as junior-to-mid-level and stakeholder-facing, with a focus on dashboards, reporting, and business insights.
The analyst reports to a senior technology leader and works closely with a Data Architect.
The posting specifies Ottawa, Ontario, on-site work; hours are 40 per week, 8 hours per day, with an ASAP start.
Compensation is CAD 90,000–CAD 106,740; full benefits are offered.
Candidates must be eligible to successfully complete the required background/security screening.
What you’ll do
- Design, develop, and maintain Power BI dashboards, reports, visualizations, and performance metrics 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 and self-service analytics.
- Develop solutions using Microsoft Fabric Lakehouse and Warehouse workloads and related Azure Data Services.
- Integrate structured and semi-structured data from APIs, JSON, file-based exchanges, and relational databases.
- Use Python/Pandas for data preparation, automation, and analysis.
- Gather stakeholder requirements and translate them into analytical and reporting solutions.
- Analyze complex datasets and communicate actionable business insights.
- Support data quality, consistency, documentation, governance, privacy, and security requirements.
- Evaluate, improve, and automate reporting processes and systems; collaborate with technical teams, stakeholders, and external providers.
What we’re looking for
- Post-secondary degree or diploma in Computer Science, Data Analytics, Mathematics, Statistics, Business, or a related field, or equivalent education and experience.
- 3+ years in data analysis, business intelligence, reporting, or a related analytical role, including 3+ years developing Power BI reports and dashboards.
- Strong SQL skills for querying, transforming, and analyzing large datasets; experience with dimensional data modeling.
- Experience with Microsoft Fabric Lakehouse/Warehouse, Azure Data Services, or comparable cloud analytics platforms.
- Experience with Python/Pandas and data integration using APIs, JSON, file exchanges, and relational databases.
- Ability to handle structured and semi-structured data, translate business requirements into analytical solutions, and communicate findings clearly.
- Strong communication and listening skills, professional presence, structured problem-solving, and comfort working directly with stakeholders.
Nice to have
- Microsoft Fabric Analytics Engineer Associate or Power BI Data Analyst Associate certification.
- Tableau or other BI/reporting technologies such as Qlik, Looker, SSRS, or advanced Excel.
- Snowflake, AWS, or Google Cloud Platform experience.
- Aviation, transportation, or another complex 24/7 operational environment experience.
- Knowledge of data governance, privacy, information security, operational performance metrics, and reporting standards.
- English and French communication ability is an asset.
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 with strong Power BI, SQL, and Microsoft data technology experience. You will build and maintain dashboards, data models, and analytical solutions while translat
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
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
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
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