SCOPE

• Provide planning, assessment, and development effort to complete the conversion of 100+ operational reports and dashboards from JasperReports to PowerBI
• Work with Project manager and Business Areas to evaluate and modernize reports, where applicable
• Migrate report functionality to Power BI Desktop or Power BI Report Builder based on Project Team assessment
• Work with Project Team to complete all relevant and required documentation, such as knowledge transfer, and communication to support the completion of the project

MANDATORY REQUIREMENTS

• 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)

DESIRED SKILLS AND EXPERIENCE

• Technical skills and expertise to design and develop in Jasper Report Tool
• 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
• Knowledge of ETL tools, such as Azure Data Factory, Microsoft SSDT

CRITERIA 1: TECHNICAL KNOWLEDGE - 50 POINTS

• 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 - 30 POINTS

• 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 - 20 POINTS

• 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

Description