PowerBI & BI Senior Cloud Specialist

Job Description 1. Main responsibility of the job holder is to design, develop and maintain Power BI dashboards in cloud with other BI Major/Minor enhancement projects and contribute skills to Analytics project as and when required. 2. Lead planning and implementation of BI projects. Job holder will actively participate in the requirement gathering &analysis, design and understanding of end-to-end BI solution architectures, testing and implementation phases enabling performance of the entire platform. 3. Work with IT project manager to determine project missions, goals, tasks, timelines and resource requirements; manage the overall Project Plan; resolve or assist in the resolution of conflicts within and between BI projects or functional areas; develop methods to monitor project’s overall progress; and provide corrective supervision if necessary. 4. Job Holder role is responsible for conceptualizing complex Institutional problems, discovering business insights through visualization techniques. Should be well adapt to develop and execute database queries and conduct analysis. 5. Knowledge of ETL/ELT tools, cube design, platform enabling configuration is essential. 6. The role requires job holder to be a creative thinker and able to propose innovative ways to look at business problems by proper analysis of data to identify the co-relations and defining proper KPIs and metrics so as to benefit Business teams with the entire workflow. 7. Also, BI Specialist will need to present back their findings to the business and conduct wireframe sessions or user walkthrough of the platform. One of the key responsibilities of this role is to work on the analytics opportunities to support digital transformation initiatives. 8. Need to perform Business Analysis of BRD to make sure business and IT team clearly understands the scope and requirements. 9. Review functional solution documents prepared by the IT team to make sure they meet the business requirements. 10. In addition to the normal roles of project management, job holder is also expected to work closely with the business teams and interpret their BI needs in technical terms, and define the same to ensure adherence to all BI standards and best practices. 11. Should have a very good understanding of data and ability to answer complex analytic questions to help organization shape its products and services in a better way. 12. Embark on exploratory data analysis projects to achieve better understanding of phenomena as well as to discover untapped areas of growth and optimization. 13.Work on projects that promote data based decision across business strategy, product design, campaign management and customer service and work out data driven solutions, create significant value addition 14. Work with business team to document the business requirements, anticipated benefits, success criteria for analytics initiatives. JOB KNOWLEDGE SKILLS ANDEXPERIENCE : 1. Enterprise-scale technical experience with cloud and hybrid infrastructures, architecture designs ,database migrations, dashboard development and technology management. Required 2. Breadth of technical experience and knowledge, with depth / Subject Matter Expertise in the following required: a. 5+ years of hands-on experience in design and development of dashboard, reports, data model using Power BI, particularly Power BI Cloud based development b. Extensive experience of working with products like Microsoft SQL Server Analysis Services (SSAS) tabular Cube development, String SSIS and Server Reporting Services (SSRS) c. Very strong SQL skills for querying and creation of views/tables, functions and stored procedures d. Experience in Data Warehouse, ETL processing, Tabular models, DAX and M query e. Experience with Multidimensional concepts, data modeling and MDX query f. Development or Coding experience with C#, Web API, .Net, Powershell, SQL NoSQL Databases including OSS(Maria, Mongo etc), Cosmos DB g. Exposure to working/building cubes for huge datasets (required) h. Knowledge of Visual Studio 3. Working experience in banking sector or in a leading solution vendor for banking products.(required) 4. Working experience within Finance team (desirable) 5. Exploratory data analysis experience 6. Strong written and verbal communication skills 7. Strong analytical skills with the ability to collect, organize, analyse, and disseminate significant amounts of information with attention to detail and accuracy 8.Knowledge of the following to facilitate the development of custom visuals: (desirable) a. TypeScript development tools b. D3 JavaScript libraries c. Scalable Vector Graphics (SVG