Department: Information Services
Classification: Analyst Programmer 2
Appointment Type and Duration: Regular, Ongoing
Salary: $62,028 - $115,128 per year
FTE: 1.0
Hybrid eligible
Review of Applications Begins
December 2, 2024; position open until filled
Special Instructions to Applicants
To be considered for this position, applicants must submit a complete application. Complete applications must include an online application and resume that address how you meet the minimum and preferred qualifications.
We are interested in finding the best candidate for this position. We encourage you to apply, even if you don't think you meet every one of our preferred qualifications - use your application to let us know what is meaningful to you about the role and what transferable skills or other qualities you would bring.
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; Enterprise Solutions, 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.
The University is also proud of the newly-announced Phil and Penny Knight Campus for Accelerating Scientific Impact, an initiative specifically designed to fast-track scientific discoveries and the process of turning those discoveries into innovations that improve the quality of life for people in Oregon, the nation and beyond. Information Services collaborates with Research and Innovation and our schools and colleges to support the research, teaching, and learning mission of the University.
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
The Data Engineer 2 position is responsible for data pipeline, transformation, and model planning, design, development, and support for enterprise data warehouses and data lakes. This position works alongside other data professionals like Architects, ETL Developers and Data Analysts, both internal and external to the department, to meet critical data and analytical needs of the institution. Additional collaboration happens with ERP Developers or other technical staff to respond to changes in source systems, to maintain high quality and timely data pipelines.
This position develops and maintains high quality and up-to-date critical system documentation. This position provides expertise and consultation to other Information Services teams with regards to data structures and pipelines. This position functions within a team to initiate, promote and coordinate activities to foster growth within the university business intelligence community. This position has no budget authority and no supervisory authority.
Minimum Requirements
This classification requires a basic foundation of knowledge and skills in systems analysis and related programming support functions generally obtained by a bachelor's degree in computer science or an equivalent amount of training and applied experience.
Professional Competencies
• Ability to work effectively with faculty, staff, and students from a variety of diverse backgrounds.
• Demonstrated advanced problem-solving skills.
• Excellent verbal and written communication skills, including the ability to explain technical concepts to audiences with a wide range of technical skills.
• Ability to adapt within a rapidly changing technical environment.
• Ability to work independently as well as in a team-oriented, collaborative environment.
• Keen attention to detail in analysis and validation and strong organizational skills.
Preferred Qualifications
• Experience with Ellucian Banner, ODS and/or EDW.
• Experience with Oracle Databases and/or Oracle Data Integrator (ODI).
• Experience with IBM Cognos or Microsoft Power B.l
• Experience with Microsoft Azure or AWS data warehouse and data lake technologies.
• Experience developing complex SQL.
• Experience developing with python.
• Experience with DataOps or DevOps tools and processes, such as git, Jenkins, DBT or Azure DevOps.
• Experience with Agile development methodology.
• Experience with ITIL version 4 or ITSM (Information Technology Service Methodology).
FLSA Exempt: Yes
All offers of employment are contingent upon successful completion of a background check.
This is a classified position represented by the SEIU Local 503, Oregon Public Employees Union.
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 https://hr.uoregon.edu/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. The University is committed to providing reasonable accommodations to applicants and employees with disabilities. To request an accommodation in connection with the application process, please contact us at uocareers@uoregon.edu or 541-346-5112.
UO prohibits discrimination on the basis of race, color, religion, national origin, sex, sexual orientation, gender identity, gender expression, pregnancy (including pregnancy-related conditions), age, physical or mental disability, genetic information (including family medical history), ancestry, familial status, citizenship, service in the uniformed services (as defined in federal and state law), veteran status, expunged juvenile record, and/or the use of leave protected by state or federal law 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 Office of Investigations and Civil Rights Compliance. Contact information, related policies, and complaint procedures are listed here.
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 https://clery.uoregon.edu/annual-campus-security-and-fire-safety-report.