Oversees large, complex data sets and utilizes advanced programming methods and statistical software for raw data extraction and aggregation, statistical analysis, and document programming to create analytic data files. Creates statistical reports; assists with manuscripts, grants, and regulatory submissions. Maintains data infrastructure and tracks data assets. Adheres to all protocols.
SVC HS Information Technology
Health Sciences IT (HSIT) is seeking a dynamic professional who assists study teams with clinical, claims, or administrative research data. The HSIT Research team provides support for the six schools of the health sciences. As such, the successful candidate will collaborate closely with research teams and their Principal Investigators (PIs) to provide datasets for analysis based on study team requirements to answer their research questions.
The health data manager will become an expert with various datasets which include EHR, CMS Claims and administrative datasets to answer research questions in support of study teams. The data manager will be responsible for ETL pipelines, documentation, data loads, light analysis, data metrics and summaries, data extraction/views, and quality assurance. They will work with small datasets ranging from 500 MB to multiple TB data lakes. They must know how to optimize queries and consider costs when working in the cloud.
The ideal candidate must have experience using SQL Server as well as writing T-SQL. They will need experience using ADS/Synapse/Data Factory/SSDT and working in Python or R. . The incumbent must have excellent documentation skills and be open to learning new technologies. Familiarity with AWS and Azure is preferred. Master’s degree or a bachelor's degree with associated experience are required.
Essential Functions
"Required skills include strong SQL Server skills with the ability to write advanced queries. They will need experience using ADS/Synapse/Data Factory/SSDT and working in Python or R. They must have experience using health data in research and working with research teams. The incumbent must have excellent documentation skills and be open to learning new technologies. Familiarity with AWS and Azure is preferred. Master’s degree or a bachelor's degree with associated experience is required.
Physical Effort
Generally sedentary desk work with computer-keyboard-video phone other than traveling to other buildings on campus for meetings/events on occasion. Must be able to sit or stand for prolonged periods of time.
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.Data Scientist III
Job Family
Research
Job Sub-Family
Data Science
Campus
Pittsburgh
Minimum Education Level Required
Master's Degree
Minimum Years Of Experience Required
6
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
must have experience using SQL Server as well as writing T-SQL. They will need experience using ADS/Synapse/Data Factory/SSDT and working in Python or R. They must have experience using health data in research and working with research teams.
Work Schedule
2 Days In Office; 3 Days Remote
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