Jr. Programmer/ Analyst
Company:
Hampton University
Job Location:
Category:
Network/System Administrator
Type:
Full-Time
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
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)
- 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
