Reporting to the Assistant Vice President for Finance & Controller, the Financial Systems Manager serves as the primary functional liaison between the Accounting Office, Information Technology Services, Oracle Support, and the College's managed-services partner, and works daily with staff in Accounting, Budget, Payroll, Procurement, Advancement, and academic and administrative departments across campus. The role blends accounting knowledge with hands-on system configuration, and suits a candidate who likes solving problems at the point where finance and technology meet.
Trinity College offers a comprehensive benefits package that includes medical, wellness, dental and vision, retirement savings with employer match, flexible spending and health savings accounts, disability and life insurance; paid leave and other paid time off benefits; tuition benefits for employees and their dependents; and a variety of other employer-sponsored and voluntary fringe benefit programs.
The anticipated annual base salary hiring range for this position is $80,300 to $124,300 per year, with final placement determined by experience, skills, qualifications, and internal equity considerations.
System administration
- Serve as the functional administrator for TrinCore Financials (General Ledger, Payables, Receivables, Cash Management, Fixed Assets, Expenses, Procurement) and EPM (Planning/Budgeting, Smart View).
- Design and maintain approval workflows; produce the system reports that support periodic access reviews and segregation-of-duties testing.
- Monitor scheduled processes, interfaces, and integrations; triage and resolve production issues; open and manage internal service requests and escalate to Information Technology Services or the managed-services partner as needed.
- Maintain configuration documentation, change logs, and the system administration knowledge base.
Chart of accounts and master data
- Own the chart of accounts: add, map, and retire segment values (fund, department, account, project, and other segments); maintain hierarchies, cross-validation rules, and reporting rollups.
- Maintain ledger setups, accounting calendars, journal sources and categories, and the cross-fund (intercompany) balancing rules.
- Set and enforce master data standards for suppliers, customers, banks, and fixed assets in partnership with the responsible offices.
Quarterly updates, testing, and enhancements
- Lead the quarterly Oracle Cloud update cycle: review release notes, assess impact, coordinate regression testing in the test environment, communicate changes to users, and sign off on production readiness.
- Gather requirements, configure, and test enhancements, new features, and process changes; manage migration from test to production.
- Coordinate environment refreshes and the annual update calendar with Information Technology Services and Oracle.
Reporting, data, and close support
- Build and maintain reports and dashboards in OTBI, BI Publisher, Financial Reporting Studio, and Smart View/Essbase, including budget-to-actual and management reports for leadership and trustees.
- Support month-end and year-end close: period open and close, allocation and revaluation processes, subledger-to-general-ledger reconciliations, and data extracts for the external audit.
- Design and maintain spreadsheet upload templates (FBDI, ADFdi) for journals, budgets, and master data; validate data integrity across modules.
- Develop additional self-service reports and training materials to support campus users.
Integrations
- Monitor integrations between TrinCore and campus systems, including the student information system, payroll/HCM, the advancement CRM, procurement and expense tools, banking and treasury, and endowment accounting and resolve issues that arise.
- Partner with Information Technology Services on integration design, file layouts, error handling, and reconciliation of interfaced data.
User support, training, and process improvement
- Provide functional support to finance users across campus; manage the support queue to agreed response standards.
- Develop and deliver training sessions, job aids, and documentation; onboard new users.
- Identify automation and process-improvement opportunities within the Accounting Office and lead small projects to deliver them.
- Represent the Accounting Office on ERP governance and change-control groups.
Controls, audit, and compliance
- Maintain system-based internal controls (change management, approval workflows) and produce supporting evidence for the external audit and internal reviews.
- Ensure configuration supports GAAP fund accounting and the College's restricted gift, endowment, and grant reporting requirements.
- Perform other duties as assigned by the Assistant Vice President for Finance & Controller.
Required
- Bachelor's degree in accounting, finance, information systems, business administration, or a related field, or an equivalent combination of education and experience.
- Minimum of five years of progressively responsible experience administering or supporting an enterprise financial system.
- Working knowledge of generally accepted accounting principles and the general ledger close process; understanding of chart-of-accounts design, subledger accounting, and approval workflows.
- Advanced proficiency in Excel.
- Experience testing and deploying system updates and enhancements, including writing test scripts and coordinating user acceptance testing.
- Strong analytical and troubleshooting skills, with the ability to explain technical issues clearly to non-technical colleagues.
- Ability to manage competing priorities and meet close, update, and audit deadlines with a high degree of accuracy.
Preferred
- Hands-on work with Oracle Fusion Cloud ERP Financials (configuration, security, and quarterly updates).
- Experience in higher education or nonprofit fund accounting, including restricted gifts, endowment, and grant reporting.
- Experience with Oracle Cloud EPM (Planning), Essbase, Financial Reporting Studio, Enterprise Data Management (EDMCS), or Oracle Integration Cloud.
- Experience with an ERP implementation or conversion (for example, from PeopleSoft) and post-go-live stabilization.
- Demonstrated experience building and maintaining reports in OTBI, BI Publisher, and/or Smart View.
Oracle Cloud Financials certification
Knowledge, skills, and abilities
- Knowledge of the Oracle Cloud security model (roles, data access sets, approval rules) and of how configuration choices affect accounting results and reporting.
- Ability to read and interpret Oracle release notes and translate them into test plans and user communications.
- Skill in documenting processes and configurations so that others can follow and audit them.
- Service orientation: patience and clarity when supporting users with varied technical comfort, from accountants to department administrators.
- Sound judgment and discretion with confidential financial, payroll, and donor information.
- Project management skills: scoping, sequencing, and finishing work on a calendar driven by close, quarterly updates, budget season, and the audit.
- Collaborative working style with Information Technology Services, vendors, and consultants, and the initiative to work independently once direction is set.
- Commitment to continuous learning as Oracle Cloud functionality evolves.