Jr. Programmer/ Analyst

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.

• 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