Systems Analyst

The Systems Analyst supports the health, security, and reliability of the College’s server applications and maintains a hybrid application portfolio spanning self-hosted and SaaS-delivered systems. This role integrates, customizes, and enhances database and web applications to meet the evolving needs of College departments, working closely with vendors, campus stakeholders, and teammates to implement, configure, and support both new and existing technologies., * Monitors system health and applies upgrades and patches as necessary to keep applications current and protected.

• Diagnoses and resolves performance issues to minimize disruption to College operations.
• Evaluates the impact of new features and application changes on College computing resources before deployment.
• Safeguards system security, stability, and performance.
• Documents processes and configurations to preserve institutional knowledge.
• Participates in weekly, team-shared, on-call rotation to investigate and resolve system outages and issues if needed.
• Provides technical support for a portfolio of self-hosted applications-including open- source, commercial off-the-shelf (COTS), and internally developed systems-as well as Software-as-a-Service (SaaS) solutions, including but not limited to Microsoft SQL Server, WordPress, Moodle, Evisions MAPS, Ellucian Banner, and other enterprise applications.
• Partners with vendors and College staff to evaluate, implement, and configure new technologies.
• Configures applications and related tools to support integration and ongoing maintenance.
• Designs, develops, and tests application code to integrate and customize the College and application portfolio.
• Develops and optimizes SQL queries, stored procedures, functions, triggers, and views; designs database tables and indexes.
• Plans and performs data conversions, imports, exports, and migrations.
• Ensures data integrity, security, and system performance.
• Consistently strives to increase level of expertise on application software and security.
• Participates in software evaluations and assessments of new technologies.
• Works collaboratively with other Information Services staff.
• Connects with industry peers to forge mutually beneficial relationships.
• Serves as assigned on College Committees.

Bachelors degree in Computer Science or a related discipline, or equivalent professional experience.

Experience

• Experience working with relational database systems such as Oracle, MS SQL Server, MySQL, or equivalent
• Experience supporting solutions hosted on Microsoft Windows and Unix/Linux environments and connecting to remote environments.
• Experience working with source control systems, configuration management software, or Docker/Kubernetes is desired.
• Experience designing, developing, and maintaining reports using SQL Server Reporting Services (SSRS), Power BI, Argos, Cognos, or other enterprise reporting tools to support business and operational reporting is preferred.
• Experience with system implementation and upgrades.

Skills and Knowledge

• Commitment to equity and inclusion, and serving the needs of a culturally and educationally diverse community.
• Must have strong analytical, problem-solving, systematic thinking, and organizational skills.
• Ability to manage multiple projects and priorities independently.
• Proficient in at least one programming language, applied to integrating, customizing, and extending existing applications.
• Excellent written and oral communication skills.
• Knowledge of application integration and APIs.
• Familiarity with developing custom applications, database solutions, and system integrations using Microsoft SQL Server is desired.

Bates College offers competitive salaries, excellent benefits (health, dental, 9% retirement contribution with potential for an additional 3% match, sick leave, 24 days of vacation, 2 personal days, 13 paid holidays, dependent care subsidy, free parking, access to library and athletic facilities & more), and a supportive, collegial environment in a drug and smoke-free workplace.

Hiring Range: The hiring range for this position is $72,352 to $78,165. Placement within the range depends on experience and other factors.

Bates is internationally recognized as a leading liberal arts college, attracting 2,000 students from across the U.S. and around the world.

Since 1855, Bates has been dedicated to educating the whole person through creative and rigorous scholarship in a collaborative residential community. Committed to opportunity and excellence, Bates has always admitted students without regard to gender, race, religion, or national origin.

Cultivating intellectual discovery and informed civic action, Bates prepares leaders sustained by a love of learning and zeal for responsible stewardship of the wider world. Bates engages the forces - intellectual trends, demographic changes, and technology - that are transforming higher education and the world into which our students graduate.

Bates has highly competitive admissions, graduates over 90 percent of its entering students, and more than half of its alumni earn graduate degrees. Bates employs 200 faculty members and 550 staff.

The college is proud of deep roots in the Lewiston/Auburn community, Maine’s second-largest urban area with a population of approximately 65,000. Bates is located on a beautiful, 133-acre, traditional New England campus in Lewiston, an emerging city with an entrepreneurial climate, a lively arts scene, and a dynamic business community. Bates is 35 miles north of Portland, 140 miles north of Boston, and 350 miles north of New York City.