DBA/Datawarehouse Architect

University of Pittsburgh

Pittsburgh (Allegheny County)

Hybrid

USD 70,000 - 90,000

Full time

14 days+

Get more replies from employers

Send a job-specific resume in minutes.

Job summary

A leading university in Pittsburgh is seeking a DBA/Datawarehouse Architect to join their Health Sciences Research IT team. The ideal candidate will have over three years of experience in MS SQL Server, strong SQL skills, and familiarity with data warehousing concepts. Responsibilities include designing data pipelines and optimizing database functions. This position offers a hybrid work model with opportunities for growth in a collaborative environment.

Qualifications

Minimum 3 years experience in MS SQL Server environment.
Experience in writing data ingestion pipelines and DBA functions.
Strong communication and documentation skills required.

Responsibilities

Design pipelines for data ingestion/transformation.
Optimize database functions and implement updates.
Support research teams with data query requirements.

Skills

Strong SQL Server skills

Ability to write advanced queries

Organizational skills

Documentation and communication skills

Education

Bachelor's Degree in computer science or related area

Tools

MS SQL Server

Azure

AWS

Snowflake

NoSQL

Python

Power BI

Job description

Join to apply for the DBA/Datawarehouse Architect role at University of Pittsburgh

1 day ago Be among the first 25 applicants

Join to apply for the DBA/Datawarehouse Architect role at University of Pittsburgh

Get AI-powered advice on this job and more exclusive features.

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.

SVC HS Information Technology

Health Sciences Research IT is seeking a DBA/Datawarehouse 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 with the 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.

The ideal candidate will have three or more years of experience working in a MS SQL Server environment in both writing data ingestion pipelines/jobs as well as database administration. The candidate must have strong communication and documentation skills. Data experience in Azure, AWS, Snowflake, and NoSQL as well as experience with EHR and claims data is preferred but not required.

Essential Functions

Required skills include strong SQL Server skills with the ability to write advanced queries and excellent organizational, documentation and communication skills with proficiency in Microsoft Office. Familiarity with Execution Plans and optimization a plus. Experience with SAS, Stata, Web technologies, C#, Python, Powershell, Power BI, Snowflake, and health datasets is ideal but not required. A bachelor’s degree in computer science, Data Science or related area is preferred, or extensive experience with relational databases, stored procedures and SQL queries.

Physical Effort

Little physical effort required. Duties are primarily sedentary. May be required to move objects up to 25 pounds occasionally.

The University of Pittsburgh is committed to championing all aspects of diversity, equity, inclusion, and accessibility within our community. This commitment is a fundamental value of the University and is crucial in helping us advance our mission, which includes attracting and retaining diverse workforces. We will continue to create and maintain an environment that allows individuals to discover, belong, contribute, and grow, while honoring the experiences, perspectives, and unique identities of all.

The University of Pittsburgh is an Affirmative Action/Equal Opportunity Employer and values equality of opportunity, human dignity and diversity. EOE, including disability/vets.

Assignment Category

Full-time regular

Job Classification

Staff.Database Administrator III

Job Family

Information Technology

Job Sub-Family

Database

Campus

Pittsburgh

Minimum Education Level Required

Bachelor's Degree

Minimum Years Of Experience Required

3

Will this position accept substitution in lieu of education or experience?

Combination of education and relevant experience will be considered in lieu of education and/ or experience requirement.

Additional Details About Required Licensure/Certification

A bachelor’s degree in computer science, Data Science or a related area is preferred, or extensive experience with relational databases, stored procedures and SQL queries.

Work Schedule

3 Days Remote, 2 Days in Office

Work Arrangement

Hybrid: Combination of On-Campus and Remote work as determined by the department.

Hiring Range

TBD Based Upon Qualifications

Relocation Offered

No

Visa Sponsorship Provided

No

Background Check

For position finalists, employment with the University will require successful completion of a background check

Child Protection Clearances

Not Applicable

Required Documents

Resume

Optional Documents

Not Applicable