SCC - Power BI Developer

Job Description

Job Description

• Job Title : SCC - Power BI Developer
• Work Type: Hybrid

• Location: Richmond, VA
• Salary: $49–$69 per hour
• Start Date: 10/01/2026
• End Date: 09/30/2027
• Industry Category: Information Technology / Business Intelligence & Data Analytics
• Employment Type: 1099 Contract
• Requisition ID: 811014
  

Overview:

• The State Corporation Commission (SCC) is seeking a Power BI Developer to design, develop, maintain, and enhance reporting and analytics solutions supporting business divisions and product teams.
• The role focuses on Microsoft Power BI, DAX, Power Query/M, SQL, semantic data modeling, Dataverse/Dynamics 365, and business stakeholder collaboration.
• This is a full-time, one-year contract engagement with an option to extend.
• Preference is for candidates local to Richmond, VA or within approximately a 2-hour drive in case an onsite meeting is required.
  

Application:

• Submit an updated resume highlighting:
• 4+ years of professional Microsoft Power BI development.
• 3+ years of DAX and Power Query/M.
• 3+ years of SQL and relational data querying.
• 2+ years of dimensional/semantic data modeling.
• 2+ years of Power BI reporting against Dataverse or Dynamics 365.
• 4+ years of business stakeholder requirements gathering and solution development.
• 4+ years of data visualization and report design.
• 4+ years independently managing competing reporting priorities.
• Highlight any preferred experience with Power BI Service administration, row-level security, Microsoft Fabric, Azure Blob Storage, Cosmos DB, public-sector/regulatory environments, and PL-300 certification.
• Include current city and state of residence.
• Candidates must physically reside within the United States for the duration of the assignment.
  

Job Description:

• Design, develop, and maintain Power BI reports, dashboards, and semantic models.
• Build reporting solutions using established Dataverse data models, including existing tables, relationships, and security configurations.
• Develop Power Query/M transformations and data connections for sources including SQL Server, Azure Blob Storage, and Cosmos DB.
• Develop and optimize DAX measures and calculated columns.
• Manage semantic model relationships for accuracy and performance.
• Work with business stakeholders to gather reporting requirements, define metrics, and translate business questions into effective visualizations.
• Support reporting needs across multiple product teams and agency initiatives.
• Maintain existing reports and datasets, including performance tuning, refresh troubleshooting, and defect resolution.
• Apply established workspace, dataset management, row-level security, and data classification standards.
• Document semantic models, measures, data sources, and refresh dependencies.
• Provide report walkthroughs and knowledge transfer to business users and SCC staff.
• Participate in Agile ceremonies, backlog refinement, and requirements discussions.
  

Responsibilities:

• Develop and maintain Power BI dashboards, reports, and semantic models.
• Create optimized DAX measures and calculated columns.
• Build and maintain Power Query/M data transformations.
• Query relational data sources using SQL.
• Develop dimensional and semantic models, including star schemas and relationship management.
• Work with Dataverse and Dynamics 365 data.
• Gather, analyze, and document reporting requirements.
• Translate business requirements into practical reporting solutions.
• Design clear, usable, and appropriate data visualizations.
• Troubleshoot data refresh, report, and dataset issues.
• Support established security and sensitive-data handling requirements.
• Manage multiple reporting priorities independently with minimal direction.
• Document solutions and support knowledge transfer.

Requirements

• 4+ years of professional experience developing business intelligence and reporting solutions using Microsoft Power BI.
• 3+ years of strong DAX experience, including:
• Measure development.
• Time intelligence.
• Performance optimization.
• Row and filter context.
• 3+ years of strong Power Query and M experience.
• 3+ years of SQL experience and querying relational data sources.
• 2+ years of dimensional and semantic data modeling, including star schema design and relationship management.
• 2+ years of experience building Power BI reports against Dataverse or Dynamics 365 data.
• 4+ years of experience working directly with business stakeholders to gather reporting requirements and translate them into working solutions.
• 4+ years of data visualization and report design experience.
• 4+ years of experience working independently and managing competing reporting priorities with minimal direction.
• Must be legally authorized to work in the United States without employer sponsorship, now or in the future.
• Must physically reside within the United States for the duration of the assignment.

• 2+ years of experience implementing and testing row-level security in Power BI.
• 2+ years of experience with Power BI Service administration concepts, including workspaces, apps, dataset refresh, gateway configuration, and deployment across environments.
• 2+ years of Microsoft Fabric experience.
• 2+ years of experience using Azure Blob Storage or Cosmos DB as reporting data sources.
• 2+ years of experience working in a public-sector, regulatory, or compliance-driven environment.
• Microsoft PL-300 Power BI Data Analyst certification.

Benefits

Compensation:

• Pay Rate: $49–$69 per hour.

• Contract Type: 1099 Contract.

• Expenses: Not specified as reimbursed.
  

Schedule:

• Full-time

• Start Date: 10/01/2026

• End Date: 09/30/2027

Work Location:

• Richmond, VA.

• Specific onsite scheduling will be determined by SCC based on business needs.