Business Intelligence and Data Warehouse Manager - Non-Classified

Full Job Description

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 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.

Requirements

Work Environment:

• 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)
  • 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.
      
  • 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.)

Position Summary:
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.

The final salary is anticipated to fall within the posted salary range; however, it could be higher or lower depending on the knowledge, skills, abilities, and other qualifications of the preferred candidate while considering internal equity.

Major Duties and Responsibilities:

• 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:
  • Define requirements for joint report development.
  • Plan implementation steps required.
  • Develop and manage a budget.
  • 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.

Qualifications

MINIMUM EDUCATION AND EXPERIENCE REQUIREMENTS:
Experience

• 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

  • Bachelor’s degree from an accredited college or university in MIS, CS, or related discipline, or equivalent experience.

• And

  • Three (3) years of managing or leading a team in an enterprise data warehouse environment or similar role.

QUALIFICATIONS AND CONDITIONS:
Qualifications for Success in the Position:

• 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

Conditions of Employment (Required):

• Must be willing and able to submit to the pre-screening process and pass a background check.
• 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.

Additional Information

Complete Applications must include:

• Completed Online Application: Required - Submitted through our ATS.
• Resume: Attached to the application
• Transcript: Required if using education to meet MQs - Attached to the online application and meeting requirements as described under "College Transcripts".

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.