Senior Data Architect

Job-Specific Responsibilities

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. If you are a technically proficient, nimble, user-focused, and accountable IT professional who also connects with the importance of collaborating well in a team environment, we are looking for you!

• Lead design discussions and document design
• Work closely with functional users to build a data solution
• Collaborate with report and ETL developers in communicating design
• Assess various tools for data analytics and integration
• Ability to lead team through pressure situations
• Develop standards and champion them
• Contribute to improve maturity model from project level to department level and eventually enterprise level

Typical Core Duties

• Lead 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
• Collaborate to prepare 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 complex scripts integration mappings and workflows, and stored procedures
• Provide technical expertise and direction in developing and supporting system level programs
• Troubleshoot advanced data problems and recommend appropriate action
• Create new or enhanced components of data architecture and interfaces
• Collaborate with business partners to determine needs and evaluate solutions
• Provide training to clients and staff
• May function as subject matter expert or project lead
• Actively contribute to formulation of plans and policies
• 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

The following Additional Qualifications are strongly preferred. If you meet some, but not all, you are still encouraged to apply; we value employees with a willingness to learn.

• Familiarity with modern data warehouses
• Familiarity with master data, data governance concepts
• Data architecture and data integration in the analytics space
• Data solutioning through interviews, analysis and conducting discovery and design meetings
• Data modeling and data flow diagraming
• Liaise with functional users on design decisions and expectation
• Lead the design efforts in a matrixed team of functional user, ETL and report developers
• Thorough understanding of OLTP and DW design
• Must have an experience of full life cycle design and delivery of at least one Data warehouse
• Analytical and critical design thinking
• Strong SQL skills, performance tuning and reading explain plan
• Strong understanding of how ETL works and recommending optimal physical design tuned for ETL tool
• Understanding of various reporting tools like OAS, Qlik and recommend design

Certificates and Licenses

• Completion of Harvard IT Academy specified foundational courses (or external equivalent) preferred

Working Conditions

Interview and onboarding activity for this position may be conducted via telephone & Zoom video conferencing, based on the department’s current presence on campus.

Harvard is an on-campus community and all positions are based in Massachusetts. We currently expect that employees in HUIT will work remotely through Fall, 2021. Effective October 1st, as a condition of continued employment, all work must be performed in a state where Harvard is registered to do business (CA, CT, MA, MD, ME, NH, NY, RI, VT).

HUIT is currently developing hybrid workplace models which actively support remote work (within a Harvard registered state) where business and team needs allow. Any remote scheduling of your work, agreed to by your supervisor, will need to be in a state in which Harvard is registered as an employer as a condition of continued employment.  Individual flexible and remote work options for this role will may discussed during the interview process.

Harvard will require COVID vaccination for all Harvard community members who will have any on-campus presence. Individuals may claim exemption from the vaccine requirement for medical or religious reasons. More information regarding the University’s COVID vaccination requirement and exceptions may be found at the University’s COVID-19 Vaccine Information webpage: http://www.harvard.edu/coronavirus/covid-19-vaccine-information/ .

Harvard continues to place the highest priority on the health, safety and wellbeing of its faculty, staff and students, as well as the wider community. Information and details can be found via Harvard’s Coronavirus Workplace Policies website: https://hr.harvard.edu/corona-virus-workplace-policies .

Additional Information

Please provide a cover letter with your application and upload as one document.

Please note:

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

More about HUIT:
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.

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/

Diversity, Inclusion & Belonging:
Harvard's commitment to Diversity, Inclusion and Belonging is rooted in our belief in drawing on the widest possible pool of talent to unify excellence and diversity. Our community strives to uphold these beliefs by honoring the rights, differences, and dignity of others and embracing individuals from varied backgrounds, cultures, races, identities, life experiences, perspectives, beliefs, and values. Harvard aims to foster a campus culture where everyone can thrive, a key to which is ensuring that we each experience a sense of inclusion and belonging.

Total Rewards:
Harvard’s Total Rewards Program is designed to attract, retain, and reward the performance of talented employees. As a Harvard staff member, you enjoy many perks that come with working for one of the top employers in Massachusetts, including:

Flexible work environment: HUIT supports flexible work arrangements where business needs allow.

Time off: 3 - 4 weeks paid vacation, paid holiday break, 12 paid sick days, 12.5 paid holidays, and 3 paid personal days per year.

Medical/Dental/Vision: We offer a variety of excellent medical plans, dental & vision plans.

Retirement: University-funded retirement plan with full vesting after 3 years of service.

Tuition Assistance Program (TAP): $40 per class at the Harvard Extension School and discounted options through participating Harvard grad schools.

Harvard University Employees Credit Union: Our employees credit union provides a complete line of services for all your financial needs. https://huecu.org

Transportation: 50% discounted MBTA pass as well as additional options to assist employees in their daily commute.

Wellness options: A variety of programs and classes at little or no cost, including stress management, massages, nutrition, meditation and complimentary health services.

Access to athletic facilities, libraries, campus events and many discounts throughout metro Boston.

Learn more: https://hr.harvard.edu/totalrewards

Accessibility:
Harvard University IT plays an important role in supporting Harvard's commitment by seeking to create, procure and deploy technologies that are accessible to all, including and especially those who live with disability. Harvard welcomes individuals with disabilities to apply for positions and participate in its programs and activities. If you would like to request accommodations or have questions about the physical access provided, please contact our University Disability Resources Department.

Job Function

Information Technology

Location

USA - MA - Cambridge

Job Code

I1358P IT Data Architect Prof IV

Department

Administrative Technology Services

Union

00 - Non Union, Exempt or Temporary

Pre-Employment Screening

Identity

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.