Country/Region:  IN
Requisition ID:  10145
Work Model: 
Position Type: 
Salary Range: 
Location:  INDIA - PUNE - BIRLASOFT OFFICE - HINJAWADI

Title:  Sr Technical Lead

Description: 

Job Description: Power BI Sr. Lead (5B)

Experience Overall: 8 to 10 years of overall experience with 5+ years in Power BI

Relevant Experiences:

7+ years of Business Intelligence, Data Warehouse experience.

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

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

3+ 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.
  • Expertise in writing SQL Queries and Stored Procedures (needs complex SQL queries, optimized queries, triggers )
  • Experience or Good knowledge in Power Platform specifically in Power Automate
  • 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 analytical thinking for translating data into informative reports and visuals
  • Sound knowledge in Power BI report publishing and administration.
  • Sound knowledge dynamic and 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 Power BI integration with AI (Co-Pilot)
  • Knowledge of Microsoft Fabric (Good to have)

 

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 Modeling, with exposure to Dimensions, FACTS and DWH and ability to understand the DATA Model to be built for Power BI Data Visualization
  • Strong IT experience in Database Design, Development, and business intelligence of Microsoft SQL Server 2016/2012
  • Experience in working with Data Models, relationship management.
  • Creating virtual / physical relationships and indexes on requirement basis and sound exposure to ER and cardinality in Data Model and DWH
  • Provide mapping from requirements to test case execution to show test coverage and results. 
  • Exposure to SQL query Execution Plan and SQL Profiler for performance tuning of Data.

 

 

Additional Skills:

  • Ability to showcase good communication with Client and stakeholder.
  • Sound Understanding of requirement and showcase ability to work and self-explore on new topics and implement.