Data Warehouse Developer

Colorado Christian University

6d•$60,000 - $70,000•Remote

About The Position

The Data Warehouse Developer is a full-time, remote, exempt position within the Data & Analytics department and reports directly to the Director of Data & Analytics. This role supports the development, maintenance, and optimization of the University’s data warehouse environment by building and maintaining data pipelines, transformations, and data marts that enable analytics and decision-making across CCU. The Data Warehouse Developer works closely with the D&A team to implement ETL/ELT processes, create and maintain data models, and ensure data accuracy and reliability across systems such as ERP, CRM, and LMS platforms. This position focuses on execution, data quality, and operational support while learning and applying established data warehouse standards and best practices.

Requirements

A Bachelor’s degree in Computer Information Systems, Data Analytics, Information Systems, Computer Science, or a related field, or equivalent professional experience.
2+ years of experience building data pipelines, ETL/ELT processes, and developing star-schema data models in a data warehouse environment.
Working knowledge of SQL, with the ability to write queries and support data transformations in SQL Server, Snowflake, or similar platforms.
Exposure to data integration across enterprise systems (ERP, CRM, LMS) and familiarity with structured data concepts.
Ability to follow established data modeling and engineering standards while implementing solutions accurately and efficiently.
Strong problem-solving skills and attention to detail when troubleshooting data or pipeline issues.
Effective communication skills and the ability to collaborate with technical and non-technical team members.
A desire to learn, grow, and contribute positively in a fast-paced, team-oriented environment.
Flexibility to work outside normal business hours as needed for scheduled data loads or issue resolution.

Nice To Haves

Experience in higher education and familiarity with Oracle ERP and Salesforce CRM platforms preferred.

Responsibilities

Support the building and maintaining of data pipelines, transformations, staging processes, and star-schema data models.
Support ELT/ETL processes in Snowflake, SQL Server, and related tools to ensure timely and accurate data availability.
Monitor data workflows and assist with troubleshooting and resolving pipeline or data issues.
Assist with automating data ingestion from institutional systems including ERP, CRM, LMS, and other sources.
Develop and maintain data tables, views, and transformations that support analytics and reporting needs.
Assist in building and maintaining data marts and reusable datasets following established modeling standards.
Identify and help resolve data integrity issues across integrated systems (ERP, CRM, and LMS platforms).
Perform data validation and quality checks to ensure accuracy and consistency.
Maintain documentation for data pipelines, transformations, and processes as directed.
Collaborate with the Data & Analytics team to support the data needs across the University.
Participate in cross-functional projects requiring data integration or data preparation.
Learn and apply best practices related to SQL development, data modeling, and data warehouse operations.
Contribute to continuous improvement efforts within the Data & Analytics team.