The Colorado School Districts Self Insurance Pool (CSDSIP) seeks an experienced and resourceful Business Systems & Data Engineer to become the second member of our Business & Data Intelligence team, complementing the skills or our existing Business Data Analyst.

The Business Systems & Data Engineer is primarily responsible for developing and maintaining CSDSIP's data infrastructure, system integrations, automation, and technical data architecture. This position partners closely with the Business Data Analyst and departments across CSDSIP to connect systems, improve data quality and accessibility, automate business processes, and support the organization's current and future technology initiatives, including Risk Management Information System (RMIS) implementation.

Our current systems are antiquated, isolated, and lacking integration. We will implement a new RMIS in the next couple of years but don’t want to wait to see improvements until then. We want to better connect and leverage our existing data, improve our current posture, and position ourselves to get the most possible out of a new system when it arrives. We need someone who can help with band-aids today, stitches tomorrow, and surgery next year, all while laying the foundation for an entirely new and much better integrated system that supports the full spectrum of our business needs.

Role and Responsibilities:

Data Engineering & Architecture

Design, develop, and maintain CSDSIP's centralized data environment in the form of a data warehouse or appropriate equivalent
Develop 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 and assist with data cleanup opportunities and design sustainable/scalable processes which ensure data quality

System Integration

Design, develop, and maintain integrations between CSDSIP's RMIS and other business systems
Design, develop, and maintain API, database, file-based, and other system integrations
Establish schedule and automated processes for transferring and synchronizing data across systems
Monitor integrations and troubleshoot data-transfer and system issues

RMIS & Systems Implementation

Serve as technical lead for data migration, integration, and technical implementation of the new RMIS and other major system projects
Develop data mapping and transformations of 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

Process Automations and Reporting Infrastructure

Assist in automating internal processes to reduce manual data entry and repetitive administrative work
Proactively identify opportunities to improve, enhance 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 use in analysis

Data Governance

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

Minimum Qualifications:

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 working 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 data extraction, transformation, loading (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 a wide array of different departments and external technology vendors

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

Compensation:

CSDSIP offers a competitive compensation and benefits package for employees, including a generous 401(k) match; participation in the Colorado Public Employees Retirement Association; paid medical, dental, and vision insurance; 13 paid holidays per year; and a flexible schedule. Office attire is usually casual, and our atmosphere is more relaxed than the typical corporation.

Salary range: $93,000 - $145,000

More About Us:

Founded in 1981, CSDSIP provides liability and property insurance and risk management to Colorado school districts, boards of cooperative educational services and charter schools. We are committed to providing superior customer service to our Members. As a Member owned and governed self-insurance pool, we work hard to ensure our products and services inform and empower our Members.

CSDSIP is an equal opportunity employer and does not discriminate based on race, age, creed, color, religion, national origin or ancestry, sex, gender, disability, veteran status, marital status, genetic information, sexual orientation, gender identity, or gender expression.

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

Work Location: In person

Colorado School Districts Self Insurance Pool jobs

Business Systems & Data Engineer