Department Information This position is only open to current Residents of Colorado. This position is ONLY open to internal candidates currently employed within the Colorado Department of Education. Incumbent will be required to 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 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.
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. 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 as compared to others doing 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. Description of Job Work Environment: This position is full-time, is federally funded (funding is contingent upon available funding), and is eligible for a hybrid work environment.
Extended hours during the evening or the weekend may be required by business needs. Commuting to the CDE buildings is required. 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. Position Summary: This position is ONLY open to internal candidates currently employed within the Colorado Department of Education.
Ready to make an impact with Colorado's education data. Join our team in a high-impact role that combines federal reporting leadership (EdFacts and CRDC), business analysis, and project management. As a central coordinator, you'll help ensure Colorado's education data is accurately collected, validated, managed, and reported while partnering across CDE to align technical systems with business needs and federal reporting requirements.
This is an exciting opportunity for a collaborative problem-solver who enjoys working across programs, translating business needs into technical solutions, and driving data-informed decision-making that supports schools, students, and educators across Colorado. The final salary is anticipated to fall within the posted salary range, however, 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: EdFacts Coordinator: Act as the official SEA liaison to the U.S
Department of Education EDFacts team and Partner Support Center (PSC). Manage all EDFacts data collections and submissions through the EDEN system. Act as subject matter expert in federal EdFacts reporting requirements, partnering with CDE staff to ensure collected data meets federal reporting requirements.
Analyze EDFacts file specifications to communicate requirement changes with CDE business units and Data Warehouse (DWH) team. Monitor and lead compliance efforts with federal reporting requirements and timelines. Utilize advanced SQL and excel skills to validate data for completeness, accuracy, and alignment with federal definitions.
Perform data quality checks and resolve data issues with program areas and federal partners. Align business rules between DWH, Data Collection Leads, and reporting outputs. Coordinate with technical developers (Informatica, SQL, ETL) to build, modify, and maintain data reporting processes.
Translate technical requirements into business language and vice versa. Submit, track, and monitor EDFacts files and resolve submission errors prior to EdFacts data reporting deadlines Communicate regularly with leadership on the EdFacts reporting status. Promote data governance, data standards (CEDS), and best practices in data usage.
Support analysis, interpretation, and presentation of education data. Lead coordination across multiple program areas (e.g., Federal Programs, SPED, Assessment). Act as a Business Analyst (BA) for EDFacts collections
Design and implement development of automated collection processes and error reporting. Collaborate on public reporting and federal accountability reporting (ESSA). CRDC Liaison: Manage the biennial Civil Rights Data Collection mandated by the federal government.
Serve as liaison between the U.S. Department of Education and Local Education Agencies (LEAs). Coordinate communication, timelines, and requirements with federal and local stakeholders
Gather requirements and define file specifications for CRDC reporting. Validate pre-populated CRDC data with business offices and LEAs. Design and support systems for file development and submission.
Assist LEAs in meeting their reporting obligations. Monitor data quality and resolve submission issues. Provide status updates to CDE leadership.
Support system development and improvements specific to CRDC reporting processes. Lead CRDC data collection for pre-populated data elements. Coordinate with CDE collection leads to create or update parameters and use cases of existing data sources.
Collect CRDC specific data from Colorado's local education agencies (school districts, BOCES, and AUs). Provide technical assistance to ensure the data is collected timely and accurately supporting School districts, Boards of Cooperative Education Services (BOCES), Administrative Units (AU) and other CDE offices or units as needed. Monitor, track, troubleshoot, and resolve reporting issues made by local education agencies during the collection window, including the severity and time spent.
Determine requirements and implement technical reports for the collection cycle. Collaborate with CDE program units and CDE application developers to test data pipeline and ensure functionality and performance meet requirements. Reporting and Analytics: Support federal and state reporting (e.g., ESSA, public reporting, accountability systems)
Support public-facing reporting requirements and annual data publication. Develop, manage, and support enterprise reporting solutions (e.g., Cognos, Data Lab, dashboards). Design and maintain business views in the DWH for multiple program areas
Translate business requirements into reporting logic, metrics, and outputs. Develop analytical insights and improve data presentation quality and usability. Implement suppression and masking rules to ensure data privacy and compliance.
Support BI report development, testing, and deployment. Provide data analysis, interpretation, and statistical support to program areas. Promote effective use of data for decision-making across the organization.
Other Responsibilities: Support implementation of the Data Governance Program. Implementation activities may include participation in data governance committee meetings, serving as the subject matter expert for EdFacts and CRDC reporting expectations. Support data governance practices and coordination across program areas.
Contribute to data standardization and enterprise data alignment. Update data dictionary and metadata tools in collaboration with data governance team. Produce project reports and manage stakeholder communication.
Minimum Qualifications, Substitutions, Conditions of Employment & Appeal Rights MINIMUM EDUCATION AND EXPERIENCE REQUIREMENTS: This position requires three (3) years of experience only, OR A combination of education and experience totaling three (3) years. Experience Only: Three (3) years of relevant experience in an occupation related to the position, such as business analytics/data analytics. OR Education and Experience: A combination of related education, formalized apprenticeship program, certification, and/or relevant experience in an occupation related to the work (business analytics/data analytics) assigned equal to three (3) years.
_______________________________________________________________________________________________________________ QUALIFICATIONS AND CONDITIONS: Qualifications for Success in the Position: Advanced Proficiency in Microsoft Excel Advanced SQL knowledge. Intermediate data reporting skills. 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 behavior. Demonstrated ability to prioritize and organize work to accommodate and meet the changing needs of the department and meet deadlines. Demonstrated ability to identify problems and recommend solutions prior to the standard being jeopardized.
Preferred Qualifications (Preferred/Not Required): 5+ years of experience with analysis programs, querying tools and or database applications. 3+ years of experience with CDE data pipeline and/or data warehouse systems. Experience validating complex data sets.
Experience as a CDE data collection lead, application developer, or ETL developer. Experience creating data visualizations. Conditions of Employment (Required): Must be willing and able to submit to the pre-screening process.
Ability and willingness to independently determine, obtain means, and complete required commuting. 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 federal funds and is subject to availability.
Supplemental Information 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.
Transcript: Required if using education to meet MQs - Attached to the online application and meeting requirements as described under "College Transcripts". Answer the supplemental questions in the application. 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 will result in your application being removed from consideration.** 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 wit...