The Role
Design, develop, validate, and maintain reports and dashboards using Power BI and SSRS. Gather requirements from stakeholders, write and optimize T-SQL queries, support ETL processes, participate in data modeling, and manage the full reporting lifecycle from development through deployment and support.
Summary Generated by Built In
** 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 UsDenver 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.
Skills Required
- Bachelor's Degree in Computer Science, Information Systems, Data Analytics, Business Intelligence, or related field
- Minimum of three years experience with business intelligence, reporting, or data analytics solutions
- Strong experience writing complex SQL queries using SQL Server Management Studio and T-SQL (including stored procedures, functions, CTEs)
- Experience developing reports and dashboards using Power BI and SQL Server Reporting Services (SSRS)
- Ability to gather requirements, document business needs, and translate them into technical reporting solutions
- Ability to independently build, troubleshoot, modify, and validate reports based on changing business requirements
- Strong understanding of reporting best practices, report performance, parameterized reports, and user-friendly design
- Strong communication skills to explain technical concepts to non-technical customers and provide status updates
- Live and work with a permanent home address in Colorado
- Ability to meet the physical demands of the position (with or without accommodations)
- Master's Degree
- Experience with SSIS, ETL processes, incremental load logic, or slowly changing dimensions
Am I A Good Fit?
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.
Success! Refresh the page to see how your skills align with this role.
The Company
What We Do
The mission of Denver Public Schools is to provide all students the opportunity to achieve the knowledge and skills necessary to become contributing citizens in our diverse society. In DPS, we’re focused on building a system that’s designed to help every student thrive. We’re re-focusing our efforts where they matter most: on creating classrooms that are vibrant centers of learning, where caring teachers are engaging their students in rigorous, culturally responsive experiences in order to lift all students toward a bright horizon. In the last ten years, DPS has experienced unprecedented growth and an expansion of programs. Building on the strong progress we’ve made, we want to continue transforming DPS into a school district grounded in equity. This districtwide focus on equity will be embedded in everything we do, so that we can help break historical patterns and become a school district that is designed to inspire every student to dream big and make their own future. View all of our current career openings here: https://careers.dpsk12.org/
