Description

Posting Details

Posting Number

S15552P

Working Title

Application Analyst Associate

Department

EITS-App Admin & Reporting

About the University of Georgia

Chartered by the state of Georgia in 1785, the University of Georgia is the birthplace of public higher education in America and is the state's flagship university (https://www.uga.edu/). The proof is in our more than 240 years of academic and professional achievements and our continual commitment to higher education. UGA is currently ranked among the top 20 public universities in U.S. News & World Report. The University's main campus is located in Athens, approximately 65 miles northeast of Atlanta, with extended campuses in Atlanta, Griffin, Gwinnett, and Tifton. UGA employs approximately 3,100 faculty and more than 7,700 full-time staff. The University's enrollment exceeds 41,000 students including over 31,000 undergraduates and over 10,000 graduate and professional students. Academic programs reside in 19 schools and colleges, including our newly established School of Medicine.

About the College/Unit/Department

College/Unit/Department website

eits.uga.edu

Posting Type

External

Retirement Plan

TRS

Employment Type

Employee

Benefits Eligibility

Benefits Eligible

Full/Part time

Full Time

Work Schedule

Additional Schedule Information

Monday - Friday, 8am - 5pm

Advertised Salary

Up to 57,000

Posting Date

08/03/2026

Open until filled

Yes

Closing Date

Proposed Starting Date

09/01/2026

Special Instructions to Applicants

• Please provide name and contact information for three professional references
• This is a full-time, on-site position
• This position is not eligible for work authorization sponsorship.

Location of Vacancy

Athens Area

EEO Policy Statement

The University of Georgia is an Equal Opportunity employer. All qualified applicants will receive consideration for employment without regard to age, color, disability, genetic information, national origin, race, religion, sex, or veteran status or other protected status. Persons needing accommodations or assistance with the accessibility of materials related to this search are encouraged to contact Central HR (hrweb@uga.edu).

USG Core Values Statement

The University System of Georgia is comprised of our 25 institutions of higher education and learning, as well the System Office. Our USG Statement of Core Values are Integrity, Excellence, Accountability, and Respect. These values serve as the foundation for all that we do as an organization, and each USG community member is responsible for demonstrating and upholding these standards. More details on the USG Statement of Core Values and Code of Conduct are available in USG Board Policy 08.02.18.01.02.

Additionally, USG supports Freedom of Expression as stated in Board Policy 06.05 Freedom of Expression and Academic Freedom.

Position Information

Classification Title

Sys Administration Tech II

FLSA

Non-Exempt

FTE

100

Minimum Qualifications

High school diploma or equivalent and 2 years of related experience

Preferred Qualifications

Position Summary

The Application Analyst Associate will develop data models in Oracle and SQL server environments using PLSQL and stored procedures to refresh data sources. They will provide expertise on Oracle database related development efforts, including Banner, Operational Data Store ( ODS ), Data Warehouse, Argos reporting tool, etc. This position will also manage and coordinate database level security to these systems, including setting up triggers for application level fine-grained access.
The Application Analyst Associate will develop solutions in PL/ SQL and SQL and conduct reviews, on as-needed basis, of PL/ SQL and SQL code written by other developers. This position will occasionally be required to work after-hours and on weekends.

Knowledge, Skills, Abilities and/or Competencies

• Knowledge of SQL query development, design principles, and database querying techniques.
• Knowledge of PL/ SQL programming concepts and development practices.
• Knowledge of Microsoft SQL Server Management Studio ( SSMS ) tools and functionality.
• Knowledge of T- SQL programming and stored procedure development methodologies.
• Knowledge of Oracle and Microsoft SQL Server database security concepts, standards, and best practices.
• Knowledge of Extract, Transform, and Load ( ETL ) processes and data integration principles that support accurate and efficient analytics.

Physical Demands

Normal office environment

Is driving a responsibility of this position?

No

Is this a Position of Trust?

Yes

