Jr. Programmer/ Analyst

About the Department

Position 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.
• 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.

Minimum 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)
• 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)

Other Qualifications

• 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
• 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