Sr. Power BI Developer

MasterApp Labs; Richmond (VA); On-site; USD 90,000 - 130,000; Part time

Job summary

MasterApp Labs is seeking a Sr. Power BI Developer in Richmond, VA for a contract role onsite. You will design, develop, and optimize Power BI reports and semantic models, leveraging Dataverse data models and various data sources.

The ideal candidate has extensive experience with DAX, Power Query, SQL, and data modeling, and will collaborate with product teams and stakeholders to translate requirements into actionable insights. Onsite meetings are required.

Qualifications

• Professional experience developing business intelligence and reporting solutions with Microsoft Power BI.
• Strong proficiency in DAX, incl. measure development, time intelligence, and performance optimization.
• Strong proficiency in Power Query and M for data transformation and preparation.
• Proficiency in SQL and experience querying relational data sources.
• Demonstrated experience with dimensional and semantic data modeling, including star schema design.
• Experience building Power BI reports against Dataverse or Dynamics 365 data.
• Demonstrated ability to work directly with business stakeholders to elicit reporting requirements.
• Strong data visualization judgment for clarity and usability.
• Demonstrated ability to work independently and manage competing reporting priorities.
• Experience implementing and testing row-level security in Power BI.

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

Skills

Power BI development

DAX

Power Query

SQL

Dimensional modeling

Data visualization

Stakeholder collaboration

Row-level security

Power BI Service administration

Familiar with Fabric

Azure Blob Storage

Cosmos DB

Dataverse

Dynamics 365 data

Tools

Power BI

Power Query

SQL

Dataverse

Dynamics 365

Azure Blob Storage

Cosmos DB

Fabric

RLS (Row-Level Security)

Job description

Title: Sr. Power BI Developer
Location: Richmond, VA, (Onsite meeting is required)
Position Type: Contract
Interview Mode: Web Cam

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.

Required/Desired Skills

• Professional experience developing business intelligence and reporting solutions with Microsoft Power BI.
• Required 4
• Strong proficiency in DAX, incl. measure development, time intelligence, performance optimization, and a working understanding of row/ filter context
• Required 3
• Strong proficiency in Power Query and M for data transformation and preparation.
• Required 3
• Proficiency in SQL and experience querying relational data sources
• Required 3
• Demonstrated experience with dimensional and semantic data modeling, including star schema design and relationship management
• Required 2
• Experience building Power BI reports against Dataverse or Dynamics 365 data
• Required 2
• Demonstrated ability to work directly with business stakeholders to elicit reporting requirements and translate them into working solutions
• Required 4
• Strong data visualization judgment, including selecting appropriate visuals and designing reports for clarity and usability
• Required 4
• Demonstrated ability to work independently and manage competing reporting priorities with minimal direction
• Required 4
• Experience implementing and testing row-level security in Power BI
• Desired 2
• Experience with Power BI Service administration concepts, incl. workspaces, apps, dataset refresh/ gateway configuration, & deployment across envirome
• Desired 2
• Experience with Microsoft Fabric is considered a plus
• Desired 2
• Experience with Azure Blob Storage or Cosmos DB as reporting data sources is considered a plus
• Desired 2
• Experience working in a public sector, regulatory, or other compliance-driven environment is considered a plus
• Desired 2
• Microsoft certification PL-300 (Power BI Data Analyst) is considered a plus
• Desired 2