Data Analyst / Developer – Power BI & Microsoft Fabric
- Location: Ottawa, ON – Hybrid (12 days on-site per month in Ottawa (3 days / wk)
- Pay Rate: $75/hr
- Contract Length: 12 Months
We at Raise are hiring a Data Analyst / Developer – Power BI & Microsoft Fabric for one of our top clients. After establishing themselves as an industry leader, they’re now expanding their team to meet rising demand. We’re hiring right now; if you’re interested, apply below for your chance to join a great place to work.
Responsibilities:
The Consultant will be responsible for providing the following services in order of priority to the Bank:
Under the direction of the Assistant Director, Cyber Strategy and Awareness:
- Serve as the Data & Analytics Architect for the Cyber Division, providing end-to-end architecture expertise across Microsoft Fabric, Power BI, and Copilot Studio—from ingestion and modeling through semantic design, reporting, governance, and AI-assisted analytics.
- Deliver high-impact reporting with Power BI and Microsoft Fabric, including designing data ingestion and establishing trusted data repositories, designing semantic models and implementing DAX, building optimized and user-friendly reports, and performance tuning and governance (endorsements, certification, and lineage).
- Design Copilot Studio agents that answer data questions and automate workflows (Power Automate, Dataverse, Microsoft Graph) with strong guardrails (RBAC), Power Platform DLP policies, and responsible evaluation/grounding for data Q&A, workflow automation, and Agentic AI solutions.
- Implement secure, authenticated refresh (OAuth2/API keys), including connection to external systems via REST APIs (OAuth2/API keys); handle pagination, throttling, and secure refresh; configure of on-premises data gateway connections where needed and document assumptions and limitations.
- Use Copilot in Power BI for faster authoring and insight summaries.
- Promote responsible AI: ensure data readiness for Copilot, apply grounding/evaluation practices, and enable users in line with our Generative AI guidelines.
- Provide guidance and subject-matter expertise to Cyber colleagues to support knowledge transfers and skill development.
- Other activities and deliverable, as required.
Required Qualifications & Skills
The Consultant should have the following qualifications and skills:
- A minimum of five (5) years of demonstrated advanced experience in Power BI modeling & DAX, performance analyzer, governance.
- A minimum of five (5) years demonstrated advanced experience in API literacy for analytics (auth, pagination, throttling).
- A minimum of two (2) years demonstrated advanced experience in Microsoft Fabric fundamentals (Workspaces, Notebooks, Pipelines, OneLake, SQL Analytics).
- A minimum of two (2) years demonstrated advanced experience in Copilot Studio agent design and integrations (Power Automate/Dataverse/Graph).
Additional Qualifications
The following will also be considered:
- RTI/KQL experience; Activator alerting.
- Demonstrated experience as a technical lead in a Power BI/MS Fabric Community of Practice.
- Demonstrated ability to effectively engage with stakeholders at a variety of levels.
Looking for meaningful work? We can help!
Raise is an established hiring firm with over 65 years of experience. We believe strongly in making the world a better place through work, which is why we’re a certified B Corporation and donate 10% of our profits to charity.
We strive to build teams that reflect the diversity of the communities we work in. We encourage all qualified applicants to apply, including people from traditionally underrepresented groups such as women, visible minorities, Indigenous peoples, people identifying as LGBTQ2SI, veterans, and people with visible/nonvisible disabilities.
We have a dedicated webpage for accommodations where you can learn more about what we offer and request accommodations: https://raise.jobs/accommodations/
In order to submit candidates for roles, our clients will sometimes require personal information to confirm the identity of applicants and their legal status to work. Raise will never ask you for personal or banking information unless you have been selected for a job. If you are ever unsure about the legitimacy of this or another job posting by Raise (or have any other questions), please contact us at +1 800-567-9675 or hello@raiserecruiting.com