Business Systems & Data Engineer

Colorado School Districts Self Insurance Pool (CSDSIP) is seeking a Business Systems & Data Engineer to build and maintain the data foundation that supports integration, reporting, and high-quality analytics. In this onsite role in Centennial, CO, you will develop the centralized data environment, connect systems through reliable pipelines, and provide technical leadership for an upcoming RMIS implementation.

Role overview

You will design and operate data infrastructure that improves data quality, accessibility, and reporting. The position works closely with the Business Data Analyst and other departments to migrate and validate data, establish governance and integration processes, and support technical projects tied to the new RMIS and other major system initiatives.

Responsibilities

• Design, develop, and maintain a centralized data environment (data warehouse or appropriate equivalent)
• Build ETL/ELT processes to collect, transform, validate, and integrate data from internal and external systems
• Document data sources, transformations, integrations, and dependencies
• Establish data models, data structures, and data governance standards
• Identify data cleanup opportunities and design sustainable, scalable processes to ensure data quality
• Design, develop, and maintain integrations between CSDSIP’s RMIS and other business systems
• Create and maintain API, database, file-based, and other system integrations
• Set up schedules and automated processes for transferring and synchronizing data across systems
• Monitor integrations and troubleshoot data-transfer and system issues
• Serve as a technical lead for data migration, integration, and technical implementation of the new RMIS and other major system projects
• Develop data mapping and transformations for historical data
• Support system testing, data validation, conversion, data reconciliation, and implementation
• Work with vendors and internal stakeholders to resolve technical issues
• Own post-go-live system integrations
• Assist with automation efforts to reduce manual data entry and repetitive administrative work
• Proactively identify opportunities to improve and strengthen reporting infrastructure for stakeholder consideration
• Assist in building and maintaining technical solutions supporting internal business processes
• Develop and maintain data models and reporting datasets
• Translate business requirements into functional programming routines and/or processes to meet project objectives
• Set up data connections and automated refresh schedules
• Provide reliable, centralized data for analysis
• Establish and maintain technical data documentation and data lineage
• Implement data validation and quality controls
• Support appropriate data security, access controls, and data management practices
• Apply data quality controls and maintain data governance practices, data dictionaries, and master data management processes

Requirements

• 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 with financial or other complex operational data
• Ability to work with business partners and outside departments using a customer-focused mindset
• 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 across departments and external technology vendors

Technologies

• 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
• Dental insurance
• Vision insurance
• Health insurance
• Health savings account
• Life insurance
• Employee assistance program
• Flexible spending account
• Paid time off
• Parental leave
• Retirement plan
• 13 paid holidays per year
• Flexible schedule
• Paid medical, dental, and vision insurance

Location and pay

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