Working under the direction of the Principal Data Architect, this position will participate in the design, architecture, security, development, and performance tuning of an Enterprise Data Warehouse at Harvard Medical School.
The primary focus of this role will be ETL development using Microsoft SSIS.
Collaborate with the Data Architect, the Data Modeler, Business Analysts, Business Intelligence Developers, and other ETL Developers to build robust, high-performance ETL processes.
Harvard offers an outstanding benefits package including:
Time Off: 3 - 4 weeks paid vacation, paid holiday break, 12 paid sick days, 11.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, $40 per class 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.
Salary Grade: 058
Union: 00 - Non Union, Exempt or Temporary
Bachelor's degree in computer science or related field, or equivalent professional experience.
5 years of SQL Development experience – SQL Server, Oracle, MySQL, Postgres, etc...
2 years of Microsoft SSIS development experience
SQL performance tuning expertise
Able to navigate unfamiliar data models of all types and to develop methods for reliably and accurately extracting data from them.
A solid understanding of Ralph Kimball Data Warehouse design methodologies.
SQL Server DBA skills.
Windows Sysadmin skills
Higher education experience
Willingness to follow established development standards.
Able to collaborate well with peers in a team environment.
Good organization skills
Concern for accuracy, details, and quality
Ability to work effectively in a multi-cultural environment cross-organizationally with and without direct supervision.
Ability to learn new technologies
Strong written and verbal communication skills
Solid analytical and problem-solving abilities
Highly self-motivated and self-directed.
EQUAL OPPORTUNITY EMPLOYER: 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, or any other characteristic protected by law.
Internal Number: 49960BR
About Harvard University Medical School
Harvard University is devoted to excellence in teaching, learning, and research, and to developing leaders in many disciplines who make a difference globally. The University, which is based in Cambridge and Boston, Massachusetts, has an enrollment of over 20,000 degree candidates, including undergraduate, graduate, and professional students. Harvard has more than 360,000 alumni around the world. The University has twelve degree-granting Schools in addition to the Radcliffe Institute for Advanced Study, offering a truly global education. Established in 1636, Harvard is the oldest institution of higher education in the United States.