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 data modelling and develop data processing pipelines to supply data repositories and warehouses using Microsoft Azure Data Factory Data Bricks and IBM InfoSphere Data Stage.
- 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
Requirements
Experience and Skill Set Requirements:
Must Haves:
- Demonstrated working knowledge of Power BI Desktop and Power BI Paginated Report Builder 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
- Demonstrated work knowledge of ETL tools such as Microsoft Azure Data Factory Data Bricks and IBM InfoSphere DataStage as well as data modelling methodologies. At least 2 years experience
Skill Set Requirements:
Skill Set:
- 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 IBM InfoSphere DataStage etc.
Technical Knowledge:
- 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 using ETL tools such as Microsoft Azure Data Factory Data Bricks and IBM InfoSphere DataStage as well as data modelling methodologies. At least 2 years experience
Analytical and Problem-Solving Skills:
- 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
Communication Skills:
- 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
Experience and Skill Set Requirements: Must Haves: Demonstrated working knowledge of Power BI Desktop, and Power BI Paginated Report Builder [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] Demonstrated work knowledge of ETL tools, such as Microsoft Azure Data Factory, Data Bricks and IBM InfoSphere DataStage, as well as data modelling methodologies. [At least 2 years experience] Skill Set Requirements: Skill Set: 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, IBM InfoSphere DataStage, etc. Technical Knowledge: 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 using ETL tools, such as Microsoft Azure Data Factory, Data Bricks and IBM InfoSphere DataStage, as well as data modelling methodologies. [At least 2 years experience] Analytical and Problem-Solving Skills: 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 Communication Skills: 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