Enterprise Systems Analyst

University of Detroit Mercy; Detroit (MI); Hybrid; USD 65,000 - 75,000; Full time

Benefits offered by this job

Medical plans

Dental plan option

Vision benefits

Tuition remission

Retirement plan

Disability insurance

Life insurance

Job summary

University of Detroit Mercy seeks an Enterprise Systems Analyst to analyze, develop, test, and maintain software and interfaces that enhance the Ellucian Banner ERP system and related third-party solutions. You will define business requirements, manage data and reporting, create Oracle procedures and packages, and support the Banner system while ensuring data integrity and user satisfaction.

The role is primarily on the McNichols campus with partial work-from-home opportunities; salary range is

Qualifications

• Experience with Ellucian Banner software, report-writing tools, and other database solutions.
• Minimum of three years related experience; relational databases, advanced SQL programming skills, and BI tools; experience with Banner, Oracle procedures and packages, Argos, and ISE Enterprise.

Responsibilities

• Define business requirements and develop business solutions; consult with the user community and external entities to define business requirements; create and document technical strategies to support the development of solutions in support of the University’s enterprise system.
• Data management and reporting through the development of data sets and report on University data.
• Create and maintain Oracle procedures and packages, as well as job scheduling.
• Gather requirements and create/maintain crosswalks to bridge data from other sources to current reporting systems.
• Ensure data integrity; diagnose system and data issues.
• Provide functional and technical support for the Banner ERP system and third‑party applications.
• Perform other duties as assigned or requested.

Skills

Ellucian Banner

SQL programming

Data management

Business intelligence

Communication skills

Education

Bachelor's degree in related field

Tools

Oracle procedures

Argos

ISE Enterprise

Banner

Job scheduling

Job description

The Enterprise Systems Analystis responsible for the analysis, development, programming, testing, and maintenance of software and interfaces that enhance the University’s Ellucian Banner ERP system and third‑party solutions. The overall support for the ERP includes assessing complex issues, creating and maintaining reports, evaluating business processes and rules, and providing technical assistance to the user community.

Essential Duties and Responsibilities

• Define business requirements and develop business solutions; consult with the user community and external entities to define business requirements; create and document technical strategies to support the development of solutions in support of the University’s enterprise system.
• Data management and reporting through the development of data sets and report on University data.
• Create and maintain Oracle procedures and packages, as well as job scheduling.
• Gather requirements and create/maintain crosswalks to bridge data from other sources to current reporting systems.
• Ensure data integrity; diagnose system and data issues.
• Provide functional and technical support for the Banner ERP system and third‑party applications.
• Perform other duties as assigned or requested.

Minimum Qualifications

Education – A college degree or four to eight years of work experience in a related field.

Employment - Two years to five years (Equivalent combination of education and employment).

Preferred Qualifications

• Ability to work in a fast‑paced environment with changing priorities amongst a collaborative team.
• Prior professional IT experience in a Higher Education environment.
• Goal‑oriented with strong initiative, imagination, and organizational qualities.

Knowledge, Skills, and Abilities

• Experience with Ellucian Banner software, report‑writing tools, and other database solutions.
• Excellent verbal and written communication skills including customer service and an ability to express oneself in an open, honest, and professional manner.
• Minimum of three years related experience; relational databases, advanced SQL programming skills, and business intelligence tools; experience with Banner, Oracle procedures and packages, Argos, and ISE Enterprise SCHEDULE preferred.
• Proficiency with Microsoft Office Suite with the ability to learn and apply new software and strive to consistently achieve excellence in all tasks and goals.

Physical Requirements

Job may require lifting light weight objects (1 to 10 pounds) with no repetitive bending or stooping. Occasionally lift average weight objects (1 to 10 pounds).

Regular exposure to favorable conditions such as those found in a normal office.

$65K to $75K Annually

Anticipated Schedule

Position is primarily on the McNichols campus with partial work‑from‑home opportunities. Work schedule: Monday – Friday 8:30 AM – 5:00 PM

Benefits Summary

At the University of Detroit Mercy we continually strive to provide a high‑quality, comprehensive benefits package to our valued employees. We offer our employees the following:

Medical

• Three health plans to choose from with a large national provider network
• Option to purchase additional dental plan through Sun Life
• Dental Care is available at the School of Dentistry to the employee, the employee's spouse or legally domiciled adult and dependents (dependents shall be as defined for Internal Revenue Service purposes).
• The fee for such services shall be waived for the employee, the employee's spouse or legally domiciled adult and dependents, up to a cap of $3,000 per individual per calendar year. Beyond the $3,000 cap amount, employees will be responsible to pay 25% of any remaining fees for the balance of that year.

Vision

• Option to purchase additional vision plan through Heritage
• Vision benefits available at Detroit Mercy Eye Institute
  • $35 Comprehensive Eye Exam
  • Contact Lens Exam starting at $70
  • 50% off Optical Frames
  • 25% off Sun Frames
  • 30% off Prescription Lenses
  • 20% off Prescription Contact Lenses
  • *Cannot be combined with insurance*

Health Savings Account and Flexible Spending Account options

Employee Assistance Program

• Provided to everyone in your household

Short-Term and Long-Term Disability

Life and AD&D

• One times base salary up to a hundred thousand dollars

Option to purchase additional life insurance, accident insurance, and/or critical illness insurance

Tuition Remission Benefit for you, your spouse, and children

Retirement Plan

• Employees have a choice of the following: Employees who contribute 3% shall receive an Employer contribution of 6%, and employees who contribute 4% in the plan shall receive an Employer contribution of 8%.

Michigan's largest, most comprehensive private University, University of Detroit Mercy is an independent Catholic institution of higher education sponsored by the Sisters of Mercy and Society of Jesus. Detroit Mercy seeks qualified candidates who will contribute to the University's mission, diversity, and excellence of its academic community. University of Detroit Mercy is an Equal Opportunity Afffirmative Action Employer with a diverse student body and welcomes persons of all backgrounds.

Pay Range

Commensurate with experience

undefined

EEO is the Law