DBA/Data Warehouse & Pipeline Architect

Pittsburgh, PA, US • Posted 16 hours ago • Updated 4 hours ago
Full Time
On-site
Fitment

Dice Job Match Score™

🤯 Applying directly to the forehead...

Job Details

Skills

  • Science
  • Database Administration
  • Optimization
  • Data Warehouse
  • SQL Tuning
  • Query Optimization
  • Performance Monitoring
  • Research
  • Database
  • Analytical Skill

Summary

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
  • 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
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.
  • Dice Id: RTX1ea725
  • Position Id: c24a69ffa0fa05df9001b2cf8e978f10
  • Posted 16 hours ago
Create job alert
Set job alertNever miss an opportunity! Create an alert based on the job you applied for.

Similar Jobs

Hybrid in Pittsburgh, Pennsylvania

20d ago

Easy Apply

Full-time

Depends on Experience

Pittsburgh, Pennsylvania

Today

Full-time

Pittsburgh, Pennsylvania

12d ago

Easy Apply

Full-time

Depends on Experience

Warrendale, Pennsylvania

Today

Full-time

Search all similar jobs