This is a fully benefited, full-time Harvard University position that has been funded through December 31, 2025. There is the possibility of renewal, contingent on funding, university priorities and satisfactory job performance.
The Administrative Data Management and Reporting Ecosystem (ADMIRE) project is designed to create a comprehensive data strategy that enables the institution to leverage administrative data to inform decisions, make predictions, and otherwise understand our operations. The demand for high-quality, normalized, and interconnected data has continued to increase, with the emergence of generative artificial intelligence putting a spotlight on the challenges of data quality and data governance. This project prioritizes the foundational technology and related services that will enable such initiatives to move forward easily in the future. The ADMIRE project will enable us to leverage the full value of our digital assets for an enterprise-wide approach to data governance, create a modern data ecosystem, and incorporate best practices into our data management capabilities.
We are looking for an experienced data analyst and modeler with a curious mind who can work with different SMEs and develop design artifacts. This person will play an integral role in the data architecture practice and upcoming data governance practice. This is an exciting role to have an opportunity to develop the data blueprint for the Harvard University Data ecosystem.
Principal Duties and Responsibilities:
A curious minded, people savvy data analyst to work in the Reporting Analytics and Integrated Data team to deliver high quality data analysis to building new data warehouses and delivering analytical projects. This is an individual contributor role. The principal responsibilities are to:
Produce data models using Erwin or ERStudio & artifacts in the IDMC data governance application (training will be provided, candidate is expected to understand the fundamentals of data governance principles)
Assess the source system process and data to set up data interfaces
Work with SMEs to understand data requirements
Provide input to data design
Articulate findings and present models
Understand data modeling for transaction systems (3rd normal forms) and datawarehouses (star schemas, snapshots)
The role will perform the following functions:
Manage aspects of data management services which may include database and analytics platform research and design, database performance and optimization, recovery/load strategy and implementation, and data modeling
Assist with the preparation of data verification and testing methods for data/applications loaded into the warehouse, or other data repositories, to ensure compatibility across different sources
Code, develop, and document scripts and stored procedures
Collaborate with stakeholders to prepare data acquisition/access analysis
Provide technical expertise and direction in developing and supporting system level programs & documentation for specific systems and processes
Troubleshoot advanced problems and recommend appropriate action
May provide training to clients and staff
Act as a resource for a school or unit
Abide by and follow the Harvard University IT technical standards, policies, and Code of Conduct
Basic Qualifications
Minimum of five years? post-secondary education or relevant work experience
Additional Qualifications and Skills
Familiarity with;
modern data warehouses
Apex
Informatica ETL tool
Certificates and Licenses
Completion of Harvard IT Academy specified foundational courses (or external equivalent) preferred
Working Conditions
Work is performed in an office setting
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.
Work Format
Hybrid (partially on-site, partially remote)
Commitment to Equity, Diversity, Inclusion, and Belonging Harvard University views equity, diversity, inclusion, and belonging as the pathway to achieving inclusive excellence and fostering a campus culture where everyone can thrive. We strive to create a community that draws upon the widest possible pool of talent to unify excellence and diversity while fully embracing individuals from varied backgrounds, cultures, races, identities, life experiences, perspectives, beliefs, and 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.