JOB SUMMARY

The Office of Undergraduate Admissions (OUA) is seeking an enthusiastic, tech savvy, self-starter to fill an immediate opening for a Business Systems Analyst Senior (BSA) position. This position will assist with the implementation of new technologies such as CRM as well as analysis of data, business processes and systems across the department.
Reporting to the Senior Associate Director of Systems and Research, the Business Systems Analyst will perform complex statistical analyses of data reported in the various information systems with a primary focus on the student data sets. This position will also design and create data visualizations that have an intuitive interface and are easy to understand.

WHO WE ARE

The University of Michigan is a premier public research university with more than 52,850 students, including 34,454 undergraduates, and is firmly committed to serving the people of Michigan and the world through preeminence in creating, communicating, preserving and applying knowledge, art, and academic value. U-M is in high demand, with a record of 105,142 undergraduate first-year and transfer applicants in fall 2024 and 8,850 incoming undergraduate students enrolling.
Reporting to the Provost and Executive Vice President for Academic Affairs, the Office of Enrollment Management (OEM) manages U-M’s enrollment function to efficiently optimize students’ experiences throughout their engagement, from prospect to alumni. The division collaborates with campus partners, faculty, and staff in support of the university’s mission.
OEM comprises a dedicated team of more than 200 full-time staff members and up to 400 additional student and temporary staff and is structured in five operational units - the Office of Undergraduate Admissions, the Office of Financial Aid, the Office of New Student Programs, the Office of the Registrar, and OEM Administration. OEM strives to provide excellence in access and support to inspiring learners who will challenge the present and enrich the future

REQUIRED QUALIFICATIONS*

• Bachelor’s degree in Business, Computer Science/Math, Information Systems or other related field
• Five years of experience in a related field
• Demonstrated skills in business systems analysis, requirements gathering, design, and system testing. Ability to learn new software and communicate clearly with others.
• Strong understanding of database reporting, database structure, data mapping, data management, data manipulation, and data mining techniques.
• High level of proficiency with Microsoft Access and Excel. Working knowledge of statistical software SPSS.
• Strong SQL querying skills and reporting software
• Ability to identify process improvements and suggest solutions with confidential data.
• Demonstrated ability to meet deadlines and respond to requests promptly.
• Strong interpersonal, communication, and customer service skills.
• Demonstrates strong motivation and ability to learn, continuing to keep up with new developments in data processing and admissions business processes.

DESIRED QUALIFICATIONS*

• An understanding of student data and reporting functions in an admissions environment.
• Experience with Oracle/PeopleSoft Student systems. Working experience with a combination of PeopleSoft Query, Business Objects, and Tableau
• Experience with SQL Developer
• Understanding of the technologies and languages that power the web, such as HTML, JavaScript.

RESPONSIBILITIES*

• Designs, programs, tests and assists in the implementation of new CRM - including production and end-user support, process analysis, documentation, evaluation and maintenance aspects.
• Analyzes business and user needs, document requirements and translate into system requirement specifications.
• Develops and executes test plans to ensure that a product or system meets design specifications, security, and other requirements.
• Creates ad hoc queries for data requests and special projects focusing primarily on recruitment and admissions, third-week count and student data. Develops data visualizations of institutional data using Tableau and other tools as needed
• Enhances existing applications by utilizing a thorough knowledge of the OUA mission, current business processes, knowledge of data and reporting requirements. Increases operating efficiency and adapt existing systems to new requirements. Develops and/enhances policies and procedures for reporting.
• Provides and interprets admissions data; responds to regular and ad-hoc data reporting requests.
• Maintains, prioritizes and coordinates project activities focused on automation.
• Provides technical documentation for all new programs and modifications.
• Provide systems, data and reporting support for OUA staff and other university departments as directed.
• Assists with special projects for OUA, Office of Enrollment Management, academic units, and other University offices requesting assistance with data and reporting. Contributes ideas and assists with problem solving.
• Other duties as assigned.

In addition to a career filled with purpose and opportunity, The University of Michigan offers a comprehensive benefits package to help you stay well, protect yourself and your family and plan for a secure future. Benefits include:

• Generous time off
• A retirement plan that provides two-for-one matching contributions with immediate vesting
• Many choices for comprehensive health insurance
• Life insurance
• Long-term disability coverage
• Flexible spending accounts for healthcare and dependent care expense