Power BI Developer

American Institutes for Research; Arlington (VA); Hybrid; USD 104,000 - 122,000; Full time

Job summary

The American Institutes for Research in Arlington, Virginia, is seeking an experienced Power BI Developer to join its team. The Power BI Developer will be instrumental in leading the design and implementation of analytics solutions, partnering with various stakeholders to deliver impactful data insights.

This position offers a hybrid work model, requiring three days a week in the office, with a salary ranging from $104,000 to $122,000. The ideal candidate will have strong expertise in Power BI and a proven track record in business intelligence.

Qualifications

• 5+ years of experience in Business Intelligence or analytics engineering.
• Advanced experience with Power BI and strong SQL skills.
• Experience working in agile environments using tools such as Jira and Confluence.

Responsibilities

• Lead the design, development, and lifecycle management of Power BI solutions.
• Partner with stakeholders to translate requirements into user stories.
• Implement and maintain security and governance practices.

Skills

Power BI

DAX

SQL

Microsoft Graph API

Agile Methodologies

Education

Bachelor’s degree in Computer Science or related field

Tools

Power Query

Microsoft Fabric

Job description

AIR’s Tek Office is seeking an experienced Power BI Developer to join its talented group. The Power BI Developer will work closely with the AIR Modernization team and stakeholders across multiple business domains to implement an enterprise analytics platform and deliver interactive dashboards, reports, and semantic models that enable informed decision‑making.

Hybrid Work Schedule

This position offers hybrid work flexibility, requiring three days per week in AIR’s Virginia office, with occasional travel for meetings, training sessions, and conferences.

About AIR

Founded in 1946 and headquartered in Arlington, Virginia, the American Institutes for Research (AIR) is a non‑partisan, 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.

Responsibilities

• 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.
• Implement and maintain security and governance practices (workspace strategy, permissions, RLS/OLS, endorsement/certification practices, and documentation).
• Support a healthy delivery process by contributing to standards, code reviews, and deployment practices (e.g., dev/test/prod, version control, and release coordination).
• Mentor junior BI developers and enable business users through training, best practices, and adoption support.
• Stay current with Microsoft analytics platform capabilities and recommend enhancements that improve usability, reliability, and value.
• Responsibilities may change based on business needs.

Qualifications

Education, Knowledge, and Experience

• Bachelor’s degree (or equivalent experience) in Computer Science, Information Systems, Data/Analytics, or a related field or at least 5 years of experience.
• 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.

Skills

• Strong communicator able to engage senior leaders and both technical and non‑technical stakeholders, clearly conveying concepts, solutions, and tradeoffs.
• Proven ability to collaborate effectively with remote and geographically dispersed teams, fostering alignment and shared understanding.
• Demonstrated ability to manage multiple concurrent priorities in fast‑paced environments, showing strong ownership, accountability, and attention to quality.
• Collaborative and analytical problem‑solver with strong critical‑thinking skills, mentoring capabilities, and the ability to help establish and promote best practices.

Disclosures

Applicants must be currently authorized to work in the U.S. on a full‑time basis. Employment‑based visa sponsorship (including H-1B sponsorship) is not available for this position. Depending on project work, qualified candidates may need to meet certain residency requirements.

Equal Employment Opportunity

American Institutes for Research is an equal employment opportunity/affirmative action employer. All qualified applicants will receive consideration for employment without discrimination on the basis of any characteristic protected by applicable federal, state or local law, including, but not limited to, actual or perceived race (including traits historically associated with race, such as hair texture, hair type, and protective hairstyles such as braid, locks, and twists), creed, color, religion, alienage or national origin, ancestry, citizenship status, age, physical or mental disability, medical condition (e.g., cancer), sex, gender, gender identity or expression (including transgender status), sexual orientation, marital status, civil union status, pregnancy, childbirth or related medical conditions, genetic information, or military or veteran status. AIR adheres to strict child safeguarding principles. All selected candidates will be expected to adhere to these standards and principles and will therefore undergo reference and background checks. AIR maintains a drug‑free work environment.

Accessibility Notice

If you need a reasonable accommodation for any part of the employment process due to a physical or mental disability, please send an email to Taliba Boone at [e-mail] or call 202.403.5000.

Salary

Anticipated Annual Salary Range: $104,000 – $122,000 USD