Business Data Engineer

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.