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
