Power BI Developer

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

- Preference is local RVA candidates OR those within 2 hours drive (in case an onsite meeting is required)

- The State Corporation Commission’s (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 with an initial term of one year and the option to extend.

Responsibilities Include:

• Design, develop, and maintain Power BI reports, dashboards, and semantic models supporting business divisions and product teams across the agency.
• Build reporting solutions on established Dataverse data models, working with existing tables, relationships, and security configurations rather than defining the underlying data layer.
• Develop data connections and transformations using Power Query against additional sources as required, including SQL Server, Azure Blob Storage, and Cosmos DB.
• Develop and optimize DAX measures, calculated columns, and semantic model relationships for accuracy and performance.
• Work with business stakeholders to understand reporting needs, define measures and metrics, and translate business questions into usable visualizations.
• Support reporting needs across multiple product teams and divisional efforts, with assignment and prioritization directed by the SCC Power Platform and business intelligence lead.
• Support short-duration, time-sensitive reporting requests as agency priorities require.
• Implement reports in accordance with established workspace structure, dataset management, and row-level security standards, and contribute recommendations to strengthen those standards.
• Apply appropriate handling of sensitive and restricted data in accordance with SCC data classification and security requirements, building to established security design.
• Maintain and enhance existing reports and datasets, including performance tuning, refresh troubleshooting, and defect resolution.
• Document semantic models, measure definitions, data sources, and refresh dependencies to support ongoing SCC maintenance and knowledge retention.
• Support end user adoption through report walkthroughs and knowledge transfer to business users and SCC staff.
• Participate in agile ceremonies, backlog refinement, and requirements discussions.

Fill the skill matrix below:

Skill

Amount

Candidate's No. of years of experience

Professional experience developing business intelligence and reporting solutions with Microsoft Power BI.

Required

4

Strong proficiency in DAX, incl. measure development, time intelligence, performance optimization, and a working understanding of row/ filter context

Required

3

Strong proficiency in Power Query and M for data transformation and preparation.

Required

3

Proficiency in SQL and experience querying relational data sources

Required

3

Demonstrated experience with dimensional and semantic data modeling, including star schema design and relationship management

Required

2

Experience building Power BI reports against Dataverse or Dynamics 365 data

Required

2

Demonstrated ability to work directly with business stakeholders to elicit reporting requirements and translate them into working solutions

Required

4

Strong data visualization judgment, including selecting appropriate visuals and designing reports for clarity and usability

Required

4

Demonstrated ability to work independently and manage competing reporting priorities with minimal direction

Required

4

Experience implementing and testing row-level security in Power BI

2

Experience with Power BI Service administration concepts, incl. workspaces, apps, dataset refresh/ gateway configuration, & deployment across envirome

2

Experience with Microsoft Fabric is considered a plus

2

Experience with Azure Blob Storage or Cosmos DB as reporting data sources is considered a plus

2

Experience working in a public sector, regulatory, or other compliance-driven environment is considered a plus

2

Microsoft certification PL-300 (Power BI Data Analyst) is considered a plus

2