The salary of the finalist selected for this role will be set based on a variety of factors, including but not limited to departmental budgets, qualifications, experience, education, licenses, specialty, and training. The above hiring range represents the University's good faith and reasonable estimate of the range of possible compensation at the time of posting.
Reporting to the Director of Financial Reporting and Business Intelligence, the Senior Reporting Analyst is responsible for supporting the analysis, design and development, testing, and deployment of Reporting work units in SAP Business Objects Webi, PeopleSoft, the University data store, and related systems, including legacy reporting systems.
The Senior Reporting Analyst will work closely with representatives from diverse business functions across the University. Responsibilities also include data analysis and resolution of issues identified by users and tracked through the Service Now customer relationship management (CRM) tool. The successful candidate works collaboratively, utilizing 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:
Supports the analysis, design, development, testing, and deployment of work units in SAP Business Objects Webi, PeopleSoft Queries, the University data store, and related systems, including support for ad-hoc and Crystal reports hosted in the Business Objects and PeopleSoft financials platform.
Troubleshoots issues and responds to system errors and failures, recreating issues in a test environment to ensure the integrity of financial data;
Writes 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;
Populates knowledge base for future use within the Finance division;
Partners with Finance and Columbia University Information Technology (CUIT) departments to coordinate development activities, and respond to business needs;
Translates functional needs into technical specifications and engages with CUIT development teams in the construction of the work units.
Defines test plans and scripts to ensure functional design requirements are met.
Participates in routine upgrades, application of patches, and fixes by overseeing end-to-end functional testing.
Administers the overall development of solutions with the subject matter experts across CUIT Enterprise Reporting.
Performs other duties and special projects as assigned.
Bachelor's degree required
A minimum of four years of related technical system experience
Advanced degree or other professional certification;
Experience with PeopleSoft Financials or equivalent Enterprise-class Financial ERP system;
Experience with using/creating/maintaining PS Query in the PeopleSoft Financials environment;
Knowledge of SAP Concur Business Intelligence reporting;
Prior experience in providing Business Objects training;
Experience in higher education.
Experience with Business Objects (Webi reporting, universe design using UDT/IDT)/Crystal Reports authoring required. Hands-on SQL experience (free hand SQL, stored procedures, PL/SQL) using Oracle/MS-SQL server.
Knowledge of a range of finance and accounting processes including financial reporting, fund accounting, year-end, etc.
The successful candidate must be able to work well with all levels of management, both internally and externally, be flexible in nature, and have sound judgment with a collaborative style that fosters teamwork and cooperation beyond the immediate team to the broader organization.
Ability to work with changing priorities and with multiple projects required.
Demonstrated ability to work in a high-pressure, fast-paced environment required.
Demonstrated excellence in a variety of competencies including project management, teamwork, analytical thinking, and client/customer awareness required.
Excellent analytical, organizational, interpersonal, oral, and written communication skills, including a high level of attention to detail and active listening skills, are required.
Must be able to problem-solve and troubleshoot, in addition to having the ability to work independently in a dynamic team environment.
Demonstrated ability to effectively partner with a diverse group of administrators required.
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.
Equal Opportunity Employer / Disability / Veteran
Columbia University is committed to the hiring of qualified local residents.
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.