A cover letter is required for consideration for this position and should be attached as the first page of your resume. The cover letter should address your specific interest in the position and outline skills and experience that directly relate to this position.
We elevate the student experience by working with Student Life and campus partners to provide innovative and creative technology solutions. Student Life Technology Solutions has a strong focus on developing relationships with Student Life units, understanding the units’ work, and providing tailored solutions while seeking economies of scale where it makes sense. Functional areas include Operations and Infrastructure, Web and Applications, Project management, and Business Intelligence.
Student Life Technology Solutions is seeking an enthusiastic and qualified Applications Programmer/Analyst to develop into the lead role in the support of systems that provide Access Control, Meal Plans, Stored Value and integrated Point of Sale (POS). You will be the subject matter expert on these systems and their integration across campus and vendors partners. You will use deep technical and procedural knowledge along with analytical skills to triage, investigate, and solve problems, as well as manage new initiatives leveraging these systems. You will continuously seek opportunities to improve system operations and the generation of business value through developing business reporting, performing system tuning, and regularly evaluating the products in this space.
45% - Application & Database Management
Assist with administering assigned systems and interfaces working with vendors and other University partners to resolve technical problems, ensure stability, and maintain availability according to business needs and service level agreements.
Routinely monitor and review automated processes to evaluate and maintain system operation.
Assist with managing the implementation and operation of interfaces, including: Simphony and CBORD CS Gold, CBORD Get and CS Gold, CS Gold and PeopleSoft, Campus Card System and CS Gold, CS Gold and CCURE, CS Gold and Odyssey HMS, working with vendors and internal team members as required.
Troubleshoot technical issues, including monitoring and responding to all CS Gold Systems and Simphony-related issues and facilitating the resolution of complicated support issues that are escalated to engage service providers and other University partners.
Serve as the vendor liaison, including timely synthesis of vendor communications and developments, impact analysis, and appropriate communication of critical information and service disruptions.
Manage, create, and edit financial account plans, user groups, permissions and security roles.
Assist business partners with preparing and executing upgrades of systems and integrations, as well as providing training on system configurations.
Assist with coordinating and managing patching, data trimming, health reviews, and refreshes of system environments with remote database administrator (RDBA).
Assist with coordination of application patching, system upgrades, technical reviews, and maintenance.
Develop, support, & maintain business processes around systems.
40% - Data integration & Support
Become the Subject Matter Expert (SME) for CS Gold & Simphony Data Structures for data management, integration with production systems, and enterprise data warehouse
Assist with managing and executing highly complex and specialized projects such as developing system interfaces and automated nightly jobs.
Utilize Oracle SQL and Crystal Reports (or similar product) to write custom scripts, imports, and reports for system automation and analysis.
Develop, support, and maintain required scheduled and ad hoc system reports.
Respond to and manage support requests from business partners leveraging system reporting capabilities
Develop, test and implement new business processes for multiple business units utilizing application systems, scripting, BAT files, PERL, SQL and other tools.
15% - Project Planning & Implementation
Assist with the development of ongoing system and hardware replacement plans, in partnership with business owners and other team members.
Contribute to system enhancements by identifying and quantifying customer requirements, delineating the gaps between business requirements and the capabilities of existing systems.
Recommend improvements to current business processes.
Analyze and document relevant technical, project, and applications management processes.
Prioritize projects/tasks and communicate priorities to constituents.
Bachelor's degree in computer science, a related field or equivalent experience
Minimum 1 year systems analysis/programming activities in a business environment
Previous experience in an application or database management support role
Previous experience training multiple constituencies in software, applications, or reporting tools
Bachelor’s degree in computer science, information technology or a related field, or an equivalent combination of education, certification, and experience.
Previous experience administering Campus ID card, meal plans, declining balance programs, and access control systems and related technologies.
Previous experience, knowledge, and certifications with CS Gold, WebManager or other card systems is highly desired.
Previous experience with Simphony.
Previous experience with Oracle SQL scripting (or similar), SAP Crystal Reports (or similar), databases, spreadsheets, or other scripting languages (e.g. Python/Perl) to generate standardized reports.
1-3 years of experience in an application or database management support role.
1-3 years of experience with point of sale systems or equivalent enterprise applications.
Demonstrated ability to build SQL scripts and queries for data analysis and extraction.
Demonstrated ability to analyze and understand unfamiliar business processes and perform root cause analysis to identify problems and opportunities.
Demonstrated ability to build and maintain complex reports using tools like Crystal Reports.
Demonstrated ability to meet deadlines, handle and prioritize simultaneous requests, and manage laterally and upwards.
Demonstrated ability to work with a high level of independence and to take initiative while remaining a strong team player.
Demonstrated ability to communicate and distill technical concepts into simple language.
Demonstrated ability to critically evaluate information gathered from multiple sources, reconcile conflicts, decompose high-level information into details, abstract up from low-level information to a general understanding, and distinguish user requests from the underlying true user needs.
Please note: Relocation will not be offered for this position.
This role my have reporting obligations until Title IX and Clery.
These are the criteria that the hiring team will be evaluating the candidate for:
Asks the right questions to accurately analyze situations.
Acquires data from multiple and diverse sources when solving problems.
Uncovers root causes to difficult problems.
Evaluates pros and cons, risks and benefits of different solution options.
Works cooperatively with others across the organization to achieve shared objectives.
Represents own interests while being fair to others and their areas.
Partners with others to get work done.
Gains trust and support of others.
Follows through on commitments.
Is seen as direct and truthful.
Practices what he/she preaches.
Shows consistency between words and actions.
Picks up on situational cues and adjusts in the moment.
Readily adapts personal, interpersonal, and leadership behavior.
Understands that different situations may call for different approaches.
Can act differently depending on the circumstances.
Creative Problem Solving / Strategic Thinking
Demonstrated ability to use creative thinking to improve processes and solve complex problems.
Demonstrated ability to provide necessary attention to solve different level problems, often multitasking to solve moderate level problems
Defines problems, analyzes causes, identifies possible solutions, recommends the best solution and develops action plans.
Demonstrates an ability to communicate clearly, correctly, knowledgeably and effectively via email and in person to teams and customers
Uses appropriate methods of communication (face-to-face, etc.) to achieve desired results
Demonstrates an ability to communicate about complex topics effectively to groups, using visual aids as needed, varying style to fit the audience
Actively communicates with those with differing opinions and differing levels of understanding
Demonstrates an unwavering focus on aligning all activities to produce maximum value for the customer
Demonstrates a focus on fulfilling expectations by seeking insight into customer needs and developing solutions that provide value for the customer
The University of Michigan seeks to recruit and retain a diverse workforce as a reflection of our commitment to serve the diverse people of Michigan, to maintain the excellence of the University and to offer our students richly varied disciplines, perspectives and ways of knowing and learning.
Note: This position may require after hours and weekend support as part of an on-call rotation, with occasional work outside of normal business hours for planned upgrades and best-effort response to major outages.
The University of Michigan is an equal opportunity/affirmative action employer.
Internal Number: 172663
About University of Michigan - Ann Arbor
A great university is made so by its faculty and staff, and Michigan is recognized as one of the best universities to work for in the country. The Michigan culture is known for engaging faculty and staff in all facets of the university to create a workplace that is vibrant and stimulating.For two consecutive years, the Chronicle of Higher Education has placed U-M in its "Great Colleges to Work For" survey. In particular, the university earns high marks for strong relations between faculty and administrators, a collaborative system of governance, strong pay and benefits, and a healthy work/life balance.