Power BI Developer

Ampcus Inc.•Richmond, VA

1d•Onsite

About The Position

The 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.

Requirements

Design, develop, and maintain Power BI reports, dashboards, and semantic models
Build reporting solutions on established Dataverse data models
Develop data connections and transformations using Power Query
Develop and optimize DAX measures, calculated columns, and semantic model relationships
Work with business stakeholders to understand reporting needs
Support reporting needs across multiple product teams
Support short-duration, time-sensitive reporting requests
Implement reports in accordance with established workspace structure, dataset management, and row-level security standards
Apply appropriate handling of sensitive and restricted data
Maintain and enhance existing reports and datasets
Document semantic models, measure definitions, data sources, and refresh dependencies
Support end user adoption through report walkthroughs and knowledge transfer
Participate in agile ceremonies, backlog refinement, and requirements discussions

Responsibilities

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 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 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 maintenance and knowledge retention.
Support end user adoption through report walkthroughs and knowledge transfer to business users and staff.
Participate in agile ceremonies, backlog refinement, and requirements discussions.