Contract Power BI Developer – Data Analytics & Dashboards

Mbi Llc; Richmond (VA); On-site; USD 96,000 - 124,000; Full time

Job summary

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

Local to Richmond, VA candidates preferred for onsite collaboration and meetings, with focus on Power BI, data modeling, DAX, Power Query, and security.

Qualifications

• Professional BI experience with Power BI.
• DAX measures, time intelligence, performance optimization.
• Power Query data transformation.
• SQL queries on relational data sources.
• Dimensional modeling and star schema design.
• Experience with Dataverse or Dynamics 365 data.
• Translate stakeholder needs into BI solutions.
• Strong data visualization judgment.
• Ability to work independently and manage priorities.
• Implement and test Row-Level Security in Power BI.
• Power BI Service administration concepts.
• Microsoft Fabric familiarity a plus.
• Azure Blob Storage or Cosmos DB as data sources a plus.
• Public sector/compliance experience a plus.
• PL-300 certification a plus.

Responsibilities

• Design, develop, and maintain Power BI reports, dashboards, and semantic models across agency divisions.
• Build solutions on Dataverse data models with existing tables, relationships, and security.
• Develop data connections and transformations using Power Query for additional sources.
• Develop and optimize DAX measures, calculated columns, and model relationships.
• Collaborate with stakeholders to define measures and translate requirements into visuals.
• Support reporting across multiple product teams and priorities.
• Handle short-duration, time-sensitive reporting requests.
• Implement reports following workspace and security standards.
• Ensure handling of sensitive data per SCC standards.
• Maintain and optimize existing reports and datasets.
• Document models, measures, data sources, and refresh dependencies.
• Support end-user adoption via walkthroughs and knowledge transfer.
• Participate in agile ceremonies and backlog refinement.

Skills

Power BI

DAX

Power Query

SQL

Dimensional Modeling

Dataverse

Stakeholder engagement

Data Visualization

Independent Work

Row-Level Security

Power BI Service

Microsoft Fabric

Azure Blob Storage

Cosmos DB

Public Sector

PL-300

Tools

Dataverse

Job description

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

Local to Richmond, VA candidates preferred for onsite collaboration and meetings, with focus on Power BI, data modeling, DAX, Power Query, and security.