Power Platform Developer - Valued Government of Canada Client

Robertson & Company Ltd.; Ottawa; On-site; CAD 80,000 - 100,000; Full time

Job summary

Robertson & Company Ltd. is seeking an on-site Power Platform Developer in Ottawa. The ideal candidate will design and maintain Power BI dashboards and optimize Microsoft Access databases. Applicants must have a relevant degree, at least 2 years of experience in software development, and must hold a Reliability-level Clearance. Experience with Dataverse and a strong knowledge of Power BI are essential. This role offers an immediate start and focuses on data processes and automation.

Qualifications

• Must have 2+ years of experience in software development activities.
• Existing Reliability-level Clearance required.
• Located in the National Capital Region for on-site work.

Responsibilities

• Design, develop, and maintain Power BI dashboards and reports.
• Manage and optimize Microsoft Access databases.
• Develop and maintain Dataverse tables and relationships.

Skills

Power BI

Custom Power Platform Applications

Data migration

ETL processes

Database management

Education

Certificate, diploma, or degree in computer science

Tools

Microsoft Access

Dataverse

Job description

This on-site Power Platform Developer opportunity is for an immediate start in the west end of Ottawa.

Key Responsibilities

Custom Power Platform Applications, with interfaces and integrated business process flows

• Design, develop, and maintain Power BI dashboards and reports.
• Manage and optimize Microsoft Access databases, including queries, forms, and reports.
• Develop and maintain Dataverse tables, relationships, and architecture.
• Perform data migration between databases and systems, ensuring data integrity and minimal disruption.
• Execute data extraction, transformation, and loading (ETL) from various sources.
• Ensure data consistency, accuracy, and security across platforms.
• Collaborate with stakeholders to gather requirements and deliver actionable insights.
• Automate data workflows and reporting processes to improve efficiency.
• Document data processes, definitions, and reporting standards.
• Support data governance and compliance initiatives.
• Provide training and support to end-users on data tools and reporting systems.
• Troubleshoot and resolve data-related issues in a timely manner.

What you must bring to this role:

• Must have a certificate, diploma, or degree in computer science or other relevant field from a recognized Canadian* post-secondary institution.
• Must have 2+ years of experience (in the past 4 years) in software development activities on any of the following applications:
• Custom Canvas and Model-Driven Power Applications.
• Connecting flows to SharePoint, Outlook, Forms and Teams Approvals.
• Must have an existing Reliability-level Clearance and be located in the National Capital Region (on-site work is in Ottawa west)
• Must have at least 2 years knowledge of visualization tools for continuous monitoring and reporting, such as Power BI.
• Should have experience with Dataverse tables, relationships, and architecture.

*Only those who are qualified will be contacted.