Metropolitan State University of Denver · 1 day ago
ETL Developer / Data Warehouse Analyst
Denver, Colorado
Full-time
Hybrid
Senior Level
$74,944/mo - $87,497/mo
5+ years expMetropolitan State University of Denver 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. This role involves designing and implementing ETL workflows, maintaining the EDW, and ensuring accurate data integration for reporting and analytics.
DatabaseEducationInformation TechnologyUniversities
Responsibilities
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
Qualification
Required
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 BusinessObjects 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, PostgreSQL, etc.)
Excellent analytical and troubleshooting abilities with attention to data accuracy and consistency
Strong communication and collaboration skills with both technical and functional stakeholders
Preferred
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 BigQuery)
Experience with Python or PowerShell scripting for automation and ETL orchestration
Understanding of data governance frameworks and FERPA compliance
Previous experience supporting data warehouse modernization or cloud migration initiatives
Benefits
Medical
Vision and dental
Free RTD pass
Tuition reimbursement
Life and supplemental insurance plans
Retirement plans
Long-term disability (LTD) plan
Company
Metropolitan State University of Denver
The Metropolitan State University of Denver is a public university located in Denver, in the U.S. state of Colorado.
1001-5000 employees
H1B Sponsorship
Metropolitan State University of Denver has a track record of offering H1B sponsorships. Please note that this does not
guarantee sponsorship for this specific role. Below presents additional info for your
reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2025 (19)
2024 (13)
2023 (17)
2022 (10)
2021 (4)
2020 (8)
Funding
Current Stage
Late StageTotal Funding
$0.1MKey Investors
US Department of Commerce, Economic Development Administation
2023-09-28Grant· $0.1M
Leadership Team
Jim Carpenter
Chief Financial Officer
Bob Amend
Interim Chief Academic and Administrative Officer
Recent News
Seattle TechFlash
2025-09-12
Denver Business Journal
2025-03-10
Company data provided by crunchbase