RQ08417 Report Developer

Deliverables:

Participate in requirements gathering sessions to understand the functional and non-functional needs

Perform assessment, and define approach in collaboration with project team and stakeholder to successfully deliver effective BI Solutions

Perform design and development activities to produce reports/dashboards/data visualizations within Power BI Desktop or Power BI Report Builder.

Perform troubleshooting and apply corrective actions to resolve issues with BI Solutions discovered during pre-release testing

Work with project team to provide relevant and required documentation to support migration activities and knowledge transfer

Participate in knowledge transfer activities

Skills and Knowledge:

Experience working in a business intelligence team/ environment, developing and delivering business intelligence and/or analytical reports and dashboards

Experience working with Power BI Desktop, and Power BI Report Builder to design and develop reports and dashboards and work with team members to explore options to redesign outdated reports

Experience writing and working with Microsoft Power BI DAX code to implement business logic within Power BI reports

Experience performing troubleshooting of SQL queries, business intelligence and analytical reports, as well as performing data analysis to complete data validation and ensure report accuracy.

Knowledge of Microsoft SQL Server, and Oracle databases

Knowledge of ETL tools, such as Azure Data Factory, Microsoft SSDT.

Criteria Ratings

Criteria 1: Technical Knowledge 50 points

Criteria 1 Details:

Experience/ demonstrated ability writing Transact-SQL (T-SQL) queries (at least 4 years of experience)

Experience/ demonstrated ability working with Power BI Desktop, and Power BI Report Builder to design and develop reports and dashboards (at least 2 years of experience)

Experience / demonstrated ability writing DAX code, perform data modelling and implement functionality within Power BI reports and dashboards (at least 2 years of experience)

Criteria 2: Analytical and Problem-Solving Skills

Criteria 2 Points: 30 points

Criteria 2 Details:

Experience/ demonstrated ability to perform technical troubleshooting, specifically within a business intelligence environment/team or against reports, dashboards, and database queries such as Transact SQL (T-SQL)

Experience / demonstrated ability to analyze data to resolve data quality issues and perform report validation

Demonstrated experience working within a team environment to troubleshoot and resolve technical problems

Ability to provide analysis, developing and implementing approved new/re-engineered business process standards.

Criteria 3: Communication Skills

Criteria 3 Points: 20 points

Criteria 3 Details:

Oral and written communication skills, Interpersonal and consultative skills, Facilitation skills

Demonstrated experience working in a team environment, contributing to team meetings on work progress, communicating risks and issues, providing results from work assessments, and explaining technical tasks to non-technical team members

Experience preparing documentation

Knowledge Transfer

Knowledge to be Transferred:

All documentation relating to the technology designs and technology knowledge specific to the candidates assignment All information gathered while working with vendors and internal solutions to be shared Any best practices, work around, lessons learned must be documented

Codes

Scripts

Power BI report and dashboard specifications (PBIX files)

Knowledge to be Transferred to: Project Manager / Team members

Details of Transfer: 1:1 meetings / team meetings / documentation on SharePoint site, throughout the duration of the project life cycle etc.

Must-haves:

Demonstrated working knowledge of Power BI Desktop [At least 2 years of experience]

Demonstrated working knowledge of SQL query languages (T-SQL, PL-SQL) [At least 4 years of experience]

Demonstrated working knowledge of DAX programming (At least 2 years of experience)