JOB SUMMARY
Role Overview: We are seeking a highly skilled Power BI Expert to design, develop, implement and governance of Power BI solutions. Ideal candidate will have in-depth knowledge of Power BI architecture, data modeling, governance, embedded analytics and database management. The role requires expertise Power BI Data Gateways, report deployment, and governance frameworks ensuring scalable and secure data solutions.
PRIMARY RESPONSIBILITIES
- Power BI Lead & Implementation:
- Design, develop, and deploy interactive Power BI reports and dashboards.
- Create efficient data models to optimize performance and scalability.
- Develop complex DAX expressions for business logic and calculations.
- Optimize report performance by using best practices in Power BI and SQL
- Power BI Architecture & Configuration:
- Configure and manage Power BI Data Gateways for secure and seamless data access
- Define and enforce Power BI workspace, dataset, and security policies.
- Implement row-level security (RLS) and data governance best practices.
- Establish data refresh schedules and ensure efficient data ingestion pipelines.
- Maintain and enhance Power BI Premium and Embedded solutions.
- Embedded Analytics & Integration:
- Integrate Power BI reports with external applications using Power BI Embedded.
- Work with Power BI REST APIs to automate workflows.
- Integrate Power BI with Oracle, SQL Server, MySQL, Microsoft Share point, Excel, Cloud data source etc.,
- Database & Performance Optimization:
- Write optimized SQL queries and stored procedures for report development.
- Ensure high-performance data refreshes and query execution.
- Work with ETL team to improve data integration with PowerBI
- Governance & Security:
- Define Power BI governance framework and best practices for standardization.
- Monitor user access, performance, and usage analytics to drive efficiency.
- Manage user roles, access controls, and data security.
- PowerApps & Power Automate (Nice to Have):
- Build PowerApps applications to extend Power BI functionality and create interactive business solutions
- Automate data flows and reporting updates using Power Automate (Flows, Triggers, Approvals, Notifications, etc.).
- Integrate Power BI, PowerApps, and Power Automate to create end-to-end business process automation.
- Stakeholder Collaboration & Training:
- Work closely with business users, data engineers, and leadership teams to understand and document reporting requirements.
- Provide training and best practice guidance to Power BI users across the organization.
- Develop self-service Power BI frameworks to empower business teams for reporting.
