Manager of Data Integration

Harvard University, Faculty of Arts & Sciences; Cambridge (MA); Hybrid; USD 100,000 - 130,000; Full time

Job summary

Harvard University is seeking a Manager of Data Integration (MDI) to oversee ETL practices, ensuring robust data access, integration, and utilization across multiple storage sources. The role collaborates with developers, the technical infrastructure team, and product owners to ensure timely delivery of integration services and maintains Informatica implementation.

The MDI will design and optimize complex integration tasks, work with Salesforce platforms, and mentor staff on ETL best practices.

Qualifications

• Minimum of five years’ post-secondary education or relevant work experience.
• Excellent communication skills, both written and oral.
• Experience orchestrating and optimizing Extract-Transform-Load (ETL) processes.
• Proficient in SOQL, SOSL, SQL.
• Competency in Web Services (JSON, XML, REST, SOAP).

Responsibilities

• Design, develop, and document complex ETL tasks, including Informatica integrations, data synchronizations, mappings, APIs, and OData.
• Collaborate with internal and external business partners to determine needs and evaluate solutions.
• Monitor Informatica daily operations and optimize scheduling for balanced and efficient service delivery.
• Provide technical direction in developing and supporting system-level integrations; architecture design and QA.
• Troubleshoot integration problems and propose resolutions using data analysis.

Skills

ETL processes

Salesforce platforms

SOQL SOSL SQL

Web Services

Communication skills

Data integration

Tools

Informatica

Oracle SQL

Salesforce

Marketing Cloud

Job description

Company Description

By working at Harvard University, you join a vibrant community thatadvances Harvard's world-changing mission in meaningful ways,inspires innovation and collaboration, and builds skills andexpertise. We are dedicated to creating a diverse and welcomingenvironment where everyone can thrive.

Why join the Harvard Faculty of Arts and Sciences?

The Faculty of Arts and Sciences (FAS) is the historic heart ofHarvard University. It is the home of Harvard’s undergraduateprogram (Harvard College, founded in 1636) as well as all ofHarvard’s Ph.D. programs (the Harvard Kenneth C. Griffin GraduateSchool of Arts and Sciences, founded in 1872), Harvard Athleticsand the Division of Continuing Education. The 40 academicdepartments and 30+ centers of the FAS support a communityunparalleled in its academic excellence across the broadest rangeof liberal arts and sciences disciplines. Together, the FAS seeksto foster an environment of ambition, curiosity and sharedcommitment to knowledge and truth that elicits excellence from allmembers of our community and prepares the next generation ofleaders through a transformative educational experience.

Job Description

Job Summary

Responsible for overall data management design and construction, ensuring optimization of data access, integration, and utilization. Manage interface and connectivity between multiple data storage sources using advanced database administration expertise.

Job-Specific Responsibilities

The Manager of Data Integration (MDI) is responsible for the Extract/Transform/Load (ETL) practice. The MDI works with developers, the technical infrastructure team and product owners to support the timely and reliable delivery of integration services and features. The MDI maintains the technology currency of the Informatica implementation.

Duties and Responsibilities

• Design, develop, and document complex tasks, including:
  • Informatica integrations, data synchronizations, mappings,APIs, and OData. Extract, transfer, and Load data in disparateenterprise systems.
  • Oracle SQL procedures, functions, and views. Organize andprocess information in a way that enables users to easily andintuitively go back and find details
  • Salesforce workflows, external objects, and external services.Allow external data to be manipulated and loaded in a manner to beuseful to end users for both searching and reporting
  • Marketing Cloud data extensions. Load data to be used in allcommunications
  • Data Cloud (Data360) Streams, Objects, Models and integrationwith Salesforce Flows
• Collaborate with internal and external business partners todetermine needs and evaluate solutions
• Monitor and support Informatica’s daily operations byoptimizing scheduling across the platform to assure balanced andefficient service delivery. Tunning of existing assets to maintainhigh level of service
• Provide technical expertise and direction in developing andsupporting system level integrations
  • Architecture design to build a solid foundation on which newservices or updates of existing services can be built
  • Quality assurance focusing on improving the integrationdevelopment process and making it efficient and effective
