University of Georgia
IT Database Professional-Ento Bugwood, Tifton
University of Georgia, Athens, Georgia, us, 30604
Posting Details
Posting Details
Posting Number S12660P
Working Title IT Database Professional-Ento Bugwood, Tifton
Department CAES-Entomology
About the University of Georgia
Since our founding in 1785, the University of Georgia has operated as Georgia's oldest, most comprehensive, and most diversified institution of higher education ( https://www.uga.edu/ ). The proof is in our more than 235 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,000 faculty and more than 7,700 full-time staff. The University's enrollment exceeds 40,000 students including over 30,000 undergraduates and over 10,000 graduate and professional students. Academic programs reside in 18 schools and colleges, as well as a medical partnership with Augusta University housed on the UGA Health Sciences Campus in Athens.
About the College/Unit/Department
In 2018, The UGA Tifton Campus began a yearlong Centennial celebration with various events to commemorate its 100th anniversary of providing updated research to the community.
Research is done on a wide range of commodities, including cotton, peanuts, vegetables and turf grass, all of which make agriculture the No. 1 industry in Georgia.
In 2004, a teaching program was initiated and it has been growing ever since. College-level instruction on campus is aimed at undergraduate and graduate-degree level study.
College/Unit/Department website http://www.caes.uga.edu/campuses/tifton.html
Posting Type External
Retirement Plan TRS or ORP
Employment Type Employee
Benefits Eligibility Benefits Eligible
Full/Part time Full Time
Work Schedule
Additional Schedule Information
Work schedule will be determined by supervisor.
Advertised Salary Commensurate with education, experience and training
Posting Date 09/13/2024
Open until filled Yes
Closing Date
Proposed Starting Date 10/01/2024
Special Instructions to Applicants
This position is located in Tifton, GA, which is approximately 200 miles southwest of Athens, Georgia, 200 miles south of Atlanta, GA and approximately 70 miles north of the Florida line.
Location of Vacancy Tifton Area
EEO Policy Statement
The University of Georgia is an Equal Opportunity/Affirmative Action employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, ethnicity, age, genetic information, disability, gender identity, sexual orientation or protected veteran 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 26 institutions of higher education and learning, as well as 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 8.2.18.1.2 and can be found online at
https://www.usg.edu/policymanual/section8/C224/#p8.2.18_personnel_conduct .
Additionally, USG supports Freedom of Expression as stated in Board Policy 6.5 Freedom of Expression and Academic Freedom found online at
https://www.usg.edu/policymanual/section6/C2653 .
Position Information
Classification Title IT Database Support Professional
FLSA Exempt
FTE 1.00
Minimum Qualifications
Requires at least a baccalaureate degree in the field. Please contact your Human Resources office for an evaluation of education/experience in lieu of the required minimum qualifications.
Preferred Qualifications
Bachelor's degree in Computer Science, Information Technology, or related field with sufficient experience to show competence and innovation in application development.Two or more years of experience in developing ETL and reporting workflows.Position Summary
This position is part of the Center for Invasive Species and Ecosystem Health at the University of Georgia - Tifton Campus (Bugwood). The Center develops, maintains, and hosts a large number of digital tools and resources including web, smartphone, and database applications. The IT Database Professional is responsible for working with center staff, federal and state agencies, and other stakeholders to maintain and develop data Extract, Transform, and Load (ETL) routines for data import and export. They will also serve a key role in creating data exports to summarize the data and deliver that information to data stores for other applications in compliance with data usage policies. Both the ETL and data summarization routines must run on schedule with little user interaction needed. Each should also include checks for Quality Control and Quality Assurance with notifications when potential issues are detected.
This is a grant funded position and the possibility of renewal of this position for subsequent years will depend on the availability of funds.
Knowledge, Skills, Abilities and/or Competencies
Familiarity with AWS Services for Data warehousing including Glue, Athena, Data Pipeline, Data ExchangeFamiliarity with Microsoft SQL ServerPreferred experience with Spatial DataSQL, Python, or other ETL related languagesAble to maintain appropriate documentation for data formats and schemasWorking knowledge of or proven capability to quickly learn additional programming languages, systems, and other tools as needed.
Physical Demands
Work in an office settingSit at a desk for extended hours
Is driving a responsibility of this position? No
Is this a Position of Trust? No
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) No
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
Data Import and Export
Develop Extract, Transform, and Load routines for data import and export. Data destinations and sources include AWS Athena, Microsoft SQL Server, Excel, CSV, TSV, JSON, Line-Delimited JSON, Parquet, Google Big Query, Geospatial databases and files, ArcGIS.Analyze data in source format, understand source data types, schema, and ontology to accurately match with concepts in destination data formats.Percentage of time 60 Duties/Responsibilities
Develop Queries
Develop queries to summarize data for use in data reports and value added export. Understand the context of the data and work with stakeholders to produce meaningful outputs that can highlight utilization of resources, impact of available resources, and connection between groups working as a collaborative team.
May include use of Microsoft SQL Server, R, Qlik, e-Charts, d3, or other tools that can summarize data and produce needed graphics.
Work collaboratively with programmers at the center for delivery of some reports to users online or through scheduled report delivery.Percentage of time 15 Duties/Responsibilities
Debugging, Quality Control and Quality Assurance
Routine Debugging, Quality Control, and Quality Assurance for both data products and automated routines.
This duty applies to both of the above job duties and ensures that the movement of data in and out of the system is working smoothly and has high fidelity between source data end downstream products.
Percentage of time 15 Duties/Responsibilities
Documentation, Research, and Product Development
Responsible for documenting the current routines that are in place, researching other methods for achieving the same or similar outcomes and determining which are most effective for meeting the expectations of the end users. In some cases, this may also mean negotiating what is expected for functionality to be able to fit within the constraints of available budget.
All of the above duties are dependent on different technologies and tools. Every solution generates cost in terms of time, money, and compute resources used.
Miscellaneous
Other duties as assigned
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 Joe LaForest
Recruitment Contact Email laforest@uga.edu
Recruitment Contact Phone
Posting Specific Questions
Required fields are indicated with an asterisk (*).
Applicant Documents
Required Documents
Resume/CVCover LetterList of References with Contact InformationOptional Documents
Posting Details
Posting Number S12660P
Working Title IT Database Professional-Ento Bugwood, Tifton
Department CAES-Entomology
About the University of Georgia
Since our founding in 1785, the University of Georgia has operated as Georgia's oldest, most comprehensive, and most diversified institution of higher education ( https://www.uga.edu/ ). The proof is in our more than 235 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,000 faculty and more than 7,700 full-time staff. The University's enrollment exceeds 40,000 students including over 30,000 undergraduates and over 10,000 graduate and professional students. Academic programs reside in 18 schools and colleges, as well as a medical partnership with Augusta University housed on the UGA Health Sciences Campus in Athens.
About the College/Unit/Department
In 2018, The UGA Tifton Campus began a yearlong Centennial celebration with various events to commemorate its 100th anniversary of providing updated research to the community.
Research is done on a wide range of commodities, including cotton, peanuts, vegetables and turf grass, all of which make agriculture the No. 1 industry in Georgia.
In 2004, a teaching program was initiated and it has been growing ever since. College-level instruction on campus is aimed at undergraduate and graduate-degree level study.
College/Unit/Department website http://www.caes.uga.edu/campuses/tifton.html
Posting Type External
Retirement Plan TRS or ORP
Employment Type Employee
Benefits Eligibility Benefits Eligible
Full/Part time Full Time
Work Schedule
Additional Schedule Information
Work schedule will be determined by supervisor.
Advertised Salary Commensurate with education, experience and training
Posting Date 09/13/2024
Open until filled Yes
Closing Date
Proposed Starting Date 10/01/2024
Special Instructions to Applicants
This position is located in Tifton, GA, which is approximately 200 miles southwest of Athens, Georgia, 200 miles south of Atlanta, GA and approximately 70 miles north of the Florida line.
Location of Vacancy Tifton Area
EEO Policy Statement
The University of Georgia is an Equal Opportunity/Affirmative Action employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, ethnicity, age, genetic information, disability, gender identity, sexual orientation or protected veteran 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 26 institutions of higher education and learning, as well as 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 8.2.18.1.2 and can be found online at
https://www.usg.edu/policymanual/section8/C224/#p8.2.18_personnel_conduct .
Additionally, USG supports Freedom of Expression as stated in Board Policy 6.5 Freedom of Expression and Academic Freedom found online at
https://www.usg.edu/policymanual/section6/C2653 .
Position Information
Classification Title IT Database Support Professional
FLSA Exempt
FTE 1.00
Minimum Qualifications
Requires at least a baccalaureate degree in the field. Please contact your Human Resources office for an evaluation of education/experience in lieu of the required minimum qualifications.
Preferred Qualifications
Bachelor's degree in Computer Science, Information Technology, or related field with sufficient experience to show competence and innovation in application development.Two or more years of experience in developing ETL and reporting workflows.Position Summary
This position is part of the Center for Invasive Species and Ecosystem Health at the University of Georgia - Tifton Campus (Bugwood). The Center develops, maintains, and hosts a large number of digital tools and resources including web, smartphone, and database applications. The IT Database Professional is responsible for working with center staff, federal and state agencies, and other stakeholders to maintain and develop data Extract, Transform, and Load (ETL) routines for data import and export. They will also serve a key role in creating data exports to summarize the data and deliver that information to data stores for other applications in compliance with data usage policies. Both the ETL and data summarization routines must run on schedule with little user interaction needed. Each should also include checks for Quality Control and Quality Assurance with notifications when potential issues are detected.
This is a grant funded position and the possibility of renewal of this position for subsequent years will depend on the availability of funds.
Knowledge, Skills, Abilities and/or Competencies
Familiarity with AWS Services for Data warehousing including Glue, Athena, Data Pipeline, Data ExchangeFamiliarity with Microsoft SQL ServerPreferred experience with Spatial DataSQL, Python, or other ETL related languagesAble to maintain appropriate documentation for data formats and schemasWorking knowledge of or proven capability to quickly learn additional programming languages, systems, and other tools as needed.
Physical Demands
Work in an office settingSit at a desk for extended hours
Is driving a responsibility of this position? No
Is this a Position of Trust? No
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) No
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
Data Import and Export
Develop Extract, Transform, and Load routines for data import and export. Data destinations and sources include AWS Athena, Microsoft SQL Server, Excel, CSV, TSV, JSON, Line-Delimited JSON, Parquet, Google Big Query, Geospatial databases and files, ArcGIS.Analyze data in source format, understand source data types, schema, and ontology to accurately match with concepts in destination data formats.Percentage of time 60 Duties/Responsibilities
Develop Queries
Develop queries to summarize data for use in data reports and value added export. Understand the context of the data and work with stakeholders to produce meaningful outputs that can highlight utilization of resources, impact of available resources, and connection between groups working as a collaborative team.
May include use of Microsoft SQL Server, R, Qlik, e-Charts, d3, or other tools that can summarize data and produce needed graphics.
Work collaboratively with programmers at the center for delivery of some reports to users online or through scheduled report delivery.Percentage of time 15 Duties/Responsibilities
Debugging, Quality Control and Quality Assurance
Routine Debugging, Quality Control, and Quality Assurance for both data products and automated routines.
This duty applies to both of the above job duties and ensures that the movement of data in and out of the system is working smoothly and has high fidelity between source data end downstream products.
Percentage of time 15 Duties/Responsibilities
Documentation, Research, and Product Development
Responsible for documenting the current routines that are in place, researching other methods for achieving the same or similar outcomes and determining which are most effective for meeting the expectations of the end users. In some cases, this may also mean negotiating what is expected for functionality to be able to fit within the constraints of available budget.
All of the above duties are dependent on different technologies and tools. Every solution generates cost in terms of time, money, and compute resources used.
Miscellaneous
Other duties as assigned
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 Joe LaForest
Recruitment Contact Email laforest@uga.edu
Recruitment Contact Phone
Posting Specific Questions
Required fields are indicated with an asterisk (*).
Applicant Documents
Required Documents
Resume/CVCover LetterList of References with Contact InformationOptional Documents