Lead Data Engineer - Power BI (T500-4169)

The resource should have 10+ years’ experience in MS-Power BI, Analysis services (AAS/Tabular SSAS). Should have good knowledge in Azure BI Platform (Azure BLOB, Azure data factory, Synapse) and strong SQL knowledge.

Experience in Azure ML will be a major advantage.

Essential Job Functions:

Power BI Stack Development (Power Query, Power Pivot and Power View)
Design and develop Power BI reports
Modelling & DAX using PowerBI
PBI Report performance tuning
UI Expertise
Power BI service/cloud
Power BI Admin
Gateway configuration
Row-level security

Azure BI platform
SQL Data Warehouse/Synapse
Azure Analysis Services (AAS)
Azure Data Factory (ADF)

Job Responsibilities:

Ability to build Power BI Reports/ Dashboards and Reports by connecting to varied data sources
Comfortable in working on DAX formula language
Perform extract, transform, join & project data from disparate sources like Snowflake/Teradata, AAS, Azure Synapse, SQL Server, flat files.
Experience in working with power bi gateways.
Experience in Azure ML is major plus
Ability to Perform Data Cleansing and Data Profiling.
Ability to optimize report performance.
Experience in implementing Row Level Security.
Document, collaborate & communicate with multiple stake holders
Coordinate and communicate between business users and the data engineering teams
Ability to organize and lead meetings with business and operational data owners
Work closely with business stakeholder, data analyst and data engineering team to perform data transformation.
Understand the business requirements/ questions to be answered
Design and align on mock-ups
Define visuals and key KPI's that enables speed to insight
Work with Data engineering team closely to perform data extraction and data transformation processes to create the data set required for the dashboard
Develop the mock-up design in Power BI and load the dashboard with real data
Implement feedback from business users and create final version of the PB reports
Scale, maintain and improve existing solutions
Refresh the prototype with live data
Implement feedback from business users and further enhance the PB reports
Migrating solutions to production environment
Prepare holistic documentations (process and technical) to enable proper knowledge transfer of both process and solution to the production team
Enable seamless transition via shadow and reverse shadow process
Support and consult the production team if required

Professional in This Role Get To

Keep management updated: Develop and Administer Power BI Projects with Building reporting models
Impact the bottom line: Work on Development of visual reports, dashboards and KPI scorecards using Power BI Desktop and Connecting to data sources, importing data and transforming data for Business Intelligence
Strengthen relationships: Establish and maintain communication with end-users and /or team members; understand their needs, resolve issues, and meet expectations as agreed
Take the lead: Understand the business requirements and develop data models accordingly and Develop unit tests and provides code coverage to accurately test business logic and functionality with good experience in Project Documentation.

hyderabad, TG, IN