Financial Systems Analyst

Teachers College, Columbia University; New York (NY); Hybrid; USD 78,000 - 85,000; Full time

Job summary

Teachers College, Columbia University seeks a Financial Systems Analyst to support financial systems including Banner Finance, Emburse Enterprise, and Unimarket. You will process daily and month-end uploads as part of the close process and collaborate across Finance, Accounting, Budget & Planning and TCIT.

The role requires 2+ years of ERP experience, strong Excel skills and ability to train end users. Hybrid work arrangement offered within the NYC area.

Qualifications

• Bachelor's degree in Accounting, Finance, Information Systems, Computer Science, Business Administration or closely related field.
• 2+ years’ experience working with financial or accounting systems.
• Experience supporting ERP systems including administration, end-user support, testing and troubleshooting.
• Knowledge of General Ledger, AP, AR,Purchasing, Budget and Payroll processes.
• Strong analytical, troubleshooting and communication skills.
• Proficiency in Microsoft Excel and Office Suite.

Responsibilities

• Provide customer support for financial systems and manage user access.
• Process ad-hoc and month-end financial system uploads.
• Assist with system training and documentation.
• Maintain Banner Finance structures and support month-end close.
• Support cross-functional meetings with Finance, Accounting, Budget & Planning and TCIT.
• Participate in system testing and implementation of updates.

Skills

ERP systems

End-user support

Data analysis

Excel

Communication

Team collaboration

Education

Bachelor's degree in Accounting/Finance/IS

Tools

Banner Finance (Ellucian)

Emburse Enterprise

Unimarket eProcurement

Job description

Posting Summary

The Office of the Controller at Teachers College, Columbia University, is seeking a Financial Systems Analyst who will be responsible for providing administrative support on key financial systems, including Ellucian Banner Finance, Emburse Enterprise expense reimbursement, and Unimarket eProcurement solutions. In addition, this position is responsible for processing daily and monthly financial system uploads as part of the month-end close process.

Posting Summary

The Office of the Controller at Teachers College, Columbia University, is seeking a Financial Systems Analyst who will be responsible for providing administrative support on key financial systems, including Ellucian Banner Finance, Emburse Enterprise expense reimbursement, and Unimarket eProcurement solutions. In addition, this position is responsible for processing daily and monthly financial system uploads as part of the month-end close process.

Job Summary/Basic Function

Under the supervision of the Financial Systems Assistant Manager, and as part of a three-person team, the Financial Systems Analyst will support the cross-functional relationship between the Finance, Accounting and Budget & Planning Offices and the Teachers College Information Technology (TCIT) office for multiple financial systems that store and process financial data. The Financial Systems Analyst will provide customer support to financial systems end users, assist with various operational tasks, including maintaining systems, ensuring accurate and timely data entry in various financial systems, and contributing to the College’s long-term goals and vision by demonstrating professionalism and excellence in pursuit of best-in-class customer service and execution.

Characteristic Duties And Responsibilities

• Financial Systems Customer Support:
• Update the delegation of authority, including transaction and signatory routing rules for budget, expense reimbursement, and purchasing approval levels within Banner Finance, Emburse Enterprise, and Unimarket eProcurement solutions systems
• Process ad-hoc and month-end financial system transaction uploads
• Support financial system end users, including granting users access to departmental budgets; monitoring weekly payroll-finance interfaces and resolving issues; serving as a liaison between end users and TCIT; and troubleshooting system errors
• Assist with the training of end users on financial systems, provide technical support, and develop and update training materials
• Financial Systems Operations:
• Maintain the financial system structural accounting elements in Banner Finance
• Assist with monthly and year-end financial system closings
• Provide support and assist with maintaining the Controller's Office website
• Assist with various financial system projects and initiatives
• Participate in financial systems testing for new patch releases, updates and upgrades to modules and third-party system integrations, and assist with the implementation of required changes
• Participate in cross-functional Human Resources, Payroll and TCIT team meetings
• Other duties as assigned

Minimum Qualifications

• Bachelor's degree in Accounting, Finance, Information Systems, Computer Science, Business Administration or a closely related field
• 2+ years’ experience working with financial or accounting systems
• Understanding and experience supporting Enterprise Resource Planning (ERP) systems, including system administration, end-user support, configuration, testing, troubleshooting, or business process improvements
• Working knowledge of accounting and financial operations, including General Ledger, Accounts Payable, Accounts Receivable, Purchasing, Budget Management and Payroll processes
• Demonstrated analytical, troubleshooting, and problem-solving skills, with the ability to identify issues, recommend solutions, and manage multiple priorities in a fast-paced environment
• Strong interpersonal, written, and verbal communication skills, with the ability to communicate effectively with both technical and non-technical stakeholders
• Demonstrated proficiency in Microsoft Excel and Microsoft Office Suite, including the ability to analyze data, prepare reports, and maintain documentation.
• Ability to work collaboratively across functional areas while managing multiple priorities and meeting established deadlines
• Ability to plan, deliver effective training sessions for diverse audiences

Preferred Qualifications

• Understanding of Linux, relational database scripting and reporting (Oracle SQL), application support, and information systems
• Experience with Banner (Ellucian) ERP software, Unimarket eProcurement solutions, and/or Emburse Enterprise expense management software

Salary Range

$78,000 - $85,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.