Department Information Incumbent will be required to complete work for CDE within Colorado. This announcement is posted until filled or preferred candidate(s) are identified; it is in your best interest to apply early. Colorado Department of Education - What We Do The Colorado Department of Education (CDE) provides leadership, resources, support, and accountability to the state's 178 school districts, 1,888 schools, over 53,000 teachers, and over 3,200 administrators to help them build capacity to meet the needs of the state's approximately 905,000 public school students. In addition, CDE provides structural and administrative support to the Colorado School for the Deaf and the Blind and the Charter School Institute. As the administrative arm of the State Board of Education, CDE is responsible for implementing state and federal education laws, disbursing state and federal funds, holding schools and districts accountable for performance, licensing all educators, and providing public transparency of performance and financial data. CDE is a values-based agency that serves students, parents, and the general public by protecting public trust through ensuring adherence to laws, strong stewardship of public funds, and accountability for student performance. CDE strives to incorporate five core values that we uphold in our work internally and externally. If you come to CDE, be prepared to incorporate Integrity, Equity, Accountability, Trust, and commitment to Service in what you do. Why Work For CDE The work we do is rewarding and impacts the students, families, educators, and communities across Colorado. Our leadership also promotes a culture that puts families and self-care as a priority. Along with meaningful work and an environment that puts employees first, the state also offers rich benefits that intend to make us an Employer of Choice! The following is a summary of the benefits we offer: * Flexible work schedules and flexible workplace options that may include flexible working hours, working from home, working in the office, and/or a hybrid working environment. * Premier medical, dental, vision, and dependent life insurance options. All with a generous employer contribution keeping employee costs as low as possible. * Employer paid short-term disability and life insurance * Up to 160 hours of Paid Family Medical Leave (PFML) * 11 paid holidays per year * Competitive vacation and sick leave accruals * Retirement through the Public Employees Retirement Association (PERA) www.copera.org * Employer paid RTD Eco Pass (certain restrictions may apply) * Paid professional development opportunities A wide salary range is posted for this position and any job offer is based upon a salary analysis to comply with the Colorado Equal Pay for Equal Work Act. The salary analysis considers relevant experience, education, certifications, and state seniority as compared to others doing substantially similar work. While most salary offers are made within the posted range, occasionally an offer is made below or above the posted range based upon this salary analysis. Description of Job Do you love using data to solve complex problems? Have you worked with an enterprise data warehouse and created database solutions for varied customer uses? Have you managed technical experts building data-oriented storage and reporting solutions? Do you believe in public education and want to be a part of making it better? If so, you may be the person we are looking for. CDE is seeking aData Warehouse/Business Intelligence Manager. This position is critical to ensuring the underlying data structures are in place to support the educational needs of our users. This role also includes management of the reporting of data for customers who need K12 student and educator information to answer key questions on how well our education system is working. Our customer base include school districts, legislators, politicians, families and other agency staff. You will join a team of technologists and education experts who are all passionate about improving Colorado's education system. Requirements if the position are as follows: * Personnel management of 5-10 direct reports, following CDE's systems of performance management and expectation setting, * Collaboration with other peer groups within CDE's Information Management Services division and across CDE, * Understanding of appropriate roles for technical personnel and coaching them towards effective participation with all other team players, * Manage and support all project related architecture, design, development, and deployment of data-oriented integration across platform and projects, * Manage project and operational deliverables to ensure adherence to deadlines, specifications, and budgets, * Monitor and track team progress and report findings to leadership team, * Ensure all data warehouse and business intelligence developers keep current with technological developments within the industry and participate in soft skills training as required, * Monitor and evaluate competitive applications and products, * Prepare and present Gap analyses as needed, for technology and business solutions for audiences up to CIO level, * Collaborate and partner with technical and business teams to support the full software development lifecycle. Please note that while this is a management level role, the ideal candidate will have management experience and hands on technical skills, to help coach, guide and lead the team. Minimum Qualifications, Substitutions, Conditions of Employment & Appeal Rights Minimum Qualifications: 10 years total experience in database design, ETL and reporting Within those years : * 3 years managing teams in an enterprise data warehouse and business intelligence or similar role. * Expert knowledge of both relational database and dimensional data warehouse best practices * 4 years of hands on business intelligence/reporting experience * 2 years hands on experience doing Extract/Transfer/Load (ETL) * Expert understanding and previous hands-on working knowledge with some of the following software components: Linux, Shell Scripting, Informatica, SQL, Oracle Database, Tableau, Cognos and MS SQL Database. * Successful experience with conflict management and leadership of highly technical teams Excellent oral, written, analytical, problem solving, and presentation skills Effective interpersonal relationship skills with highly technical staff as well as business/program oriented staff Excellent organizational and time management skills. Collaboration and partnering skills, with technical and business team to present, define, strategies, requirements, road-maps, budgets, and solutions PREFERRED QUALIFICATIONS Experience in the K12 education industry. Experience with MS Azure cloud environment. Experience in building data mart/data warehouses from scratch. Experience in evaluating various technological solutions to solve business requirements. Hands on experience on BI tools like Cognos, OBIEE, Tableau, PowePi, etc. Supplemental Information Complete Applications must include: * Completed Online Application:Required - Submitted through ourATS. * Resume: Required FOR CURRENT OR FORMER EMPLOYEES OF THE STATE OF COLORADO: Per the requirements of the Step Pay Program implemented on July 1, 2024, any State employee must be paid a rate that is equal to or greater than the appropriate step pay rate within their classification's pay range based on completed years in their current class series as of June 30. All current and former State employees must ensure that your entire work history within the State Classified System, including at Institutions of Higher Education, is indicated in your application so that your time-in-series can be calculated accurately. Email Address: All correspondence regarding your status in the selection/examination process will be conducted via email. Include a working email address on your application; one that is checked often as time-sensitive correspondence such as exam information or notification will take place via email. Please set up your e-mail to accept messages from "state.co.us" and "info@governmentjobs.com" addresses. It is your responsibility to ensure that your email will accept these notices and/or review your junk mail and spam-filtered email. Equity, Diversity, and Inclusion (EDI) and Equal Employment Opportunity The State of Colorado believes that equity, diversity, and inclusion drive our success, and we encourage candidates from all identities, backgrounds, and abilities to apply. The State of Colorado is an equal opportunity employer committed to building inclusive, innovative work environments with employees who reflect our communities and enthusiastically serve them. Therefore, in all aspects of the employment process, we provide employment opportunities to all qualified applicants without regard to race, color, religion, sex, disability, age, sexual orientation, gender identity or expression, pregnancy, a medical condition related to pregnancy, creed, ancestry, national origin, marital status, genetic information, or military status (with preference given to military veterans), or any other protected status in accordance with applicable law. The Colorado Department of Education is committed to the full inclusion of all qualified individuals. As part of this commitment, our agency will assist individuals who have a disability with any reasonable accommodation requests related to employment, including completing the application process, interviewing, completing any pre-employment testing, participating in the employee selection process, and/or performing essential job functions where the requested accommodation does not impose an undue hardship. If you have a disability and require reasonable accommodation to ensure you have a positive experience applying or interviewing for this position, please direct your inquiries to hr@cde.state.co.us.