Power BI Administrator / Developer

The Power BI Developer & Administrator is a technical expert responsible for building, optimizing, and maintaining Power BI reporting solutions and infrastructure. This role works closely with data engineers and business analysts to design enterprise-grade data models, write optimized SQL queries, manage Power BI Service workspaces, and ensure secure, high-performing dashboards.

This is a hands-on technical role requiring deep experience in Power BI architecture, DAX, SQL, and data modeling along with knowledge of Azure SQL and ADF pipelines.

Essential Duties and Responsibilities

• Power BI Development: Create visually compelling and user-friendly dashboards, paginated reports, and semantic models using Power BI Desktop and Service.
• Data Modeling & DAX: Develop DAX measures, calculated columns, and reusable data models that follow best practices and support scalability.
• Environment Administration: Manage Power BI workspaces, datasets, gateways, refresh schedules, and enforce governance policies.
• Security: Configure and maintain row-level security (RLS) to protect sensitive data.
• SQL Development: Write and tune SQL queries, views, and stored procedures in Azure SQL to optimize reporting performance.
• Performance Monitoring: Monitor dataset refresh performance, troubleshoot failures, and recommend optimizations.
• Collaboration: Work closely with business users, analysts, and data engineers to ensure data pipelines deliver accurate, ready-to-use information.
• Training & Support: Provide self-service analytics enablement by mentoring power users and documenting data models and report usage.

Qualifications

• Bachelor’s degree in Data Analytics, Computer Science, or related field.
• 4–6+ years of hands-on experience in Power BI development and administration.
• Proven experience managing Power BI in an enterprise environment (workspace governance, security, performance tuning).
• Strong background in SQL development and experience with Azure SQL/Synapse
• Expert-level knowledge of DAX and Power Query (M language).
• Strong understanding of data modeling (star schema, snowflake schema, surrogate keys, SCDs).
• Proficiency with Power BI Service features: deployment pipelines, incremental refresh, composite models.
• Skilled in query optimization and performance tuning for large datasets.
• Familiarity with Power BI REST API, PowerShell scripting, and CI/CD pipelines.
• Nice to Have: Experience with Power Apps and Power Automate for extended automation and workflows.
• Excellent documentation and communication skills.