Data Warehouse Developer
Description
About the Job
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.
About CCU
Colorado Christian University is the premier interdenominational Christian university in Colorado and the Rocky Mountain region, delivering world class education to thousands of students. The fully accredited, nonprofit University is located in Lakewood, Colorado, a suburb of Denver.
Colorado Christian University was founded in 1914 on two principles — grace and truth. CCU’s scriptural foundation comes from John 1:17: For the law was given through Moses; grace and truth came through Jesus Christ. (ESV)
CCU's mission is Christ-centered higher education transforming students to impact the world with grace and truth.
A leader in higher education, the University has been consistently ranked in the top 2 percent of colleges and universities nationwide for its core curriculum by the American Council of Trustees and Alumni. CCU has had nine consecutive years of enrollment growth and has been named one of the five fastest-growing master’s granting universities by The Chronicle of Higher Education.
CCU offers more than 200 degree program options for traditional and adult students through its College of Undergraduate Studies and College of Adult and Graduate Studies. More than 9,000 students attend the University on the main campus, in regional centers throughout Colorado, and online.
Scripture states all Christians are called to serve Christ and to minister to others. Because Christians are individuals with different gifts and callings, we serve Christ in a variety of ministry vocations. CCU invites you to explore how you may use your calling and gifts at the University.
Job Location
Remote - must reside and work legally in the U.S. All work must be performed within the U.S.
Remote - must reside and work legally in the U.S. All work must be performed within the U.S.
What is most appealing about working at CCU?
- Faith-friendly: CCU’s culture is unique to higher education. Where else can you pursue academic excellence yet read the Holy Bible, pray with teammates and students at work, and work to impact our culture in support of Christian values?
- Convictionally Christian: As a university, we have an enduring commitment to Christ, his kingdom and the truth of God’s Word.
- Live out your calling: We are a traditional evangelical university where you can invest your God-given talents and abilities alongside coworkers and teammates, while having a profound influence on students as they deepen their relationship with Jesus Christ.
- Equip students for kingdom work: You can be a part of helping students discover their callings and preparing them for positions of significant leadership in the church, business, government, education, and other professions, as a key part of our University's Strategic Priorities.
We're looking for candidates who have:
- 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.
- Experience in higher education and familiarity with Oracle ERP and Salesforce CRM platforms preferred.
- 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.
Key Job Duties
Mission Contribution
CCU’s mission is Christ-centered higher education transforming students to impact the world with grace and truth. In this role, the Data Analyst contributes to the mission by leveraging data to help the University be more efficient and effective.
Data Warehouse Development
- 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.
Data Management & Support
- 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.
Collaboration & Development
- 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.
Work Environment
While performing the duties of this job, you may be required to walk; stand; sit; reach with hands and arms; balance; stoop; speak with clarity, have appropriate vision and hearing capabilities. The employee must occasionally lift and/or move up to 25 pounds. You may be required to work occasional irregular hours, including some nights and weekends.
While performing the duties of this job, you may be required to walk; stand; sit; reach with hands and arms; balance; stoop; speak with clarity, have appropriate vision and hearing capabilities. The employee must occasionally lift and/or move up to 25 pounds. You may be required to work occasional irregular hours, including some nights and weekends.
What we offer our employees:
We offer competitive compensation and benefits packages to all employees. Our benefit package includes: a tuition waiver program, excellent healthcare, generous paid time off, matching 403(b) retirement plan, and additional organizational paid benefits and voluntary benefit offerings. Pay and benefits will be discussed in more detail as candidates progress through the interview process. The pay range for this job is $60,000 - $70,000 annually. Pay is assigned by reviewing a combination of job-related factors that may include: internal/external pay equity, the salary structure/pay grade, or a candidate’s qualifications/experience for the job. A wage range posted is not a guarantee of a specific wage and CCU reserves the right to make pay decisions based on economic and equity considerations. CCU does not determine pay based on sex or any other protected status.
Applications will be accepted until position is filled.
Spiritual Requirements
- Committed follower of Jesus Christ, who believes there is no salvation apart from faith in his atonement on the cross, by grace alone becoming "born again" thus beginning a personal relationship with Christ, the Son of God.
- Able to effectively communicate personal faith and apply biblical principles and convictions in the workplace. Must have a strong sense of calling to the ministry of Colorado Christian University.
- Regularly attend and be engaged in meaningful involvement in a Bible-believing evangelical local church. Knowledgeable about the Word of God and passionate about Christian education.
- Must be a traditional evangelical Christian whose lifestyle is in consonance with sound Christian principles, is compatible with CCU’s Statement of Faith, and is in agreement with the Strategic Priorities promulgated by the University.