Title: Technical Lead
Experience Overall: 6 to 8 years of overall experience with 5+ years in Power BI
Relevant Experiences:
5+ years of Business Intelligence, Data Warehouse experience.
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.
Working experience with Tabular Reporting in Power BI
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.
• Good to have knowledge of Power Platform
• Good to have knowledge of Microsoft Fabric
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.