Posting Summary:
Teachers College, Columbia University, is seeking an Integration and Automation Engineer to help modernize and streamline our enterprise application ecosystem. In this role, you will design and build integrations, automations, and custom solutions that connect core systems, improve data flow, and simplify business processes across the College. You’ll work closely with both technical teams and campus partners to translate real-world needs into secure, maintainable solutions, while also managing vendor platforms and contributing to long-term technology strategy. This is a hands-on, high-impact role for someone who enjoys ownership, problem-solving, and shaping how enterprise systems work together in a mission-driven higher-education environment.

Job Summary/Basic Function:
The Integration and Automation Engineer is responsible for designing, developing, and optimizing system integrations, automations, and custom solutions across Teachers College’s enterprise applications and data platforms. This role partners closely with technical and non-technical stakeholders to evaluate business processes, translate requirements into secure and maintainable technical solutions, and implement tools that streamline operations and support institutional goals. The position also manages vendor software and in-house enhancements, assesses technology platforms for long-term alignment with College objectives, and provides clear, timely communication on project progress and outcomes. The role requires a high degree of independence, ownership of work, and demonstrated initiative, creativity, and project-level leadership.

CHARACTERISTIC DUTIES AND RESPONSIBILITIES:

• Design and implement technical solutions using both vendor-provided and custom-developed software.
• Maintain and enhance in-house and third-party systems to ensure reliability and performance.
• Diagnose and resolve system or data issues reported by users, providing clear and timely support. 
• Gather, interpret, and document requirements from college offices, ensuring a clear understanding of their data and processing needs. Analyze those needs, propose and evaluate solution options, and provide project-level leadership when appropriate.
• Produce clear technical and functional documentation to support designs and decisions.
• Manage vendor relationships and coordinate vendor support activities.
• Communicate issues clearly and work with vendors and campus stakeholders to resolve them.
• Install, test, and validate software updates, upgrades, and patches to maintain system stability and security.
• Provide technical guidance and training to campus offices, supporting their use of both departmental and institutionally managed software.
• Assist in optimizing data retrieval and reporting to ensure efficient and accurate insights.
• Develop and maintain standards and documentation for data, software development, and systems management.
• Identify and correct data and code errors, troubleshoot system and database performance issues, and implement appropriate security measures to protect data integrity and access.

Various other functions:

• Stay current with emerging technologies and best practices to continuously improve systems and processes.
• Maintain and expand technical skills to remain proficient in relevant tools, languages, and platforms.
• Foster collaborative relationships with other users of vendor software.
• Assist in mentoring junior programming staff, providing guidance and training.

Minimum Qualifications:

• Bachelor's Degree
• 5+ years of experience designing, developing, and implementing system integrations, automations, or related applications
• Experience with relational databases and SQL, preferably Oracle
• Experience working with an iPaaS (Integration Platform as a Service) system
• Hands-on experience with procedural programming for database, integration, or automation tasks
• Experience using Linux from the command line, including developing shell scripts
• Strong analytical, technical, and communication skills.

Preferred Qualifications:

• Experience leading projects.
• Experience in higher education.
• Experience with any of the following systems or languages:
• Ellucian Banner
• Workato
• Oracle APEX
• PL/SQL

Salary Range:

$110,000 - $125,000

Work Modality:

Hybrid

Competitive Compensation and Benefits 

The salary range reflects the College’s good faith and reasonable estimate of the compensation for the position at the time of the job posting.  Salary decisions are dependent on several factors including but not limited to market and organizational considerations, experience, and qualifications of a selected candidate as well as internal and external equity.

Our benefits contribute significantly to the total compensation package that includes medical, dental, vision, and supplemental insurance plans; flexible and hybrid work schedules; tuition remission; life insurance; short and long-term disability insurance; an exceptional employer retirement matching program; health savings accounts (HSA), flexible spending accounts (FSA), Public Service Loan Forgiveness eligibility, and a robust Employee Assistance Program (EAP).

Hybrid/Remote

Teachers College maintains a hybrid work environment, which provides employees with flexible work arrangements while ensuring we preserve the important aspects of our unique in-person college-campus culture. Depending on role and business needs, colleagues will either work onsite or in a hybrid model (a combination of in-office and virtual days). Employees are expected to live within a 150-mile radius of the College.