Evaluates business requirements, creates advanced data ingestion processes and modeling, and provides extensive support for databases and relevant services. Designs new data architectures. Ensures data quality and delivery. Trains and assists lower-level data engineers; often serves as team lead. Supports data analysts and scientists with expert-level research and consulting.
Med-Orthopedic Surgery
In lieu of educational requirements, additional years of relevant experience may be considered, as per university guidelines.
The Department of Orthopedic Surgery is committed to equity, diversity, and inclusion.All qualified applicants are encouraged to apply and will be considered without regard to race, ethnicity, religion, sex, gender, sexual orientation, age, disability, or veteran status. The University offers comprehensive benefits to eligible employees. Aside from our great health plans, we have a generous match to our 403B retirement savings plan, vacation, sick and personal days. We have Paid Winter Recess (Christmas to New Year’s Day). Finally, we offer generous educational benefits for eligible employees, their dependents and spouse/domestic partner.
Essential FunctionsThis Data Engineer position will support a team of faculty investigators, staff data scientists, informatics specialists and basic research and medical scientists to launch a centralized databank for musculoskeletal research.The successful candidate will be familiar with common research data modalities (Omics and MRI/CT imaging data), formats (e.g. DICOM), metadata, and terminology.Responsibilities include data conditioning, consolidation, workflow optimization and automation, and quality control.Previous experience with large biomedical data and imaging informatics platforms such as PACS and container services such as Docker is highly desirable.Experience with, SAS, Python and SQL databases is also desirable.DEGREE: Information Science, Data Science, Computer Science, Biostatistics, Statistics, or related field with at least 5 years of experience in data analysis, database management, or information technology.
Typically has strong IT background with several years of practical experience.Proven track record with database supported with at least 5 years of practical experience within the DBA role for the platform. Strong knowledge of query language. Driven to continually self-learn, learning new features of the RDBM software and understand DBA role and expectations of position. Proficient in communication with customers, peers and management. Evaluates business requirements, creates advanced data ingestion processes and modeling, and provides extensive support for databases and relevant services. Designs new data architectures. Ensures data quality and delivery.
SQL Server, SAS, Python, R, VB Script or similar scripting languages
Data Confidentiality/Security - Maintain confidentiality of sensitive information at all times.
Data Quality - Maintain data quality at all times.
Explore innovative strategies and technologies surrounding data collection, processing, and storage. Establish quality controls and procedures, design reports and summaries, and ensure project needs are met. Continuously test and evaluate systems and processes, identify and address inefficiencies and develop innovative, progressive, technical solutions to enhance existing operations.
Create and maintain conceptual, logical and physical data models of data assets & resources
Establish and enforce data standards, patterns and optimizations to enable teams to deliver high performance analytics and applications. Collaboratewith data science and analytic teams on future data needs, setting roadmap for architectural runway and managing expectations of the research team business and productteams.
Ensure data flows and related information is being tracked, managed and documented. Document data models and the build the data ecosystem at large using tools of various means. Ensure standards are met for data engineering and delivery efforts
5 – 7 years in Database Administration
Physical EffortMust be able to lift up to 15 pounds and sit 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 CategoryFull-time regular
Job ClassificationStaff.Data Engineer IV
Job FamilyInformation Technology
Job Sub-FamilyDatabase
CampusPittsburgh
Minimum Education Level RequiredBachelor's Degree
Minimum Years Of Experience Required5
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 ScheduleM-F 8-4
Work ArrangementHybrid: Combination of On-Campus and Remote work as determined by the department.
Hiring RangeTBD Based Upon QualificationsRelocation OfferedNo
Visa Sponsorship ProvidedNo
Background CheckFor position finalists, employment with the University will require successful completion of a background check
Child Protection ClearancesNot Applicable
Required DocumentsResume
Optional DocumentsNot Applicable