Business Systems & Data Engineer

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)