Data Management Analyst

Type of Announcement: This announcement is not governed by the selection processes of the classified personnel system. Applications will be considered from residents and non-residents of Colorado. How To Apply: Please submit an online application for this position at Reach out to the Department Contact to apply using a paper application, including any supplemental questions. Failure to submit a complete and timely application may result in the rejection of your application. Applicants are responsible for ensuring that application materials are received by the appropriate Human Resources office before the closing date and time listed.

Department Information This position is not part of the classified personnel system; applications will be accepted from Residents and Non-Residents of Colorado. The 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 , 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., 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. Description of Job

Work Environment: This position is a full-time, hybrid, state-funded position (funding is contingent upon availability and may end at any time)

• Office hours are typically Mon-Fri, 8 am-5 pm.
• Extended hours during the evening or the weekend may be required by business needs.
• A Remote (Home) office is required.
• Required to report to the work location per business needs.
• Essential Functions (ADAAA)

• SEDENTARY/Office environment: o Required to sit, view a computer screen, and utilize a keyboard and mouse for extended periods of time. o Required lifting, bending, stooping, pushing, walking, etc.

• 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 Data Services Unit is a team of data professionals passionate about transforming education data into meaningful insights. We provide exceptional technical support to school district personnel and produce accurate, reliable data reports that inform educators, policymakers, researchers, and the public. As a member of our team, you will have the opportunity to work independently on assigned projects while collaborating with colleagues on initiatives that support Colorado school districts and advance the work of the Colorado Department of Education. We value teamwork, respect, open communication, and continuous learning, and we foster a supportive remote work environment with occasional opportunities to collaborate in person at the CDE office.

This Data Management Analyst position will oversee the Student Attendance snapshot, Teacher Student Data Link snapshot, and Teacher Student Data Link interchange. This position is a member of the Student Data and Reporting team who supports the Student Interchange. Note: Specific data collection assignments are subject to change based on business needs.

The Data Management Analyst position is responsible for understanding Legislative requirements and identifying the data which will be collected and reported by Colorado’s Local Education Agencies. The individual in this role is required to validate the data and implement quality assurance best practices to ensure the quality of the data. This position is responsible for leading the data collections assigned which include communication and outreach plans, implementation, supporting and training Colorado’s local education agencies throughout the process and data analysis. This position requires collaboration with various units across the department to determine collection changes necessitated by legislation or regulation and to provide data needed to fulfill reporting, technical assistance, monitoring, and analysis obligations., Primary Duties (Student Attendance, Teacher/Student Data Link)

• Collect data from Colorado’s local education agencies (school districts, BOCES, and AUs) and provide technical assistance to ensure the data is collected timely and accurately.
• Facilitate the activities associated with assigned data collections and processes throughout the cycle of each collection which includes opening, tracking data submissions, validating the data, providing technical support, closing, and creating required data reports.
• Review and update all resource materials, including file layouts, training documentation, timeline, and maintain webpage documentation for assigned data collections.
• Coordinate with CDE program units and CDE application developers to test data pipeline and ensure functionality and performance meet requirements.
• Track, troubleshoot, and resolve reporting issues made by local education agencies during the collection window, including the severity and time spent for each.
• Review and test business rules, COGNOS reports for data quality issues after the collection period.
• Consult with program staff for requirements and implement technical reports for collection cycle.
• Document bugs for updates and defects including steps to recreate issues and deadlines for resolution.
• Provide direct support to School districts, Boards of Cooperative Education Services (BOCES), Administrative Units (AU) and other CDE offices or units.
• Communicate regularly and provide assistance to local education agencies for all data associated business rules and COGNOS reports available.
• Review, update, and deliver all necessary training to local education agencies using a variety of modalities for diverse audiences with varying knowledge and skill levels.
• Coordinate weekly communications with local education agencies through Town Halls and provide direct one-to-one assistance via phone, email and/or virtual meetings as needed.
• Manages data in Excel using basic formulas, charts, and graphs and/or access the database directly using SQL or similar programming language.
• Utilizes basic SQL and Excel skills to extract data from the CDE data warehouse for statistical analyses to fill data requests.
• Provide specific information and reports for data inquiries from federal, state, local education agencies and from the public.
• Update data summaries, data reports, and PowerPoint presentations based on provided analyses on collected data with the goal of reducing confusion and improving data quality.
• Review data to determine its validity and update validation rules as needed to improve the overall data quality. This includes quality assurance of the data collection business rules and application.
• Consult with other CDE units as collection business analyst to provide data needed to fulfill reporting, technical assistance, monitoring, and analysis obligations for legislation.
• Consult with the CDE’s Information Management Services (IMS) staff to verify the accuracy and integrity of data.
• Is the subject matter expert (SME) on assigned data pipeline collections, providing insight on requirements, reports, and data processes.
• Review and update the Data Dictionary documentation as needed.
• Consult as a major data steward within CDE’s Data Governance structure.
• Understand the data use, purpose, and requirement for all data collections in assigned role.
• Assist as a technical advisor and provide assistance to CDE staff in areas associated with data collection, education research, statistics, evaluation, and programs.
• Understand and communicate how requested changes from program staff will impact the collection and if other collections or systems are impacted.
• Consult with other SMEs when data collection changes impact other collections to ensure all requirements will be met and the changes are designed efficiently.
• Coordinate data changes necessitated for assigned collection based on consultation, review, and guidance from CDE program staff.
• Communicate collection changes for EDAC review, LEAs, and vendor contacts.
• Consult and provide support for other data services unit data collections.
• Other duties as assigned.

