A federal financial institution is seeking a highly skilled Data Analyst / Developer to support advanced data and analytics initiatives within a cybersecurity-focused environment. The successful candidate will act as a Data & Analytics Architect, delivering end-to-end solutions across Microsoft Fabric, Power BI, and Copilot Studio.
...
This role involves designing scalable data architectures, building high-impact dashboards, integrating APIs, and enabling AI-driven analytics while ensuring governance, security, and performance optimization.
Advantages
Work on cutting-edge data platforms including Microsoft Fabric and Copilot Studio
Opportunity to contribute to AI-driven analytics and automation initiatives
Hybrid work model with flexibility and high-impact responsibilities
Collaborate with cybersecurity and data experts in a mission-critical environment
Exposure to enterprise-level data governance, architecture, and performance tuning
Responsibilities
Serve as a Data & Analytics Architect, delivering end-to-end solutions from data ingestion to reporting and governance
Design and develop Power BI dashboards and reports, including:
Data modeling and DAX development
Performance tuning and optimization
Governance practices (certification, lineage, endorsements)
Build and manage data pipelines and repositories using Microsoft Fabric
Design and implement Copilot Studio agents to:
Automate workflows (Power Automate, Dataverse, Microsoft Graph)
Answer data-related queries with appropriate guardrails (RBAC, DLP policies)
Integrate external data sources via REST APIs, including:
Authentication (OAuth2, API keys)
Handling pagination and throttling
Secure data refresh configurations
Promote and implement Responsible AI practices, ensuring data readiness and governance
Use Copilot in Power BI to accelerate reporting and insights generation
Provide technical leadership, guidance, and knowledge transfer to internal teams
Qualifications
5+ years of advanced experience in:
Power BI (data modeling, DAX, performance tuning, governance)
API integration for analytics (authentication, pagination, throttling)
2+ years of experience with:
Microsoft Fabric (Workspaces, Pipelines, OneLake, SQL Analytics)
Copilot Studio (agent design and integrations with Power Platform tools)
Strong experience with:
REST APIs and secure data integration
Data architecture, ingestion pipelines, and semantic modeling
Power Platform (Power Automate, Dataverse, Microsoft Graph)
Ability to design scalable, secure, and governed data solutions
Additional Requirements
Must be able to obtain Secret security clearance (minimum 5 years residency in Canada required)
Must be able to work on-site in Ottawa periodically (~12 days/month)
Summary
This role involves designing scalable data architectures, building high-impact dashboards, integrating APIs, and enabling AI-driven analytics while ensuring governance, security, and performance optimization.
Randstad Canada is committed to fostering a workforce reflective of all peoples of Canada. As a result, we are committed to developing and implementing strategies to increase the equity, diversity and inclusion within the workplace by examining our internal policies, practices, and systems throughout the entire lifecycle of our workforce, including its recruitment, retention and advancement for all employees. In addition to our deep commitment to respecting human rights, we are dedicated to positive actions to affect change to ensure everyone has full participation in the workforce free from any barriers, systemic or otherwise, especially equity-seeking groups who are usually underrepresented in Canada's workforce, including those who identify as women or non-binary/gender non-conforming; Indigenous or Aboriginal Peoples; persons with disabilities (visible or invisible) and; members of visible minorities, racialized groups and the LGBTQ2+ community.
Randstad Canada is committed to creating and maintaining an inclusive and accessible workplace for all its candidates and employees by supporting their accessibility and accommodation needs throughout the employment lifecycle. We ask that all job applications please identify any accommodation requirements by sending an email to accessibility@randstad.ca to ensure their ability to fully participate in the interview process.
This posting is for existing and upcoming vacancies.
show more
A federal financial institution is seeking a highly skilled Data Analyst / Developer to support advanced data and analytics initiatives within a cybersecurity-focused environment. The successful candidate will act as a Data & Analytics Architect, delivering end-to-end solutions across Microsoft Fabric, Power BI, and Copilot Studio.
This role involves designing scalable data architectures, building high-impact dashboards, integrating APIs, and enabling AI-driven analytics while ensuring governance, security, and performance optimization.
Advantages
Work on cutting-edge data platforms including Microsoft Fabric and Copilot Studio
Opportunity to contribute to AI-driven analytics and automation initiatives
Hybrid work model with flexibility and high-impact responsibilities
Collaborate with cybersecurity and data experts in a mission-critical environment
Exposure to enterprise-level data governance, architecture, and performance tuning
Responsibilities
Serve as a Data & Analytics Architect, delivering end-to-end solutions from data ingestion to reporting and governance
Design and develop Power BI dashboards and reports, including:
...
Data modeling and DAX development
Performance tuning and optimization
Governance practices (certification, lineage, endorsements)
Build and manage data pipelines and repositories using Microsoft Fabric
Design and implement Copilot Studio agents to:
Automate workflows (Power Automate, Dataverse, Microsoft Graph)
Answer data-related queries with appropriate guardrails (RBAC, DLP policies)
Integrate external data sources via REST APIs, including:
Authentication (OAuth2, API keys)
Handling pagination and throttling
Secure data refresh configurations
Promote and implement Responsible AI practices, ensuring data readiness and governance
Use Copilot in Power BI to accelerate reporting and insights generation
Provide technical leadership, guidance, and knowledge transfer to internal teams
Qualifications
5+ years of advanced experience in:
Power BI (data modeling, DAX, performance tuning, governance)
API integration for analytics (authentication, pagination, throttling)
2+ years of experience with:
Microsoft Fabric (Workspaces, Pipelines, OneLake, SQL Analytics)
Copilot Studio (agent design and integrations with Power Platform tools)
Strong experience with:
REST APIs and secure data integration
Data architecture, ingestion pipelines, and semantic modeling
Power Platform (Power Automate, Dataverse, Microsoft Graph)
Ability to design scalable, secure, and governed data solutions
Additional Requirements
Must be able to obtain Secret security clearance (minimum 5 years residency in Canada required)
Must be able to work on-site in Ottawa periodically (~12 days/month)
Summary
This role involves designing scalable data architectures, building high-impact dashboards, integrating APIs, and enabling AI-driven analytics while ensuring governance, security, and performance optimization.
Randstad Canada is committed to fostering a workforce reflective of all peoples of Canada. As a result, we are committed to developing and implementing strategies to increase the equity, diversity and inclusion within the workplace by examining our internal policies, practices, and systems throughout the entire lifecycle of our workforce, including its recruitment, retention and advancement for all employees. In addition to our deep commitment to respecting human rights, we are dedicated to positive actions to affect change to ensure everyone has full participation in the workforce free from any barriers, systemic or otherwise, especially equity-seeking groups who are usually underrepresented in Canada's workforce, including those who identify as women or non-binary/gender non-conforming; Indigenous or Aboriginal Peoples; persons with disabilities (visible or invisible) and; members of visible minorities, racialized groups and the LGBTQ2+ community.
Randstad Canada is committed to creating and maintaining an inclusive and accessible workplace for all its candidates and employees by supporting their accessibility and accommodation needs throughout the employment lifecycle. We ask that all job applications please identify any accommodation requirements by sending an email to accessibility@randstad.ca to ensure their ability to fully participate in the interview process.
This posting is for existing and upcoming vacancies.
show more
