University of Georgia
Posting Details
Posting Number:
S14564P
Working Title:
Data Warehouse Professional I
Department:
EITS-Institutional Research
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. 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 the School of Medicine.
About the College/Unit/Department:
College/Unit/Department website:
oir.uga.edu
Posting Type:
External
Retirement Plan:
TRS or ORP
Employment Type:
Employee
Benefits Eligibility:
Benefits Eligible
Full/Part time:
Full Time
Work Schedule:
8am - 5pm, Monday - Friday. This position is not eligible for a remote schedule.
Advertised Salary:
Up to 70,000; Commensurate with Experience
Posting Date:
01/06/2026
Open until filled:
Yes
Closing Date:
Proposed Starting Date:
02/23/2026
Special Instructions to Applicants: Please provide name and contact information for three professional references. 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, 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 26 institutions of higher education and the System Office. Our USG Statement of Core Values are Integrity, Excellence, Accountability, and Respect. More details on the USG Core Values and Code of Conduct are available in USG Board Policy 8.2.18.1.2 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 at https://www.usg.edu/policymanual/section6/C2653.
Position Information Classification Title:
Data Warehouse Pro I
FLSA:
Exempt
FTE:
1.00
Minimum Qualifications:
Bachelor\'s degree in a related field or equivalent
Preferred Qualifications:
Experience in a Higher Education environment.
Experience with SSIS or Azure Data Factory.
Experience with Python/Pyspark.
Experience with API data extraction.
Experience with Power BI.
Experience with Excel Pivot Tables and/or OLAP cubes.
Position Summary:
The Office of Institutional Research at the University of Georgia is seeking a skilled and motivated Data Warehouse Professional to join our team. This role is responsible for designing, developing, and maintaining our data infrastructure, including data warehouse, data lakes, and other storage solutions that support reporting and operational data needs across the institution. The successful candidate will collaborate with other data warehouse team members, DBAs, business analysts, and other stakeholders to ensure efficient, secure, and effective data management practices that deliver high value to the university.
Knowledge, Skills, Abilities and/or Competencies
Understanding of data warehousing and lakehouse concepts (bronze, silver, gold layers).
Experience with traditional relational database systems (SQL Server, Oracle) and lakehouse environments like Microsoft Fabric or Databricks.
Proficiency with SQL (T-SQL, Spark SQL) for data transformation, modeling and optimization.
Experience developing ETL/ELT pipelines using SSIS, Azure Data Factory or Microsoft Fabric Data Factory.
Skilled in Python or PySpark and creating notebooks for data processing and analytics.
Experience integrating structured and semi-structured data across different systems.
Awareness of data security, governance, and access controls in SQL Server or Microsoft Fabric.
Ability to translate business requirements into effective technical solutions.
Strong problem-solving skills and eagerness to learn new technologies.
Excellent communication and interpersonal skills to collaborate with both technical and functional staff at all levels.
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
Security Access (e.g., public safety, IT security, personnel records, etc.):
Yes
Credit and P-Card policy:
Be advised a credit check will be required for all positions with financial responsibilities. For more 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 criminal background check, confirmation of credentials and employment history, and, if applicable, a satisfactory credit check. A pre-employment drug test may be required for high-risk positions. Please visit the UGA Background Check website.
Duties/Responsibilities
Design, develop, test, and implement ETL processes to integrate data from diverse sources into the data warehouse using SSIS, SQL Server database objects, T-SQL, and Python.
Design, develop, test, and implement data pipelines in Microsoft Fabric to ingest, transform, and load data from diverse sources into lakehouse and warehouse environments, leveraging Data Factory, Spark SQL, PySpark and notebooks.
Collaborate with business analysts and stakeholders to understand data integration requirements and business objectives.
Percentage of time:
50
Provide technical support and ensure system availability, including occasional work outside normal business hours.
Support database migrations, upgrades, and updates.
Monitor data warehouse (SSIS) and lakehouse (pipeline) performance to identify capacity issues and bottlenecks.
Maintain technical documentation and support materials.
Stay current on emerging technologies, industry trends, and best practices in data warehousing.
Adhere to UGA\'s change management and version control procedures.
Follow USG and UGA data governance standards for data access, privacy, and security.
Percentage of time:
40
Perform related duties as assigned.
Percentage of time:
10
#J-18808-Ljbffr
S14564P
Working Title:
Data Warehouse Professional I
Department:
EITS-Institutional Research
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. 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 the School of Medicine.
About the College/Unit/Department:
College/Unit/Department website:
oir.uga.edu
Posting Type:
External
Retirement Plan:
TRS or ORP
Employment Type:
Employee
Benefits Eligibility:
Benefits Eligible
Full/Part time:
Full Time
Work Schedule:
8am - 5pm, Monday - Friday. This position is not eligible for a remote schedule.
Advertised Salary:
Up to 70,000; Commensurate with Experience
Posting Date:
01/06/2026
Open until filled:
Yes
Closing Date:
Proposed Starting Date:
02/23/2026
Special Instructions to Applicants: Please provide name and contact information for three professional references. 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, 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 26 institutions of higher education and the System Office. Our USG Statement of Core Values are Integrity, Excellence, Accountability, and Respect. More details on the USG Core Values and Code of Conduct are available in USG Board Policy 8.2.18.1.2 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 at https://www.usg.edu/policymanual/section6/C2653.
Position Information Classification Title:
Data Warehouse Pro I
FLSA:
Exempt
FTE:
1.00
Minimum Qualifications:
Bachelor\'s degree in a related field or equivalent
Preferred Qualifications:
Experience in a Higher Education environment.
Experience with SSIS or Azure Data Factory.
Experience with Python/Pyspark.
Experience with API data extraction.
Experience with Power BI.
Experience with Excel Pivot Tables and/or OLAP cubes.
Position Summary:
The Office of Institutional Research at the University of Georgia is seeking a skilled and motivated Data Warehouse Professional to join our team. This role is responsible for designing, developing, and maintaining our data infrastructure, including data warehouse, data lakes, and other storage solutions that support reporting and operational data needs across the institution. The successful candidate will collaborate with other data warehouse team members, DBAs, business analysts, and other stakeholders to ensure efficient, secure, and effective data management practices that deliver high value to the university.
Knowledge, Skills, Abilities and/or Competencies
Understanding of data warehousing and lakehouse concepts (bronze, silver, gold layers).
Experience with traditional relational database systems (SQL Server, Oracle) and lakehouse environments like Microsoft Fabric or Databricks.
Proficiency with SQL (T-SQL, Spark SQL) for data transformation, modeling and optimization.
Experience developing ETL/ELT pipelines using SSIS, Azure Data Factory or Microsoft Fabric Data Factory.
Skilled in Python or PySpark and creating notebooks for data processing and analytics.
Experience integrating structured and semi-structured data across different systems.
Awareness of data security, governance, and access controls in SQL Server or Microsoft Fabric.
Ability to translate business requirements into effective technical solutions.
Strong problem-solving skills and eagerness to learn new technologies.
Excellent communication and interpersonal skills to collaborate with both technical and functional staff at all levels.
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
Security Access (e.g., public safety, IT security, personnel records, etc.):
Yes
Credit and P-Card policy:
Be advised a credit check will be required for all positions with financial responsibilities. For more 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 criminal background check, confirmation of credentials and employment history, and, if applicable, a satisfactory credit check. A pre-employment drug test may be required for high-risk positions. Please visit the UGA Background Check website.
Duties/Responsibilities
Design, develop, test, and implement ETL processes to integrate data from diverse sources into the data warehouse using SSIS, SQL Server database objects, T-SQL, and Python.
Design, develop, test, and implement data pipelines in Microsoft Fabric to ingest, transform, and load data from diverse sources into lakehouse and warehouse environments, leveraging Data Factory, Spark SQL, PySpark and notebooks.
Collaborate with business analysts and stakeholders to understand data integration requirements and business objectives.
Percentage of time:
50
Provide technical support and ensure system availability, including occasional work outside normal business hours.
Support database migrations, upgrades, and updates.
Monitor data warehouse (SSIS) and lakehouse (pipeline) performance to identify capacity issues and bottlenecks.
Maintain technical documentation and support materials.
Stay current on emerging technologies, industry trends, and best practices in data warehousing.
Adhere to UGA\'s change management and version control procedures.
Follow USG and UGA data governance standards for data access, privacy, and security.
Percentage of time:
40
Perform related duties as assigned.
Percentage of time:
10
#J-18808-Ljbffr