Power BI Developer - Data Visualization & DAX Expert

Intellibee; Richmond (VA); On-site; USD 110,000 - 140,000; Full time

Job summary

The State Corporation Commission (SCC) Enterprise Technology Services (ETS) Division seeks a contract Power BI Developer to design, build, and maintain reporting and analytics solutions across agency divisions. This full-time contract spans an initial one-year term with a potential extension.

The role emphasizes building on Dataverse data models, optimizing DAX, and delivering robust visualizations while ensuring data security and alignment with governance standards.

Qualifications

• Proven experience developing BI/reporting solutions with Power BI (4+ years).
• Strong DAX, time intelligence, performance optimization skills (3+ years).
• Power Query/M data transformation experience (3+ years).
• SQL querying of relational data sources (3+ years).
• Dimensional/semantic modeling including star schema (2+ years).
• Experience building Power BI reports against Dataverse or Dynamics 365 data (2+ years).
• Ability to elicit reporting requirements from business stakeholders (4+ years).
• Strong data visualization judgment for clarity and usability (4+ years).
• Ability to work independently and manage competing priorities (4+ years).
• Desirable: Row-level security in Power BI (2+ years).
• Desirable: Power BI Service administration concepts (2+ years).
• Desirable: Microsoft Fabric (2+ years).
• Desirable: Azure Blob Storage or Cosmos DB as data sources (2+ years).
• Desirable: Public sector/compliance-driven environment (2+ years).
• Desirable: PL-300 certification (2+ years).

Responsibilities

• Design, develop, and maintain Power BI reports, dashboards, and semantic models across agency divisions.
• Build reporting solutions on existing Dataverse data models with current tables, relationships, and security.
• Create data connections and transformations using Power Query across SQL Server, Azure Blob Storage, Cosmos DB.
• Develop and optimize DAX measures, calculated columns, and model relationships.
• Collaborate with stakeholders to define metrics and translate questions into visuals.
• Support multiple product teams and prioritization under the SCC BI lead.
• Handle time-sensitive reporting requests as agency priorities require.
• Ensure reports follow workspace structure, dataset management, and security standards.
• Protect sensitive data per SCC classification and security requirements.
• Document models, data sources, and refresh dependencies for maintenance.
• Facilitate end-user adoption via walkthroughs and knowledge transfer.
• Participate in agile ceremonies and requirement discussions.

Skills

Microsoft Power BI

DAX

Power Query/ M

SQL

Dimensional/semantic modeling

Dataverse/Dynamics 365 data

Stakeholder collaboration

Data visualization

Priority & time management

Row-level security (RLS)

Power BI Service administration

Microsoft Fabric

Azure Blob Storage/Cosmos DB as data源

Public sector experience

Microsoft PL-300

Job description

The State Corporation Commission (SCC) Enterprise Technology Services (ETS) Division seeks a contract Power BI Developer to design, build, and maintain reporting and analytics solutions across agency divisions. This full-time contract spans an initial one-year term with a potential extension.

The role emphasizes building on Dataverse data models, optimizing DAX, and delivering robust visualizations while ensuring data security and alignment with governance standards.