Power BI Developer
DataStaff, Inc is in need of a Power BI Developer for a long-term contract opportunity for one of our direct clients in Richmond, VA.
*This position is hybrid
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.
Required Skills:
- 4 Years - Professional experience developing business intelligence and reporting solutions with Microsoft Power BI.
- 3 Years - Strong proficiency in DAX, including measure development, time intelligence, performance optimization, and a working understanding of row/ filter context
- 3 Years - Strong proficiency in Power Query and M for data transformation and preparation.
- 3 Years - Proficiency in SQL and experience querying relational data sources
- 2 Years - Demonstrated experience with dimensional and semantic data modeling, including star schema design and relationship management
- 2 Years - Experience building Power BI reports against Dataverse or Dynamics 365 data
- 4 Years - Demonstrated ability to work directly with business stakeholders to elicit reporting requirements and translate them into working solutions
- 4 Years - Strong data visualization judgment, including selecting appropriate visuals and designing reports for clarity and usability
- 4 Years - Demonstrated ability to work independently and manage competing reporting priorities with minimal direction
Desired Skills:
- 2 Years - Experience implementing and testing row-level security in Power BI
- 2 Years - Experience with Power BI Service administration concepts, incl. workspaces, apps, dataset refresh/ gateway configuration, & deployment across envirome
- 2 Years - Experience with Microsoft Fabric is considered a plus
- 2 Years - Experience with Azure Blob Storage or Cosmos DB as reporting data sources is considered a plus
- 2 Years - Experience working in a public sector, regulatory, or other compliance-driven environment is considered a plus
- 2 Years - Microsoft certification PL-300 (Power BI Data Analyst) is considered a plus
This opportunity is available on a corp-to-corp basis or as a W2 position with a competitive benefits package. DataStaff, Inc. offers medical, dental, and vision coverage options as well as paid vacation, sick, and holiday leave. As many of our opportunities are long-term, we also have a 401k program available for employees after 6 months.