Data Management Analyst

Department Information

• 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

Description of Job

Work Environment:

• Office hours are typically Mon-Fri, 8 am-5 pm
• Extended hours during the evening or the weekend may be required by business needs
• 5% Travel required within Denver Metro/Downtown for Meetings/Training
• A Remote (Home) office is required
• Required to report to the work location per business needs
• 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.

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.

This Data Management Analyst position is assigned to the Discipline Interchange, Student Discipline snapshot, Prevent Harassment and Discrimination periodic and the Restraint/Seclusion data collections which are collected from Colorado's local education agencies including districts and BOCES. This position also provides essential administrative functions to the Education Data Advisory Committee (EDAC).

Data Management Analyst position

• 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 technical assistance to local education agencies for all data associated with 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.
• Utilize 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 the 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 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.
• 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.
• Provide all communication for collection changes, including EDAC, LEAs, and vendor contacts.
• Consult and provide support for other data services unit data collections.
• Assist in case management of State Assigned Student Identification numbers (SASIDs) in the Record Integration Transfer System (RITS).
• Other duties as assigned.

• Assume a major role in coordinating the activities and records of the Education Data Advisory Committee.
• Produce an annual calendar of collections for the field.
• Serve as EDAC Secretary by gathering review documents, organizing meetings, taking notes, keeping database up to date, etc.
• Update form numbering system and redesign the EDAC database for all EDAC documents.

Minimum Qualifications, Substitutions, Conditions of Employment & Appeal Rights

MINIMUM EDUCATION AND EXPERIENCE REQUIREMENTS:
three years of professional experience in data management, statistics, or computer programming.
A bachelors degree may substitute for Bachelor’s degree from an accredited college or university in data management, statistics, computer programming or a closely related field

QUALIFICATIONS AND CONDITIONS:
Qualifications for Success in the Position:

• Basic Proficiency in Microsoft Excel.
• Basic proficiency in a statistical language such as SQL, Python, etc
• Basic data reporting skills.
• Excellent communication and presentation skills
• Comfortable with giving presentations
• 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.

• Basic SQL knowledge.

• 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 (percentage 5%)
• 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 (percentage 5%).

Supplemental Information

Complete Applications must include:

• Completed Online Application: Required - Submitted through our ATS.
• Cover Letter: Required - Copy and Paste into the Supplemental Questions (11,000 character limit, aprx. 3 pages)
• Resume: Required - Copy and Paste into the Supplemental Questions (11,000 character limit, aprx. 3 pages)