Job Description

Roles and Responsibilities:

• 1-3 years of Experienced in MS Excel data cleaning and analysing using various features such as Pivot Tables & Pivot Charts, Look ups, Rank & Conditional Formatting
• Good Knowledge on Power BI Data Modelling and Data Warehousing concepts like Star Schema, Snowflake Schema, Dimensions, Fact Tables, Relationships and Filter Directions
• 1-3 years of experience in Power Query and Power Pivot for Connecting, Importing, Shaping and Transforming data for Business Intelligence tools like Excel and Power BI
• Designing Power BI reports and dashboards as per the requirement using Power BI inbuilt and custom visualizations like Bullet Charts, Histogram, San-key, eports, Creating Workspace, Publishing Reports, Designing Good Looking & Meaningful Dashboards, Publishing dashboards and Row Level Security Implementation
• Working Knowledge in implementing report Slicers, Bookmarks, Hierarchy, Drill Down, Drill Through, Filters, Interactions and Custom Themes
• Collaborate with business teams to design and implement projects. To understand business requirements in the BI context and design data models to convert raw data to meaningful insights
• Analysis and development of complex DAX Queries, Reports and Dashboards KPIs with clear objectives and monitor them consistently.

• 1-3 years of experience in VBA programming knowledge, VB.NET, SQL Server & Power BI
• Strong knowledge of Visual Basic, VBA, VB.NET, Integrate capability in Excel-based tools to both pull and push data from/to SQL Server
• Must be able to analyse, write code, technical knowledge to prepare requirement documents conduct impact analysis and do testing.
• Must have excellent programming knowledge of MS Excel VBA macros, excel functions, coding knowledge, Estimating, designing, and developing code solutions, testing, debugging, and documenting programs on complex projects
• Both under graduates and post graduates can apply
• Good communication (Demonstrate strong reading comprehension and writing skills)
• Able to work independently, strong analytic skills

NTT Data