Data Management Analyst-Non-Classified

State of Colorado; Denver (CO); Hybrid; USD 65,000 - 95,000; Full time

Benefits offered by this job

Flexible work schedules

Medical insurance

PFML (Paid Family Medical Leave)

Holidays

Vacation and sick leave

PERA retirement

RTD Eco Pass

Professional development

Job summary

The Colorado Department of Education's Data Services Unit seeks a Data Management Analyst to oversee the Student Attendance snapshot, Teacher-Student Data Link snapshot, and related data flows. You will validate data, implement QA, and collaborate with local education agencies across Colorado to ensure accurate reporting.

You will lead data collections, develop outreach plans, train districts, and provide technical support, leveraging SQL, Excel, Cognos, and other tools in a largely remote,

Responsibilities

• Collect data from Colorado's local education agencies and provide technical assistance to ensure data is collected timely and accurately.
• Track, troubleshoot, and resolve reporting issues during the collection window.
• Review data quality and validate data against business rules and requirements.
• Update data summaries and reports to improve data quality and clarity for stakeholders.

Skills

SQL

Excel

Data analysis

Communication

Tools

COGNOS

Power BI

SQL

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.

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.
• DL Not Required: Required to independently determine, obtain means to complete required travel. (For positions that only report to CDE locations and can use public transportation to complete that.)
• 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 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.

Major Duties and Responsibilities:

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