Over the past five years, the Data Architecture team at Harvard Medical School has been building a data warehouse for Administrative and Education data (named 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 to hire a BI Developer to serve as a consultant to departments across the school that need to use Delphi data in their daily work. This work involves:
Developing Tableau dashboards for school-wide reporting and for smaller departments without their own Tableau Developers.
Developing Tableau Data Sources for larger departments with their own Tableau Developers.
Interacting with stakeholders across the school and at all levels to understand their data requirements and collaborating with them on reporting/dashboard solutions.
Administering and managing the Tableau Servers and Software.
Mentoring new Tableau users across the school.
The ideal person will have strong experience in a stakeholder-facing Business Analyst role, will have deep experience with SQL and Tableau, and will have a desire to broaden their skills by learning new technologies and practices. Candidates will be asked to show portfolios.
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 Business Analyst experience. Proven ability to work well with non-technical people. Comfortable working with many types of stakeholders - from BI developers to data analysts to line managers to C-Level.
5 years of SQL Development experience – SQL Server, Oracle, MySQL, Postgres, etc.
5 years of development experience with Tableau.
Data Analysis Skills.
Kimball Data Modeling.
SSIS or other ETL Tool.
Master Data Management.
Higher Ed experience.
Willingness to follow established development standards and patterns.
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.
Certificates and Licenses
Completion of Harvard IT Academy specified foundational courses (or external equivalent) preferred
This position is based in Boston, but the work may be done primarily remote. Any remote work must be performed in a state in which Harvard is registered to do business (CA*, CT, GA, IL, MA, MD, ME, NH, NJ, NY, RI, VA, VT, and WA). 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 health of our workforce is a priority for Harvard University. With that in mind, we strongly encourage all employees to be up-to-date on CDC-recommended vaccines.
Please note that we are currently conducting a majority of interviews and onboarding remotely and virtually. We appreciate your understanding.
The Harvard Medical School is not able to provide visa sponsorship for this position.
Paid Time Off: 3-4 weeks of accrued vacation time per year (3 weeks for support staff and 4 weeks for administrative/professional staff), 12 accrued sick days per year, 12.5 holidays plus a Winter Recess in December/January, 3 personal days per year (prorated based on date of hire), and up to 12 weeks of paid leave for new parents who are primary care givers.
Health and Welfare: Comprehensive medical, dental, and vision benefits, disability and life insurance programs, along with voluntary benefits. Most coverage begins as of your start date.
Work/Life and Wellness: Child and elder/adult care resources including on campus childcare centers, Employee Assistance Program, and wellness programs related to stress management, nutrition, meditation, and more.
Retirement: University-funded retirement plan with contributions from 5% to 15% of eligible compensation, based on age and earnings with full vesting after 3 years of service.
Tuition Assistance Program: Competitive program including $40 per class at the Harvard Extension School and reduced tuition through other participating Harvard graduate schools.
Tuition Reimbursement: Program that provides 75% to 90% reimbursement up to $5,250 per calendar year for eligible courses taken at other accredited institutions.
Professional Development: Programs and classes at little or no cost, including through the Harvard Center for Workplace Development and LinkedIn Learning.
Commuting and Transportation: Various commuter options handled through the Parking Office, including discounted parking, half-priced public transportation passes and pre-tax transit passes, biking benefits, and more.
Harvard Facilities Access, Discounts and Perks: Access to Harvard athletic and fitness facilities, libraries, campus events, credit union, and more, as well as discounts to various types of services (legal, financial, etc.) and cultural and leisure activities throughout metro-Boston.
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.
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.