The Detroit Public Schools Community District needs to architect and own the delivery of top-tier analytical solutions to drive strategic decision-making for over 50,000 students. This includes building and maintaining personalized data portals embedded within SharePoint for students and staff, and serving as the definitive voice for data visualization and user experience across the district.
Requirements
- Demonstrated expertise and fluency in designing complex reports in a BI platform such as Power BI.
- Advanced proficiency in SQL for manipulating and transforming large datasets with millions of rows.
- Expertise in Power BI "Embedded" or integrating BI assets into SharePoint and other web platforms.
- Experience implementing Row-Level Security (RLS) to manage complex data permissions for diverse user groups (e.g., students vs. teachers).
- Advanced data modeling and transformation experience, such as in SSAS.
Responsibilities
- Lead the full development lifecycle of district-wide BI solutions, including strategic planning, design, development, testing, and deployment.
- Architect and manage student and staff-facing data portals embedded within SharePoint, ensuring intuitive navigation and real-time access to performance metrics.
- Own the creation of accurate and high-impact data displays that communicate critical district metrics and KPIs.
- Optimize data queries and manipulations using SQL within Power BI and other enterprise tools to ensure reports are scalable and high-performing.
- Engineer efficient, reusable data models that serve as the foundation for district-wide reporting.
- Drive the technical integration and security of Power BI reports within the SharePoint environment, ensuring robust performance for thousands of users.
- Champion and enforce best practices in data visualization and UI/UX design, staying at the forefront of emerging BI technologies.
Other
- Four (4) or more years of experience in business intelligence, data visualization, and UI/UX design.
- Direct stakeholder engagements to define complex business requirements and oversee the production of wireframes and prototypes.
- Facilitate design-oriented focus groups with principals, teachers, and administrators to ensure data tools meet the practical needs of school-based staff.
- Standardize technical documentation for business rules and metric calculations to ensure transparency for both internal and external stakeholders.
- Serve as a primary strategist within the Data Services department, shaping the organization's long-term data roadmap and architecture.
