Manager, Financial Reporting
Columbia. University in New York
|Deadline||Open until filled|
|Date Posted||August 12, 2014|
Columbia University is one of the world's most important centers of research and at the same time a distinctive and distinguished learning environment for undergraduates and graduate students in many scholarly and professional fields. The University recognizes the importance of its location in New York City and seeks to link its research and teaching to the vast resources of a great metropolis. It seeks to attract a diverse and international faculty and student body, to support research and teaching on global issues, and to create academic relationships with many countries and regions. It expects all areas of the university to advance knowledge and learning at the highest level and to convey the products of its efforts to the world. Columbia is one of the top academic and research institutions in the world, conducting path breaking research in medicine, science, the arts, and the humanities. It includes three undergraduate schools, thirteen graduate and professional schools, and a school of continuing education. We are committed to attracting and retaining the best and brightest in the workforce to support our mission of excellence in higher education and research.
Reporting to the Director, Financial Reporting/FIS, the Manager, Financial Reporting is responsible for leading the analysis, design, development, testing and managing the deployment of financial and management reports. Responsibilities also include data analysis and resolution of issues identified by users and tracked through the Service Now customer relationship management (CRM) tool. The Manager, Financial Reporting will work closely with representatives from diverse business functions across the University. The successful candidate will utilize their education and experience with SQL and reporting packages to develop, support, and maintain an array of standard packaged reports as well as custom reports developed and maintained to stakeholder specifications.
Responsibilities include, but are not limited to:
Leads analysis, design, development, testing and deployment of work units in PeopleSoft, the Financial Data Store (FDS) and related systems, including both scheduled and ad-hoc reporting as well as for financial and management reports including Crystal Reports (including those hosted in a Business Objects platform), PS Queries, NVision, and SQR reports hosted in a PeopleSoft financials platform. Troubleshoots issues and responds to system errors and failures, recreating issues in a test environment to ensure integrity of financial data. Write SQL queries to extract, analyze and research data issues as reported by users. Escalates incidents to the next level of system support and provides technical assistance to Finance Service Center Analysts by analyzing the appropriate routing of system issues, questions and customer service requests via Service Now. Achieves agreed upon service level performance metrics by effectively troubleshooting and resolving incidents. Actively contributes to ongoing process improvement by assisting in the development and communication of policies, procedures and user support tools. Populates knowledge base for future use within the Finance division. Partners with Finance and Columbia University Information Technology (CUIT) to coordinate development activities, and respond to business needs. Translates functional needs into technical specifications and engages with Information Technology development teams in the construction of the work units. Defines test plans and scripts to ensure functional design requirements are met. Participates in the routine application of patches and fixes, overseeing end to end functional testing. Administers the overall development of solutions with the subject matter experts across Columbia University Information Technology (CUIT) Enterprise Reporting. Performs other duties and special projects as assigned.
Bachelor's degree required; advanced degree or other professional certification desirable. A minimum of five years related experience with at least three of those years experience in Oracle/SQL query writing/tuning and experience with Financial (Management) Reporting required. Experience in higher education is preferred. Knowledge in a range of finance and accounting processes including financial reporting, fund accounting, year end, etc. required. Demonstrated excellence in analytical thinking/problem resolution required. Must have experience with Business Objects/Crystal Reports/WEBI/other Enterprise-class BI platforms. Must possess excellent analytical, organizational, interpersonal, oral and written communication skills, as well as active listening skills and a high level of attention to detail. Must be able to negotiate issues, resolve problems and have strong influencing skills. Must have a passion for excellent customer service and commitment to exceptional quality. Strong proficiency in Microsoft Office required. As a member of the Financial Information Systems group, collaboration with subject matter experts both within the team as well as across the Finance Division and schools within the University is required.
Experience with PeopleSoft Financials or equivalent Enterprise-class Financial ERP system strongly preferred. Experience with using/creating/maintaining NVision, PS Query, and SQR reporting from a PeopleSoft Financials environment strongly preferred. Experience in a range of finance and accounting processes including financial reporting, fund accounting, year-end close, etc. preferred. Experience in higher education or other large, complex organization preferred. The successful candidate will be able to work well with all levels of management, both internally and externally, have sound judgment with a collaborative style that fosters teamwork and cooperation beyond the immediate team to the broader organization. Demonstrated ability to adapt to changing priorities and multiple projects in a high pressure, fast-paced environment required as are a commitment to excellent customer service and to delivering an exceptional quality product.
To be considered an applicant, all interested parties MUST apply through the Columbia University online employment application system. Paste the following quick link into your browser to access this position posting:
Columbia University is an Equal Employment / Affirmative Action Employer