HM Note : This onsite contract role is in office every day at the managers discretion. Candidate resumes must include first and last name email and telephone contact information. This role commences April 1 2026
Description
- The Common Cluster Solutions Branch focuses on services that support both ministries and all branches within the cluster. CCS also provides business intelligence data analysis and other KPI reporting on important areas of business operations to our partners and the cluster.
- These services include Business Intelligence (BI) which consists of performance reporting analytics and consulting services and includes offering self-service tools to enable and empower our business partners to make informed decisions for their day-to-day business operations.
- The resource would be engaged on a number of discrete projects that have been approved by ministry program areas as key priorities including :
- SOLGEN Private Security and amp; Investigation Services Branch (PSISB) to develop Compliance Enforcement reporting Phase 1
- SOLGEN Private Security and amp; Investigation Services Branch (PSISB) to develop Compliance Enforcement reporting Phase 2
- SOLGEN Animal Welfare Services (AWS) critical operational reporting
- Modernized Use of Force reporting;
- Inventory of Mental Health Programs reporting;
- eRoster reporting.
- In addition other Microsoft Power BI work is ongoing within the Branch and resources may be required to assist in other Power BI development work involved in the unit.
Skills
Experience and Skill Set Requirements
Create Power BI report(s) data modelsUndertake special assignments / sub-projects as assignedConduct assess evaluate and document stakeholder interests and business needsEnsure alignment and adherence to IT processes and standardsSupport the testing team during system and UAT testingParticipate in Knowledge transferProven experience as a Microsoft Power BI developer building Business Intelligence reports and dashboardsDemonstrated experience with M DAX and Power QueryDemonstrated knowledge and experience with Microsoft Azure ecosystem Power BI service Azure Datafactory SQL ServerProven experience with SQL Server and other database technologiesProven demonstratable experience in data modeling and data visualization; working with different data schemas and BI implementation methodologiesKnowledge of data analysis data managementProven ability to partner with internal / external stakeholders and liaise with technical experts and non-technical colleaguesExperience in understanding capturing and analyzing complex and sometimes competing business requirements to develop Power BI and Business Intelligence productsExcellent verbal and written communication skills interpersonal and facilitation skills and nbsp; and nbsp;Strong written presentation and interpersonal communication skills with special attention to correct use of tense grammar / spelling and terminologyDemonstrated effective time management and organizational skills including the ability to plan and prioritize workload ensuring timelines are met and respond to demands of a dynamic environmentMandatory Requirements : At least 5 years of experienceAll roles procured are required to be cleared through the Contractor Security Clearance Process of the OPS. and nbsp;Security Clearance process levels roles etc. are subject to change without prior notice. Candidates may be required to undergo revised / new process (or levels) any time prior or during the term of the contract.Use Power Query to extract data from different data sources and choose a storage mode and connectivity type. and nbsp;Profile clean and load data into Power BI and nbsp;Design data models that are intuitive high-performing and simple to maintain and nbsp;Create compelling Power BI report designs and report formatting including report navigation for all audience types (executive operational)Examine sort and present data using Power BI in a cohesive mannerConnect Power BI reports to data sourcesCriteria Ratings MUST TOTAL 100
Technical Skills : 60 Points
Proven work experience as a Power BI Report DeveloperDemonstrated experience with M DAX and Power QueryDemonstrated knowledge of Microsoft Azure ecosystem and the Power Platform including Azure Data FactoryProven experience with SQL Server and Power BI DatasetsProven demonstratable experience in data modeling and data visualizations for Power BI; working with different data schemas and BI implementation methodologies and nbsp;Knowledge of data analysis data managementExperience in understanding capturing and analyzing complex and sometimes competing business requirements to develop Power BI and Business Intelligence productsDemonstrated experience with performance tuning in Power BI including measures relationships and visualsDemonstrated experience with data sources for Power BI including DirectQuery Import and appropriate Considerations and limitationsDemonstrated experience with Power BI datasetsDemonstrated experience with Power BI refreshDocumentation Collaboration and amp; Communication Skills : 40 Points
Documentation Collaboration and amp; Communication SkillsAbility to partner with internal / external stakeholders and liaise with technical experts and non-technical colleagues regarding project deliverablesProven experience in developing documentationDemonstrated experience collaborating with Developers Testers and Program ManagersProven experience in producing diagrams videos and other visual contentExperience analyzing customer feedback and responding to it to improve the customer experienceExperience in bringing clarity to complex business challenges and conflicting articulation of business issues through techniques that result in common understanding of the issues as well as agreement on business process requirements vs technology requirements to solve the issues.Experience in understanding capturing and analyzing complex and sometimes competing business requirements to develop Business Intelligence productsExcellent verbal and written communication skills interpersonal and negotiation skills and nbsp; and nbsp;Facilitation skills Interpersonal and consultative skillsStakeholder management skills. Demonstrated strong problem-solving and organizational skillsA team player with a track record for meeting deadlines. and nbsp; and nbsp;Working knowledge and experience developing reports for use by a wide spectrum of stakeholders and nbsp;Strong written presentation and interpersonal communication skills with special attention to correct use of tense grammar / spelling and terminology.Demonstrated effective time management and organizational skills including the ability to plan and prioritize workload ensuring timelines are met and respond to demands of a dynamic environmentKnowledge Transfer
Completed deliverables detailsProcesses used for developing the deliverablesPower BI models PBIX filesAll source code created in development of deliverablesTeam lead / Team members1 : 1 meetings / team meetings / throughout the duration of the project life cycle etc.Must Haves :
Proven work experience as a Power BI Report DeveloperDemonstrated experience with M DAX and Power QueryKnowledge of Microsoft Azure ecosystem and the Power PlatformProven experience with SQL Server and Power BI DatasetsProven demonstratable experience in data modeling and data visualizations for Power BI; working with different data schemas and BI implementation methodologies and nbsp;Key Skills
Cobol,Foreclosure Paralegal,Machinery Maintenance,Accounts Reconciliation,General Services,HR Recruitment
Employment Type : Full Time
Experience : years
Vacancy : 1