Department: Financial and Administrative Shared Services - Information Technology
Classification: Analyst Programmer 2
Appointment Type and Duration: Regular, Ongoing
Salary: $60,816 - $112,872 per year
FTE: 1.0
Review of Applications Begins
August 19, 2024; open until filled
Special Instructions to Applicants
To be considered for this position, applicants must submit a complete application. Complete applications must include a completed online application and a resume that addresses how you meet the minimum and preferred qualifications. A cover letter may be included but is not required for a completed application.
We are interested in finding the best candidate for the position. We encourage you to apply, even if you don’t think you meet all 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
Administrative Services oversees multiple business hubs and Shared Service organizations throughout the University. Located within the Finance and Administration portfolio, the objective of the division is to provide efficient, strategic and specialized administrative services to support the missions of various departments, schools and colleges at the University of Oregon. Administrative Services focuses on supporting department-specific budget, finance, payroll, human resource and procure-to-pay functions; as well as specialized physical security technologies. We are a metric-driven, people-first administrative team that strives to create efficient, effective and sustainable support structures across campus.
Position Summary
As a Business Data Engineer, you will play a pivotal role in developing, maintaining, and optimizing data pipelines and infrastructure to support mission-critical reporting and operational intelligence. Your responsibilities will include programming, designing, and developing custom ETL scripts using Python, SQL, Javascript, and other languages, ensuring the seamless movement and consolidation of data from disparate operational systems. Additionally, you will maintain and optimize a complex library of custom scripts, while also designing and updating various data warehouse structures via MS SQL Server to enhance performance and facilitate reporting and operational functions.
You will be instrumental in the creation, deployment, and optimization of a vast library of hundreds custom reports and data products using reporting tools such as Tableau, Excel, Cognos, and native system reporting tools. Collaborating closely with campus stakeholders, you will elicit report requests and requirements, ensuring that the reports and data products developed cater to the diverse needs of senior leadership and various departments. Furthermore, you will actively engage in analyzing business needs, working directly with senior leadership to understand goals, implement necessary changes, and continuously improve business operations processes.
In addition to your technical responsibilities, you will take a proactive approach to training and supporting end-users, creating technical documentation, and providing training on new tools and reports. By establishing and maintaining a learning end-user community within supported units, you will foster a culture of data-driven decision-making and operational excellence. This role offers an exciting opportunity to contribute to the advancement of data-driven practices while playing a key role in shaping the future of analytics and reporting within the organization.
Interactions/contacts occur daily with team members, the campus community and external stakeholders while performing work. This position works in a collaborative environment both independently and as part of a team. To be successful, you will need to be flexible and adaptable with respect to learning and using new technologies and be highly self-motivated and able to take direction. Work is reviewed regularly by the Supervisor to ensure it is performed efficiently, safely, and meets both expectations and applicable requirements.
ESSENTIAL PERSONNEL:
This unit may provide essential services during times of emergencies and inclement weather. This position may be required to fulfill essential services and functions during these times.
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
• Maintain a respectful workplace and model a positive and proactive attitude.
• Model the highest ethical standards.
• Manage business process changes with the goal of optimizing organizational performance.
• Work effectively in a diverse team environment and create effective networks for problem solving and positive change.
• Provide superior customer service.
• Be receptive to feedback, willing to learn and embracing continuous improvement.
• Communicate effectively, orally and in writing.
• Ability to adapt to, learn, and use new technologies within a rapidly changing technical environment.
• Ability to move multiple projects forward within a specific timeframe and budget.
• A deep understanding of business intelligence concepts and supporting technologies.
Preferred Qualifications
• Bachelor's degree in the field of Computer Science or Information Systems
• Two years of direct experience using a programming language such as SQL, Python, or Javascript as part of primary job duties
• Two years of experience with high-level report development tools (such as Tableau, Cognos, Power BI, etc.)
• Experience with fund accounting
• One year of experience analyzing financial data
• One year of experience writing ETL scripts
• Experience with Ellucian Banner
• Experience with tools used in software development such as source code control and issue tracking
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.