IT Analyst (Software Analyst) (Multiple Positions)- College Of Social Work

The University of Tennessee, Knoxville
Knoxville, TN

View more

Administrative Jobs
Technology, Analysts & Programming
Employment Type
Full Time
Institution Type
Four-Year Institution

Job Details

IT Administrator/Analyst II 
The University of Tennessee Knoxville, College of Social Work, through the Social Work Office of Research and Public Service (SWORPS) is accepting applications for an IT Administrator/Analyst II—IT Database Administrator. This position will independently work with State government and other grantors to design and implement solutions as part of SWORPS’ application development team.  While the position will focus on advanced SQL Server database administration, the candidate will also design, code, test, implement, and support web-based database applications, data reporting, business analytics and other technological solutions.  This position meets with internal and external customers to create product specifications, implement solutions, and maintain customer relationships.  Other duties as required.

Job Functions/Responsibilities:

Database administration and reporting

  • Independently develop and maintain databases using Microsoft SQL Server, mySQL, and other products
  • Perform advanced database administration for existing enterprise-level database products
  • Assess data security needs and protect data integrity, privacy, and security
  • Create database designs, stored procedures, diagrams, and scripts
  • Work with system administration to provide and protect database environments
  • Create reports, data extracts, visualizations, and dashboard-style data presentations
  • Document database products and create data dictionaries
  • Query writing, report writing
Software and Application Support

    Develop and maintain web based database applications using Microsoft SQL Server, Microsoft and PHP as part of a development team.Implement and maintain version contraolCreate reports, data extracts, visualizations, and dashboard-style data for use in ASP.Net applications.Work closely with development team, system administrator, and project managers to fulfill database and data needs
Position Requirements:   

Bachelor's Degree

Senior-level database administration skills.  Senior, expert-level ability with Microsoft SQL Server.  Strong Microsoft ASP.NET and SQL Server skills.  Strong knowledge of PHP programming.  Advanced reporting skills, including Microsoft SQL Server Reporting Services.  Extensive knowledge of database administration, stored procedures, scripting, dashboard reporting and data visualization.  Strong demonstrable knowledge of data privacy and security regulations.  Ability to work independently in a team environment and collaborate effectively in a fast paced development environment.  Ability to communicate effectively in English.

Preferred requirements:

Demonstrated knowledge of Tableau, Telerik, and/or other reporting and analytics tools.  Ability to design dashboard type reporting products and data visualizations using a variety of products, including ArcGIS and other mapping technologies.  Ability to use analytic techniques for work with data.  Knowledge of cybersecurity assessment techniques, NIST 800 series requirements, and product documentation techniques.  Proven skill with full life cycle product development and database administration.

Job: Information Technology Professional
Primary Location: US-Tennessee-knoxville
Organization: Social Work Research & Pub Svc
Schedule: Full-time
Job Posting: Dec 20, 2022, 4:30:26 PM


Working at The University of Tennessee, Knoxville

Founded in 1794, the University of Tennessee is one of the nation’s oldest and most storied public universities. Based in Knoxville, Tennessee’s flagship land-grant institution includes the statewide Institute of Agriculture and the Space Institute in Tullahoma. The university embodies excellence in teaching, discovery, scholarship, research, creative activity, outreach, and engagement. Known as the Volunteers, we lead with a spirit of selflessness, empathy, and courage, and strive to be champions for diversity, equity, and inclusion

UT Knoxville is a Research 1 university with 11 academic colleges and more than 900 programs of study. With an enrollment of more than 30,000 students, our academic programs are repeatedly ranked top in their class. The university co-manages Oak Ridge National Laboratory, the country’s most prominent national lab, driving innovation in advanced manufacturing and materials, national security, and more. We are closely connected with our communities through outreach and extension efforts across Tennessee and through partnerships with non-profits, corporations, and industries—regionally, nationally, and around the globe.

The city of Knoxville is nestled in the foothills of the Great Smoky Mountains. The modern, thriving community is surrounded by gorgeous lakes and hundreds of miles of walking, hiking, and biking trails. Situated along the banks of the Tennessee River, our beautiful features an eclectic music scene, internationally recognized festivals, unique restaurants, and a robust offering of diverse cultural activities. Knoxville is located within a day’s drive of Atlanta, Nashville, Asheville, Charlotte, Louisville, Cincinnati, Memphis, Chicago, and Washington D.C.

Knoxville and the surrounding counties have a population of more than 850,000 people. The region houses many leading corporations and organizations, including Oak Ridge National Laboratory, Pilot/Flying J, the Tennessee Valley Authority, and Regal Cinemas, along with HGTV, Food Network, and other networks owned by Discovery Inc.

As a member of the UT family, you will be surrounded by top-notch faculty, staff, and students from around the world. You will be part of a diverse campus community that is passionate about changing the world and cheering for the Vols on game day.

Get job alerts

Create a job alert and receive personalized job recommendations straight to your inbox.

Create alert