Business Data Engineer

Business Data EngineerJob no: 534250Work type: Classified StaffLocation: Eugene, ORCategories: Administrative/Professional, InformationTechnology, Computer and Information ScienceDepartment: Financial and Administrative SharedServices - Information TechnologyClassification: Analyst Programmer 2Appointment Type and Duration: Regular,OngoingSalary: $60,816 - $112,872 per yearFTE: 1.0Review of Applications BeginsAugust 19, 2024; open until filledSpecial Instructions to ApplicantsTo be considered for this position, applicants must submit acomplete application. Complete applications must include acompleted online application and a resume that addresses how youmeet the minimum and preferred qualifications. A cover letter maybe 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 allpreferred qualifications--use your application to let us know whatis meaningful to you about the role and what transferable skills orother qualities you would bring.Department SummaryAdministrative Services oversees multiple business hubs and SharedService organizations throughout the University. Located within theFinance and Administration portfolio, the objective of the divisionis to provide efficient, strategic and specialized administrativeservices to support the missions of various departments, schoolsand colleges at the University of Oregon. Administrative Servicesfocuses on supporting department-specific budget, finance, payroll,human resource and procure-to-pay functions; as well as specializedphysical security technologies. We are a metric-driven,people-first administrative team that strives to create efficient,effective and sustainable support structures across campus.Position SummaryAs a Business Data Engineer, you will play a pivotal role indeveloping, maintaining, and optimizing data pipelines andinfrastructure to support mission-critical reporting andoperational intelligence. Your responsibilities will includeprogramming, designing, and developing custom ETL scripts usingPython, SQL, Javascript, and other languages, ensuring the seamlessmovement and consolidation of data from disparate operationalsystems. Additionally, you will maintain and optimize a complexlibrary of custom scripts, while also designing and updatingvarious data warehouse structures via MS SQL Server to enhanceperformance and facilitate reporting and operationalfunctions.You will be instrumental in the creation, deployment, andoptimization of a vast library of hundreds custom reports and dataproducts using reporting tools such as Tableau, Excel, Cognos, andnative system reporting tools. Collaborating closely with campusstakeholders, you will elicit report requests and requirements,ensuring that the reports and data products developed cater to thediverse 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 businessoperations processes.In addition to your technical responsibilities, you will take aproactive approach to training and supporting end-users, creatingtechnical documentation, and providing training on new tools andreports. By establishing and maintaining a learning end-usercommunity within supported units, you will foster a culture ofdata-driven decision-making and operational excellence. This roleoffers an exciting opportunity to contribute to the advancement ofdata-driven practices while playing a key role in shaping thefuture of analytics and reporting within the organization.Interactions/contacts occur daily with team members, the campuscommunity and external stakeholders while performing work. Thisposition works in a collaborative environment both independentlyand as part of a team. To be successful, you will need to beflexible and adaptable with respect to learning and using newtechnologies and be highly self-motivated and able to takedirection. Work is reviewed regularly by the Supervisor to ensureit is performed efficiently, safely, and meets both expectationsand applicable requirements.ESSENTIAL PERSONNEL:This unit may provide essential services during times ofemergencies and inclement weather. This position may be required tofulfill essential services and functions during these times.Minimum RequirementsThis classification requires a basic foundation of knowledge andskills in systems analysis and related programming supportfunctions generally obtained by a bachelor's degree in computerscience, or an equivalent amount of training and appliedexperience.Professional Competencies• Maintain a respectful workplace and model a positive andproactive attitude.• Model the highest ethical standards.• Manage business process changes with the goal of optimizingorganizational performance.• Work effectively in a diverse team environment and createeffective networks for problem solving and positivechange.• Provide superior customer service.• Be receptive to feedback, willing to learn and embracingcontinuous improvement.• Communicate effectively, orally and in writing.• Ability to adapt to, learn, and use new technologies within arapidly changing technical environment.• Ability to move multiple projects forward within a specifictimeframe and budget.• A deep understanding of business intelligence concepts andsupporting technologies.Preferred Qualifications• Bachelor's degree in the field of Computer Science orInformation Systems• Two years of direct experience using a programming languagesuch as SQL, Python, or Javascript as part of primary jobduties• Two years of experience with high-level report developmenttools (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 assource code control and issue trackingFLSA Exempt: YesAll offers of employment are contingent upon successfulcompletion 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 benefitspackage to eligible employees, including health insurance,retirement plans, and paid time off. For more information aboutbenefits, visit https://hr.uoregon.edu/about-benefits.The University of Oregon is an equal opportunity, affirmativeaction institution committed to cultural diversity and compliancewith the ADA. The University encourages all qualified individualsto apply and does not discriminate on the basis of any protectedstatus, including veteran and disability status. The University iscommitted to providing reasonable accommodations to applicants andemployees with disabilities. To request an accommodation inconnection with the application process, please contact us atuocareers@uoregon.edu or541-346-5112.UO prohibits discrimination on the basis of race, color, religion,national origin, sex, sexual orientation, gender identity, genderexpression, pregnancy (including pregnancy-related conditions),age, physical or mental disability, genetic information (includingfamily medical history), ancestry, familial status, citizenship,service in the uniformed services (as defined in federal and statelaw), veteran status, expunged juvenile record, and/or the use ofleave protected by state or federal law in all programs, activitiesand employment practices as required by Title IX, other applicablelaws, and policies. Retaliation is prohibited by UO policy.Questions may be referred to the Office of Investigations and CivilRights Compliance. Contact information, related policies, andcomplaint procedures are listed here.In compliance with federal law, the University of Oregonprepares an annual report on campus security and fire safetyprograms and services. The Annual Campus Security and Fire SafetyReport is available online atIn compliance with federal law, the University of Oregonprepares an annual report on campus security and fire safetyprograms and services. The Annual Campus Security and Fire SafetyReport is available online athttps://clery.uoregon.edu/annual-campus-security-and-fire-safety-report.To apply, visit https://careers.uoregon.edu/en-us/job/534250/business-data-engineerjeid-45d5a5fd1764514a848e88905a630756