Data Analyst and Modeler

29-Aug-2024

Data Analyst and Modeler

Harvard University Information Technology

66726BR

Position Description

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)

• 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

Work Format Details

HUIT actively supports hybrid work where business needs allow. This position has been designated as a primarily remote position. While this position is primarily remote, travel to campus may be necessary based on business needs and the nature of work. Examples include bi-annual or quarterly Town Halls, critical business meetings or other work events. Additional details will be discussed during the interview process. All remote work must be performed within one of the Harvard Registered Payroll States, which currently includes Massachusetts, Connecticut, Maine, New Hampshire, Rhode Island, Vermont, Georgia, Illinois, Maryland, New Jersey, New York, Virginia, Washington, and California (CA for exempt positions only). Certain visa types and funding sources may limit work location. Individuals must meet work location sponsorship requirements prior to employment.

About Us

More about HUIT:
Harvard University Information Technology (HUIT) is a community of Information Technology professionals committed to delivering service and technological solutions in support of teaching, learning, research and administration.  We are recruiting an IT workforce that has both breadth in their ability to collaborate and innovate across disciplines – and depth in specific areas of expertise. HUIT offers opportunities for IT professionals to learn and work in a unique technology landscape and service-focused environment. 

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 

IT Academy (designed for IT Staff):
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: https://itacademy.harvard.edu/ 

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 - Cambridge

Job Code

I1358M IT Data Architect Mgt IV

Work Format

Hybrid (partially on-site, partially remote)

Sub-Unit

------------

Salary Grade

058

Department

Administrative Technology Services

Union

00 - Non Union, Exempt or Temporary

Time Status

Full-time

Appointment End Date

31-Dec-2025

Pre-Employment Screening

Identity

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.

LinkedIn Recruiter Tag (for internal use only)

#LI-BT1