Jr. Programmer/ Analyst
- Hampton, VA, United States
Applications open in a new tab.
Job details
- Posting language
- English
- Posted
Original job description
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
Benefits
We offer a complete benefits package to full-time employees and part-time employees who regularly work 20 hours or more per week including health care, dental, vision, retirement, life insurance, short-term disability, long-term disability, legal insurance, accident, critical illness, hospitalization, tuition remission, holidays, vacation, and sick leave.
To learn more details, visit our website: https://home.hamptonu.edu/hr/benefits/.
More about this job
Skills
- SQL
- Reporting
- Normalise data
- Negotiate with stakeholders
- ERP
- Troubleshoot
- Provide training
- Data analysis
- Multitask
- Linux
- Computer science
- System administration
- Transact-SQL
- Software development
- Communication skills
- Customer service