Business Systems & Data Engineer

The Business Systems & Data Engineer designs and maintains the Colorado School Districts Self Insurance Pool (CSDSIP) data infrastructure, integrations, and automation. This onsite role focuses on improving data quality, accessibility, and reporting, including technical support for an upcoming RMIS implementation.

Responsibilities

• Design, develop, and maintain CSDSIP’s centralized data environment (data warehouse or an 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 that support 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 to transfer and synchronize data across systems
• Monitor integrations and troubleshoot data-transfer and system issues
• Act as technical lead for data migration, integration, and technical implementation for the new RMIS and other major system projects
• Develop data mapping and transformations for historical data
• Support testing, data validation, conversion, data reconciliation, and implementation activities
• Collaborate with vendors and internal stakeholders to resolve technical issues
• Own post-go-live system integrations
• Automate internal processes to reduce manual data entry and repetitive administrative work
• Identify opportunities to improve reporting infrastructure for stakeholder review
• Develop technical solutions that support internal business processes
• Develop and maintain data models and reporting datasets
• Translate business requirements into functional programming routines and/or processes aligned with project objectives
• Set up data connections and automated refresh schedules
• Provide reliable, centralized data for analysis use
• Establish and maintain technical data documentation and data lineage
• Implement data validation and quality controls
• Support data security, access controls, and data management practices
• 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 working with financial or other complex operational data
• Ability to work with business partners and outside departments with a customer-focused mindset
• Experience building 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

Technologies

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

Education

Bachelor’s degree (or equivalent) in Computer Science, Information Technology, Software Engineering, Data Science, Statistics, Engineering, or a related field.

Location

Centennial, CO (onsite) · Work location: In person

Compensation

• Salary range: USD 93,000 - 145,000 per year
• Pay: $93,000.00 - $145,000.00 per year

Benefits

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

Nice to Have

• Experience working with legacy applications
• Experience designing, building, or maintaining a data warehouse or other centralized data environment
• Experience supporting enterprise software implementations, including data migration, conversion, testing, and reconciliation
• Experience working with property and casualty insurance, claims, and underwriting data
• Experience supporting system security, role-based access controls, and the secure transfer of sensitive information
• Familiarity with Power BI or other data visualization tools, including data models, reporting datasets, and data refresh processes