Apply on Employer Site

University of Pittsburgh · 23 hours ago

DBA/Datawarehouse Architect

Pittsburgh, PA

Full-time

Hybrid

Mid Level

3+ years exp

The University of Pittsburgh is seeking a DBA/Data Warehouse Architect to join their Health Sciences Research IT team. This role focuses on ETL pipeline development and data warehouse architecture while supporting multiple research projects and translating requirements into efficient data structures.

Higher Education

No H1B

Responsibilities

Design, implement, and execute ETL pipelines for data ingestion and transformation

Support ingestion of high volume, multi format data, including thousands of files and very large (TB scale) datasets

Develop and maintain analytics ready datasets based on project specifications

Translate research and analytical requirements into efficient, scalable data warehouse structures

Optimize query performance using SQL Server, including advanced queries, stored procedures, indices, views, functions, and execution plans

Perform supporting DBA functions, including permissions management, performance tuning, and monitoring

Collaborate closely with project analysts, Principal Investigators, and other DBAs/data engineers to support multiple concurrent research projects

Apply strong organizational, documentation, and communication skills, including proficiency with Microsoft Office

Qualification

ETL pipeline developmentSQL ServerData warehouse architectureSASPythonPower BICommunication skillsOrganizational skillsDocumentation skills

Required

Supports multiple more complex services/databases; designs, develops, manages, and maintains databases

Plans and maintains database architecture and reporting

Optimizes database functions and implements integrated architecture and reporting updates

Trains and guides lower-level staff