Power BI Developer - Hybrid Richmond, VA

Novalink Solutions LLC; Richmond (VA); On-site; USD 90,000 - 120,000; Full time

Job summary

Novalink Solutions LLC is seeking a contract Power BI Developer for the State Corporation Commission in Virginia. The role focuses on designing, building, and maintaining reporting and analytics solutions across the agency.

Initial term is one year with potential extensions, and local RVA candidates or those within two hours' drive are preferred. The candidate will work on Power BI reports, portals, and semantic models, leveraging Dataverse data models, SQL Server, Azure Blob Storage, and Cosmos

Qualifications

• Professional experience developing BI and reporting with Power BI.
• Strong DAX, time intelligence, and performance optimization.
• Strong Power Query and M for data prep.
• Proficiency in SQL and relational data sources.
• Experience with dimensional data modeling and star schemas.
• Experience building Power BI reports with Dataverse/Dynamics 365.

Responsibilities

• Design, develop, and maintain Power BI reports, dashboards, and semantic models.
• Build reporting solutions on Dataverse data models and existing tables.
• Develop data connections and transformations using Power Query and SQL-based sources.
• Optimize DAX measures and relationships for performance and accuracy.
• Collaborate with stakeholders to translate reporting needs into visuals.
• Support multiple product teams and agency priorities for reporting needs.
• Document models, data sources, and refresh dependencies.

Skills

Power BI

DAX

Power Query

SQL

Data modeling

Data visualization

Stakeholder engagement

Row-level security

Time intelligence

Tools

Dataverse

Dynamics 365

Power BI Service

Azure Blob Storage

Cosmos DB

Job description

• Actual Job Title 811014 - SCC - Power BI Developer
• Job Type FT Contract
• Country United States

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.

Requirements

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