Data Pipeline Town Hall Coordinator

• Coordinate weekly Data Pipeline Town Hall presentation agendas across CDE units
• Support presenters from all CDE units with presentation tools and slides
• Manage LEA listserv
• Manage host schedule

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
• 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.
• Sign the acknowledgment form that this position is funded through state funds and is subject to availability., 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 our ADAAA Coordinator at Please note that each agency’s contact information is different; therefore, we encourage all applicants to view the full, official job announcement which includes contact information and class title. Select the job you wish to view, then click on the “Print” icon. 01

Tell us about a time you supported a non-technical customer or stakeholder with a complex data reporting need. What steps did you take to understand their needs, explain the information, and ensure a positive outcome? 02

Describe a time you discovered an issue with a process that could have negative downstream impacts. How did you determine what changes were needed without creating new issues? What did you do to improve the process? 03, If you experience technical difficulty with the NEOGOV system (e.g. uploading or attaching documents to your online application) call NEOGOV technical support at 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.

• Bachelor’s degree from an accredited college or university in data management, statistics, computer programming, or a closely related field, and at least three (3) years of professional experience in data management, statistics, or computer programming., * 3-5 years of experience with analysis programs, querying tools and/or database applications.
• Intermediate proficiency in Microsoft Excel, including experience using VLOOKUP, PivotTables, IF formulas, and other functions to organize, analyze, and interpret data.
• Intermediate SQL knowledge
• Excellent communication and presentation skills
• Meticulous (i.e., proofing work, spelling, grammar, formatting).
• Proven communication, administrative, and project management skills.
• Effective and constructive people skills.
• Evidence of strong logical thinking, problem analysis skills, and technical writing skills
• Knowledge/experience in working with file layouts, editing data, and basic data analysis.
• Ability to effectively balance quality of work and productivity expectations.
• Ability to collaborate with internal and external customers (i.e., school districts, BOCES, other CDE units).
• Demonstrates initiative and exhibits an initiative-taking approach to work.
• Ability to work equally well independently or as a member of a team.
• Exhibits CDE’s mission, vision, and values by the consistent expression of professional, respectful, and customer service-oriented behaviors.

Preferred but not required

• Data reporting experience and/or District/BOCES data respondent experience
• Student information system/student data experience
• Experience training or teaching

• 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)
• 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., Resumes must be uploaded as an attachment to your online application. Documentation will not be accepted after the closing date and time of the announcement.Have you uploaded and attached your resume to this application?

• Yes
• No

04

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

05

If you are using education to qualify, a legible copy of your educational documentation must be submitted with your application. Official or unofficial transcript copies are acceptable. Transcripts from colleges or universities outside of the United States must be assessed for U.S. equivalency by a NACES educational credential evaluation service. These document must show the name of the school, your name, that the degree was awarded and on what date, and the type and name of the degree. Failure to provide a transcript or foreign credential evaluation report may result in your application being rejected and you will not be able to continue in the selection process for this position. Have you included your transcript(s) as an attachment to your application? (If not, you may go back and do so now).

• Yes, I have attached my transcript(s) that will be used to verify whether or not I meet the education requirement as announced.
• No, I have not attached transcripts to my application because I am using experience to meet the minimum qualifications.
• I have requested my transcripts from my college/university and will submit a new application and attach them to that application before the announcement closes.

06

The posted salary range is the department’s good faith offer for this position. Are you willing to accept a salary within this range if offered the position?

• Yes.
• No.
• Maybe. I believe my knowledge and skills encompass all of the minimum qualifications, the preferred qualifications, and special requirements of the position. I have detailed this in the work experience section of the application.

07

If you responded ‘Maybe’ to Question 6, (Salary offer within Posted Range), please list the preferred or special qualifications from the job posting that you meet. 08