ETL Developer​/Data Warehouse Analyst

Overview

The University is seeking an experienced ETL Developer / Data Integration Analyst to support the migration of enterprise data from Workday into the institution’s Enterprise Data Warehouse (EDW), built on Oracle with SAP Business Objects Data Services (BODS), and to maintain the on-premise EDW and eventual migration to Cloud. This role supports the on-going efforts of enterprise reporting, data analytics, and data-driven decision making at all levels of the university.

The ideal candidate will be a hands-on data integration professional with a strong understanding of higher education systems and best practices in ETL and data governance.

• Design, build, and maintain ETL processes to extract, transform, and load data from Workday into the current SAP BODS-based EDW.
• Collaborate on the design of data integration strategies that will ease the future migration to a new EDW environment (e.g., cloud-based or modernized data platform).
• Analyze Workday data structures, reports, and APIs (RaaS, WWS) to establish robust data mapping and transformation logic.
• Integrate legacy Banner SIS data with Workday data to ensure historical continuity and unified reporting across systems.
• Work with business analysts, the BI team, and Institutional Research to understand requirements.
• Implement and monitor data validation, reconciliation, and quality assurance routines to maintain high data integrity.
• Develop and maintain technical documentation, including data flow diagrams, metadata, and ETL job specifications.
• Support data governance and compliance efforts (including FERPA and data access policies).
• Participate in planning and architecture discussions for the next-generation EDW platform to ensure smooth transition of data pipelines.

• Bachelor’s degree in Computer Science, Information Systems, Data Engineering, or related discipline.
• Knowledge of higher education reporting standards (IPEDS, CDS, state-level reporting).
• 5+ years of experience developing and maintaining ETL processes using SAP Business Objects Data Services (BODS) or equivalent enterprise ETL tools.
• Hands-on experience integrating Workday data into an Enterprise Data Warehouse.
• Demonstrated strong understanding of data warehousing concepts, data modeling, and ETL performance optimization.
• Demonstrated strong SQL development skills and experience working with relational databases (Oracle, SQL Server, Postgre
  
  SQL, etc.).
• Excellent analytical and troubleshooting abilities with attention to data accuracy and consistency.
• Strong communication and collaboration skills with both technical and functional stakeholders.

Important Note: Successful applicants will ensure their resumes clearly demonstrate that their work experience describes how they meet ALL required qualifications.

• Experience with Workday Student data model (Academic Records, Student Financials, Admissions, Curriculum).
• Familiarity with cloud-based data platforms (e.g., Snowflake, AWS Redshift, Azure Synapse, or Google Big Query).
• Experience with Python or Power Shell scripting for automation and ETL orchestration.
• Understanding of data governance frameworks and FERPA compliance.
• Previous experience supporting data warehouse modernization or cloud migration initiatives.

We encourage you to apply even if you do not meet every preferred qualification. We are most interested in candidates who will best contribute to the University.

• Full-time, 40 hours per week
• [Exempt]
• Days of the Week:
  Mon – Fri
• Evenings and Weekend Work:
  As needed
• Schedule:
  
  Hybrid Schedule policy
• Travel:
  Rarely

The anticipated hiring range is $74,944.00 - $87,497.00. This position is paid monthly and is eligible for MSU Denver benefits. Salary offers are determined based on final candidate qualifications and experience. Under Colorado law, MSU Denver is required to provide a reasonable estimate of the compensation range for this role and should not offer a salary outside of the range posted in this job announcement.

Posting range: $74,944.00 - $87,497.00. The salary information provided is a guide and may be adjusted based on experience and internal…