13-May-2022
Harvard Medical School
58456BR
Position Description
Over the past three years, the Data Architecture team at Harvard Medical School has been building a data warehouse for Administrative and Education data (Delphi). Delphi currently draws from more than 40 data sources and serves as a data hub for the medical school. Delphi incorporates a Data Lake and a Kimball Style Data Mart with Master Data Management.
The DA team is currently looking for an ETL Developer to design and build data flows in and out of Delphi. Our ETL framework currently executes well over 1,000 SSIS packages a day, pulling data from a variety of database types, from files, and from APIs. And we continue to grow.
Candidates must have strong experience with SQL and SSIS. Candidates should understand Kimball data models and should have the ability to navigate unfamiliar databases. Our ETL Developers collaborate with Data Architects and BI Developers for requirements and QA.
Basic Qualifications
- Minimum of five years’ post-secondary education or relevant work experience
Additional Qualifications and Skills
Must Haves
Bonus Experience:
Additional Qualifications:
Additional Information
This position is based in Boston, but the work may be done fully or primarily remote. Any remote work must be performed in a state in which Harvard is registered to do business (CA*, CT, MA, MD, ME, NH, NY, RI, and VT). Individual flexible and remote work options for this role will be discussed during the interview process. *Note: Harvard employees working in California must be exempt.
The University requires all Harvard community members to be fully vaccinated against COVID-19 and remain up to date with COVID-19 vaccine boosters, as detailed in Harvard’s Vaccine & Booster Requirements . Individuals may claim exemption from the vaccine requirement for medical or religious reasons. More information regarding the University’s COVID vaccination requirement, exemptions, and verification of vaccination status may be found at the University’s “COVID-19 Vaccine Information” webpage: http://www.harvard.edu/coronavirus/covid-19-vaccine-information/ .
Please note that we are currently conducting a majority of interviews and onboarding remotely and virtually. We appreciate your understanding.
Harvard University offers an outstanding benefits package including:
- Time Off: 3 - 4 weeks paid vacation, paid holiday break, 12 paid sick days, 12.5 paid holidays, and 3 paid personal days per year.
- Medical/Dental/Vision: We offer a variety of excellent medical plans, dental & vision plans, all coverage begins as of your start date.
- Retirement: University-funded retirement plan with full vesting after 3 years of service.
- Tuition Assistance Program: Competitive tuition assistance program, incredibly affordable classes directly at the Harvard Extension School, and discounted options through participating Harvard grad schools.
- Transportation: Harvard offers a 50% discounted MBTA pass as well as additional options to assist employees in their daily commute.
- Wellness options: Harvard offers programs and classes at little or no cost, including stress management, massages, nutrition, meditation, and complementary health services.
- Harvard access to athletic facilities, libraries, campus events, and many discounts throughout metro Boston.
The Harvard Medical School is not able to provide visa sponsorship for this position.
Not ready to apply? Join our Talent community to keep in touch and learn about future opportunities!
https://app.jobvite.com/TalentNetwork/action/campaign/w/NzM2NjU
Job Function
Information Technology
Location
USA - MA - Boston
Job Code
I1358P IT Data Architect Prof IV
Department
IT | Data Architecture
Union
00 - Non Union, Exempt or Temporary
Pre-Employment Screening
Criminal, Education, Identity
Commitment to Equity, Diversity, Inclusion, and Belonging
We are committed to cultivating an inclusive workplace culture of faculty, staff, and students with diverse backgrounds, styles, abilities, and motivations. We appreciate and leverage the capabilities, insights, and ideas of all individuals. Harvard Medical School Mission and Community Values
EEO Statement
We are an equal opportunity employer and all qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, disability status, protected veteran status, gender identity, sexual orientation, pregnancy and pregnancy-related conditions, or any other characteristic protected by law.
Similar Positions
-
Principal Ml Research Scientist, Harvard University Administration, United States, 29 days ago
Details Posted: 28-Feb-24 Location: USA - MA - Allston Type: Full-time Salary: Open Categories: Administrative/Support Staff/Administrative Internal Number: 65173BR Job Summary The Kempner Institu...
-
Assistant Director Of Campus Inclusion, Consulting, And Community Support, Harvard University Graduate School of Education, United States, 20 days ago
Details Posted: 07-Mar-24 Location: USA - MA - Cambridge Type: Full-time Salary: Open Categories: Administrative/Support Staff/Administrative Internal Number: 64638BR Job Summary HGSE is a diverse...
-
Research Associate, Harvard University Business School, United States, 6 days ago
Details Posted: 22-Mar-24 Location: USA - MA - Boston Type: Full-time Salary: Open Categories: Research - Laboratory/Non-Laboratory Staff/Administrative Internal Number: 65370BR Position Descripti...
-
Enrollment And Outreach Coordinator, Admissions And Enrollment Services, Harvard University Medical School, United States, 1 day ago
Details Posted: 26-Mar-24 Location: USA - MA - Boston Type: Full-time Salary: Open Categories: Administrative/Support Staff/Administrative Internal Number: 65288BR Position Description The Enrollm...
-
Director, Planned Giving, University Development Office, Harvard University Alumni Affairs and Development, United States, 23 days ago
Details Posted: 05-Mar-24 Location: USA - MA - Cambridge Type: Full-time Salary: Open Categories: Alumni Affairs Staff/Administrative Internal Number: 65219BR Job Summary Alumni Affairs and Develo...
-
Assistant Professor Of Immunology Dana Farber Cancer Institute & Harvard Medical School, Dana-Farber Cancer Institute, United States, 1 day ago
Assistant Professor of Immunology - Dana-Farber Cancer Institute & Harvard Medical School Dana-Farber Cancer Institute Boston, MA Full Time – Onsite The Department of Cancer Immunology & Virology ...