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