Technical Specialist- Power BI

Country/Region: IN
Requisition ID: 22070
Work Model:
Position Type:
Salary Range:
Location: INDIA - PUNE - BIRLASOFT OFFICE - HINJAWADI
Title: Technical Specialist- Power BI
Description:
Area(s) of responsibility
Job Description: Power BI Lead

Experience Overall: 6 to 8 years of overall experience with 4+ years in Power BI

Relevant Experiences:

3+ years of Business Intelligence, Data Warehouse experience. .(Good Knowledge on BI and Data Warehousing concepts).

3+ years’ experience with Data modelling with Power Query and Power Pivot

4+ years’ experience and a deep technical knowledge of Power BI Desktop / Pro / Premium

2+ years’ experience with advanced MDX and DAX expressions

Visualization Skillsets: -

Handson experience with Power BI desktop Dashboard and Report development with sound formatting and navigation Skills
Strong aptitude for Power BI architecture and its integration with embedded application and Security features along with deep exposure to Power BI Pro and Premium capabilities and Apps
Expertise in DAX (Data Analysis Expressions) for creating custom calculations in Power BI is crucial. Work with Query Editor and troubleshooting DAX formulae for performance optimization.
Responsible for developing visual reports, KPI scorecards, and dashboards using Power BI desktop
Should have exposure to requirement understanding for translating data into informative reports and visuals
Sound knowledge in Power BI report publishing and administration.
Sound knowledge Role based security along with integration using Power Automate for workflows.
Troubleshoot data-related issues, maintain the Power BI infrastructure, and use the latest Power BI features, updates, and best practices.
Exposure to Power BI gateway, content pack, advance and recent features of Power BI embedding using REST API
Work with Multiple Data sources and knowledge of selection of import, Live connection, and direct query data importing
Creation of HLD and LLD design documents and Unit Test cases
Exposure latest features released every month for Power BI services.
Database Key Skills :

Handson experience with T-SQL code for creating Stored Procedure, functions, and handling data validations.
Performance Monitoring using execution plans and Index tuning Designed and Developed Database Objects like Tables, Stored Procedures, user defined data types and functions for the project.
Developed, tested, and implemented Referential Integrity rules and regulations through constraints, triggers and views, partitioned views.
Sound Knowledge of Data Modelling, with exposure to Dimensions, FACTS and DWH and ability to understand the DATA Model to be built for Power BI Data Visualization. Read more