Report Developer - Senior

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 selfservice tools to enable and empower our business partners to make informed decisions for their daytoday business operations.

• SOLGEN Private Security & Investigation Services Branch (PSISB) to develop Compliance Enforcement reporting Phase 1
  
• SOLGEN Private Security & 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.
  

Requirements

Experience and Skill Set Requirements

Deliverables:

• Create Power BI report(s) data models
  
• Undertake special assignments/subprojects as assigned
  
• Conduct assess evaluate and document stakeholder interests and business needs
  
• Ensure alignment and adherence to IT processes and standards
  
• Support the testing team during system and UAT testing
  
• Participate in Knowledge transfer
  

Skills and Knowledge:

• Proven experience as a Microsoft Power BI developer building Business Intelligence reports and dashboards
  
• Demonstrated experience with M DAX and Power Query
  
• Demonstrated knowledge and experience with Microsoft Azure ecosystem Power BI service Azure Data factory SQL Server
  
• Proven experience with SQL Server and other database technologies
  
• Proven demonstrable experience in data modeling and data visualization; working with different data schemas and BI implementation methodologies
  
• Knowledge of data analysis data management
  
• Proven ability to partner with internal/external stakeholders and liaise with technical experts and nontechnical colleagues
  
• Experience in understanding capturing and analyzing complex and sometimes competing business requirements to develop Power BI and Business Intelligence products
  
• Excellent verbal and written communication skills interpersonal and facilitation skills
  
• 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 environment
  
• Mandatory Requirements: At least 5 years of experience
  
• All roles procured are required to be cleared through the Contractor Security Clearance Process of the OPS.
  
• 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.
  

Mandatory Requirements:

• Use Power Query to extract data from different data sources and choose a storage mode and connectivity type.
  
• Profile clean and load data into Power BI
  
• Design data models that are intuitive highperforming and simple to maintain
  
• 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 manner
  
• Connect Power BI reports to data sources