BI Developer

06-Feb-2024

Harvard Medical School

64994BR

Position Description

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.
• Research, design, and implement technical solutions to deliver business requirements. Interact with stakeholders across the School and at all levels to understand their data requirements and collaborate with them on reporting/dashboard solutions. 
• Administering and managing the Tableau servers and software.
• Mentoring new Tableau users across the School.
• Abide by and follow the Harvard University IT technical standards, policies and Code of Conduct.

The ideal candidate 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.

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 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.
• Experience with Kimball Data Modeling, SSIS or other ETL Tool, and/or Master Data Management preferred.
• Familiarity with higher education or academic research environment preferred.
• Willingness to follow established development standards and patterns.
• Demonstrated team performance skills, service mindset approach, and the ability to act as a trusted advisor.
• 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

Additional Information

Candidates may be asked to show portfolios.

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.

Not ready to apply? Join our talent community to keep in touch and learn about future opportunities! ( https://www.gem.com ?formID=16341e35-cbc6-4904-88a3-09b35763307e)

Work Format Details

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.

Benefits

We invite you to visit Harvard's Total Rewards website (https://hr.harvard.edu/totalrewards ) to learn more about our outstanding benefits package, which may include:

• 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.

Job Function

Information Technology

Department Office Location

USA - MA - Boston

Job Code

I0858P IT Business Analysis Prfss IV

Department

Information Technology - 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

https://hms.harvard.edu/about-hms/campus-culture/mission-community-values-diversity-statement

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.

LinkedIn Recruiter Tag (for internal use only)

#LI-DK1