Manager of Data Integration

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.

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 rangeof liberal arts and sciences disciplines. Together, the FAS seeksto 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 ofleaders through a transformative educational experience.

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.

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.

• 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 beuseful to end users for both searching and reporting
  • Marketing Cloud data extensions. Load data to be used in all communications
  • Data Cloud (Data
    360) 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. Tunning 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 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

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

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