Business Analyst (HRIS)

St. Louis Community College; Bridgeton (MO); On-site; USD 70,000 - 100,000; Full time

Job summary

St. Louis Community College is seeking an experienced HRIS Banner Analyst to support Banner ERP for Human Resources/Payroll. The role involves designing, developing, and implementing processes aligned with college policies and documenting custom code.

The candidate will create SQL scripts, build HR reports, test upgrades, and troubleshoot issues, working with HRIS Banner Lead and IT Banner team to ensure data accuracy and robust reporting.

Qualifications

• Bachelor’s degree in computer science or related field or equivalent experience.
• Five or more years of relevant work experience.
• Experience with Ellucian ERP and ERP financial modules preferred.
• SQL coding and programming knowledge preferred.
• Experience with BI reporting tools (Crystal Reports, Hyperion, Cognos, Tableau, ODS) preferred.

Responsibilities

• Serve as a primary HR/Payroll IT liaison for Banner ERP functional support.
• Develop and implement Banner processes aligned with College policies.
• Create and maintain SQL scripts and HRIS reports.
• Test, document, and implement system changes and upgrades.
• Troubleshoot issues and maintain data integrity.
• Collaborate with HRIS Lead and IT Banner team on reporting standards.

Skills

SQL coding

Data analysis

BI reporting

Troubleshooting

Education

Bachelor’s Degree in Computer Science or closely related discipline

Tools

Ellucian ERP

ERP financial modules

Crystal Reports

Hyperion

Cognos

Tableau

Job description

Serves as one of the first points of contact for Human Resources/Payroll Department personnel as Banner ERP functional support. Under general direction of the HRIS Banner Lead is responsible to design, develop and implement processes and changes to components of Banner for alignment with current College policies and maintains documentation of IT created custom code for Human Resources/Payroll. Assignments may include, but are not limited to, consulting with HRIS Banner Lead and Human Resource/Payroll business unit leaders to analyze user requests, evaluate software, test and implement mandated legal, procedural and policy changes, assess technologies that integrate with information systems, create and develop SQL code, troubleshoot Enterprise and desktop level software and develop Human Resource/Payroll Department reports.

• Maintain regular communication with Human Resource/Payroll personnel for the proactive identification of areas for improvement/enhancement, assessment of the status of current projects, and monitoring the effectiveness of changes implemented. Research and advise Human Resource/Payroll personnel of possible solutions within the existing operating environment and those requiring added resources as broad options are requested and funded. Troubleshoot, analyze, detect, identify, document and correct technical problems and deficiencies.
• Design, plan, and implement processes that assure data integrity and accuracy. Develop and evaluate test plans for new system implementations and upgrades in collaboration with HRIS Banner Lead and Information Technology Banner team to include both short and long-term timelines.
• Review, evaluate, and test internally developed, and vendor supplied application system upgrades and patches assuring functionality that meets user needs. Maintain documentation as a permanent record maximizing maintainability of systems.
• Investigate system problems using functional and technical expertise. Document problems, determine source, and actions taken to resolve.
• Create and maintain system configuration and functionality documentation as a permanent record to maximize system maintainability.
• Responsible for the development of reports, scripts, and queries for the retrieval and presentation of data. Author Business Intelligence reports, using specialized systems expertise and programs to generate special reports and summaries. Analyze data and data requirements regarding reporting solutions; ensure data quality and match report results back to core systems transaction results. Maintain documentation of reporting solutions, data mapping, data dictionary and other standards. Coordinate end user review and acceptance of developed reports. Resolve production report issues and respond quickly to priority data and report requests.
• Work with other business analytic team members, along with the HRIS Lead, to maintain reporting standards and protocols.
• Contribute to and participate in district-wide committees and user groups.
• Participate in learning opportunities, conferences, and seminars to improve functional and technical skills.
• Manage tickets that are submitted via the help desk ticketing system as it pertains to user access etc.
• Perform other job-related duties as assigned.

• Bachelor’s Degree in computer science or closely related discipline or equivalent work experience and education/training providing similar knowledge and skills is necessary.
• Five (5) or more years of progressively responsible relevant experience. Certification in systems and applications to be supported may be considered an equivalency for experience requirements.
• Experience with Ellucian ERP system is preferred.
• Experience with ERP system financial modules is preferred.
• Experience with SQL coding, and knowledge of programming/operating languages(s) is preferred.
• Experience with Business Intelligence report writing tools (i.e. Crystal Reports, Hyperion, Cognos, Tableau, ODS). Experience with data analysis is preferred.

• May be on call during non-working hours.
• Occasional travel within the district or to outside locations.

Physical Requirements:

• Negligible