Applications Architect, Power BI / Business Intelligence (Remote, DC Public Schools)

About This Role

DC Public Schools (DCPS), Office of Data & Technology, has launched new Business Intelligence initiatives and is seeking a highly proficient Power BI developer / applications architect to support backend setup, dashboard development, tool deployment, staff and user training, and BI strategy for the agency. This is a remote DC Government contract.

Responsibilities

• Design and develop compelling Power BI data visualizations and dashboards
• Design, develop, and maintain Power BI Dataflows (Gen 2) and Fabric Warehouses
• Create functional and technical documentation for Business Intelligence solutions
• Communicate effectively with technical and non-technical stakeholders and deliver training for staff and users
• Collaborate with business and IT partners to identify key use cases and define requirements
• Conduct whiteboarding sessions, workshops, design sessions, and project meetings
• Support systems analysis, application/architecture standards, data-model consistency, and BI strategy for the agency

Qualifications

• Bachelor’s degree in IT or related field (or equivalent experience)
• 6 to 10 years applying data visualization and business intelligence to real-world business problems
• Advanced MS Power BI experience with deep understanding of Power BI Desktop/Server, DAX, and SQL
• Microsoft technology stack experience (SQL Server, SQL Management Studio, SSIS, SSAS, Azure data platform)
• Exceptional analytical, conceptual, and problem-solving abilities; strong communication and experience training staff and users
• Able to work remotely on Eastern Time business hours
• Preferred: experience with K-12 education data and school-district staff; self-motivated to deliver independently and in a team

Required Skills

• Power BI dashboard and data-visualization development
• Power BI Dataflows (Gen 2) and Microsoft Fabric Warehouse design
• Data modeling and SQL across the Microsoft BI stack
• BI solution documentation and standards
• Stakeholder collaboration, requirements definition, and user training
• Systems analysis and application-architecture support
• *Software / tools:* Power BI (Desktop/Server), DAX, SQL, SQL Server, SSMS, SSIS, SSAS, Azure data platform, Microsoft Fabric