Power BI Developer DAX, Power Query, SQL & Dataverse

Posted: 09/15/2026 | Hiring Organization: Rose International | Position Number: 507489 | Industry: Government/Staffing | Location: Richmond, VA 23219 | Work Model: Hybrid (Regular shift) | Employment Type: Temporary, Full‑Time | Estimated Duration: 13 months

Pay

Hourly rate: $60.00 – $65.00

About the role

The client seeks a contract Power BI Developer to design, build, and maintain reporting and analytics solutions supporting business divisions across the agency.

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

Requirements

• Professional experience developing business intelligence and reporting solutions with Microsoft Power BI (4 years).
• Strong proficiency in DAX, including measure development, time intelligence, performance optimization, and 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 (3 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 (2 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).
• Ability to work independently and manage competing reporting priorities with minimal direction (4 years).

Preferred Skills

• Experience implementing and testing row‑level security in Power BI (2 years).
• Experience with Power BI Service administration concepts, including workspaces, apps, dataset refresh/gateway configuration, and deployment across environments (2 years).
• Experience with Microsoft Fabric (2 years).
• Experience with Azure Blob Storage or Cosmos DB as reporting data sources (2 years).
• Experience working in a public‑sector, regulatory, or other compliance‑driven environment (2 years).

Preferred Certifications

• Microsoft PL‑300 (Power BI Data Analyst) certification.