• Job Description

  Req#: R0002793

  JOB TITLE

  Data Integration Engineer I

  LOCATION

  Worcester

  DEPARTMENT NAME

  Integration Services & Data Management

  DIVISION NAME

  Worcester Polytechnic Institute - WPI

  JOB DESCRIPTION SUMMARY

  Reporting to the Assistant Director of Integration Services and Data management, the Data Integration Engineer I will be responsible for analyzing, designing, developing, and implementing robust and scalable integrations. This position supports all integration and data management-related services. They will also be a key contributor in maintaining and enhancing the Identity management solution.
  
  Enterprise Cloud Systems & Integration Services supports applications and initiatives across WPI, including Workday, SnapLogic, Amazon Web Services, and Informatica MDM. The successful candidate will be a critical member of the Enterprise team, working closely with other engineers and business users to identify, develop, and implement modern and robust integrations, data management, and Identity management solutions.
  
  Information Technology (IT) collaborates with the WPI community to meet academic, research, campus life, and administrative needs for technology and access on a global scale. IT promotes innovation to deliver an advanced technology infrastructure, security and access management, integrated data systems, and user-centric support services. Join our Information Technology team and help us enable another one-hundred fifty years of WPI’s success.
  
  WPI is a vibrant, active, and diverse community of extraordinary students, world-renowned faculty, and state of the art research facilities. At WPI, we have competitive and comprehensive benefits, including health insurance, long-term care, retirement, tuition assistance, flexible spending accounts, work-life balance, and much more.
  
  WPI is passionate about creating an inclusive workplace that promotes and values diversity. We are looking for candidates who can support our commitment to equity, diversity, and inclusion.
  
  This position is a remote opportunity.

  JOB DESCRIPTION

  Responsibilities:

  • Design, develop, and support complex integrations between various enterprise applications (i.e. Workday and Salesforce).

  • Build the infrastructure required for optimal extraction, transformation, and loading of data from a wide variety of data sources using cloud technologies such as SnapLogic (IpaaS), SQL, AWS, Informatica, and PRISM Analytics.

  • Promote extract-transform-load (ETL) standards in alignment with industry best practices.

  • Independently execute end-to-end integration projects, including requirements gathering, development, testing, and production support.

  • Design, model, create, and maintain an optimal data architecture that supports business intelligence reporting and analytic solutions for the university.

  • Assist with data management-related projects, including implementation of new data systems.

  • Understand and maintain WPI’s end-to-end ID generation process and identity management solution.

  • Provide platform support for integration and data management technologies like AWS, SnapLogic, and Informatica

  • Collaborate effectively with functional users and IT staff to create data collection and consumption plans that align with the university’s priorities.

  • Create mappings to move data from source systems into the enterprise reporting and analytics environment.

  • Provide on-going support for integrations.

  • Perform code reviews and code migrations.

  • Understand all university data privacy policies and ensure that solutions implement appropriate security controls and models.

  • Perform other duties as assigned.

  Minimum Requirements:

  • Bachelor’s degree in a technical discipline or equivalent experience.

  • Understanding of XML, JSON, APIs, and web calls.

  • Ability to write SQL scripts and procedures.

  • Ability to translate business functionality to technical requirements.

  • Ability to recommend and implement solutions in accordance with industry best practices.

  • Knowledge of AWS resources like Redshift are preferred.

  • Database and data warehousing experience is preferred.

  • Experience with analysis, design, development, testing, implementation of integration solutions using cloud integration/ETL tools and technologies, such as SnapLogic and Informatica is preferred.

  • Experience in MDM or Identity Management implementations preferred.

  • Excellent time management, organization, and planning skills.

  • Outstanding verbal and written communication skills, ability to work with diverse teams across all levels.

  • Higher education experience preferred.

  Please include a cover letter with a resume for consideration.

  FLSA STATUS

  United States of America (Exempt)

  WPI is an Equal Opportunity Employer that actively seeks to increase the diversity of its workplace. All qualified candidates will receive consideration for employment without regard to race, color, age, religion, sex, sexual orientation, gender identity, national origin, veteran status, or disability. It seeks individuals with diverse backgrounds and experiences who will contribute to a culture of creativity, collaboration, inclusion, problem solving, innovation, high performance, and change making. It is committed to maintaining a campus environment free of harassment and discrimination.

• About the company

  A WPI education has never been more relevant than it is today, because the demand for innovative thinkers who can solve problems on a global scale has never been greater.

Notice