What are the responsibilities and job description for the Data Warehouse Developer position at Harvard University?
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
- Bachelor’s degree in computer science or related field, or equivalent professional experience.
- 5 years of SQL Development experience on a variety of databases – SQL Server, Oracle, MySQL, Postgres, etc…
- 2 years of SSIS development experience.
- SQL performance tuning expertise.
Bonus Experience:
- SQL Server DBA skills.
- Windows Server sysadmin skills.
- Semarchy experience
- SSRS experience.
- Tableau experience.
Additional Qualifications:
- Willingness to work within an established framework and follow standardized development methods.
- Able to collaborate well with peers in a team environment.
- Good organization skills.
- A concern for accuracy, details and quality
- Ability to work effectively in a multi-cultural environment cross-organizationally with and without direct supervision.
- Ability and willingness to learn new technologies.
- Strong written and verbal communication skills.
- Solid analytical and problem-solving abilities.
- Highly self-motivated and self-directed.
Additional Information
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.
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
Location
Job Code
Sub-Unit
Department
Time Status
Salary Grade
Union
Pre-Employment Screening
Commitment to Equity, Diversity, Inclusion, and Belonging
EEO Statement
