Data Analyst & Software Developer - Undergraduate Admissions (S743)
The primary function of this position is to assist with design, implementation, configuration, testing, and maintenance of the Office of Undergraduate Admissions’ two most important data systems: Oracle’s PeopleSoft Recruiting and Admissions module and a Salesforce hosted Student Recruitment CRM. Secondary functions include, but are not limited to, report writing, data analysis, and end-user support.
This position works closely with Enterprise Data Management (EDM), Information & Media Technology (IMT), multiple Enrollment Services offices, and other data administrators on campus to assist in advancing the undergraduate enrollment goals of the university. This position requires a highly skilled individual with a strong technical background, solid work ethic, and the ability to manage multiple projects at once.
- Bachelor’s degree in Computer Science, Management Information Systems or closely related field.
- 3-5 years of experience configuring and managing data systems required, preferably in an admissions environment.
- Knowledge of IT systems in general and experience troubleshooting basic client and system issues required.
- 1-3 years of experience testing and developing new functionality and system upgrades preferred.
- 1-3 years of experience in reporting and data analysis preferred.
- 1-3 years of experience working with PeopleSoft and Salesforce preferred.
- SQL experience in an Oracle Server environment preferred.
Primary Duties/Essential Functions
- Serve as the primary liaison between the Office of Undergraduate Admissions and the Office of Information and Media Technology (IMT).
- Partner with the Director of Admissions to identify, prioritize, coordinate and create system and process improvements that will increase the effectiveness and efficiency of the Office of Undergraduate Admissions.
- Collaborate with Enterprise Data Management (EDM) to provide configuration and ongoing maintenance of the PeopleSoft Recruiting and Admissions module, as well as periodic testing of patch and bundle updates.
- Collaborate with EDM to design, develop, test and implement new functionality within the Salesforce Student Recruitment CRM through the university-standard release-to-Production process.
- Develop and manage reports using PeopleSoft Query and Salesforce to be used for a wide variety of functions, including but not limited to communication generation, checklist assignment, and internal/external analysis.
- Partner with the Director of Admissions to assist in the creation, maintenance and coordination of data file import and export processes for exchanging data between the Office of Undergraduate Admissions, external vendors, and other departments on campus.
- Partner with IMT and the Director of Admissions to identify and quickly resolve system outages that threaten existing workflow and communication protocols.
- Provide end-user training and maintain training documentation for the proper usage and functionality of the PeopleSoft Recruiting and Admissions module and the Salesforce Student Recruitment CRM.
- Attend conferences, webinars, and training sessions as appropriate and approved by the Director of Admissions in an effort to continually enhance the effectiveness and efficiency of UG Admissions systems and processes.
- Partner with the Director of Admissions to ensure that data needs and system integrations remain accurate through transitions in application cycles and academic years.
- Perform and manage other assignments as determined by the Director of Admissions.
- Ability to identify, analyze, troubleshoot and solve complex technical and functional problems.
- Ability to quickly learn new technical skills and identify available resources to assist in that learning.
- Ability to work quickly and efficiently in designing and implementing technical solutions.
- Ability to identify end-user needs and translate them into functional designs.
- Ability to clearly articulate and explain business processes and concepts.
- Ability to define problems, collect data, establish facts, and draw valid conclusions.
- Ability to communicate effectively with internal and external constituents, both verbally and in writing.
- Ability to prioritize, organize and manage multiple tasks and projects at once in a deadline-oriented environment.
- Ability to work independently, as well as in a team environment with high levels of collaboration.
- Ability to maintain a positive attitude and mature demeanor, while quickly adapting to changing requirements.
- Ability to be accurate and precise, with strong attention to detail on many steps of a complex processes.
- Ability to organized and keep large amounts of confidential information.
- Ability to exercise good judgment and discretionary skills in determining when to act independently and when to consult management prior to taking action.
- Ability to maintain harmonious work relationships with staff, students, faculty and external constituents.
- In agreement with the purpose and goals of Azusa Pacific University in providing a Christian-based higher education for its students.
- Sitting for extended periods of time.
- Intermittent sitting, standing and walking.
- Computer usage for extended periods of time.
- Hearing and speaking in person and on the telephone
- Repetitive arm/wrist/finger motions with use of a computer.
- Able to conduct business at other offices on campus.
- Ability to lift, pull, bend, grasp and occasionally lift up to 20 lbs.
- Ability to reach top of four-drawer file cabinet or stoop to reach bottom drawer of four-drawer file cabinet.
- Looking at a computer monitor for extended periods of time.
- Reading/viewing instructions, documentation, and printed application materials in both physical and digital formats.
- Pleasant office, comfortable temperature.
The following technologies are typical of the context within which the Data Analyst & Software Developer will work, though this is not intended to be an exhaustive list. As such, the Data Analyst & Software Developer must have experience with, or be able to adapt quickly to these types of technologies.
- Oracle/PeopleSoft for Higher Education (Campus Solutions).
- Programming languages such as APEX, Java, Visual Basic, etc.
- Reporting tools such as SQL, PS Query, XML Publisher, etc.
- Productivity tools such as Microsoft Office and/or Google Docs.
- Email tools such as Microsoft Outlook and/or Gmail.
Azusa Pacific University will conduct a background check on all final candidates.Review of applications will begin immediately, and the position will remain open until filled unless otherwise stated. Azusa Pacific University does not discriminate on the basis of race, color, national origin, sex, age, disability, or status as a veteran in any of its policies, practices, or procedures. Women and minorities are encouraged to apply.