Power BI Developer

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

Job summary

Ampcus Inc is seeking a contract Power BI Developer in Richmond, VA to design, build, and maintain reporting and analytics solutions for multiple business divisions. The role is a full-time contract with an initial one-year term and potential extension.

The ideal candidate will design BI solutions, develop data connections with Power Query to SQL Server, Azure Blob Storage, and Cosmos DB, and optimize DAX measures within Dataverse-based models while collaborating with stakeholders and BI

Qualifications

• Experience designing Power BI reports and dashboards for business units.
• Ability to translate business questions into effective visualizations and metrics.

Responsibilities

• Design, develop, and maintain Power BI reports, dashboards, and semantic models supporting business divisions 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 SQL Server, Azure Blob Storage, and Cosmos DB.
• Develop and optimize DAX measures, calculated columns, and semantic model relationships for accuracy and performance.
• Collaborate with stakeholders to understand reporting needs, define measures and metrics, and translate business questions into usable visuals.
• Support reporting needs across multiple product teams and BI lead priorities, with agile backing.

Skills

Agile ceremonies

Tools

Power BI

Power Query

DAX

Dataverse

SQL Server

Azure Blob Storage

Cosmos DB

Job description

Ampcus Inc. is a certified global provider of a broad range of Technology and Business consulting services. We are in search of a highly motivated candidate to join our talented Team.

Job Title: 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.