Apply on Employer Site

The University of Georgia · 1 day ago

Data Warehouse Professional I

Athens, GA

Full-time

Onsite

New Grad, Entry Level

$0/yr - $70K/yr

The University of Georgia is the state’s flagship university, seeking a skilled and motivated Data Warehouse Professional to join their Office of Institutional Research. This role is responsible for designing, developing, and maintaining data infrastructure to support reporting and operational data needs across the institution.

Artificial Intelligence (AI)Information TechnologyRoboticsSoftware

No H1B

Responsibilities

Design, develop, test, and implement ETL processes to integrate data from diverse sources into the data warehouse using SQL Server Integration Services (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

Provide technical support and ensure system availability, including occasional work outside normal business hours

Support database migrations, upgrades, and updates

Monitor data warehouse (ex. SSIS) and lakehouse (ex. 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

Perform related duties as assigned

Qualification

ETL processesSQL proficiencyData warehousing conceptsPython/PySparkSSISAzure Data FactoryPower BICommunication skillsProblem-solving skillsInterpersonal skills

Required

Bachelor's degree in a related field or equivalent

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

Preferred

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

Company

The University of Georgia

Glassdoor4.2

The University of Georgia, a land-grant and sea-grant university with state-wide commitments and responsibilities, is the state's flagship institution of higher education.

Founded in 1785