Power BI Developer

Ampcus, Inc; Richmond (VA); On-site; USD 90,000 - 120,000; Full time

Job summary

Ampcus, Inc. in Richmond, VA seeks a Power BI Developer for a full-time contract role within the Enterprise Technology Services division.

The position designs, builds, and maintains reporting and analytics solutions across agency business units, delivering insights and dashboards that drive decision making. The role involves working with Dataverse data models, Power Query, SQL Server, Azure Blob Storage, and Cosmos DB, while implementing security and performance improvements through advanced DAX

Qualifications

• Experience designing Power BI reports and dashboards.
• Strong knowledge of DAX and semantic models.
• Experience with data integration and multiple data sources.

Responsibilities

• Design, develop, and maintain Power BI reports, dashboards, and semantic models.
• Build reports on Dataverse data models and existing tables/relationships/security.
• Develop data connections and transformations using Power Query across SQL Server, Azure Blob Storage, Cosmos DB.
• Optimize DAX measures, calculated columns, and relationships for performance and accuracy.
• Collaborate with stakeholders to translate reporting needs into visualizations.
• Support multiple product teams and agile BI initiatives.
• Triage short-duration reporting requests and maintain security standards.
• Document data sources, models, and refresh dependencies.

Skills

Power BI

Data visualization

Stakeholder communication

Tools

SQL Server

Azure Blob Storage

Cosmos DB

Dataverse

Power Query

DAX

Job description

Power BI Developer

Location(s): Richmond, VA

Job Description

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.

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

Ampcus is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, age, protected veterans or individuals with disabilities.