24 days old


Eugene, OR 97403
ETL Developer

Job no: 521431
Work type: Officer of Administration
Location: Eugene, OR
Categories: Administrative/Professional, Information Technology, Computer and Information Science

Department: Information Services
Appointment Type and Duration: Regular, Ongoing
Salary: Commensurate with experience
Compensation Band: OS-OA08-Fiscal Year 2017-2018
FTE: 1.0

Application Review Begins
December 20, 2017; position open until filled

Special Instructions to Applicants
When applying you will be required to attach the following electronic documents:

1. A resume and;
2. A cover letter indicating how you meet the minimum qualifications of the position.

You will also be required to submit the names of at least three professional references, their e-mail addresses, and telephone numbers as part of the application process.

Any application missing the above documents/information may be considered incomplete.

If you would like to view the complete position description including the duties, please email ishr@uoregon.edu and reference the job number and job title.

Department Summary
Information Services (IS) is the central information technology unit at the University of Oregon and provides wide ranging services to campus. Information Services consists of four major functional areas: Customer Experience, which serves as the key contact point for interactions with campus clients and customers; Applications & Middleware, which manages and supports applications, integration services, identity management and data management; Information Security, which helps protect virtual or physical information; and Technology Infrastructure, which provides administration and support for the software, hardware, and services needed to support the campus IT environment. Information Services also includes the Advanced Network Technology Center. IS works closely with the Network for Education and Research in Oregon.

Established in 1876, the University of Oregon offers a breadth and depth of curricula with more than 270 academic programs and provides the opportunity to work at a respected research university with a strong holistic, liberal arts foundation. The UO also has a history of political and social involvement that embraces diverse beliefs, cultures, and values, and it is committed to environmental responsibility.

Eugene is the home of the University of Oregon. Located in the lush Willamette Valley, Eugene is well-known for outdoor pursuits like running, cycling, rafting, and fishing, as well as arts, music, crafts, brewing, wine-making, and community-supported agriculture. With branches in Portland and on the Oregon coast, the UO is deeply connected to Oregon's natural and cultural treasures.

Position Summary
Reporting to the Director of Business Applications and serving under the IDR Team Lead, this position is responsible for Extract Transform and Load (ETL) planning, design, development, and support for enterprise data warehouses and data marts. This position works independently and also functions as an effective team member in a variety of projects related to providing enterprise reporting, analytics, and other application services.

This position develops and maintains high quality and up-to-date critical system documentation. This position provides back-up ETL support for the CRM services as part of the overall Business Applications team. This position functions within a team to initiate, promote and coordinate activities to foster growth within the University report writing community. This position has no budget authority and no supervisory authority.

Candidates who promote and enhance diversity are strongly desired.

Minimum Requirements
• Bachelor's degree from an accredited institution or an equivalent amount of demonstrated skills and experience.
• Three (3) years of report development experience with large-scale transactional, enterprise applications (such as Banner, SAP, Oracle Apps, etc.).
• Demonstrated experience with ETL processes and procedures.
• One (1) year experience with high-level report development tools (such as Cognos, Crystal, Business Objects, etc.).
• Three (3) years of experience with direct query languages and tools such as SQL, and general software development tools such as source code control, issue tracking and automated testing.

Professional Competencies
• Demonstrated ability in writing triggers, stored procedures, views, functions, etc.
• Demonstrated ability to comprehend and adhere to software development process standards aimed at repeatable, cross-team support.
• Demonstrated ability to participate in system deployments using multiple instances (such as Development, Test, Training and Production).
• Proven understanding of Business Intelligence concepts and supporting technologies.
• Demonstrated excellent written, oral, and interpersonal communication skills.
• Demonstrated experience working with end-users in analysis and/or support/training roles.
• Ability to work effectively with faculty, staff, and students from a variety of diverse backgrounds.
• Demonstrated problem solving skills.
• Ability to adapt within a rapidly changing technical environment.
• Excellent verbal and written communication skills, including the ability to explain technical concepts to audiences with a wide range of technical skills.
• Ability to work independently as well as in a team-oriented, collaborative environment.
• Proven ability to be flexible and adaptable in regards to learning and using new technologies.
• Demonstrated history of being highly self-motivated and able to take direction.
• Keen attention to detail in analysis and validation and strong organizational skills.

Preferred Qualifications
• Bachelor's degree in the field of Computer Science, Information Systems, or Software Engineering.
• Experience with Ellucian Banner, ODS and/or EDW.
• Experience with IBM Cognos.
• Experience analyzing Financial, HR or Higher Education data.
• Experience with Agile development methodology.
• Experience with ITIL or ITSM.

FLSA Exempt: Yes

All offers of employment are contingent upon successful completion of a background inquiry.

The University of Oregon is proud to offer a robust benefits package to eligible employees, including health insurance, retirement plans and paid time off. For more information about benefits, visit http://hr.uoregon.edu/careers/about-benefits.

The University of Oregon is an equal opportunity, affirmative action institution committed to cultural diversity and compliance with the ADA. The University encourages all qualified individuals to apply, and does not discriminate on the basis of any protected status, including veteran and disability status.

UO prohibits discrimination on the basis of race, color, sex, national or ethnic origin, age, religion, marital status, disability, veteran status, sexual orientation, gender identity, and gender expression in all programs, activities and employment practices as required by Title IX, other applicable laws, and policies. Retaliation is prohibited by UO policy. Questions may be referred to the Title IX Coordinator, Office of Affirmative Action and Equal Opportunity, or to the Office for Civil Rights. Contact information, related policies, and complaint procedures are listed on the statement of non-discrimination.

In compliance with federal law, the University of Oregon prepares an annual report on campus security and fire safety programs and services. The Annual Campus Security and Fire Safety Report is available online at http://police.uoregon.edu/annual-report

Advertised: 17 Nov 2017 Pacific Standard Time


  • Administrative / Clerical
  • Engineering
  • Information Technology
  • Legal

Before you go...

Our free job seeker tools include alerts for new jobs, saving your favorites, optimized job matching, and more! Just enter your email below.

Share this job:


Eugene, OR 97403

Share this job


Eugene, or

Separate email addresses with commas

Enter valid email address for sender.

Join us to start saving your Favorite Jobs!

Sign In Create Account
Powered ByCareerCast