Power BI Administrator/Lead (3-6 yrs)

Job Description :

Role & Responsibilities :

Power BI Administration :

- Manage and configure the Power BI environment, including workspaces, user access, and settings.

- Monitor Power BI service performance and usage metrics to ensure optimal efficiency.

- Ensure compliance with data governance policies by implementing security protocols, such as Row-Level Security (RLS) and data sensitivity labeling.

User Support and Training :

- Provide technical support for the Power BI users, assisting with troubleshooting and issue resolution.

- Create and maintain documentation for Power BI processes, standards, and best practices.

- Conduct training sessions to upskill users on Power BI usage, including data modeling, visualization best practices, and report sharing.

Data Management and Integration :

- Oversee the integration of data from multiple sources into Power BI and ensure data accuracy and consistency.

- Collaborate with the data engineering team to design and implement efficient data models that enhance Power BI report performance.

- Implement and manage data refresh schedules, ensuring timely and accurate data availability.

Governance and Security :

- Establish and enforce governance policies to maintain data security and compliance across all Power BI assets.

- Configure access controls, manage permissions, and monitor for unauthorized access.

- Maintain documentation related to compliance requirements, data privacy, and security guidelines for Power BI.

Job Requirement :

Primary Skills (Must-Have) :

Power BI Administration Expertise :

- In-depth knowledge of Power BI administration, including workspaces, user roles, and access management.

- Proficiency in configuring Power BI features such as Row-Level Security (RLS), data sensitivity labels, and audit logs.

Data Modeling and DAX Knowledge :

- Strong understanding of data modeling principles within Power BI and proficiency with Data Analysis Expressions (DAX).

- Ability to create and optimize complex data models and measures to enhance report performance.

Data Integration and ETL Skills :

- Experience with integrating data from various sources (SQL Server, Azure Data Lake, APIs, etc.) into Power BI.

- Familiarity with Power Query (M language) for data transformation and preparation.

Troubleshooting and Problem-Solving :

- Strong troubleshooting skills to quickly identify and resolve Power BI-related issues.

- Ability to analyze and optimize Power BI performance metrics.

Good-to-Have Skills :

Microsoft Azure Knowledge :

- Experience with Azure services such as Azure Synapse Analytics, Azure Data Factory, and Azure Active Directory.

- Familiarity with integrating Azure services with Power BI for enhanced data connectivity and management.

Power BI REST API and Automation :

- Knowledge of Power BI REST API for automating tasks like report deployment, workspace management,and usage monitoring.

- Experience with scripting (PowerShell, Python) for automation and custom development.

Database and SQL Proficiency :

- Strong understanding of SQL and experience with relational databases (e.g., SQL Server, Oracle).

- Ability to write and optimize SQL queries to support efficient data extraction and transformation.

Experience with Data Visualization Best Practices :

- Understanding of visualization best practices to ensure reports are insightful, accessible, and easy to understand.

- Knowledge of other visualization tools (e.g., Tableau, Qlik) is a plus.

Strong Communication and Collaboration Skills :

- Ability to effectively communicate technical concepts to non-technical users.

- Experience working in cross-functional teams and managing stakeholder expectations.

Education and Experience :

- Bachelor's Degree in Computer Science, Information Systems, Data Science, or a related field.

- 3+ years of experience as a Power BI Administrator or similar role in data management and analytics.

- Relevant Power BI or Microsoft certifications (e.g., PL-300: Microsoft Power BI Data Analyst) are preferred.