Power BI Developer

AIRs 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. This position reports into the Technology Office.

This position offers hybrid work flexibility requiring three days per week in AIRs 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 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.

Responsibilities:

The responsibilities for the position include:

• Lead the design development and lifecycle management of Power BI solutions (semantic models dashboards and reports) across multiple business domainsand 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 deliverperformant maintainable analytics.
• Build andmaintainingestion 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 andmaintainsecurity 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 andreleasecoordination).
• 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

• Bachelors degree (or equivalent experience) in Computer Science Information Systems Data/Analytics or a related fieldor at least 5 years of experience.
• At least5years 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 handson 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 (PL300) 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 endtoend 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 nontechnical 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 fastpaced environments showing strong ownership accountability and attention to quality.
• Collaborative and analytical problemsolver with strong criticalthinking skills mentoring capabilities and the ability to helpestablishand 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.

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 gendergender 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 or call 202.403.5000.

Fraudulent Job Scams Warning & Disclaimer:AIR is aware of individuals falsely presenting themselves as AIR representatives. Fraudulent job scams seek to extract sensitive information or money from victims. To protect yourself please be aware that AIR recruitment will only email you from an @ domain. Please take extra caution while examining the email address for example is correct and is not a legitimate AIR email address. If you are unsure of the legitimacy of a communication you have received please reach out to If you see a job scam or lose money to one report it to the Federal Trade Commission (FTC) at . You can also report it to your state attorney general. Find out more about how to avoid scams #LI-Hybrid