Description

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 ([email protected]).
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

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 25 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 15 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 15 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

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 Julius Gantt Recruitment Contact Email [email protected] Recruitment Contact Phone

Posting Specific Questions

Required fields are indicated with an asterisk (*).

Applicant Documents

Required Documents

1. Resume/CV
2. Cover Letter
3. List of References with Contact Information

Optional Documents