Power BI Developer

Title: Power BI Developer

Location: Richmond, VA

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.