Oberlin College's Center for Information Technology (CIT) is seeking an IT Business Analyst / Applications Developer to help advance educational technology, manage ERP systems, lead implementations, and migrate to cloud products. The role will focus on current and future state business process mapping and improvements, cloud systems migration, production support, system configuration, troubleshooting, security administration, integration, and interfaces with third-party systems.
Requirements
- Minimum 3-year experience with ERP
- Proficiency in SQL, PL/SQL, and database concepts.
- Ability to utilize APIs for data extraction, transformation, and loading (ETL).
- Web service integrations, RESTful and SOAP APIs, as well as authentication mechanisms.
- Skills in data mapping, transformation, and manipulation to ensure compatibility between ERP system and integrations.
- Familiarity with data formats like XML, JSON, CSV, and tools like XSLT, JSON, and other scripting languages for data transformation.
- Thoroughness in testing integrations to ensure accuracy, data integrity, and compliance with regulatory requirements.
Responsibilities
- This role serves functional areas and assists subject matter experts with ensuring data integrity, testing of system changes, and analyzing data flows for data management improvement opportunities and client support.
- The role also assists with system upgrades, patches, testing and other technical projects as assigned and serves as a backup for daily operations, administration, and maintenance of the ERP system.
- Works at the highest technical level of various phases of systems analysis.
- Provide technical support for the College’s Third-party systems and the ERP system as needed.
- Develop practical reporting tools for the business departments.
- Carry out complex and multi-level tasks from start to finish.
- Ability to understand business process, analyze technology consult vendors and other higher ed institutions, and apply best practices to design effective solutions.
Other
- This position 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.
- The incumbent may be part of an on-call rotation and may be expected to work on some weekends.
- This position is on-site, 5 days per week.
- Must possess an aptitude for patience, professionalism, tactfulness, and empathy.
