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.
