Application Analytics & BI Associate

The University of Georgia; Athens (GA); On-site; USD 51,000 - 63,000; Full time

Benefits offered by this job

TRS retirement plan

Job summary

The University of Georgia is seeking an Application Analyst Associate in Athens to develop data models in Oracle and SQL Server, using PL/SQL and stored procedures to refresh data sources and support reporting. You will manage database security and collaborate across teams on data integration and analytics.

Responsibilities include developing PL/SQL/SQL code, reviewing others' code, and occasionally working after-hours or weekends to meet critical timelines.

Qualifications

• Knowledge of SQL query development, design principles, and database querying techniques.
• Knowledge of PL/SQL programming concepts and development practices.
• Knowledge of SSMS tools and functionality.
• Knowledge of T-SQL programming and stored procedure development methodologies.
• Knowledge of Oracle and Microsoft SQL Server database security concepts and best practices.
• Knowledge of ETL processes and data integration principles.

Responsibilities

• Develop and optimize models to support Power BI semantic models and reports.
• Develop stored procedures and data pipelines to support daily refresh of data warehouse and reporting infrastructure.
• Populate and maintain data dictionary as technical authority for interdepartmental data governance.

Skills

SQL query development

PL/SQL programming

SSMS

T-SQL programming

Oracle and MS SQL Server security

ETL processes

Education

High school diploma or equivalent

Tools

Banner

Operational Data Store (ODS)

Data Warehouse

Argos reporting tool

Job description

The University of Georgia is seeking an Application Analyst Associate in Athens to develop data models in Oracle and SQL Server, using PL/SQL and stored procedures to refresh data sources and support reporting. You will manage database security and collaborate across teams on data integration and analytics.

Responsibilities include developing PL/SQL/SQL code, reviewing others' code, and occasionally working after-hours or weekends to meet critical timelines.