University of Oregon
Eugene, OR, USA
Business Data Engineer
Job no: 534250
Work type: Classified Staff
Location: Eugene, OR
Categories: Administrative/Professional, Information Technology, Computer and Information Science
Department: Financial and Administrative Shared Services - Information Technology Classification: Analyst Programmer Appointment Type and Duration: Regular, Ongoing Salary: $60,816 - $112,872 per year FTE: 1.0
Review of Applications Begins
August 19, 2024
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 mailto: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 https://investigations.uoregon.edu/reporting.
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
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
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
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
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.
To apply, visit https://apptrkr.com/5458227
jeid-d2e1689b95601a4aa29439de19f3bce9
Full Time
Business Data Engineer
Job no: 534250
Work type: Classified Staff
Location: Eugene, OR
Categories: Administrative/Professional, Information Technology, Computer and Information Science
Department: Financial and Administrative Shared Services - Information Technology Classification: Analyst Programmer Appointment Type and Duration: Regular, Ongoing Salary: $60,816 - $112,872 per year FTE: 1.0
Review of Applications Begins
August 19, 2024
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 mailto: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 https://investigations.uoregon.edu/reporting.
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
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
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
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
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.
To apply, visit https://apptrkr.com/5458227
jeid-d2e1689b95601a4aa29439de19f3bce9
San Diego Association of Governments - SANDAG
Annual Salary Range: $96,824.00 - $150,092.80
First Review of Applications: July 27, 2024
Expected Start Date: August/September 2024
Description
The Application Developer will participate in a variety of advanced professional, analytical, and coordination support duties for programming, design, development, deployment, and maintenance of ARJIS applications technology. As the agency continues toward its goal of delivering data products in alternate formats, the ability to develop and implement innovative tools and resources, develop solutions to meet the needs of projects and customers, and participate in inter-departmental and/or cross-functional project teams will be an increasingly important aspect of the position.
The Application Developer will be detail-oriented, capable of maintaining accurate data and records, with superior quantitative analytical capabilities, organized, with effective communication skills.
Overview of the Automated Regional Justice Information System
ARJIS is recognized as a leader in the use of technologies for regional, State, and national public safety applications. ARJIS’s technology portfolio includes Software AG’s webMethods suite, Microsoft SharePoint 2010 and IIS, JBoss, Apache, ESRI GIS suite, and Microsoft SQL Server. Within these products, ARJIS uses both .net and Java to implement customer facing solutions.
The ARJIS division develops and maintains a complex, multi-agency information network that allows real-time law enforcement applications and data to be shared among 82 local, state, and federal criminal justice agencies. Averaging 50,000 transactions daily, ARJIS is used by more than 4,400 officers and investigators for tactical analysis, statistical information, crime analysis, and investigative purposes. Providing real-time shared access to information increases collaboration among law enforcement jurisdictions, improves the overall effectiveness of the regional criminal justice system, and helps to address and anticipate public safety issues to improve the quality of life for residents of the San Diego region.
Experience and Qualifications
A bachelor’s degree from an accredited college or university with major course work in computer science, information technology, or a related field. A combination of relevant education and recent work experience may be considered in lieu of the bachelor’s degree requirement.
A minimum of five years of full-time professional information technology experience preferably in a public safety environment; understanding of pertinent federal, state, and local laws, codes, and regulations regarding public safety is preferred.
Demonstrated experience developing, deploying, maintaining, and enhancing client web and mobile based applications in a Microsoft Windows/IIS/Visual Studio/SQL Server environment; ability to design debugging, testing, and performance monitoring routines.
Demonstrated application development experience using Visual Studio and the Microsoft .NET Framework; demonstrated knowledge and implementation of programming technologies including C#.NET, Entity Framework 6.x, SQL, HTML5, CSS3, JavaScript, and jQuery; demonstrated knowledge and understanding of object-oriented programming methodologies and best practices; knowledge of VBA for Access, Java, MVC, and Python is desirable.
The final candidate selected for this position must successfully pass a pre-employment criminal background check in compliance with the FBI and the California Department of Justice requirements. Periodic rechecking of criminal background history will be a condition of employment; the selected candidate can anticipate a driving record check upon hire, and approximately annually thereafter. The results of the check may determine whether the selected candidate will be permitted to drive for SANDAG business.
Benefits SANDAG offers comprehensive benefits, to include health, dental, and vision insurance as well as employee assistance, wellness, and work/life balance programs. Additionally, SANDAG offers the following:
Hybrid (Monday and Wednesday telework days; Tuesday, Thursday, and Friday in office)
9/80 flexible work schedule (every other Monday off)
Pay-for-performance merit increases
CalPERS pension plan with employer and employee contributions
Excellent health insurance options for employees and their eligible dependents
Free dental and vision insurance for employees and their eligible dependents
Education Assistance of up to $5,250 a year for regular employees
Free transit pass for use throughout the San Diego region, Rapid Express, Trolley, and COASTER
Paid time off including 12 paid holidays, 2 floating holiday days, generous paid time off (PTO) per year
Call (619) 699-1900 or visit https://www.governmentjobs.com/careers/sandag ? for information. First review July 27, 2024. EOE.
Full Time
Annual Salary Range: $96,824.00 - $150,092.80
First Review of Applications: July 27, 2024
Expected Start Date: August/September 2024
Description
The Application Developer will participate in a variety of advanced professional, analytical, and coordination support duties for programming, design, development, deployment, and maintenance of ARJIS applications technology. As the agency continues toward its goal of delivering data products in alternate formats, the ability to develop and implement innovative tools and resources, develop solutions to meet the needs of projects and customers, and participate in inter-departmental and/or cross-functional project teams will be an increasingly important aspect of the position.
The Application Developer will be detail-oriented, capable of maintaining accurate data and records, with superior quantitative analytical capabilities, organized, with effective communication skills.
Overview of the Automated Regional Justice Information System
ARJIS is recognized as a leader in the use of technologies for regional, State, and national public safety applications. ARJIS’s technology portfolio includes Software AG’s webMethods suite, Microsoft SharePoint 2010 and IIS, JBoss, Apache, ESRI GIS suite, and Microsoft SQL Server. Within these products, ARJIS uses both .net and Java to implement customer facing solutions.
The ARJIS division develops and maintains a complex, multi-agency information network that allows real-time law enforcement applications and data to be shared among 82 local, state, and federal criminal justice agencies. Averaging 50,000 transactions daily, ARJIS is used by more than 4,400 officers and investigators for tactical analysis, statistical information, crime analysis, and investigative purposes. Providing real-time shared access to information increases collaboration among law enforcement jurisdictions, improves the overall effectiveness of the regional criminal justice system, and helps to address and anticipate public safety issues to improve the quality of life for residents of the San Diego region.
Experience and Qualifications
A bachelor’s degree from an accredited college or university with major course work in computer science, information technology, or a related field. A combination of relevant education and recent work experience may be considered in lieu of the bachelor’s degree requirement.
A minimum of five years of full-time professional information technology experience preferably in a public safety environment; understanding of pertinent federal, state, and local laws, codes, and regulations regarding public safety is preferred.
Demonstrated experience developing, deploying, maintaining, and enhancing client web and mobile based applications in a Microsoft Windows/IIS/Visual Studio/SQL Server environment; ability to design debugging, testing, and performance monitoring routines.
Demonstrated application development experience using Visual Studio and the Microsoft .NET Framework; demonstrated knowledge and implementation of programming technologies including C#.NET, Entity Framework 6.x, SQL, HTML5, CSS3, JavaScript, and jQuery; demonstrated knowledge and understanding of object-oriented programming methodologies and best practices; knowledge of VBA for Access, Java, MVC, and Python is desirable.
The final candidate selected for this position must successfully pass a pre-employment criminal background check in compliance with the FBI and the California Department of Justice requirements. Periodic rechecking of criminal background history will be a condition of employment; the selected candidate can anticipate a driving record check upon hire, and approximately annually thereafter. The results of the check may determine whether the selected candidate will be permitted to drive for SANDAG business.
Benefits SANDAG offers comprehensive benefits, to include health, dental, and vision insurance as well as employee assistance, wellness, and work/life balance programs. Additionally, SANDAG offers the following:
Hybrid (Monday and Wednesday telework days; Tuesday, Thursday, and Friday in office)
9/80 flexible work schedule (every other Monday off)
Pay-for-performance merit increases
CalPERS pension plan with employer and employee contributions
Excellent health insurance options for employees and their eligible dependents
Free dental and vision insurance for employees and their eligible dependents
Education Assistance of up to $5,250 a year for regular employees
Free transit pass for use throughout the San Diego region, Rapid Express, Trolley, and COASTER
Paid time off including 12 paid holidays, 2 floating holiday days, generous paid time off (PTO) per year
Call (619) 699-1900 or visit https://www.governmentjobs.com/careers/sandag ? for information. First review July 27, 2024. EOE.