Business Systems & Data Engineer

Colorado School Districts Self Insurance Pool; Centennial (CO); On-site; USD 93,000 - 145,000; Full time

Benefits offered by this job

401(k) and 401(k) matching

Colorado Public Employees Retirement

Health, dental, vision insurance

Health savings account

Life insurance

Employee assistance program

Flexible spending account

Paid time off

Parental leave

13 paid holidays per year

Flexible schedule

Paid medical, dental, and vision

Job summary

Colorado School Districts Self Insurance Pool is seeking an experienced data engineer to design and maintain a centralized data environment in Centennial, CO. This onsite role will drive a RMIS implementation and ensure reliable data pipelines and integrations across internal and external systems.

You will build ETL/ELT processes, data models, governance standards, and documentation, while leading data migration and validation activities to ensure high-quality data for reporting and analytics.

Qualifications

• Bachelor’s degree in a related field.
• 5+ years of experience in data engineering, platform engineering, or data integration.
• Experience with relational databases, data modeling, migrations, and optimizations.
• Experience with financial or complex operational data.
• Ability to work with business partners across departments.
• Hands-on experience building data integrations, data pipelines, and automated data transfers using APIs, SQL, scripting.

Responsibilities

• Design, develop, and maintain CSDSIP’s centralized data environment and supporting architecture.
• Build ETL/ELT processes to collect, transform, and integrate data from internal and external systems.
• Create and maintain data models, data structures, and data governance standards.
• Document data sources, transformations, integrations, dependencies, data lineage, and processes.
• Implement data validation and quality controls with data dictionaries and MDM practices.

Skills

5+ years experience

Relational databases

Data modeling

Data integrations

ETL/ELT

APIs

SQL

Scripting

Project management

Strong communication

Education

Bachelor’s degree

Tools

RMIS

Power BI

Job description

Improve data quality, accessibility, and reporting by building and maintaining the centralized data environment that powers CSDSIP’s business systems. This onsite role supports an upcoming RMIS implementation and helps create reliable, governed data pipelines and integrations across internal and external systems.

What you’ll do

• Design, develop, and maintain CSDSIP’s centralized data environment (data warehouse or equivalent) and the supporting technical architecture.
• Build ETL/ELT processes to collect, transform, validate, and integrate data from internal and external systems.
• Create and maintain data models, data structures, and data governance standards.
• Document data sources, transformations, integrations, dependencies, data lineage, and technical data processes.
• Implement data validation and quality controls, supported by data dictionaries and master data management practices.
• Design, develop, and maintain integrations between RMIS and other business systems.
• Develop and run integrations using APIs, database, file-based, and other methods, including scheduled and automated data transfers and synchronization.
• Monitor data movement and troubleshoot data-transfer and system issues.
• Act as a technical lead for data migration, integration, and technical implementation for RMIS and other major system projects.
• Support testing and delivery activities including data validation, conversion, and reconciliation.
• Translate business requirements into functional programming routines or processes to meet project objectives.
• Provide reliable centralized data for analysis and support internal business processes with technical solutions.
• Own post-go-live system integrations and proactively identify ways to strengthen reporting infrastructure.

What you bring

• Bachelor’s degree (or equivalent) in Computer Science, Information Technology, Software Engineering, Data Science, Statistics, Engineering, or a related field.
• 5+ years of experience in data engineering, platform engineering, systems integration, business systems development, or a closely related technical field.
• Experience with relational databases, data modeling, migrations, and optimizations.
• Experience working with financial or other complex operational data.
• Ability to work with business partners and outside departments using a customer-focused mindset.
• Hands‑on experience developing and maintaining data integrations, data pipelines, and automated data transfer processes using APIs, SQL, scripting, or other integration tools.
• Experience with ETL/ELT, data mapping, and data validation across multiple systems.
• Experience documenting technical processes, data structures, system integrations, and data flows.
• Strong analytical, problem‑solving, and communication skills.
• Ability to manage multiple projects, work independently, and collaborate with staff and external technology vendors across departments.

Technologies you’ll work with

• ETL/ELT, APIs, SQL, Power BI
• Data warehouse
• RMIS

Benefits

• 401(k) and 401(k) matching (generous 401(k) match)
• Participation in the Colorado Public Employees Retirement Association
• Health, dental, vision insurance
• Health savings account
• Life insurance
• Employee assistance program
• Flexible spending account
• Paid time off
• Parental leave
• 13 paid holidays per year
• Flexible schedule
• Paid medical, dental, and vision insurance

Compensation and work location

• Salary range: $93,000 - $145,000 per year
• Work location: In person (Centennial, CO)