BI Developer

Sr Technical Lead-Data Engg-Power Bi

Area(s) of responsibility

About Birlasoft:
Birlasoft, a global leader at the forefront of Cloud, AI, and Digital technologies, seamlessly blends domain expertise with enterprise solutions. The company’s consultative and design-thinking approach empowers societies worldwide, enhancing the efficiency and productivity of businesses. As part of the multibillion-dollar diversified CKA Birla Group, Birlasoft with its 12,000+ professionals, is committed to continuing the Group’s 170-year heritage of building sustainable communities.

1.    About the Job –Experience Overall: 8 to 10 years of overall experience with 5+ years in Power BI
2.    Job Title – Power BI Sr. Lead 
3.    Location: Mumbai, Pune, Noida only
4.    Educational Background – Bachelor's degree in Computer Science, Information Technology, or related field.
JOB DESCRIPTION
4+ 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 ) 
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 
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 Level

Senior Level