Data Enterprise Applications Analyst

Socket.dev; Worcester (MA); On-site; USD 90,000 - 120,000; Full time

Job summary

Assumption University is seeking a Database & Enterprise Applications Analyst to manage the SQL Server environments and support enterprise systems including Ellucian Colleague ERP. You will ensure performance, security, and availability while delivering reporting and data extracts for multiple offices.

The role supports the migration from on-premises Ellucian Colleague to Ellucian SaaS and serves as a technical advisor to the Data Governance and Security Committee.

Qualifications

• 3–5 years of experience in database administration, preferably with Microsoft SQL Server.
• Strong proficiency with T-SQL and experience developing reports, queries, and data extracts.
• Familiarity with data governance and data security concepts, including access management and regulatory considerations such as FERPA.

Responsibilities

• Administer, monitor, and maintain the University's SQL Server database environments (installation, configuration, patching, backups, recovery, performance).
• Provide technical and functional support for Ellucian Colleague ERP and coordinate with functional offices.
• Design, develop, test, and maintain SQL-based reports, queries, and data extracts; support ad hoc reporting requests.

Skills

T-SQL

SQL Server

Performance tuning

Security management

Reporting

Education

Bachelor's degree in Computer Science, Information Systems, or related field

Tools

Ellucian Colleague

Evisions Argos

Job description

Description

Assumption University is accepting resumes for a Database & Enterprise Applications Analyst. Reporting directly to the Enterprise Applications Manager, this position is responsible for the administration, maintenance, and optimization of the University's SQL Server database environments and provides application and reporting support for the University's enterprise systems, including the Ellucian Colleague ERP.

The Database & Enterprise Applications Analyst ensures the performance, integrity, security, and availability of University databases while supporting the Enterprise Applications team in maintaining and enhancing the systems that serve students, faculty, and staff. In addition to core database administration duties, this position provides day-to-day support for Colleague, plays a significant role in SQL-based report development, and supports the University's rollout of Evisions Argos as a self-service reporting tool for end users. The University is currently on-premises with Ellucian Colleague and is planning a migration to Ellucian's SaaS environment; this position will play a key role in supporting that transition. This position also serves as a member of and technical advisor to the University's Data Governance and Security Committee.

The successful candidate will be a strong technical problem-solver with excellent communication skills, capable of balancing routine database administration with project work, ad hoc reporting requests, and evolving responsibilities in support of Assumption University's mission and values.

Duties include but are not limited to:

• Administer, monitor, and maintain the University's SQL Server database environments, including installation, configuration, patching, upgrades, backup and recovery, and performance tuning.
• Ensure database security, integrity, and availability, including managing user access, monitoring for anomalies, and supporting disaster recovery planning and testing.
• Provide technical and functional support for the Ellucian Colleague ERP, including troubleshooting, data maintenance, patching support, and coordination with functional offices.
• Support the University's planned migration of Ellucian Colleague from on-premises to Ellucian SaaS, including data validation, integration adjustments, and post-migration reporting continuity.
• Design, develop, test, and maintain SQL-based reports, queries, and data extracts for offices across the University; respond to ad hoc reporting and data requests.
• Support the rollout, administration, and ongoing maintenance of Evisions Argos, including developing DataBlocks and reports and assisting end users in adopting self-service reporting.
• Serve as a member of and technical advisor to the University's Data Governance and Security Committee, providing expertise on data security, access management, data quality, and the technical feasibility of proposed policies and standards.
• Implement data governance and security decisions adopted by the committee, including access controls, data classification measures, and related technical safeguards.
• Collaborate with Enterprise Applications staff and campus departments to gather reporting requirements and ensure data accuracy and consistency across systems.
• Document database configurations, procedures, and reporting solutions.
• Assist with data integrations between Colleague and third-party systems.
• Participate in projects, system implementations, and upgrades as assigned.
• Perform other duties and responsibilities as directed in support of the Office of Information Technology.

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. Sitting, standing, walking, and bending are required of this position. Use of a computer keyboard and computer screen for periods of time with close vision and the ability to adjust visual focus plus manual dexterity are required.

MENTAL DEMANDS:

The mental demands described 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 reading (documents), detailed work, confidentiality, language, math, reasoning, oral communications, written communications, customer contact, multiple concurrent tasks, constant interruptions, and performing calculations when necessary.

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.

Requirements

• Must be willing to contribute actively to the mission of the University and demonstrate respect for the Catholic and Assumptionist identity of Assumption University.
• Bachelor's degree in computer science, information systems, or a related field, or equivalent combination of education and experience.
• 3–5 years of experience in database administration, preferably with Microsoft SQL Server, including backup/recovery, performance tuning, and security management.
• Strong proficiency with T-SQL and experience developing reports, queries, and data extracts.
• Familiarity with data governance and data security concepts, including access management and regulatory considerations such as FERPA.
• Strong analytical and troubleshooting skills.
• Excellent verbal and written communication skills, including the ability to work with non-technical users to define reporting needs.
• Ability to handle confidential and sensitive data with discretion.
• Ability to work independently and collaboratively as part of a team.
• Willingness to take on new and evolving responsibilities as the University's enterprise systems environment changes.

Preferred Qualifications:

Experience supporting Ellucian Colleague or another higher education ERP.

Experience with Evisions Argos or similar reporting platforms (e.g., SQL Server Reporting Services, Informer).

Experience supporting a migration from on-premises systems to SaaS or cloud-hosted environments.

Experience participating in data governance, data security, or compliance initiatives.

Experience in a higher education environment.