Med-Critical Care Medicine - Pennsylvania-Pittsburgh - (20003135)
A Data Warehouse Developer is sought for a growing data center which serves the schools of the health sciences. This person's primary objective will be to create a Data Warehouse for large health datasets. The incumbent will be required to work in a hybrid on-prem and cloud environment which will include SQL, Microsoft SQL Server, and NoSQL options. The developer will need to determine the best location and format for data storage and retrieval requirements. The data will arrive in various formats including SAS, CSV, and fixed width. The format will change based on the data owner. All actions must be performed in our secure HIPAA compliant environment according to data center policies and procedures and thoroughly documented. In some cases, you will serve as an Honest Broker.
The incumbent will work with Principal Investigators and their teams to assess their needs. This will require gathering specifications and listening to requirements from various positions within the University. Based on their findings, the developer designs the models and ETL to create the warehouse to allow for efficient analytic extraction. They must be able to optimize queries as much as possible as well as be selective on indices. This position will need to take ownership of several ongoing projects and balance the needs of various groups and encourage collaboration and reusability. This position will be responsible for data for many multi-million dollar grants so must have excellent documentation and accuracy. The data warehouse developer must be responsive to different requirements from different groups. They must be able to consider various options to best meet query performance and budgets.
The candidate must be able to evaluate different performance metrics and test solutions to find the proper fit. Requires a Master's degree and five years of experience demonstrating: a strong understanding of data architectures with SQL and data modeling abilities, the ability to write advanced queries and excellent organizational, documentation and communication skills. Familiarity with execution plans and optimization a plus. Experience with C#, Powershell, SAS, Stata, R, Python, and health datasets is ideal but not required. Substitutions are allowed per University guidelines.
Master's Degree in Computer Science or related area. Experience with relational databases, stored procedures and SQL queries. 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#, and health datasets is ideal but not required.
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: Fulltime-Regular
Job Classification: Staff.Systems/Programmer.IV
Minimum Education Level Required: Master's
Minimum Experience Level Required: 5-6 years experience
Work Schedule: M-F 830-5PM
Hiring Range: TBD Based on qualifications
Relocation Offered: Yes
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, Cover Letter
Internal Number: 20003135
About University of Pittsburgh
Founded in 1787, the same year the U.S. Constitution was signed, the University of Pittsburgh is one of the oldest institutions of higher education in the United States. One of three state-related research universities in Pennsylvania, Pitt is a member of the Association of American Universities (AAU), which comprises 62 preeminent doctorate-granting research institutions in North America.Pitt faculty members have expanded knowledge in the humanities and sciences, earning such prestigious honors as the National Medal of Science, the MacArthur Foundation’s “genius” grant, the Lasker-DeBakey Clinical Medical Research Award, and election to the National Academy of Sciences and the Institute of Medicine. Pitt scientists have defeated polio, unlocked the secrets of DNA, lead the world in organ transplantation, and pioneered TV and heavier-than-air flight, among numerous other accomplishments.Pitt students have earned Rhodes, Goldwater, Marshall, and Truman Scholarships, among other highly competitive national and international scholarships.Alumni have pioneered MRI and TV, won Nobel and Pulitzer Prizes, led corporations and universities, served in government and the military, conquered Hollywood and The New York Times bestsellers list, and won Super Bowls and NBA championships.