CURRENT OPPORTUNITIES

• Job Type: Officer of Administration
• Regular/Temporary: Regular
• Hours Per Week: Full-time
• Salary Range: $90,000-$100,000

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 enhancements
• Acts 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 funding
• Help document current business processes, and help clarify roles and responsibilities – recommend ongoing process improvements and have a sense of business process end to end ownership
• Works with department leadership to develop processing procedures and system modifications to meet their specifications
• Works to translate functional needs into technical specifications and engages with the Application Service Provider, Information Technology and vendors in the construction of the work units
• Actively contributes to ongoing process improvement by assisting in the development and communication of policies, procedures and user support tools
• Coordinates with and supports department leadership, business partners and users to troubleshoot issues and responds to system errors and failures, recreating issues in a test environment
• Escalates incidents/issues to the next level of functional or technical system support as needed
• Interfaces with users to verify issue resolution, validate incidents and communicate progress to customers in a timely manner
• Serves as an administrator in leading technical troubleshooting/resolutions with current interfacing financial systems and the user-community
• Participates in the routine application of patches and fixes
• Performs systems and report testing and validation, and collaborates with department and technical support to resolve related issues and errors
• Uses project management skills to identify, evaluate and recommend updates to the current business processes, application and reporting tools
• Drafts specifications, informational materials and configuration documentation for technical support and user training
• Performs other related duties and special projects as assigned
• Help automate business process when possible and troubleshoot production issues
• Develop, 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 assigned

Minimum 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.