Key Skills: Data Modelling, Power BI, SQL, DAX, Dashboards, Creating dashboards & reports, MSExcel, Data Visualization, Azure, Azure ADF.
Roles & Responsibilities:
- Design and build Power BI reports and dashboards using DAX, Power Query (M), bookmarks, and drill-through features.
- Implement semantic models using best practices.
- Develop Paginated (RDL) reports using Power BI Report Builder.
- Tune and optimize reports connected to On-prem / Cloud databases via DirectQuery for performance.
- Manage and monitor Power BI Premium P1 capacity, including auto-scaling, memory usage, CPU load, and report cache strategies.
- Troubleshoot on-premises data gateways and optimize connector settings.
- Collaborate on report classification and governance, including report lifecycle, naming conventions, RLS/OLS, and sensitivity labels.
- Integrate Power BI with multiple systems and design unified models across sources.
- Lead a team of visualization developers and participate in task planning and assignment.
- Automate Power BI reports and implement RPA solutions.
- Present data findings and recommendations to functional areas impacted by analysis.
- Analyze data to identify underlying principles and contribute analyses to departmental groups.
- Organize, plan, and prioritize work to improve productivity and achieve tangible results.
- Establish and maintain constructive working relationships across the organization.
Experience Required:
- 6-9 years of experience in building and optimizing Power BI dashboards and reports.
- Strong hands-on expertise in data modeling, DAX, and performance tuning for large datasets.
- Experience with Power BI Premium capacity management and monitoring.
- Background in integrating Power BI with diverse data sources and implementing governance practices.
- Exposure to automation using RPA tools and Power BI Report Builder for Paginated Reports.
- Ability to lead small teams and drive task ownership while collaborating with stakeholders.
Education: B.Tech M.Tech (Dual), BCA, B.E., B.Tech, MCA