• Troubleshoot integration problems and recommend appropriately resolution employing data analysis skills
• Provide training to staff in both best practices of ETL procedures as well as design and development of integrations,mappings, and APIs
• Actively contribute to formulation of plans and policies

Working Conditions

• The health of our workforce is a priority for HarvardUniversity. With that in mind, we strongly encourage all employees to be up-to-date on CDC-recommended vaccines.

Qualifications

Basic Qualifications

• Minimum of five years’ post-secondary education or relevant work experience

Additional Qualifications and Skills

• Excellent communication skills, both written and oral
• Experience orchestrating and optimizing Extract-Transform-Load(ETL) processes
• Demonstrated experience working on Salesforce platforms,preferably within the higher education context (Ed Cloud)
• Proficient in SOQL, SOSL, SQL
• Competency in Web Services (JSON, XML, REST, SOAP)

Additional Information

• Standard Hours/Schedule: 35 hours per week
• Compensation Range/Rate (including Shift Differential ifapplicable): $100K-$130K/annual
• Visa Sponsorship Information: Harvard University is unable to provide visa sponsorship for this position
• Pre-Employment Screening: Identity, Criminal
• Other Information:
  • This is a 2-year term position with the possibility of extension.
  • All formal offers will be made by FAS Human Resources.

About Us

The Division of Continuing Education (DCE) comprises four academicunits serving about 30,000 domestic and international studentsannually, which allow Harvard to meet the learning needs ofintellectually curious and highly motivated students from highschool through retirement. Established in 1910, the HarvardExtension School (HES) offers access to Harvard faculty for adiverse community of adult learners, enrolling about 15,000students. HES offers over 1,000 open enrollment courses — 85percent of which are accessible online — and provides flexibilitythrough noncredit, undergraduate, and graduate courses, includingdegrees, certificates, and a premedical program. The Harvard SummerSchool, founded in 1871, offers around 450 credit and noncreditcourses both on the Harvard Campus and online, catering to 10,000high school, college, and adult learners. Additionally, it offersmore than 15 international study abroad programs, hosting up to 300students each summer. Harvard DCE Professional & ExecutiveDevelopment delivers over 140 noncredit programs annually, reachingmore than 3,600 participants through online platforms and itsexecutive development center in Cambridge. The Harvard Institutefor Learning in Retirement offers about 140 peer-taught courses toapproximately 550 active members.

Work Format Details

This position has been determined by school or unit leaders thatsome of the duties and responsibilities can be effectivelyperformed at a non-Harvard location. The work schedule and locationwill be set by the department at its discretion and based uponoperational needs. When not working at a Harvard or Harvard-designated location, employees in hybrid positions mustwork in a Harvard registered state in compliance with theUniversity’s Policy on Employment Outside of Massachusetts .Additional details will be discussed during the interview process.Certain visa types and funding sources may limit work location.Individuals must meet work location sponsorship requirements priorto employment.

Salary Grade and Ranges

This position is salary grade level 058. Please visit Harvard's Salary Ranges to view the corresponding salary range and related information.

Benefits

Harvard offers a comprehensive benefits package that is designed tosupport a healthy work-life balance and your physical, mental andfinancial wellbeing. Because here, you are what matters. Ourbenefits include, but are not limited to:

• Generous paid time off including parental leave
• Medical, dental, and vision health insurance coverage startingon day one
• Retirement plans with university contributions
• Wellbeing and mental health resources
• Support for families and caregivers
• Professional development opportunities including tuitionassistance and reimbursement
• Commuter benefits, discounts and campus perks

Learn more about these and additional benefits on our Benefits & WellbeingPage .

EEO/Non-Discrimination Commitment Statement

Harvard University is committed to equal opportunity and non-discrimination. We seek talent from all parts of society and the world, and we strive to ensure everyone at Harvard thrives. Our differences help our community advance Harvard's academic purposes.

Harvard has an equal employment opportunity policy that outlines our commitment to prohibiting discrimination on the basis of race, ethnicity, color, national origin, sex, sexualorientation, gender identity, veteran status, religion, disability,or any other characteristic protected by law or identified in theuniversity's non-discrimination policy. Harvard's equal employment opportunity policy and non-discrimination policy help allcommunity members participate fully in work and campus life freefrom harassment and discrimination.