Business Intelligence Developer

Job Description

Job Title

Position Title: Business Intelligence Developer

Location: Office of Strategy, Data and Accountability

Salary: $81,929 - $111,190

Reports to: Deputy Executive Director of Data Services

Bargaining Unit: N/A

Benefits Eligible: Yes

Telecommuting Eiligibility: Eligible for telecommuting up to 40% (two days per week)

Position Summary

As the primary visualization expert within the Data Services team, the Business Intelligence Developer will architect and own the delivery of top-tier analytical solutions for a district representing over 50,000 students. The district leverages a technology stack of SQL and Power BI to drive strategic decision-making. This role is not only responsible for the district's core reporting but will specifically lead a high-priority initiative to build and maintain personalized data portals embedded within SharePoint for students and staff. The successful candidate will collaborate with data engineers, infrastructure architects, and analysts to direct the design of beautiful, high-utility dashboards, serving as the definitive voice for data visualization and user experience across the district.

Minimum Qualifications

Required:

• A Bachelor’s degree, preferably in a technical area, and/or technical/equivalent experience.
• Four (4) or more years of experience in business intelligence, data visualization, and UI/UX design.
• 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.
  
  

Preferred

• Relevant BI certifications.
• 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).
• Experience working in an urban public-school district.
• Proven ability to define business requirements and lead communication with executive stakeholders.
• Advanced data modeling and transformation experience, such as in SSAS.
  
  

Essential Functions

• Lead the full development lifecycle of district-wide BI solutions, including strategic planning, design, development, testing, and deployment.
• Direct stakeholder engagements to define complex business requirements and oversee the production of wireframes and prototypes.
• 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.
• 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.
• Perform other duties as assigned by manager.
  
  

Security Clearance

Internal Applicants

If you are a current Detroit Public Schools Community District employee, you do not have to submit to a new security clearance, unless your new role requires a different type of criminal background check.

External Applicants

In alignment with Michigan law, if you are hired to fill a position, you will be required to submit to a Detroit Public Schools Community District criminal background check. Information regarding required background checks will be shared at point of hire.

Method Of Application

Applicants must apply through the online application system. Only applications submitted through the online application system will be considered for any posted position and all applications require a resume to be considered.

Applicants requesting assistance during the application process should contact the Office of Human Resources via email at [email protected] or phone at (313) 873-6897.Successful candidates are required to submit official transcript(s) at point of offer to hire. It is the applicant's responsibility to provide all documentation (including copies) as requested.

DPSCD does not discriminate based on race, color, national origin, sex, disability and/or religion. Contact the Civil Rights Coordinator for more information at (313) 240-4377 or detroitk12.org/compliance.