IT Business Analyst

Through its partnership with the City of New York, CUNY’s Building Performance Laboratory is hiring qualified energy management professionals to serve as on-site consultants and fill critical staffing capacity needs at the Department of Citywide Administrative Services’ Division of Energy Management (“DEM”). For background, DEM serves as the hub for energy management for City government operations. DEM develops the City’s annual utility energy budget; manages the City’s electricity, natural gas, and steam accounts; helps agency partners identify and pursue energy-saving opportunities; does energy efficiency and clean power generation projects across the City’s portfolio; and implements operations and maintenance best practices. Specifically, DEM is tasked with leading the City’s efforts to reduce emissions from City government operations 40 percent by 2025, 50 percent by 2030, and 80 percent by 2050 from baseline.

For this specific role, on behalf of DEM, CUNY BPL seeks to hire an IT Business Analyst to use their knowledge and experience, along with current industry standard processes, to review and interpret business process needs. The person will study the business requirements provided by teams and translate those into functional requirements that developers can code.

NYC residency may be required for continued employment. Immigration sponsorship is not available through this program. This is a hybrid position. Remote work arrangements are not a right or entitlement of employment and, as such, are discretionary and subject to operational needs unless otherwise provided by the CUNY Flexible Work Guidelines.

• Perform a variety of quality control checks to maintain and assure the accuracy and consistency of data in tracking systems
• Perform database SQL server queries and program data analysis as requested
• Write reporting requirement documents and create product specifications and technical mock-ups for new business intelligence tools to support decision-making and performance tracking
• Maintain existing dashboard reporting tools, identify enhancements, track, and promote usage
• Perform and/or manage user acceptance and regression testing
• Interview business stakeholders to gather detailed product requirements (scope, background, business case, etc.)
• Develop Business Requirements and User Stories to define business rules and objectives, current operational procedures, risk, input and output requirements, system access, etc.
• Translate Business Requirements into functional requirements by developing As-Is and To-Be process documentation, use case scenarios, data models, logic details, work instructions, etc.
• Create test case documents to facilitate quality assurance and user acceptance testing prior to product release
• Manage projects, including client interaction, developing project plans and supporting analytics offerings
• Work with internal staff and subcontractors to meet project objectives
• Other duties as assigned
  

The ideal candidate will bring the following skills and experience to this position:

• 4+ years of experience gathering projects requirements
• 2+ years of experience managing and planning projects
• 4+ years of experience in Office or Google Docs products
• Experience in querying data from various sources
• Experience in various user interfaces and interactions
• Experience in testing web applications and familiarity with testing tools and processes
• Demonstrated ability to work with databases and provide quantitative and graphical analyses
• Familiarity with data warehousing and business intelligence concepts

Desirable Skills:

• Fit/gap analysis and Business Requirements gathering and prototyping
• Relational database knowledge and hands on SQL Server
• Working knowledge of Azure DevOps or TFS (Team Foundation Server) or Agile/SCRUM software tools
• Expert use of Microsoft Office suite - creating project plans, Visio flowcharts, PowerPoint presentations, advanced Excel calculations and workbooks, etc.
• Excellent oral and written communication skills

The Research Foundation of The City University of New York (RFCUNY) was established as a not-for-profit educational corporation chartered by the State of New York in 1963. RFCUNY supports CUNY faculty and staff in identifying and obtaining external support (pre-award) from government and private sponsors and is responsible for the administration of all such funded programs (post-award).

RFCUNY stands between CUNY’s principal investigators (PIs) and the sponsors who support them and strives to fulfill its essential responsibilities to both groups. Working closely with individual PIs and Grants Officers on the campuses, RFCUNY oversees employment, accounting, audit, reporting, purchasing, and special responsibilities that include management of a planned giving program; liaison with governmental agencies and foundations; negotiation of agreements; facility construction and renovation; protection and commercialization of intellectual property; and compliance with applicable standards in research involving human subjects, animal care, environmental and radiological safety, and conflicts of interest.