Data Warehouse Lead

University of Georgia

retirement plan

United States, Georgia, Athens

Aug 04, 2025

Posting Details

Posting Number	S13958P
Working Title	Data Warehouse Lead
Department	EITS-Institutional Research
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,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 formed 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
Additional Schedule Information	Monday - Friday, 8am - 5pm
Advertised Salary	Up to 85,000; Commensurate with Experience
Posting Date	08/04/2025
Open until filled	Yes
Closing Date
Proposed Starting Date	10/01/2025
Special Instructions to Applicants	Please provide the name and contact information for three professional references.
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 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	3-5 years of experience in data warehousing, ETL development, data integration, and/or database management. Experience with cloud-based data warehousing platforms, such as Azure. Experience with Microsoft Fabric for data integration and analytics, supporting end-to-end data solutions across cloud environments. Knowledge of Power BI, Tableau, or other data visualization tools for reporting and analysis. Relevant certifications in data warehousing, ETL tools, or cloud technologies are beneficial but not required.
Position Summary	The Data Warehouse Lead is focused on leading the technical implementation, development, and optimization of the university's data warehouse environment. This position will guide a team of data professionals while ensuring the data warehouse operates efficiently and effectively to support the institution's reporting and analytics functions. In addition, the Data Warehouse Lead will collaborate with the Office of Institutional Research staff, central DBAs, and business/functional analysts to deliver a high ROI for the institution. This role combines hands-on technical work and leadership, providing opportunities for both technical growth and leadership development within a collaborative academic environment.
Knowledge, Skills, Abilities and/or Competencies	Expertise in data warehousing concepts, ETL processes, data modeling (e.g., Star Schema, Snowflake Schema), and relational database systems. Proficiency in the SQL Server Management Studio (SSMS) and SQL Server Integration Services (SSIS) for ETL processes, data migration, and automation of data workflows. Strong analytical and troubleshooting skills to resolve complex data issues. Experience leading teams and managing projects, ensuring successful project delivery. Strong leadership and mentoring capabilities, with a commitment to developing team members' technical skills. Excellent communication and interpersonal skills to lead the data warehouse team and liaise with technical and functional staff at all levels in the organization
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

Lead Data Warehouse Development (25%):

Oversee the continued development, maintenance, and optimization of the UGA data warehouse environment.
Lead the design and implementation of ETL processes, integrations with source systems, and data models to ensure high-quality data availability for reporting and analysis.
Collaborate with functional analysts and technical teams to define and implement data pipelines and storage strategies.

Percentage of time

Duties/Responsibilities

Technical Guidance and Mentorship (15%):

Maintain technical support documentation.
Provide hands-on technical mentorship to team members.
Conduct code reviews, ensuring adherence to best practices and standards in data modeling, ETL design, and performance optimization.
Assist team members in troubleshooting and resolving complex data issues, ensuring the continued development of technical expertise within the team.

Percentage of time

Duties/Responsibilities	Data Warehouse Performance Optimization (10%): Monitor and manage the performance of the data warehouse to ensure it meets institutional performance and scalability requirements. Collaborate with the data warehouse team to optimize ETL processes, query performance, and storage strategies. Identify and address performance bottlenecks, ensuring efficient data loading, access, and querying.
Percentage of time	10

Duties/Responsibilities	Access Management (10%): Oversee the management of user access and authentication within the data warehouse environment, ensuring that data access is restricted to authorized personnel. Work closely with database administrators (DBAs) to configure and manage appropriate access privileges across various database systems.
Percentage of time	10

Duties/Responsibilities	Collaboration with Institutional Stakeholders (10%): Partner with data analysts and other key university stakeholders to ensure that the data warehouse supports reporting, analytics, and other institutional data needs. Ensure alignment of the data warehouse structure with reporting and visualization tools, such as Power BI, Tableau, and other business intelligence platforms.
Percentage of time	10

Duties/Responsibilities	Quality Assurance and Data Integrity (10%): Ensure that data quality standards are met through validation checks and consistent monitoring of data loads. Follow UGA data governance policies to ensure the accuracy, integrity, and privacy of sensitive data, including student records and research data.
Percentage of time	10

Duties/Responsibilities

Project Leadership and Coordination (15%):

Lead and manage small to medium-sized data warehouse projects, ensuring that milestones, deadlines, and deliverables are met in accordance with university objectives.
Coordinate cross-functional teams to ensure the successful delivery of data warehouse solutions that align with both business and technical requirements.
Identify, assess, and mitigate project risks, providing regular updates to senior leadership.

Percentage of time

Duties/Responsibilities	Continuous Improvement and Innovation (5%): Stay informed on the latest trends and developments in data warehousing, cloud platforms, and ETL technologies. Continuously evaluate and implement best practices and improvements to enhance the data warehouse environment, ensuring its competitive edge.
Percentage of time	5