Power BI Developer

About this role

<p><span style="font-family: arial, helvetica, sans-serif; font-size: 12pt;">AIR’s Tek Office is seeking an experienced <strong>Power BI Developer </strong>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.</span></p> <p><span style="font-family: arial, helvetica, sans-serif; font-size: 12pt;">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.</span></p> <p><span style="font-family: arial, helvetica, sans-serif; font-size: 12pt;"><strong>About AIR:</strong></span></p> <p><span style="font-family: arial, helvetica, sans-serif; font-size: 12pt;">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.</span></p> <p><span style="font-family: arial, helvetica, sans-serif; font-size: 12pt;"><strong>Responsibilities:</strong></span></p> <p><span style="font-family: arial, helvetica, sans-serif; font-size: 12pt;">The responsibilities for the position include:</span></p> <ul> <li style="font-family: arial, helvetica, sans-serif; font-size: 12pt;"><span style="font-family: arial, helvetica, sans-serif; font-size: 12pt;">Lead the design, development, and lifecycle management of Power BI solutions (semantic models, dashboards, and reports) across multiple business domains and the enterprise. </span></li> <li style="font-family: arial, helvetica, sans-serif; font-size: 12pt;"><span style="font-family: arial, helvetica, sans-serif; font-size: 12pt;">Partner with business and technical stakeholders to translate requirements into clear user stories, data definitions, and reusable reporting patterns. </span></li> <li style="font-family: arial, helvetica, sans-serif; font-size: 12pt;"><span style="font-family: arial, helvetica, sans-serif; font-size: 12pt;">Model data using dimensional best practices (e.g., star schema) and write optimized DAX to deliver performant, maintainable analytics. </span></li> <li style="font-family: arial, helvetica, sans-serif; font-size: 12pt;"><span style="font-family: arial, helvetica, sans-serif; font-size: 12pt;">Build and maintain ingestion and transformation workflows (Power Query/M, SQL, and/or Fabric capabilities) to integrate data from Dynamics 365 and other sources. </span></li> <li style="font-family: arial, helvetica, sans-serif; font-size: 12pt;"><span style="font-family: arial, helvetica, sans-serif; font-size: 12pt;">Leverage Microsoft Fabric (Lakehouse/Warehouse/OneLake, as applicable) to implement scalable and secure data storage, processing, and semantic model strategies. </span></li> <li style="font-family: arial, helvetica, sans-serif; font-size: 12pt;"><span style="font-family: arial, helvetica, sans-serif; font-size: 12pt;">Own operational excellence for BI solutions, including refresh reliability, monitoring, troubleshooting, and performance optimization. </span></li> <li style="font-family: arial, helvetica, sans-serif; font-size: 12pt;"><span style="font-family: arial, helvetica, sans-serif; font-size: 12pt;">Implement and maintain security and governance practices (workspace strategy, permissions, RLS/OLS, endorsement/certification practices, and documentation). </span></li> <li style="font-family: arial, helvetica, sans-serif; font-size: 12pt;"><span style="font-family: arial, helvetica, sans-serif; font-size: 12pt;">Support a healthy delivery process by contributing to standards, code reviews, and deployment practices (e.g., dev/test/prod, version control, and release coordination). </span></li> <li style="font-family: arial, helvetica, sans-serif; font-size: 12pt;"><span style="font-family: arial, helvetica, sans-serif; font-size: 12pt;">Mentor junior BI developers and enable business users through training, best practices, and adoption support. </span></li> <li style="font-family: arial, helvetica, sans-serif; font-size: 12pt;"><span style="font-family: arial, helvetica, sans-serif; font-size: 12pt;">Stay current with Microsoft analytics platform capabilities and recommend enhancements that improve usability, reliability, and value. </span></li> <li style="font-family: arial, helvetica, sans-serif; font-size: 12pt;"><span style="font-family: arial, helvetica, sans-serif; font-size: 12pt;">Responsibilities may change based on business needs.</span></li> </ul> <p><span style="font-family: arial, helvetica, sans-serif; font-size:…