Senior Integration Developer

Salem State University; Salem, Northern (MA, KY); Hybrid; USD 110,000 - 150,000; Full time

Job summary

Salem State University seeks a Senior Integration Developer to lead development, support, and monitoring of its data integration architecture. You will partner with the data warehouse admins and business owners to implement ETL strategies and ensure optimal warehouse operations.

This grant-funded role emphasizes strong programming and analytical skills and may require occasional evening/weekend work. The ideal candidate has extensive experience with data integration tools and scripting, plus a

Qualifications

• Bachelor's degree in CS, MIS or related field.
• At least five years of professional IT experience.
• At least five years with data integration and ETL tech (e.g., Jitterbit, Informatica) including custom-coded solutions.
• Experience writing and troubleshooting complex SQL queries and creating database views.
• Experience with database management and preparing data for integrations.
• Experience with scripting languages for batch processing or system administration.

Responsibilities

• Lead development, support, maintenance, and monitoring of Salem State’s data integration architecture.
• Collaborate with the data warehouse admins, IT, and business owners on ETL implementations.
• Ensure data warehouse and integration processes function optimally and support university needs.
• Provide guidance to other developers on data transformation and ETL strategies.

Skills

Programming

Analytical thinking

Problem solving

SQL scripting

Batch processing scripting

Education

Bachelor's degree in computer science, management information systems, or a related field

Tools

Jitterbit

Informatica

Job description

Overview

The Senior Integration Developer will lead in the development, support, maintenance, and monitoring of Salem State’s data integration architecture. As part of the Application and Integration Architect team, the Senior Integration Developer executes data integration and ETL strategies and assists other developers in doing so. To ensure success as an integration developer, candidates must have strong programming, analytical, and problem-solving skills. This position partners with the data warehouse and business systems administrators and with business owners on data transformation and ETL implementations. This position will also act as a resource to ensure that the data warehouse and integration processes at the university are functioning optimally and are supporting the needs of the university.

What you do at Salem State University matters. As a staff member, you’ll be part of an institution that is a proud Hispanic-Serving Institution and that serves one of the most diverse student bodies in Massachusetts. We believe in building a workplace culture that mirrors our values: inclusive, equitable and driven by a genuine desire to help people succeed. You’ll find professional development opportunities, a supportive team environment and work that connects directly to our students’ futures.

Please Note: This is a grant-funded position and continued employment is contingent upon ongoing grant funding.

Required Qualifications

1. A bachelor's degree in computer science, management information systems,or a related field
2. A minimum of five years of professional experience in an information technology environment
3. A minimum of five years of experience working with data integration and ETL technologies, such as Jitterbit, Informatica, or equivalent, including custom-coded solutions
4. Experience with writing and troubleshooting complex SQL queries and developing database views
5. Experience with database management, converting raw data into actionable information, and preparing data for data integrations
6. Experience with scripting languages in the context of batch processing or system administration scripting

Preferred Qualifications

1. Experience with SQL technologies such as SQL Server Management Studio (SSMS), SQL Server Reporting Services (SSRS), PowerBI, or equivalent database/SQL-based technologies
2. Experience with server operating systems in the context of managing system automation and file delivery processes (CRON, Task Schedule, sFTP)
   

Working Location

This is a hybridpositionin Salem, MA with some on-campus, in-person responsibilities,which may require occasional work on evenings and weekends.

Employment is contingent upon a completed background and CORI check satisfactory to the university.

This position is not eligible for H1B visa sponsorship.

EEO Statement

The university considers all qualified candidates without regard to race, color, religion, sex, age, national origin, disability status, veteran status, gender identity, sexual orientation, genetic information, pregnancy or pregnancy-related condition or any other characteristic protected by law.

ADA Statement

Salem State University complies with the Americans with Disabilities Act (ADA) to provide reasonable accommodation to qualified applicants and employees with disabilities. Foraccommodation information or requests please email [e-mail].

Recruitment Agencies

Salem State University does not partner with or accept candidates from outside staffing agencies. All hiring is managed directly by our internal Talent Acquisition team.