Application Analyst Associate
Stryker Corporation
Get more replies from employers
Send a job-specific resume in minutes.
Job summary
University of Georgia is seeking an Application Analyst Associate to develop data models in Oracle and SQL Server, refresh data sources, and manage security at the database level. The role focuses on PL/SQL, stored procedures, and Power BI reporting, with after-hours work as needed.
Ideal candidates will have a strong background in SQL development, ETL, and data governance, and will join a team supporting analytics across university systems.
Qualifications
- High school diploma or equivalent and 2 years of related experience.
- Experience with Oracle and SQL Server databases.
- Knowledge of PL/SQL programming concepts and stored procedures.
- Familiarity with ETL processes and data warehousing principles.
Responsibilities
- Develop and optimize Power BI semantic models and reports.
- Develop stored procedures and data pipelines to refresh data warehouse for reporting.
- Maintain data dictionary and support interdepartmental data governance processes.
- Support reporting needs with functional offices and users; ensure quality and performance.
Skills
Education
Job description
Posting Number S15552P
Working Title Application Analyst Associate
Department EITS-App Admin & Reporting
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.
College/Unit/Department website eits.uga.edu
External
TRS
Employee
Benefits Eligible
Full Time
Monday - Friday, 8am - 5pm
Up to 57,000
08/03/2026
Yes
09/01/2026
Athens Area
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.
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.
Classification Title Sys Administration Tech II
FLSA Non-Exempt
FTE 100
High school diploma or equivalent and 2 years of related experience
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 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.
Normal office environment
No
Yes
No
No
No
No
Yes
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.
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.
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 supporting Power BI reporting infrastructure
- Develop semantic models optimized for reusability while supporting departmentally distinct data definitions as necessary
- Populate and maintain data dictionary, acting as technical authority to support interdepartmental data governance processes
- Directly support reporting needs with appropriate functional offices and users
- Follow standard procedures, oversee technical development and testing of reports, dashboards, and procedures
- Author and maintain documentation to ensure freshness
- Support Functional and Technical personnel in fine-tuning current data models and reports, tuning for scalability and performance
50
Develop and enhance legacy Student Information Systems Reporting Environment
- 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
- Assist in the implementation and support of Banner's ODS , including modifications to ETL processes and feeds from Banner to ODS .
- Write SQL queries to extract required information to conduct data analysis, build and interpret predictive models, and troubleshoot issues
- Compile data into meaningful data visualizations including dashboards, tables and graphs and present findings to team members, leadership and clients
- Coordinate Change Management for assigned production changes and coordinate enhancement releases
- Troubleshoot, manage, and support batch jobs and APIs used to support reporting processes
- Manage monitoring facilities related to reporting processes
20
Maintain software versions and environments
- Manage monthly patching cycles
- Apply security-related triggers to applicable users, system accounts, and processes
- Communicate database security measures with other developers in an effort to support appropriate use and protection of institutional data
- Gather information as requested by management in support of internal and state audits.
- Coordinate security-related modifications to database tables and attributes
20
Manage database-level security and coordinate modifications to table-level attributes of the Banner Microsoft Fabric workspaces and SQL server databases
- Maintain custom database level roles for Banner, Operational Data Store, Microsoft Fabric workspaces and SQL servers. Revise access level for these roles as needed.
- Apply security related triggers to applicable users, system accounts, and processes
- Communicate database security measures with other developers in an effort to support appropriate use and protection of institutional data
- Gather information as requested by management in support of internal and state audits.
- Coordinate security-related modifications to database tables and attributes
10
Recruitment Contact
For questions concerning this position or recruitment progression, please refer to the Recruitment Contact listed below.
Mark Cox
mark.cox@uga.edu
- Resume/CV
- Cover Letter
- List of References with Contact Information
'/%3e%3cpath%20d='M101.744%2012.4726L102.894%2016.1947L99.0021%2013.2201L101.744%2012.4726ZM105.3%208.40937H100.488L99.0026%203.59473L97.5116%208.41047L92.7%208.40385L96.5965%2011.3834L95.1055%2016.1942L99.0021%2013.2196L101.408%2011.3834L105.3%208.40992V8.40937Z'%20fill='white'/%3e%3cdefs%3e%3clinearGradient%20id='paint0_linear_5593_1381'%20x1='90'%20y1='9.44471'%20x2='99'%20y2='9.44471'%20gradientUnits='userSpaceOnUse'%3e%3cstop%20stop-color='%2300AD70'/%3e%3cstop%20offset='0.998594'%20stop-color='%2300B67A'/%3e%3cstop%20offset='1'%20stop-color='%23DCDCE6'/%3e%3c/linearGradient%3e%3c/defs%3e%3c/svg%3e){kind=small}
