Power BI Developer 7474-1011

HM Note: This hybrid role is three (3) days in office at the managers discretion

Description:

The resource would be engaged on a number of discrete projects that have been approved as key priorities including:

1) develop Compliance Enforcement reporting Phase 1

2) develop Compliance Enforcement reporting Phase 2

3) Animal Welfare Services (AWS) critical operational reporting

4) Modernized Use of Force reporting;

5) Inventory of Mental Health Programs reporting;

6) eRoster reporting.

In addition other Microsoft Power BI work is ongoing and resources may be required to assist in other Power BI development work involved in the unit.

Skills

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 and nbsp; 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 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. 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.

Mandatory Requirements:

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 highperforming 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 manner

Connect Power BI reports to data sources

Criteria Ratings

Criteria 1: Technical Skills 60 Points

Proven work experience as a Power BI Report Developer

Demonstrated experience with M DAX and Power Query

Demonstrated knowledge of Microsoft Azure ecosystem and the Power Platform including Azure Data Factory

Proven experience with SQL Server and Power BI Datasets

Proven demonstrable 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 management

Experience in understanding capturing and analyzing complex and sometimes competing business requirements to develop Power BI and Business Intelligence products

Demonstrated experience with performance tuning in Power BI including measures relationships and visuals

Demonstrated experience with data sources for Power BI including DirectQuery Import and appropriate Considerations and limitations

Demonstrated experience with Power BI datasets

Demonstrated experience with Power BI refresh

Criteria 2: Documentation Collaboration and amp; Communication Skills 40 Points

Documentation Collaboration and amp; Communication Skills

Ability to partner with internal/external stakeholders and liaise with technical experts and nontechnical colleagues regarding project deliverables

Proven experience in developing documentation

Demonstrated experience collaborating with Developers Testers and Program Managers

Proven experience in producing diagrams videos and other visual content

Experience analyzing customer feedback and responding to it to improve the customer experience

Experience 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 products

Excellent verbal and written communication skills interpersonal and negotiation skills and nbsp; and nbsp;

Facilitation skills Interpersonal and consultative skills

Stakeholder management skills. Demonstrated strong problemsolving and organizational skills

A 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 environment

Knowledge Transfer

Knowledge to be Transferred:

Completed deliverables details

Processes used for developing the deliverables

Power BI models PBIX files

All source code created in development of deliverables

Knowledge to be Transferred to:

Team lead / Team members

Details of Transfer:

1:1 meetings / team meetings / throughout the duration of the project life cycle etc.