Production Support Analyst
Full Time
Customer Service
United States
Respond to inquiries and requests related to retirement systems and production processing of participant and client data. Analyze and work on system issues, database corrections, database updates/conversions, system testing and requirements, and report design for Operations departments. Consider financial impact and risk to participants, clients, and business units in all aspects of day-to-day work.
Responsibilities
- Research and resolve basic system issues that occur during production data loads.
- Create and process queries from multiple system tables.
- Act as a liaison between business units and IT groups to correct and/or report system issues; create intake tickets (JIRA) with appropriate documentation.
- Perform production table updates, inserts, and deletions using DB2 SQL and Microsoft SQL Server; maintain integrity and accuracy of data on multiple databases/systems.
- Troubleshoot application/process issues to help identify the “root” cause and impact to stakeholders.
- Interpret and communicate information to end users, management, and development/systems staff.
- Learn and understand data structures within various system databases.
- Provide data to various business units for mass mailings.
- Assist in testing system changes for usability, performance, and adherence to standards.
- Collaborate with peers to ensure work items are completed within set timing standards as determined by priority level.
Qualifications
- Bachelor’s degree in a business or IT field, or equivalent education/experience
- Technical aptitude to work with mainframe (Paris), Linux, DB2 SQL, MS SQL Server, etc.
- Analytical and problem-solving skills
- Written and oral communication skills
- Organizational skills and attention to detail
- Proficiency using MS Office (Excel, Word, SharePoint, Access)
Preferred Qualifications
- Knowledge of AWD, Linux, DB2 SQL, and Microsoft SQL Server.
- Pension, accounting and/or technical experience
- Knowledge of retirement operations processes
Working Conditions
- Hybrid environment
- Rotate on call for nightly batch systems support after completion of training
This job description is not a contract of employment nor for any specific job responsibilities. The Company may change, add to, remove, or revoke the terms of this job description at its discretion. Managers may assign other duties and responsibilities as needed. In the event an employee or applicant requests or requires an accommodation in order to perform job functions, the applicable HR Business Partner should be contacted to evaluate the accommodation request.