Data Warehouse Professional I jobs in United States
cer-icon
Apply on Employer Site
company-logo

Inside Higher Ed · 3 hours ago

Data Warehouse Professional I

Inside Higher Ed is seeking a Data Warehouse Professional I to join the University of Georgia's Office of Institutional Research. This role involves designing, developing, and maintaining data infrastructure to support reporting and operational data needs across the institution.

Digital MediaEducationHigher EducationJournalismRecruiting
badNo H1Bnote

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

Data warehousing conceptsSQL proficiencyETL/ELT pipelinesPython/PySparkSSISAzure Data FactoryPower BIExcel Pivot TablesProblem-solving skillsCommunication 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

Benefits

Retirement Plan: TRS or ORP
Benefits Eligibility: Benefits Eligible

Company

Inside Higher Ed

twittertwittertwitter
company-logo
Inside Higher Ed is the online source for news, opinion, and jobs related to higher education.

Funding

Current Stage
Growth Stage
Total Funding
unknown
2022-01-10Acquired
2006-08-31Series Unknown

Leadership Team

leader-logo
Stephanie Shweiki
Director, Foundation Partnerships
linkedin
Company data provided by crunchbase