ANALYST, BUSINESS INTELLIGENCE

Job Description

** Applications will be received until August 5, 2026 . If the position is not filled by then, we may consider applications submitted after the deadline. Interested applicants must apply online by visiting the Denver Public Schools job board at careers.dpsk12.org. **

About this job:

Business Intelligence analyst with experience using the Microsoft Business Intelligence stack. The ideal candidate will have experience in the full life cycle of Business Intelligence solutions. The candidate will contribute to the design, user requirements, documentation and strategic implementation of systems to be used by the teachers, principals, and staff of Denver Public Schools.


What DPS Offers You:

• A Culture that values Equity, Accountability, Integrity, Collaboration and Fun with a shared vision that Every Learner Thrives.
• Salary Range: $87,203 - $106,806 annually Click here for more information on compensation for these roles.
• In addition to competitive compensation, DPS has other Total Reward offerings such as; time off, health and wellness benefits, and PERA Retirement.

What You'll Do:

• Partner directly with customers and business stakeholders across HR, Finance, and Student data areas to understand reporting needs, gather requirements, and clarify business rules.
• Translate business requirements into clear technical specifications and reporting solutions.
• Write, troubleshoot, and optimize SQL queries, stored procedures, functions, and other database objects using SQL Server Management Studio and T-SQL.
• Build, enhance, and maintain reports using Power BI and SQL Server Reporting Services.
• Validate report data for accuracy, consistency, and alignment with business requirements.
• Take reporting requests from initial conversation through development, testing, user review, deployment, and final delivery.
• Troubleshoot and support existing reports and reporting applications as needed.
• Communicate clearly and effectively with both technical and non-technical customers throughout the full reporting lifecycle.
• Participate in data model and reporting design discussions, including star schemas and other structures needed to support business reporting requirements.

What You'll Need:

• Minimum of a Bachelor's Degree in Computer Science, Information Systems, Data Analytics, Business Intelligence, or a related field.
• Master's Degree preferred.
• Minimum of three years of experience working with business intelligence, reporting, or data analytics solutions.
• Strong experience writing complex SQL queries using SQL Server Management Studio and T-SQL.
• Ability to gather requirements directly from customers, ask clarifying questions, document business needs, and translate those needs into technical reporting solutions.
• Experience developing reports and dashboards using Power BI and SQL Server Reporting Services.
• Ability to independently build, troubleshoot, and modify reports based on changing business requirements.
• Strong understanding of reporting best practices, including parameterized reports, CTEs, data validation, report performance, and user-friendly design.
• Strong communication skills, including the ability to explain technical concepts to non-technical customers and provide clear status updates.
• Ability to manage work from start to finish, including requirements gathering, development, testing, feedback, deployment, and support.
• Experience with SSIS, ETL processes, incremental load logic, or slowly changing dimensions preferred.
• Lead for racial and educational excellence and work to dismantle systems of oppression and inequity in our community, along with believing in and supporting all students so they feel seen and heard with access to high quality education.
• Live and work with a permanent home address in Colorado while working with us.
• Have the ability with or without accommodations to meet the physical demands of the position.

Denver Public Schools is an Equal Opportunity Employer and does not discriminate on the basis of race, color, religion, sex (including pregnancy, gender expression, and sexual orientation), parental status, national origin, age, disability, genetic information (including family medical history), political affiliation, military service, or any other status protected by law or regulations. It is our intention that all qualified applicants be given equal opportunity and that selection decisions be based on job-related factors.

Students First. Integrity. Equity. Collaboration. Accountability. Fun

About Us

Denver Public Schools is committed to meeting the educational needs of every student with great schools in every neighborhood. Our goal is to provide every child in Denver with rigorous, enriching educational opportunities from preschool through high school graduation. DPS is comprised of nearly 200 schools including traditional, magnet, charter and alternative pathways schools, with an enrollment of more than 90,000 students.


DPS has become the fastest-growing school district in the country in terms of enrollment and the fastest-growing large school district in the state in terms of student academic growth. Learn more at dpsk12.org.