Manager of Data Integration

Harvard University; Cambridge (MA); Hybrid; USD 100,000 - 130,000; Full time

Benefits offered by this job

Generous paid time off including paren

Medical, dental, and vision health ins

Retirement plans with university con

Wellbeing and mental health resources

Support for families and caregivers

Tuition assistance and reimbursement

Commuter benefits, campus perks

Job summary

Harvard University seeks a Manager of Data Integration to oversee the ETL practice and ensure reliable data access across multiple sources. You will work with developers, infrastructure and product owners to deliver integrated services and maintain Informatica ecosystems.

The role emphasizes designing scalable data flows, optimizing SQL procedures, and building Salesforce integrations to support reporting and analytics in a higher education setting.

Qualifications

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

Responsibilities

• Design, develop, and document complex ETL tasks including: Informatica integrations, data synchronizations, mappings, APIs, and OData.
• Oracle SQL procedures, functions, and views. Organize and process information for easy retrieval.
• Salesforce workflows, external objects, and external services for end users’ searching and reporting.
• Load Marketing Cloud data extensions for communications.
• Data Cloud (Data360) Streams, Objects, Models integrations with Salesforce Flows.
• Collaborate with business partners to determine needs and evaluate solutions.
• Monitor Informatica operations and optimize scheduling for balanced service delivery.
• Provide technical direction for system-level integrations and architecture design.
• QA to improve integration development processes.
• Train staff on ETL best practices and integration development.
• Contribute to planning and policy formation.

Skills

ETL processes

Salesforce platform

SOQL SOSL SQL

Web services (JSON XML REST SOAP)

Communication skills

Education

Five years post-secondary education or relevant work experience

Tools

Informatica

Oracle SQL

Salesforce

Job description

Company Description

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

Company Description

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

Why join the Harvard Faculty of Arts and Sciences?

The Faculty of Arts and Sciences (FAS) is the historic heart of Harvard University. It is the home of Harvard’s undergraduate program (Harvard College, founded in 1636) as well as all of Harvard’s Ph.D. programs (the Harvard Kenneth C. Griffin Graduate School of Arts and Sciences, founded in 1872), Harvard Athletics and the Division of Continuing Education. The 40 academic departments and 30+ centers of the FAS support a community unparalleled in its academic excellence across the broadest range of liberal arts and sciences disciplines. Together, the FAS seeks to foster an environment of ambition, curiosity and shared commitment to knowledge and truth that elicits excellence from all members of our community and prepares the next generation of leaders 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 include:

• Design, develop, and document complex tasks, including:
  • Informatica integrations, data synchronizations, mappings, APIs, and OData. Extract, transfer, and Load data in disparate enterprise systems.
  • Oracle SQL procedures, functions, and views. Organize and process information in a way that enables users to easily and intuitively go back and find details
  • Salesforce workflows, external objects, and external services. Allow external data to be manipulated and loaded in a manner to be useful to end users for both searching and reporting
  • Marketing Cloud data extensions. Load data to be used in all communications
  • Data Cloud (Data360) Streams, Objects, Models and integration with Salesforce Flows
• Collaborate with internal and external business partners to determine needs and evaluate solutions
• Monitor and support Informatica's daily operations by optimizing scheduling across the platform to assure balanced and efficient service delivery. Tuning of existing assets to maintain high level of service
• Provide technical expertise and direction in developing and supporting system level integrations
• Architecture design to build a solid foundation on which new services or updates of existing services can be built
• Quality assurance focusing on improving the integration development process and making it efficient and effective
• Troubleshoot integration problems and recommend appropriate 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 Harvard University. 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 if applicable): $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.
  • A cover letter is highly encouraged for consideration.
  • All formal offers will be made by FAS Human Resources.

About Us

The Division of Continuing Education (DCE) comprises four academic units serving about 30,000 domestic and international students annually, which allow Harvard to meet the learning needs of intellectually curious and highly motivated students from high school through retirement. Established in 1910, the Harvard Extension School (HES) offers access to Harvard faculty for a diverse community of adult learners, enrolling about 15,000 students. HES offers over 1,000 open enrollment courses — 85 percent of which are accessible online — and provides flexibility through noncredit, undergraduate, and graduate courses, including degrees, certificates, and a premedical program. The Harvard Summer School, founded in 1871, offers around 450 credit and noncredit courses both on the Harvard Campus and online, catering to 10,000 high school, college, and adult learners. Additionally, it offers more than 15 international study abroad programs, hosting up to 300 students each summer. Harvard DCE Professional & Executive Development delivers over 140 noncredit programs annually, reaching more than 3,600 participants through online platforms and its executive development center in Cambridge. The Harvard Institute for Learning in Retirement offers about 140 peer-taught courses to approximately 550 active members.

Work Format Details

This position has been determined by school or unit leaders that some of the duties and responsibilities can be effectively performed at a non-Harvard location. The work schedule and location will be set by the department at its discretion and based upon operational needs. When not working at a Harvard or Harvard-designated location, employees in hybrid positions must work in a Harvard registered state in compliance with the University’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 prior to 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

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

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

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, sexual orientation, gender identity, veteran status, religion, disability, or any other characteristic protected by law or identified in the university's non-discrimination policy. Harvard's equal employment opportunity policy and non-discrimination policy help all community members participate fully in work and campus life free from harassment and discrimination.