The incumbent serves as the Data and ETL architect on the Health Sciences Data Warehouse (HSDW) team. They are responsible for ensuring the data and ETL architecture supports stakeholder requirements related to the HSDW project. They will work with the HSDW team to design and develop data architecture (physical and/or logical) and ETL standards and develop ETL.
As part of driving key architectural decisions related to data, ETL and reporting within the data warehousing environment, the position will also develop, implement and enforce strategies to optimize data quality, ETL development and test strategies for the data warehouse. They will be responsible for developing and maintaining documentation and specifications for the Data Warehouse in their areas of responsibility.
The incumbent will also be engaged in ETL development, testing, and supporting existing ETL. This will include, but not limited to implementation of data integration strategies per ETL specifications and iTarget standards. They will lead discussions regarding architectural components that comprise the environment itself and participate in modeling sessions to understand business rules associated with data transformation. The incumbent will work on developing and implementing test strategies such as unit testing of ETL transformations and integration testing of ETL jobs.
A strong understanding of Data Architecture, ETL Architecture, ETL concepts and Data warehousing tools is required. Familiarity with Pentaho and Oracle business Intelligence (OBIEE) is preferred. A strong discipline in creating appropriate documentation and specifications is required.
Internal Number: 172135
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.