Power BI Developer / Business Analyst

Power BI Developer / Business Analyst

Job Description

Description:

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.

VIVA is an equal opportunity employer. All qualified applicants have an equal opportunity for placement, and all employees have an equal opportunity to develop on the job. This means that VIVA will not discriminate against any employee or qualified applicant on the basis of race, color, religion, sex, sexual orientation, gender identity, national origin, disability or protected veteran status