Posted last month
Data Analyst – Power BI / Microsoft Fabric
@ Myticas Consulting
Ottawa, Ontario
Overview
Myticas Consulting is hiring a Data Analyst for a full-time, on-site role in Ottawa, ON, reporting to a senior technology leader. The work centres on Power BI dashboards, SQL and Microsoft Fabric data solutions, with close stakeholder contact. Pay is $90,000 to $106,740 for 40 hours per week, with full benefits and a start as soon as possible.
Responsibilities:
- Design and maintain Power BI dashboards and reports
- Develop and optimize SQL queries across multiple systems
- Build dimensional and semantic data models
- Develop Microsoft Fabric Lakehouse and Warehouse solutions
- Gather stakeholder requirements and communicate insights clearly
Requirements summary:
- 3+ years in data analysis or business intelligence
- 3+ years developing Power BI reports and dashboards
- Strong SQL skills and dimensional data modelling
- Experience with Microsoft Fabric or Azure Data Services
- Experience with Python/Pandas and APIs, JSON, relational databases
- Strong communication and listening skills
Tools & skills
Source and dates
Source type not verified · jsonld
- Employer posting date
- 2026-09-23
- First seen by our source
- 2026-10-16
- Source record updated
- 2026-10-16
These dates describe the source record, not a live verification that the employer is still hiring. Check the original posting.
Job details
| Seniority | Mid level |
| Department | Data & analytics |
| Experience | 3+ years |
| Hours per week | 40 |
| Schedule | day |
| Travel | air: none · ground: none |
| Work setting | Office |
| Position | Mostly sitting |
| Physical demands | physical low · computer high |
| Languages | English |
| Background checks | criminal record |
| Education | College diploma (preferred), Bachelor’s degree (preferred) |
| Fields of study | Computer Science, Data Analytics, Mathematics, Statistics, Business |
Summary and details written by AI from the posting; the employer’s posting is the authority.
Myticas Consulting
Saved company profile
Historical company information from a saved The Jobs API profile (LinkedIn/Crunchbase fields). It is not live-verified; figures may have changed. Missing values remain unknown.
Myticas Consulting is a leading edge IT Staffing and Recruitment organization with locations throughout North America.
Full company description
Myticas Consulting is a proven, industry-leading IT staffing and recruitment organization with offices in major North American cities, including Ottawa, Ontario, and Chicago, Illinois, as its prime headquarters. Our large team of IT recruitment and sales professionals have over 50+ years of combined experience providing the highest quality of Telecommunication Engineering, ERP and IT Software Development resources, to both Public and Private sector enterprise level environments. Here at Myticas, we strive to continually provide unmatched quality of IT resources, that prove to stand the test of time, and go above and beyond all project expectations and deliverables. The "motto" at Myticas is not only to work with you, but to understand what success really looks like for your organization, and to deliver the IT staffing needs that matter most to increasing both the functionality and efficiency of your environment. With our evolving expertise in Telecom, ERP, DW/BI and EAI resources, and a guaranteed replacement program for all our partners, the defined win-win scenario has never been presented in a more simple manner.
- LinkedIn followers
- 216,509
- People associated on LinkedIn
- 65
- Reported office locations
- 83 Hinton Ave., Ottawa, Ontario K1Y0Z7, CA
- 3701 Algonquin Rd. Suite 580, Rolling Meadows, Illinois 60008, US
- Other recorded names
- Myticas Consulting
- Specialties
- Embedded Engineering and Software Engineering
- Profile identifies a recruitment agency
- Yes
Myticas Consulting is a proven, industry-leading IT staffing and recruitment organization with offices in major North American cities, including Ottawa, Ontario, and Chicago, Illinois, as its prime headquarters. Our large team of IT recruitment and sales professionals have over 50+ years of combined experience providing the highest quality of Telecommunication Engineering, ERP and IT Software Development resources…
| Field | Value |
|---|---|
| Industry | Staffing and Recruiting |
| Company size | 51-200 employees |
| Headquarters | Ottawa, Ontario |
| Organization type | Privately Held |
| Specialties | Embedded Engineering and Software Engineering |
| Open jobs on Jobsy | 68 |
| View page |
Data Analyst – Power BI / Microsoft Fabric
Location: Ottawa, ON – On-site
Hours: 40 hours/week (8 hours/day)
Start: ASAP
Compensation: $90,000–$106,740
Benefits: Full benefits
Clearance: Must be eligible to successfully complete the required background/security screening
THE OPPORTUNITY
We are seeking a Data Analyst to join a highly collaborative technology and data team supporting a complex, operational environment in Ottawa.
This is an excellent opportunity for a junior-to-mid-level Data Analyst with strong Power BI, SQL and Microsoft data technologies experience who enjoys turning data into meaningful dashboards, reporting and business insights.
Reporting to a senior technology leader and working closely with a Data Architect, you will design and maintain dashboards, reports, data models and analytical solutions using Microsoft Fabric, Power BI and related Azure/cloud analytics technologies.
This is also a stakeholder-facing role. Strong communication, listening skills and the ability to understand business requirements and explain data clearly are equally important to technical capability.
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 supporting reporting and self-service analytics.
- Develop data solutions using Microsoft Fabric, including 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 and understand stakeholder requirements and translate them into effective analytical and reporting solutions.
- Analyze complex datasets and communicate findings as clear, actionable business insights.
- Support data quality, consistency, documentation, governance, privacy and security requirements.
- Help evaluate, improve and automate existing reporting processes and systems.
- Work closely with technical teams, business stakeholders and external vendors/service providers.
WHAT WE'RE LOOKING FOR
- Post-secondary degree/diploma in Computer Science, Data Analytics, Mathematics, Statistics, Business or a related field, or equivalent education and experience.
- 3+ years of experience in data analysis, business intelligence, reporting or a related analytical role.
- 3+ years developing Power BI reports and dashboards.
- Strong SQL skills, including querying, transforming and analyzing large datasets.
- Experience with dimensional data modelling.
- Experience with Microsoft Fabric (Lakehouse/Warehouse), Azure Data Services or comparable modern cloud analytics platforms.
- Experience with Python/Pandas.
- Experience integrating data using APIs, JSON, file-based exchanges and relational databases.
- Ability to work with structured and semi-structured data from multiple sources.
- Proven ability to translate business requirements into analytical solutions.
- Ability to analyze complex information and present findings clearly to both technical and non-technical stakeholders.
- Strong communication and listening skills, professional presence and a clear, structured approach to problem-solving.
- Comfortable working directly with business users, customers and stakeholders.
NICE TO HAVE
- Microsoft certifications such as Fabric Analytics Engineer Associate or Power BI Data Analyst Associate.
- Tableau experience and exposure to other BI/reporting technologies such as Qlik, Looker, SSRS or advanced Excel.
- Experience with Snowflake, AWS or Google Cloud Platform (GCP).
- Experience in aviation, transportation or another complex 24/7 operational environment.
- Knowledge of data governance, privacy and information security practices.
- Experience with operational performance metrics and reporting standards.
- Ability to communicate in English and French is an asset.
WHO WILL SUCCEED IN THIS ROLE
You don't need to be the most senior technical person in the room. We're looking for someone who combines solid hands-on data skills with the ability to listen, understand requirements, communicate clearly and work collaboratively.
You should be technically adaptable, comfortable taking direction from senior data/technology professionals, and confident interacting directly with stakeholders to turn their requirements into useful, reliable data solutions.
Journal
Only you can see this. Kept on this device, and in your account when you sign in.