Senior Data Architect
Harvard University
- Cambridge, MA
- Permanent
- Full-time
- Experience in end-to-end architecting data solutions (DataWarehouse, Data Lakes, and data governance) with at least one with an ERP (EBS, PeopleSoft or similar) source system.
- Have a thorough understanding of OLTP and DW design.
- Lead diverse teams through design phase to production.
- Produced logical and physical data models using modeling tools like Erwin, ERStudio or equivalent, and data flow diagrams of ETL logic, and coherent high level system diagrams to influence senior leadership.
- Familiarity with modern data warehouses Azure / Snowflake and knowing concepts like ELT (extract load and transform) and master data, data governance concepts.
- Harvard University requires pre-employment reference and background screening.
- We are unable to provide work authorization and/or visa sponsorship.
- This position has a 180-day orientation and review period.
Harvard University welcomes individuals with disabilities to apply for positions and participate in its programs and activities. If you would like to request an accommodation or have questions about the physical access provided, please contact our University Disability Resources Department.DepartmentAdministrative Technology ServicesPre-Employment ScreeningIdentityJob FunctionInformation TechnologySchool/UnitHarvard University Information TechnologyBasic Qualifications
- Minimum of five years' post-secondary education or relevant work experience
- Completion of Harvard IT Academy specified foundational courses (or external equivalent) preferred
- Work is performed in an office setting
- Partner with business stakeholders to understand their data challenges and opportunities.
- Translate business requirements into technical specifications for data solutions.
- Design and architect scalable, secure, and high-performance data pipelines, data warehouses, and data lakes.
- Select and implement appropriate data storage technologies (e.g., relational databases, data warehouses, data lakes) based on project needs.
- Define and implement data governance policies and procedures to ensure data quality, security, and compliance.
- Stay up-to-date on the latest data technologies, cloud platforms, and data management best practices.
- Lead and mentor junior data engineers, data modelers, and architects.
- Collaborate with cross-functional teams to ensure seamless integration of data solutions.
- Develop and document technical specifications, design artifacts, and solution roadmaps.
- Evaluate and recommend new data tools and technologies.
- Will have a deep understanding of distributed systems architecture and principles like scalability, fault tolerance, and high availability.
- May be responsible for designing and implementing data security measures and access controls.
- 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.
Harvard University Information Technology (HUIT) is responsible for the strategy, planning, and delivery of information technology across the University. Our mission is to assure Harvard's leadership in IT. We strive to make it easier for faculty, students, and staff to teach, research, learn and work through the effective use of information technology. HUIT's core values are User Focused, Collaborative, Innovative and Open.HUIT's core values are:
- User-focused
- Collaborative
- Innovative
- Open
HUIT's IT Academy aims to enable each IT staff person to grow professionally and become a trusted partner to her or his team. The IT Academy is built on the belief that every IT staff member across the University (including technology employees at each school and campus) can grow in her or his area of expertise as well as building strong people and project management skills. Learn more here: