Data & Integration Specialist

BASIC PURPOSE :

Assumption University is seeking an individual to design, develop, and maintain data integration, reporting, and analytics solutions that support Assumption University's operational, regulatory, and strategic needs. This role ensures data accuracy, security, and accessibility by managing ETL processes, database systems, and business intelligence tools. Through collaboration with stakeholders, the position translates complex data into actionable insights, enabling informed decision-making across the institution.

KEY RESPONSIBILITIES :

Data Integration & ETL

• Design, develop, and maintain ETL processes using SQL Server Integration Services (SSIS)
• Create and optimize data pipelines to ensure efficient, secure, and reliable data movement across systems
• Monitor and troubleshoot integration workflows, ensuring data integrity and timely delivery
• Implement error handling and logging mechanisms within SSIS packages
• Responsible for all new and existing integrations between enterprise applications and systems

Database Management

Data Governance & Quality

Process Optimization & Documentation

Business Process Analysis

API Development & Integration

Reporting & Business Intelligence

REQUIRED QUALIFICATIONS :

Technical Skills

Professional Experience

Core Competencies

PREFERRED QUALIFICATIONS

PHYSICAL DEMANDS : The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this position. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

This position requires :

MENTAL DEMANDS : The mental demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this position. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions. Examples of mental demands include :

ABOUT ASSUMPTION UNIVERSITY :

St. John Paul II wrote : "Man's creation by God 'in his own image' confers upon every human person an eminent dignity; it also postulates the fundamental equality of all human beings." Assumption University recognizes the essential contribution of a diverse community of students, staff, and faculty and condemns all forms of harassment, discrimination, and disrespect.

As such, and in compliance with the requirements of federal law and / or the laws of the Commonwealth of Massachusetts, Assumption University prohibits discrimination on the basis of race, color, national origin, religion, disability, age, veteran status, marital status, gender, gender identity, sexual orientation, and pregnancy, as well as other legally protected status, in admission to, access to, treatment in, or employment in its programs and activities, except where such conditions may constitute bona fide qualifications for the programs or activities in question.

Equal Opportunity Employer

This employer is required to notify all applicants of their rights pursuant to federal employment laws. For further information, please review the Know Your Rights notice from the Department of Labor.