Health Data Manager
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.
Job Summary
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.
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.
Work Schedule: 2 Days In Office; 3 Days Remote
Work Arrangement: 2 Days In Office; 3 Days Remote
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
Equal employment opportunity, including veterans and individuals with disabilities.
PI270180479