What are the responsibilities and job description for the DBA/Data Warehouse & Pipeline Architect position at University of Pittsburgh?
Health Sciences Research IT is seeking a DBA/Data Warehouse & Pipeline Architect to join our team serving the schools of the health sciences. The candidate will work with other team members and research groups to design pipelines for data ingestion/transformation and implement the designs and execute them. This will be for ingesting thousands of files and others single large files in various formats. They will help support a large number of different research groups on many projects. The candidate will support work with the project teams to understand the data query requirements to optimize query performance with indices/views/functions etc. and be able to create analytic files based on specifications provided. The candidate must understand data warehousing concepts. The candidate will be responsible for DBA functions as well such as permissions, optimization, query optimization, performance monitoring, etc. Our team has a great mix of junior and experienced people.
Required Qualifications
Required Qualifications
- Strong understanding of data warehousing concepts and architecture
- Experience designing and implementing data ingestion and transformation pipelines
- Hands-on experience with SQL performance tuning, including: Query optimization, Indexes, views, and functions, & Performance monitoring
- Experience supporting multiple stakeholders and research projects simultaneously
- Ability to translate data and query requirements into efficient database designs
- Experience creating analytic datasets/files from specifications