Business Intelligence Developer

Detroit International; Detroit (MI); Hybrid; USD 84,000 - 115,000; Full time

Benefits offered by this job

Telecommuting up to 40%

Benefits eligible

Job summary

Detroit Public Schools Community District is hiring a Business Intelligence Developer to architect and deliver top-tier analytical solutions for a district representing over 50,000 students. The role uses SQL and Power BI to drive strategic decision-making and leads a key initiative to build personalized data portals in SharePoint for students and staff.

The successful candidate will collaborate with data engineers, infrastructure architects, and analysts to design intuitive dashboards and

Qualifications

• Bachelor's degree in a technical field or equivalent experience.

Responsibilities

• Lead end-to-end BI solutions development lifecycle (planning, design, development, testing, deployment).
• Direct stakeholder engagements to define requirements and oversee wireframes/prototypes.
• Architect and manage SharePoint-embedded data portals for students and staff.
• Create accurate, high-impact data displays communicating district KPIs.
• Optimize SQL queries for scalable, high-performing reports.
• Develop reusable data models for district-wide reporting.
• Ensure Power BI reports are secure and well-integrated in SharePoint.
• Champion best practices in data visualization and UI/UX.
• Facilitate design-focused groups with principals, teachers, and admins.
• Document business rules and metric calculations for transparency.
• Contribute to long-term data roadmap and architecture.

Skills

Power BI

SQL

UI/UX design

Data visualization

Stakeholder communication

SSAS

Power BI Embedded

RLS (Row-Level Security)

SharePoint integration

Urban district experience

Business requirements gathering

Education

Bachelor's degree in technical field

BI certifications

Tools

SharePoint

SSAS

Job description

Job Title

Job Description

Job Title

Position Title: Business Intelligence Developer

Location: Office of Strategy, Data and Accountability

Salary: $84,387 - $114,526

Reports to: Deputy Executive Director of Data Services

Bargaining Unit: N/A

Benefits Eligible: Yes.

Telecommuting Eligibility: Eligible for telecommuting up to 40% (2 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

• 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.
• Relevant BI certifications. (preferred)
• Expertise in Power BI "Embedded" or integrating BI assets into SharePoint and other web platforms. (preferred)
• Experience implementing Row-Level Security (RLS) to manage complex data permissions for diverse user groups (e.g., students vs. teachers). (preferred)
• Experience working in an urban public-school district. (preferred)
• Proven ability to define business requirements and lead communication with executive stakeholders. (preferred)
• Advanced data modeling and transformation experience, such as in SSAS. (preferred)

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.

DPSCD does not discriminate on the basis of race, color, national origin, sex, disability and/or religion. Contact the Civil Rights Coordinator for more information at [phone] or detroitk12.org/compliance.