This position is not part of the classified personnel system; applications will be accepted from Residents and Non-Residents of Colorado. Incumbent will be required to live in and complete work for CDE within Colorado. 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., This position is full-time, state-funded (funding is expected to continue indefinitely unless otherwise indicated in this posting), and is hybrid (Remote/Home Office with a requirement to report to work location per business needs).

• Extended hours during the evening or the weekend may be required by business needs.
• Up to 5% Travel required within State of Colorado for Meetings/Trainings.
• A Remote (Home) office is required.
• Required to report to the work location per business needs
• Essential Functions (ADAAA) o LIGHT/Office environment:

Required to sit, view a computer screen, and utilize a keyboard and mouse for extended periods of time.

May be required to lift and move up to 10 lbs of force frequently or 20 lbs occasionally.

Required lifting, bending, stooping, pushing, walking, etc.

Light work usually requires walking or standing to a significant degree.

o DL Not Required: Required to independently obtain and determine means to complete travel requirements. (For positions that only report to CDE locations and can use public transportation to complete that.), The BI Manager plays a key role in the evolution of CDE's enterprise data platform. This role collaborates with application development, data pipeline engineering, governance, and project management teams to deliver scalable, secure, and reliable data services supporting reporting, analytics, and public transparency initiatives. Scopes, plans, and prioritizes multiple projects. Manages all aspects of the warehouses, such as data sourcing, migration, quality, design, and implementation. Familiar with a variety of the field's concepts, practices, and procedures. Relies on experience and judgment to plan and accomplish goals. Performs a variety of tasks. Leads and directs the work of others. A wide degree of creativity and latitude is expected., + Provide direction for diverse and complex initiatives and accountability for a variety of tasks to architect and deliver data warehousing solutions that exceed customer expectations in content, usability, accuracy, reliability, and performance.

• Lead modernization of the enterprise data platforms, including data pipelines, analytics layers, and reporting systems.

• Manage Data Warehouse and Business Intelligence Teams

• Collaborate and partner with technical and business teams to accomplish the following: o Define requirements for joint report development. o Plan implementation steps required. o Develop and manage a budget. o Deliver solutions per requirements.

• Collaborate with data governance teams to ensure metadata, lineage, data quality, and privacy standards are integrated into the data platform.

• Prepare and present gap analyses as needed, for technology and business solutions for audiences up to CIO level.

• Partner with application development and data pipeline teams to ensure reliable end-to-end data flow from source systems to analytics platforms

• Manage and support all project-related architecture, design, development, and deployment of data-oriented integration across platforms and projects.

• Manage project and operational deliverables to ensure adherence to deadlines, specifications, and budgets.

• Monitor and track team progress and report findings to the leadership team.

• Ensure all data warehouse developers keep current with technological developments within the industry.

• Monitor and evaluate competitive applications and products.

• Provide active technical coaching and management support for the warehouse team staff and mentor others across the organization.

• Implement performance metrics and report on team effectiveness.

• Provide overall direction to the team members assigned to their designated projects.

• Prioritize tasks, delegate assignments, and evaluate performance of the entire project team.

• Work independently, assume responsibility for job development and training, research and resolve questions and problems, request manager's input, and keep the manager informed.

• Other duties as assigned.

This position does have supervisory responsibilities. The duties and responsibilities for employees who supervise staff include, but are not limited to, the following.

• Model and ensure consistency with organizational values and policies.
• Clearly communicate expectations and standards to staff.
• Conduct timely performance management of staff, including formal evaluations, ongoing and routine feedback, and holding staff accountable.
• Be aware of employee time worked and work schedules
• Approve time worked for payroll and monitoring, and approve all work schedules, including remote and flex schedules, in accordance with CDE's policies.
• Provides the applicable tools and resources staff require to perform their job., + Ability and willingness to independently determine, obtain means, and complete required travel (up to 5% Travel required within State of Colorado for Meetings/Trainings).
• Work extended schedule per business needs.
• Report to work location per business needs.
• DL Not Required: Required to independently determine and obtain means to complete travel requirements (up to 5% Travel required within State of Colorado for Meetings/Trainings).
• Sign the acknowledgment form that this position is state and federally funded through state and federal funds and subject to availability.

• Seven (7) years of professional experience in data systems management, software development, or related discipline.

• Three (3) years of the experience listed above must include managing or leading a team in an enterprise data warehouse environment or similar role.

• Education and Experience o Bachelor's degree from an accredited college or university in MIS, CS, or related discipline, or equivalent experience.

• And o Three (3) years of managing or leading a team in an enterprise data warehouse environment or similar role., + Expert knowledge of both relational database and dimensional data warehouse best practices.

• Experience with modern data engineering practices and data pipeline orchestration.

• Experience with data governance, metadata management, and data lineage tools.

• Hands-on experience in developing web applications backed by database systems.

• Strong understanding and previous hands-on working knowledge with some of the following software components: Linux, Shell Scripting, Informatica, SQL, and Oracle Database.

• Experience in full-stack application development, using SQL Stored Procedures, Python, Java, PHP, or similar programming languages.

• Experience with LAMP stack application development. (Linux, Apache, MySQL, and PHP).

• Experience implementing DevOps or DataOps practices for analytics and data engineering teams.

• Experience in Agile or Scalable Agile Frameworks

• Strong written and verbal communication skills.

• Strong attention to detail (proofing work, spelling, grammar, formatting, etc.).

• Demonstrated ability to effectively balance quality of work and productivity expectations.

• Demonstrated ability to effectively collaborate with internal and external customers (e.g. school districts, other CDE units).

• Demonstrated ability to prioritize and organize work to accommodate and meet the changing needs of the department and meet deadlines.

• Demonstrated ability to take initiative and exhibit a proactive approach to work.

• Demonstrated ability to identify problems and recommend solutions prior to the standard being jeopardized.

• Demonstrated ability to work independently, as well as on a team.

Preferred Qualifications (Preferred/Not Required):

• Certification in Agile or Scalable Agile Frameworks, If you experience technical difficulty with the NEOGOV system (e.g. uploading or attaching documents to your online application) call NEOGOV technical support at 855-524-5627 Mon-Fri between 6 am and 6 pm (Pacific Time). Helpful hints: if you are having difficulty uploading or attaching documents to your application first, ensure your documents are PDF or Microsoft Word files, and second, close the document before you attempt upload (attach) it.

• 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 relative to others performing 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.

The State of Colorado strives to create a Colorado for All by building and maintaining workplaces that value and respect all Coloradans through a commitment to equal opportunity and hiring based on merit and fitness. The State is resolute in non-discriminatory practices in everything we do, including hiring, employment, and advancement opportunities., Please indicate your understanding that failure to submit all items listed under "Complete Applications" at the time of application may remove your application from consideration. If have not uploaded the required items, you can go back now and upload those documents before submission of this application.

• Yes
• No

03

Are you using substitutions to meet the minimum qualifications for the position?

• Yes
• No

04

If you are using substitutions to meet the minimum qualifications for the position, select which option applies to you.

• Using additional education to substitute for the required experience.
• Using additional relevant experience to substitute for the education requirement.
• Not using substitutions.

05

If you are a current or previous State of Colorado employee (including public Institutions of higher education), please provide your Employee Identification Number (EID) in order to verify your current or previous employment. If you indicated that you are a current State of Colorado employee, please list all State of Colorado Departments or institutions of Higher Education for which you have worked for and your Employee ID (if known): Your EID begins with 997 and is nine digits long. Please do not enter your Social Security Number. If not applicable, please state "N/A".

06