The Sr. Data Engineer will develop and operate data ingestion, transformation, quality, and analytics pipelines for Colorado’s Statewide Longitudinal Data System (SLDS). The role uses Informatica and Snowflake to ingest agency and third-party data into the SLDS common data model, transform raw feeds into harmonized longitudinal records, and maintain analytics-layer models. The engineer will apply identity-matching logic, resolve matching exceptions, monitor scheduled production feeds, investigate failures, reload corrected or late files, reconcile row counts, and rebuild downstream objects. The position is responsible for data-quality checks, layout-change detection, audit trails, privacy protections, and compliance with applicable requirements such as FERPA, COPPA, ADA, and state statutes. It also includes query and warehouse performance optimization, testing and code review, and release promotion across Development, Test, UAT, and Production using Azure DevOps and Azure Test Plans. Work includes development and validation of CDHE course data feeds and, conditionally, postsecondary demographic, Pell Grant eligibility, disability, and PSAT/SAT assessment data. The engineer will transition operational knowledge from an implementation partner, shadow and co-run existing feeds, and take on production operations after meeting a readiness gate. Additional work includes resolving stabilization defects, maintaining and hardening analytics-layer models, improving metrics, profiling dashboard back-end queries, and collaborating with data architecture, analytics, and operations teams. The engagement is a six-month W-2 contract, with a possibility of extension based on project performance and state funding. The posting describes the work arrangement as Remote/Telecommuting, while also stating that the candidate must reside in Colorado for the duration of the engagement and expressing a strong preference for local/Denver Metro candidates.
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
Career Level
Senior
Education Level
No Education Listed