Position Summary

　　Reporting to the Associate Director, Operational Initiatives, Sponsored Project Finance ("SPF"), the Business Systems Analyst will support and maintain Columbia's proprietary web-based data warehouse and application and other IT applications via coding, report writing and administrative assistance critical to the daily operations of SPF, with the objective of ensuring compliance with University policies, industry standards and sponsor terms and conditions. This position plays a key role as a technical resource and functional liaison between the Sponsored Project Finance team, University departments, the Finance Information Systems team, Application Service Provider and CUIT supporting the University's sponsored programs through configuration and development of the proprietary application.

　　Responsibilities

　　Works closely with Sponsored Project Finance, Application Service Provider and Information Technology to coordinate development activities, and respond to business needs by identifying system requirements and support opportunities for process improvement and system enhancementsActs as a technical resource to develop and write (i.e., code) business intelligence reports, dashboards, database tables, metrics and analysis tools that support the billing, reporting and collection of sponsored project fundingHelp document current business processes, and help clarify roles and responsibilities - recommend ongoing process improvements and have a sense of business process end to end ownershipWorks with department leadership to develop processing procedures and system modifications to meet their specificationsWorks to translate functional needs into technical specifications and engages with the Application Service Provider, Information Technology and vendors in the construction of the work unitsActively contributes to ongoing process improvement by assisting in the development and communication of policies, procedures and user support toolsCoordinates with and supports department leadership, business partners and users to troubleshoot issues and responds to system errors and failures, recreating issues in a test environmentEscalates incidents/issues to the next level of functional or technical system support as neededInterfaces with users to verify issue resolution, validate incidents and communicate progress to customers in a timely mannerServes as an administrator in leading technical troubleshooting/resolutions with current interfacing financial systems and the user-communityParticipates in the routine application of patches and fixesPerforms systems and report testing and validation, and collaborates with department and technical support to resolve related issues and errorsUses project management skills to identify, evaluate and recommend updates to the current business processes, application and reporting toolsDrafts specifications, informational materials and configuration documentation for technical support and user trainingPerforms other related duties and special projects as assignedHelp automate business process when possible and troubleshoot production issuesDevelop, document and help conduct end to end test scenarios and test procedures needed for product sign off after - system, DB and operating system upgrades, system enhancements, Disaster recovery testing, and other system related changes.Other duties as assignedMinimum Qualifications

　　Bachelor's degree in Computer Science or related field required.Minimum of four years related experience required.Preferred Qualifications

　　Related technical, functional and information systems experience preferred.Non-profit and/or research accounting knowledge a plus.Experience in higher education strongly preferred.Experience with process improvement preferred.Other Requirements

　　Excellent verbal and written communication skills.Excellent interpersonal skills with a proven ability to collaborate with a team.Excellent analytical and problem-solving skills.Extensive knowledge of financial applications and associated reporting tools.Strong working knowledge of ERP systems integration.Strong working knowledge of SAP Business Objects Web Intelligence or similar reporting and analysis tool (e.g., Cognos, Power BI, OBIEE and Tableau).Fluency in SQL and other similar languages with ability to become an advanced user in multiple languages rapidly, including C# and .NET.Proficient with the technical development of reports, dashboards, databases and analysis tools.Excellent organizational skills and attention to detail.Proficient with Microsoft Office Suite or related software.Proficient with or able to quickly learn systems and software used by the organization.Demonstrated ability to work in a high pressure, fast-paced environment required.Must be able to problem-solve and troubleshoot, in addition to having the ability to work independently in a dynamic team environment. Must be able to work well with all levels of employees, be flexible in nature, have sound judgment with an open and collaborative style that encourages teamwork and cooperation beyond the immediate team to the broader organization. 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.

　　Minimum Salary: 31200.00Maximum Salary: 31200.00Salary Unit: Yearly