ETL Developer

Are you passionate about transforming data into meaningful insights? Do you enjoy building and optimizing data pipelines in a collaborative, mission-driven environment? Join Information Strategy and Services as an ETL Developer, where you'll design and build data integration solutions that power analytics and decision-making across the university. This role plays a key part in developing and maintaining data pipelines that support business intelligence and data-driven initiatives. If you're someone who thrives on solving complex data challenges, we'd love to meet you.

What You'll Do:

• Design, develop, test, and maintain ETL/ELT processes for enterprise data systems
• Build and optimize data pipelines across platforms such as SQL Server, Oracle, and Snowflake
• Create and maintain data mappings, workflows, and technical documentation
• Monitor ETL processes, troubleshoot errors, and ensure data integrity and performance
• Collaborate with data analysts, modelers, and technical teams to deliver data solutions
• Develop and maintain SQL queries, stored procedures, and data transformations
• Support data warehouse and data lake development, including historical and future-dated data structures
• Participate in on-call support rotation for ETL processing and issue resolution

Note: Responsibilities will scale based on experience level-from guided development at the entry level to independent design, optimization, and mentorship at the senior level.

• Bachelor's degree in Information Systems, Computer Science, Business Analytics, Engineering, Business, Education, or a closely related field

• Substitution: 4 years of professional or high-level technical work experience may be substituted for the bachelor's degree. An associate's degree with two years of relevant work experience may be substituted for the bachelor's degree

Experience:

ENTRY LEVEL

• Enterprise ETL design/development familiarity (e.g. Azure Data Factory, Informatica, dbt, DataStage, etc.)

PROFESSIONAL

• 1 or more years' experience with enterprise ETL design/development experience (e.g. Azure Data Factory, Informatica, dbt, Fivetran, DataStage)

SENIOR

• Two (2) or more years' experience with enterprise ETL design/development experience (e.g. Azure Data Factory, Informatica, dbt, Fivetran, DataStage, Boomi), * 2 or more years' experience with tools (e.g. Boomi, Azure Data Factory, Informatica, Mulesoft, UC4, Autosys)
• Experience with Boomi API development
• Experience authoring PL/SQL or complex SQL and Python
• Experience in programming, workflow automation and complex logic
• Experience in support of a Business Intelligence or data warehousing/data lake initiative
• Knowledge of relational and dimensional data models and MS SQL or Oracle databases
• Experience working in higher education environment

Conditions of Employment:

• Applicants must be legally authorized to work in the United States without requiring sponsorship. We are unable to provide work visa sponsorship or employment authorization for this position now or in the future.

Knowledge, Skills and Abilities:

• Naturally intellectually curious, analytical, problem solver
• Can translate ambiguous concepts, business processes and requirements, as they relate to data
• Must apply discretion, awareness, and sensitivity with regard to data
• A belief that strong relationships are key to success
• A self-starter with a can-do attitude
• A collaborator with a focus on providing solutions based on the requirements and necessary outcomes of those whom we serve

The University of Colorado offers a comprehensive benefits package that includes health insurance, life insurance, retirement plans, tuition benefits, ECO pass, paid time off - vacation, sick, and holidays and more. To see what benefits are available, please visit: https://www.cu.edu/employee-services/benefits-wellness.

Why Work For

The University:

Why work for the University?

At the University of Colorado Anschutz, you'll be part of a nationally recognized institution at the forefront of health innovation and technology. With multiple prestigious national designations, including as a top-tier academic medical center and a hub for cutting-edge research. CU Anschutz offers IT professionals the opportunity to support groundbreaking work that transforms healthcare and improves lives. Here, your expertise in technology directly empowers world-class research, education, and clinical care. Join a collaborative, mission-driven environment where your skills make a real impact. Here, your work matters.

We have AMAZING benefits and offer exceptional amounts of holiday, vacation and sick leave! The University of Colorado offers an excellent benefits package including:

• Medical: Multiple plan options
• Dental: Multiple plan options
• Additional Insurance: Disability, Life, Vision
• Retirement 401(a) Plan: Employer contributes 10% of your gross pay
• Paid Time Off: Accruals over the year
• Vacation Days: 22/year (maximum accrual 352 hours)
• Sick Days: 15/year (unlimited maximum accrual)
• Holiday Days: 10/year
• Tuition Benefit: Employees have access to this benefit on all CU campuses
• ECO Pass: Reduced rate RTD Bus and light rail service

There are many additional perks & programs with the CU Advantage., $116,000 - $124,729

The above salary range (or hiring range) represents the University's good faith and reasonable estimate of the range of possible compensation at the time of posting. This position may be eligible for overtime compensation, depending on the level.

Your total compensation goes beyond the number on your paycheck. The University of Colorado provides generous leave, health plans and retirement contributions that add to your bottom line.

Hybrid - This position is eligible for a hybrid work environment. AMC ISS strives for a high-flex work environment, meaning although this role may predominately be executed effectively with a remote schedule, there may be instances where in-person meetings and/or activities are needed. There is no minimum or prescribed in-person requirement. The work schedule will be based around core working hours in Colorado Mountain Time. Why Join Us: Information Strategy and Services (ISS) partners across the campus to deliver information technology services that empower teaching, learning, research, and patient care. ISS is organized into four core functions: Technology & Infrastructure, Security & Compliance, Information & Data Enablement and Business Services. Together, we connect service and technology. Our work is guided by six shared principles that connect our teams and shape how we serve our customers: * Curiosity- Explore beyond one's own experience and environment. * Compassion- Demonstrates empathy, understanding, and respect for all people. * Collaboration- Partner well beyond our space and build partnerships to achieve organizational results. * Commitment- Dedication and engagement one has to their job, team, organization and university. * Competence- Know our craft and be committed to continuous improvement and learning. * Confidence- Be empowered and assured to represent our customers and their needs. Active investment in our culture and our people is foundational in developing and delivering service excellence. To cultivate a people centric workplace, we do the following: * Growth & Development: Our Workforce Development Program builds critical skills and supports career advancement. * Empowered Managers: Leaders are trained in coaching and team effectiveness to drive success. * Open Communication: Stay connected through monthly town halls and annual summits. * Wellness Focus: We prioritize employee well-being with supportive wellness initiatives. * Coaching Culture: Continuous learning and feedback are part of how we grow together. * Flexible Work: We offer flexible arrangements whenever possible to support work-life balance.