Student Data & SQL Reporting Assistant

UF/IFAS - School of Natural Resources and Environment; Gainesville (FL); On-site; USD 25,000 - 28,000; Part time

Job summary

UF/IFAS - School of Natural Resources and Environment seeks a student to analyze and query a complex relational database using SQL. You will learn and apply SSMS to build reusable reporting queries and document their purpose and usage.

The role includes assisting with digital accessibility tasks and web-content support, with a focus on accurate data handling and clear technical documentation. Gainesville, FL on-site position.

Qualifications

• Current UF undergraduate or graduate student.
• Coursework or practical experience with SQL and relational databases.
• Ability to write SQL queries for a complex, multi-table relational database.
• Familiarity with relational database concepts, including tables, primary and foreign keys, joins, filtering, grouping, and aggregate functions.
• Strong general computer and information-technology skills.
• Ability and willingness to learn unfamiliar software platforms and technical systems.
• Strong analytical and problem-solving skills.
• Strong attention to detail.
• Ability to work independently and clearly document technical work.

Responsibilities

• Review and understand the structure and relations of the existing database.
• Use SSMS to access, review, and query database information.
• Develop SQL queries involving multiple related tables, joins, filters, aggregations, and other database operations.
• Create reusable queries for recurring monthly, annual, and ad hoc reporting needs.
• Develop queries to retrieve and summarize historical information over specified date ranges.
• Assist with retrieving historical information regarding distribution of program materials and other program activities.
• Validate query results against available tracking records and known historical information.
• Troubleshoot discrepancies and identify potential data-quality or database-structure issues.
• Organize SQL queries into a documented query library that can be readily used or modified by T2 staff.
• Clearly document the purpose, parameters, output, and appropriate use of each query.
• Meet with T2 staff to understand reporting requirements and demonstrate how queries should be run.
• Document accessibility remediation procedures so common issues can be addressed consistently in future materials.

Skills

SQL queries

Relational databases

Analytical skills

Detail oriented

Independent work

Learning ability

IT skills

Education

UF undergraduate or graduate student

Tools

SSMS

WordPress

Moodle

Excel

Power BI

Job description

UF/IFAS - School of Natural Resources and Environment seeks a student to analyze and query a complex relational database using SQL. You will learn and apply SSMS to build reusable reporting queries and document their purpose and usage.

The role includes assisting with digital accessibility tasks and web-content support, with a focus on accurate data handling and clear technical documentation. Gainesville, FL on-site position.