Description
We are seeking an enthusiastic Jr. Programmer/Analyst to provide
Tier I/II technical support assisting users with various Banner ERP
needs and report writing. This position is required to assist in
writing, testing, maintaining, and supporting PL/SQL scripts in
Windows, Linux, and MacOS operating systems. The successful
candidate will have experience in application development using
current, industry-standard technologies. This role requires an
individual with proficient communication and people skills coupled
with technical understanding of the software development lifecycle.
Working with the technical staff and functional/business units is
essential.
Examples of Duties
- Create SQL query statements to satisfy user requests for
reporting.
- Prepare data for job runs.
- Support existing jobs or query request.
- Design Argos Datablocks for reporting.
- Collaborate with stakeholders to gather reporting requirements
and translate them into technical specifications.
Extract, clean, and analyze data from multiple sources
including SQL databases, ERP systems, and CSV files.
Monitor data quality and troubleshoot reporting issues as they
arise.
Provide training and support to end-users on self-service
reporting tools.
Troubleshoot, analyze, and change user requests for reporting
purposes.
Develop and/or enhance standard operating procedures.
Ability to demonstrate the learning capability to cope with
fast-paced development.
Write ad-hoc SQL queries to support data analysis.
Ability to prioritize and multitask.
Experience optimizing report performance.
Problem solve Banner module issues.
Linux server tasks
Perform other duties as assigned.
Typical Qualifications
- Bachelor’s degree in computer science or related field. May
substitute the equivalent in a combination of education, technical
certifications or training, or work experience.
- One or more years of significant and relevant systems
administration experience.
- Solid foundational knowledge of Structured Query Language
(SQL)
- 3+ years’ experience with database languages Transact SQL
(T-SQL), Procedural Language (PL)/SQL and related
technologies.
- 1+ years of experience in Relational database concepts,
relational logical modeling, best practices, and/or physical
design.
- Design and evaluate methods or scripts to address Banner user
requests.
- Understand industry standard best practices for Software
Development Life Cycle (SDLC)
Supplemental Information
- Unit Test and SQL Query optimization
- Experience with Argos reporting tool.
- Use of Toad Software
- Banner 9 modules
- Linux commands
- Reporting tool experience is a plus.
- Ability to prioritize and multitask.
- Deadline driven and meticulous.
- Current CompTIA, Microsoft, or other industry related
certification
- Excellent written and verbal communication
- Excellent customer service skills