Power BI Developer (Only AZ)

Power BI Front-End Developer Knowledge, Skills, and Abilities (KSA) Document

1. Knowledge

Power BI & Data Visualization

• - Strong understanding of Power BI Desktop and Power BI Service.
• - Knowledge of data modeling concepts, including star schemas, relationships, and data normalization.
• - Understanding of DAX (Data Analysis Expressions) for calculated columns, measures, and KPIs.
• - Familiarity with Power Query (M language) for data transformation and cleaning.
• - Knowledge of report lifecycle management, workspace configurations, and dataset governance.
• - Awareness of row-level security (RLS) and data access best practices.
• - Understanding of UX/UI principles for dashboard layout, color theory, and effective data storytelling.
• - Knowledge of Power BI Paginated Reports for pixel-perfect, production-ready reporting.

Data & BI Concepts

• - Solid understanding of business intelligence principles, including ETL, semantic modeling, and data governance.
• - Working knowledge of SQL and relational database structures.
• - Knowledge of common data sources used in enterprise BI (SQL Server, SharePoint, Azure Synapse, Dataverse, etc.).
• - Knowledge of healthcare operations and terminology, preferably within Medicaid, including claims, encounters, eligibility, provider data, and regulatory reporting requirements.

Microsoft Ecosystem

• - Familiarity with Microsoft Fabric, Azure Data Lake, and other cloud data tools.
• - Knowledge of integrating Power BI with Power Apps, Power Automate, and Teams.

2. Skills

Technical Skills

• - Ability to design intuitive and engaging Power BI reports with drill-through, bookmarks, hierarchies, and custom visuals.
• - Strong DAX development skills to build dynamic, scalable measures.
• - Skilled in data cleansing, merging, and transformation with Power Query.
• - Ability to optimize report performance (reducing load times, improving model efficiency).
• - Experience publishing, refreshing, and managing datasets in Power BI Service.
• - Ability to troubleshoot data issues, refresh failures, and performance bottlenecks.
• - Ability to automate and orchestrate processes using Power Automate.

Analytical & Problem-Solving Skills

• - Ability to translate business questions into analytical requirements.
• - Comfortable working with ambiguous or incomplete requirements.
• - Skilled at data storytelling - presenting insights clearly and concisely.

Collaboration Skills

• - Works effectively with business stakeholders, data engineers, and leadership.
• - Strong communication skills to explain technical concepts in simple terms.
• - Ability to gather requirements through interviews, workshops, or user stories.

3. Abilities

Design & Development Abilities

• - Ability to create user-friendly dashboards aligned with business needs and branding guidelines.
• - Ability to prototype and iterate on visual designs based on feedback.
• - Ability to maintain version control and manage incremental report updates.

Operational & Organizational Abilities

• - Ability to manage multiple report development projects simultaneously.
• - Ability to prioritize enhancements, bugs, and stakeholder requests.
• - Ability to write clear documentation for data models, reports, and processes.

Strategic Abilities

• - Ability to identify new opportunities where analytics can improve decision-making.
• - Ability to enforce and improve BI governance and best practices.
• - Ability to serve as a subject matter expert (SME) on BI tools and visualization standards.

4. Optional / "Nice-to-Have" KSAs

• - Knowledge of Python or R for advanced analytics.
• - Experience with Microsoft Fabric, Lakehouses, or Azure Synapse.
• - Familiarity with Agile/Scrum environments.
• - Experience creating custom Power BI visuals using JavaScript or TypeScript.

Required Skills

• Strong understanding of Power BI Desktop and Power BI Service (minimum 5 years of experience)
• Understanding of UX/UI principles for dashboard layout, color theory, and effective data storytelling.
• Working knowledge of SQL and relational database structures.
• Education Bachelors Degree

Preferred Skills

• Knowledge of healthcare operations and terminology, preferably within Medicaid, including claims, encounters, eligibility, provider data, and regulatory reporting requirements.