CDE ONLY: EdFacts Coordinator/CRDC Liaison/Reporting Analyst

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.

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:
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 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.

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 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 "[email protected]" addresses. It is your responsibility to ensure that your email will accept these notices and/or review your junk mail and spam-filtered email.

Appeal Rights:
If you receive notice that you have been eliminated from consideration for the position, you may protest the action by filing an appeal with the State Personnel Board/State Personnel Director within 10 days from the date you receive notice of the elimination.
 
Also, if you wish to challenge the selection and comparative analysis process, you may file an appeal with the State Personnel Board/State Personnel Director within 10 days from the receipt of notice or knowledge of the action you are challenging.
 
Refer to Chapters 4 and 8 of the State Personnel Board Rules and Personnel Director's Administrative Procedures, 4 CCR 801, for more information about the appeals process. The State Personnel Board Rules and Personnel Director's Administrative Procedures are available at www.colorado.gov/spb.
 
A standard appeal form is available at: https://spb.colorado.gov/ . If you appeal, your appeal must be submitted in writing on the official appeal form, signed by you or your representative, and received at the following address within 10 days of your receipt of notice or knowledge of the action: Colorado State Personnel Board/State Personnel Director, Attn: Appeals Processing, 1525 Sherman Street, 4th Floor, Denver, CO 80203. Fax: 303-866-5038. Phone: 303-866-3300. The ten-day deadline and these appeal procedures also apply to all charges of discrimination.

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 [email protected].