The University of Pittsburgh is seeking a DBA/Data Warehouse Architect to join a research-intensive environment. This role focuses on designing and implementing ETL pipelines and data warehouse architecture, with traditional DBA responsibilities supporting these activities. You will work collaboratively with internal team members and research groups to build data ingestion and transformation pipelines for dozens of concurrent research projects.
What You'll Do
- 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
- Train and guide lower-level staff
What We're Looking For
- Strong SQL Server skills with the ability to write advanced queries
Nice to Have
- Experience with SAS, Stata, spark, web technologies, C#, Python, PowerShell, Power BI, Snowflake, and health-related datasets
Technical Stack
- SQL Server, SAS, Stata, spark, web technologies, C#, Python, PowerShell, Power BI, Snowflake, Microsoft Office
Team & Environment
You will work collaboratively with internal team members and research groups.
The University of Pittsburgh is an equal opportunity employer / disability / veteran.
