Job description

SCC - Power BI Developer (811014) Virginia Information Technology Agency Title/Role: SCC - Power BI Developer Region Description: Req. Status: Open No. of Openings: 1 Start Date: 10/01/2026 End Date: 09/30/2027 Max Submittals by Vendor: 2 Per Opening Worksite Address: 1300 E Main Street Richmond, VA 23219 Agency Interview Type: Web Cam Interview Only Work Arrangement: Hybrid Short Description: SCC - Power BI Developer Preference is local RVA candidates OR those within 2 hours drive (in case an onsite meeting is required) MAX VENDOR RATE: $88.53 *Deadline to submit: by 4 pm est on Mon 9/21 Complete 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. Skill Required / Desired Amount of Experience Professional experience developing business intelligence and reporting solutions with Microsoft Power BI. Required 4 Years Strong proficiency in DAX, incl. measure development, time intelligence, performance optimization, and a working understanding of row/ filter context Required 3 Years Strong proficiency in Power Query and M for data transformation and preparation. Required 3 Years Proficiency in SQL and experience querying relational data sources Required 3 Years Demonstrated experience with dimensional and semantic data modeling, including star schema design and relationship management Required 2 Years Experience building Power BI reports against Dataverse or Dynamics 365 data Required 2 Years Demonstrated ability to work directly with business stakeholders to elicit reporting requirements and translate them into working solutions Required 4 Years Strong data visualization judgment, including selecting appropriate visuals and designing reports for clarity and usability Required 4 Years Demonstrated ability to work independently and manage competing reporting priorities with minimal direction Required 4 Years Experience implementing and testing row-level security in Power BI Desired 2 Years Experience with Power BI Service administration concepts, incl. workspaces, apps, dataset refresh/ gateway configuration, & deployment across envirome Desired 2 Years Experience with Microsoft Fabric is considered a plus Desired 2 Years Experience with Azure Blob Storage or Cosmos DB as reporting data sources is considered a plus Desired 2 Years Experience working in a public sector, regulatory, or other compliance-driven environment is considered a plus Desired 2 Years Microsoft certification PL-300 (Power BI Data Analyst) is considered a plus Desired 2 Years

Requirements

Must-haves

SCC - Power BI Developer (811014)
Virginia Information Technology Agency
Title/Role: SCC - Power BI Developer
Req. Status: Open
No. of Openings: 1
Start Date: 10/01/2026
End Date: 09/30/2027
Max Submittals by Vendor: 2 Per Opening
Worksite Address: 1300 E Main Street Richmond, VA 23219
Agency Interview Type: Web Cam Interview Only
Work Arrangement: Hybrid
SCC - Power BI Developer
Preference is local RVA candidates OR those within 2 hours drive (in case an onsite meeting is required)
Deadline to submit: by 4 pm est on Mon 9/21
Preference is local RVA candidates OR those within 2 hours drive (in case an onsite meeting is required)
• 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.

Nice-to-haves

Experience with Microsoft Fabric is considered a plus Desired 2 Years
Experience with Azure Blob Storage or Cosmos DB as reporting data sources is considered a plus Desired 2 Years
Experience working in a public sector, regulatory, or other compliance-driven environment is considered a plus Desired 2 Years
Microsoft certification PL-300 (Power BI Data Analyst) is considered a plus Desired 2 Years

Application prep

Use the role’s language and application details while tailoring your materials.

Keywords to mirror

sqlazureagile

Platform: jobdiva
Effort: medium

Benefits

Benefits detected in the listing.

Vision