Job Description
Responsibilities The FDIC Treasury Integrated Platform (TIP) is a cloud-native modernization of legacy financial reporting systems, delivering enterprise analytics and reporting through Power BI embedded within an Angular and Spring Boot application. We are seeking a hands-on Power BI Embedded Specialist/Architect to own the Power BI ecosystem end-to-end. This includes tenant setup, semantic modeling, Row-Level Security (RLS), embedded analytics integration, reporting delivery, and governance. This is not a report-only role or a pure architecture role—it requires deep technical execution across Power BI Service, Embedded, and enterprise data modeling. Key Responsibilities: Power BI Platform & Embedded Setup Configure Power BI tenant, capacity (Premium / Embedded), workspaces, and deployment pipelines (Dev/Test/UAT/Prod) Set up Microsoft Entra ID service principals and App-Owns-Data embedding Define and implement Power BI Embedded architecture and integration with Spring Boot and Angular Configure secure connectivity to Azure PostgreSQL (Flexible Server) Semantic Modeling & Data Layer Build certified Power BI semantic models (DAX, Power Query, dimensional design) Implement RLS (including dynamic RLS for embedded scenarios) Configure Import, DirectQuery, and Composite models Implement incremental refresh and reusable KPI measures Reporting & Analytics Develop interactive dashboards, KPIs, and canned reports Build paginated reports for export-heavy requirements Support self-service analytics using governed datasets Ensure Section 508 / WCAG 2.1 AA compliance Embedded Integration Implement Power BI REST APIs (including GenerateToken for embedding) Define embed configurations and security model for App-Owns-Data Support Angular SDK integration and Spring Boot token services Troubleshoot embedding, RLS, refresh, and capacity issues Governance & Operations Define report lifecycle (Dev → Prod via deployment pipelines) Configure subscriptions, scheduling, and distribution En