Power BI Developer

At least 5 years of experience in Business Intelligence or analytics engineering, with a strong focus on Power BI solution delivery.

Advanced experience with Power BI (semantic models, DAX, Power Query) and strong SQL skills, with hands‑on work in Microsoft Fabric (Warehouse/Lakehouse), modern data management practices, and building/supporting ETL/ELT pipelines integrating enterprise applications such as Dynamics 365 or similar systems.

Microsoft Power BI Data Analyst (PL‑300) or relevant Microsoft Fabric/Power Platform certifications, along with experience in governance frameworks, environment strategy, and administration across Power BI and the broader Power Platform is preferred.

Experience working in agile environments using tools such as Jira and Confluence, with a solid understanding of dimensional modeling, data quality, lineage, and end‑to‑end data pipeline operations.

Experience using Microsoft Graph API for automation, integration, and advanced reporting scenarios is preferred, but not required.

AIR adheres to strict child safeguarding principles.

is designed to reward our staff competitively and motivate them to achieve our critical mission. This position offers the anticipated annual salary as listed. Salary offers are made based on internal equity within the institution and external equity with competitive markets. Please note this is the annual salary range for candidates that are based in the United States.

$104,000

—

$122,000 USD

Lead the design, development, and lifecycle management of Power BI solutions (semantic models, dashboards, and reports) across multiple business domains and the enterprise.

Partner with business and technical stakeholders to translate requirements into clear user stories, data definitions, and reusable reporting patterns.

Model data using dimensional best practices (e.g., star schema) and write optimized DAX to deliver performant, maintainable analytics.

Build and maintain ingestion and transformation workflows (Power Query/M, SQL, and/or Fabric capabilities) to integrate data from Dynamics 365 and other sources.

Leverage Microsoft Fabric (Lakehouse/Warehouse/OneLake, as applicable) to implement scalable and secure data storage, processing, and semantic model strategies.

Own operational excellence for BI solutions, including refresh reliability, monitoring, troubleshooting, and performance optimization.

Founded in 1946 and headquartered in Arlington, Virginia, the American Institutes for Research (AIR) is a nonpartisan, not-for-profit organization that conducts behavioral and social science research and delivers technical assistance to address some of the most pressing challenges in the United States and globally. We generate evidence and apply data-driven solutions that expand opportunities and improve lives for all.