Data Analyst Developer – Power Bi Microsoft Fabric

Ontario
Permanent
Full-time

28 days ago

Under the direction of the Assistant Director, Cyber Strategy and Awareness, the Consultant will be responsible for delivering the following services, listed in order of priority:

Serve as the Data & Analytics Architect for the Cyber Division, providing end-to-end architecture expertise across Microsoft Fabric, Power BI, and Copilot Studio. This includes data ingestion, modeling, semantic design, reporting, governance, and AI-assisted analytics.

Deliver high-impact reporting solutions using Power BI and Microsoft Fabric, including:

Designing data ingestion processes and establishing trusted data repositories
Developing semantic models and implementing DAX
Building optimized, user-friendly reports
Performing performance tuning and implementing governance practices (endorsements, certification, lineage)

Design and implement Copilot Studio agents to answer data-related questions and automate workflows using Power Automate, Dataverse, and Microsoft Graph. Ensure strong governance through RBAC, Power Platform DLP policies, and responsible AI practices, including grounding and evaluation for data Q&A and workflow automation.

Implement secure, authenticated data refresh processes (OAuth2/API keys), including:

Integration with external systems via REST APIs
Handling pagination and throttling
Configuring on-premises data gateway connections as required
Documenting assumptions and limitations

Leverage Copilot in Power BI to accelerate report development and generate insight summaries.
Promote responsible AI practices by ensuring data readiness for Copilot, applying grounding and evaluation standards, and enabling users in alignment with Generative AI guidelines.
Provide guidance and subject matter expertise to Cyber Division colleagues to support knowledge transfer and skill development.

Perform additional activities and deliverables as required.Must-Have Qualifications

Minimum of five (5) years residing in Canada and eligibility to obtain Security Clearance
At least five (5) years of advanced experience with Power BI, including data modeling, DAX, performance analyzer, and governance
At least five (5) years of advanced experience with API integration for analytics (authentication, pagination, throttling)
At least two (2) years of advanced experience with Microsoft Fabric fundamentals (Workspaces, Notebooks, Pipelines, OneLake, SQL Analytics)
At least two (2) years of advanced experience designing and integrating Copilot Studio agents (Power Automate, Dataverse, Microsoft Graph)

Nice-to-Have Qualifications

Experience with RTI/KQL and Activator alerting
Demonstrated experience as a technical lead within a Power BI or Microsoft Fabric Community of Practice
Proven ability to effectively engage and communicate with stakeholders at various levels

At Aplin - together with our brands CompuStaff and Impact Recruitment - we connect great people with great organizations across North America. We believe diverse teams build stronger companies, and we welcome applicants from all backgrounds, experiences, and perspectives. We use AI tools to assist in a fair and efficient matching process, helping our recruiters connect the right people with the right opportunities. To be considered, applicants must be legally entitled to work in Canada, including holding any required permits. Our recruitment services are always free for job seekers.

David Aplin Group

Apply Now