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. To apply, visit: About WPI
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. Diversity & Inclusion at WPI
WPI is committed to creating an inclusive workplace where everyone feels valued and respected; a place where every student, faculty and staff member can be themselves, so that they can study, live, and work comfortably, to reach their full potential, and make meaningful contributions in order to meet departmental and institutional goals. WPI thrives on innovative practice and welcomes diverse perspectives, insight, and people from diverse lived experiences, to enhance the community environment and propel the institution to the next level in a competitive, global marketplace.