Does this position have operation, access, or control of financial resources?

No

Does this position require a P-Card?

No

Is having a P-Card an essential function of this position?

No

Does this position have direct interaction or care of children under the age of 18 or direct patient care?

No

Does this position have Security Access (e.g., public safety, IT security, personnel records, patient records, or access to chemicals and medications)

Yes

Credit and P-Card policy

Be advised a credit check will be required for all positions with financial responsibilities. For additional information about the credit check criteria, visit the UGA Credit Background Check website.

Background Investigation Policy

Offers of employment are contingent upon completion of a background investigation including, a criminal background check demonstrating your eligibility for employment with the University of Georgia; confirmation of the credentials and employment history reflected in your application materials (including reference checks) as they relate to the job-based requirements of the position applied for; and, if applicable, a satisfactory credit check. You may also be subject to a pre-employment drug test for positions with high-risk responsibilities, if applicable. Please visit the UGA Background Check website.

Duties/Responsibilities

Duties/Responsibilities

Develop and optimize models to support Power BI Semantic Models and Reports

1. Develop stored procedures and data pipelines to support daily refresh of data warehouse supporting Power BI reporting infrastructure
2. Develop semantic models optimized for reusability while supporting departmentally distinct data definitions as necessary
3. Populate and maintain data dictionary, acting as technical authority to support interdepartmental data governance processes
4. Directly support reporting needs with appropriate functional offices and users
5. Follow standard procedures, oversee technical development and testing of reports, dashboards, and procedures
6. Author and maintain documentation to ensure freshness
7. Support Functional and Technical personnel in fine-tuning current data models and reports, tuning for scalability and performance

Percentage of time

50

Duties/Responsibilities

Develop and enhance legacy Student Information Systems Reporting Environment

1. Provide support for legacy reporting environments
   • Support the development, deployment, and administration of Argos reporting
   • Assist with tasks related to Operational Data Store ( ODS )-based reporting
2. Assist in the implementation and support of Banner's ODS , including modifications to ETL processes and feeds from Banner to ODS .
3. Write SQL queries to extract required information to conduct data analysis, build and interpret predictive models, and troubleshoot issues
4. Compile data into meaningful data visualizations including dashboards, tables and graphs and present findings to team members, leadership and clients
5. Coordinate Change Management for assigned production changes and coordinate enhancement releases
6. Troubleshoot, manage, and support batch jobs and APIs used to support reporting processes
7. Manage monitoring facilities related to reporting processes

Percentage of time

20

Duties/Responsibilities

Maintain software versions and environments

1. Manage monthly patching cycles
2. Apply security-related triggers to applicable users, system accounts, and processes
3. Communicate database security measures with other developers in an effort to support appropriate use and protection of institutional data
4. Gather information as requested by management in support of internal and state audits.
5. Coordinate security-related modifications to database tables and attributes

Percentage of time

20

Duties/Responsibilities

Manage database-level security and coordinate modifications to table-level attributes of the Banner Microsoft Fabric workspaces and SQL server databases

1. Maintain custom database level roles for Banner, Operational Data Store, Microsoft Fabric workspaces and SQL servers. Revise access level for these roles as needed.
2. Apply security related triggers to applicable users, system accounts, and processes
3. Communicate database security measures with other developers in an effort to support appropriate use and protection of institutional data
4. Gather information as requested by management in support of internal and state audits.
5. Coordinate security-related modifications to database tables and attributes

Percentage of time

10

Contact Information

Recruitment Contact

Contact Details

For questions concerning this position or recruitment progression, please refer to the Recruitment Contact listed below.

Recruitment Contact Name

Mark Cox

Recruitment Contact Email

mark.cox@uga.edu

Recruitment Contact Phone

Posting Specific Questions

Required fields are indicated with an asterisk (*).

Applicant Documents

Required Documents

1. Resume/CV
2. Cover Letter
3. List of References with Contact Information

Optional Documents