Book Fair Analyst (Data Management Analyst)- Non-Classified

Posting number: 02076-Cnslt-IMS-0926 Department: Department of Education Division: Information Management Services Job classification: NON-CLASSIFIED Posting type: Open Categories: Education Summary This position is not part of the classified personnel system, applications will be accepted from Residents and Non-Residents of Colorado.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.(Term-limited position ending in July 2029) 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.Examples of duties Work Environment:This is a full-time, term-limited, grant-funded position with a hybrid work environment. • Extended hours during the evening or the weekend may be required by business needs. • Travel: Approximately 5% travel within Colorado, including the Denver metro area and downtown, for meetings and training. • A Remote (Home) office is required. • Required to report to the work location per business needs • DL Not Required: Required to independently determine and obtain means to complete travel requirements. • Essential Functions (ADAAA)• SEDENTARY/Office environment:• Required to sit, view a computer screen, and utilize a keyboard and mouse for extended periods of time. • Required: lifting, bending, stooping, pushing, walking, etc. Position Summary:• 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. • Manage the activities and processes throughout the Summer Book Fair Data Collection which includes opening, tracking data submissions, validating the data, providing technical support, closing, and creating required data reports. • Serve as a primary CDE point of contact for the participating schools and districts for the Summer Book Fair Program, providing ongoing communication, technical assistance, implementation support, and coordination throughout the project. • Support implementation of the Summer Book Fair Fidelity Assessment and Reporting Plan, including collecting, tracking, validating, and reporting data associated with established fidelity measures and identifying implementation issues that require follow-up with schools, districts, vendors, or CDE program staff. • Coordinate with participating schools and districts to obtain required implementation and fidelity information, monitor completion of program requirements, and support timely resolution of data or implementation issues. • Collaborate with the Early Literacy office, program vendors, program developers, and evaluation partners, as appropriate, to ensure fidelity data are accurate, complete, and available for program monitoring, grant reporting, and evaluation purposes. • Maintain documentation and tracking systems related to school and district participation, implementation milestones, fidelity measures, and required follow-up. • Create and update all resource materials, including file layouts, training documentation, timeline, and maintain webpage documentation for the Summer Book Fair Data Program. • Collaborate with CDE program units and CDE application developers to test data pipeline and ensure functionality and performance meet requirements. • Monitor, 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. Use this for creating or updating business rules and/or COGNOS reports to improve data quality during the collection if possible or for the following year. • Determine requirements and implement technical reports for the collection cycle. • Document bugs for updates and defects including steps to recreate issues and deadlines for resolution. • Provide direct support to participating schools, school districts, Boards of Cooperative Education Services (BOCES), and other CDE offices or units, serving as a primary point of contact for school and district questions related to Summer Book Fair implementation, data reporting, fidelity requirements, and project timelines. • Communicate regularly, track and assist local education agencies with all items associated with business rules, data reporting and the COGNOS reports available. • Determine needs, 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. • Manage data in Excel using intermediate formulas, charts, and graphs and/or access the database directly using SQL or similar programming language. • Utilize intermediate SQL and Excel skills to extract data from the CDE data warehouse for statistical analyses to fill data requests. • Report on specific information and reports for data inquiries as needed. • Analyze reported 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. • Collaborate with the CDE's Information Management Services (IMS) staff to verify the accuracy and integrity of data. • Review and update the Data Dictionary documentation as needed. • Act as a major data steward within CDE's Data Governance structure. • Understand and report on the data use, purpose, and requirement for all data collections processes for the data pipeline. • Act as a technical advisor and help 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 how other collections or systems are impacted. Provide options for requested changes with minimal impacts on collection. • Collaborate with other SMEs when data collection changes impact other collections to ensure all requirements will be met and the changes are designed efficiently. • Communicate all collection changes for EDAC review, LEAs, and vendor contacts. • Collaborate and provide support for other data services unit data collections. • Proactively review data and requirements to prepare potential updates and options for discussions with program staff. This includes providing mock-ups of the updated file layout, business rules and/or COGNOS reports if applicable. • Collaborate with the development team to improve user experience within the data pipeline process. • Other duties as assigned. Qualifications MINIMUM EDUCATION AND EXPERIENCE REQUIREMENTS: Bachelor's degree from an accredited college or university in data management, statistics, computer programming, or a closely related field OR three (3) years of professional experience in data management, statistics, or computer programming.Competency and Qualification Requirements: • 3-5 years of experience with analysis programs, querying tools, and/or database applications. • Intermediate Proficiency in Microsoft Excel. • Intermediate SQL knowledge. • Intermediate data reporting skills. • Excellent communication and presentation skills • Meticulous (i.e., proofing work, spelling, grammar, formatting). • Proven communication, administration, 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 Qualifications (Preferred/Not Required): • Data reporting experience and/or District/BOCES data respondent experience • Student information system/student data experience • Experience training or teaching 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. • Required to sign a Waiver of Retention Rights (for term-limited positions) Supplemental information Notes:Only completed applications received by the deadline will be considered for review. Following the close of the posting, all applications will be reviewed, and selected candidates will be contacted to participate in the interview process. HR does not use AI to scan for MQs. Complete Applications must include:• Completed Online Application: Required - Submitted through our ATS. • Cover Letter: Required - Attached as a separate document. • Resume: Required - Attached as a separate document. College Transcripts: If you are using education to qualify, a legible copy of your official or unofficial college transcript(s) or a foreign credential evaluation report must be submitted with your application. Transcripts must show the name of the school and that a degree was conferred. Transcripts from colleges or universities outside of the United States must be assessed for U.S. equivalency by a NACES educational credential evaluation service. 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. Failure to submit a complete application as defined above by the announcement close may result in your application being removed from consideration. Transcript Note: You may redact information that identifies your age, date of birth, or dates of school attendance or graduation from any application materials, such as transcripts or certificates, submitted with your application Resumes and Cover Letters WILL NOT be reviewed for minimum qualification screening. 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.