COMPUTER ASSOCIATE (SOFTWARE)

The Department of Financial Planning & Analysis (DFPA) is seeking a Computer Associate (Software), L2 to work in the Budget Control and Coordination (BCC) division. The BCC division is responsible for specialized technical support, software maintenance, and report development of our financial system. The implementation of the Hyperion System has increased accuracy and transparency of reporting. Key Responsibilities Assist in managing the Authority's Operating and/or Capital budget, including technical budgetary exercises. Assist in evaluating technical proposals and estimating the impact of management decisions and policies. Provide technical assistance in the preparation of the Authority's Operating, Revenue and/or Capital Budgets, consistent with the priorities of the Authority's Executive Management. Identify and recommend solutions to operational issues having an impact on the Authority. Generate ideas to improve existing programs, find new ways to make Budget exercises more efficient. Maintain MS Access and SQL Databases including updating and creating queries to help the team perform ad‑hoc analysis for upper management. Responsible for running Oracle processes for the bi‑weekly payroll to post in GL. Maintain Oracle Hyperion planning. Work with Hyperion to import and extract data; create and update Hyperion calculations, forms, and reports to assist the team with Budgetary exercises and analysis. Maintain and troubleshoot issues with ODI integrations between Hyperion and other systems. Provide technical support and SmartView assistance. Maintain integrity of the system by doing routine reconciliation of system data. Create technical training material for inner and outer departments on technical processes as well as doing live training. Have experience working with Visual Basis and SQL along with Microsoft Office (Word, PowerPoint, Access, Excel, Outlook). Maintain department web pages. Provide and convert data from Hyperion to be loaded into the U.S. Department of Housing and Urban Development (HUD) – Energy and Performance Information Center (EPIC) reporting system. Minimum Qualifications A baccalaureate degree from an accredited college including or supplemented by 24 semester credits in computer science or a related computer field and at least one year of satisfactory full‑time computer software experience in computer systems development, applications programming, database administration, maintenance and support, systems programming, data communications, mainframe development, mobile development, web development and design; OR A four‑year high school diploma or its educational equivalent and five years of satisfactory full‑time computer software experience as described in item 1 above; OR Education and/or experience equivalent to items 1 or 2 above. College education may be substituted for up to two years of the required experience in item 2 on the basis that 60 semester credits from an accredited college equals one year of experience. Additionally, 24 semester credits from an accredited college or graduate school in computer science or a related field, or a certificate of at least 625 hours in computer programming from an accredited technical school (post‑high school), may be substituted for one year of experience. However, all candidates must have at least a four‑year high school diploma or its educational equivalent and at least one year of satisfactory full‑time experience as described in item 1 above. Preferred Skills Hyperion Planning & Essbase: ability to write and maintain Calc Scripts, Business Rules, and batch scripts. Familiarity with automation tools that streamline repetitive tasks. Proficiency with Smart View (the Excel‑based interface), Financial Reporting Studio, and managing metadata hierarchies. Experience with data integration tools to pull information from various ERP systems. SQL Infrastructure & Database: understanding of relational databases (SQL database) essential for querying, troubleshooting, and backend management. Advanced querying, data transformation and structured logic using composite expressions, CTEs, and complex filtering. VBA for Microsoft Access: programmatic manipulation of Access‑specific objects such as Forms, Reports, Controls, and the Application object. Event controls (On‑Open, On‑Load, On‑Activate, On‑Current) and dynamic SQL for executing data‑driven operations. Core Web Page: C# or Visual Basic proficiency, ASP.NET Core, Entity Framework Core for efficient data access and performance tuning. Strong analytical skills, interpersonal, managerial and organizational skills. Benefits Choice of medical coverage plans. Deferred compensation plans. Defined pension benefit plan as a member of the New York City Employees’ Retirement System (NYCERS). Equal Opportunity Employment The City of New York is an inclusive equal opportunity employer committed to recruiting and retaining a diverse workforce and providing a work environment free from discrimination and harassment based upon any legally protected status or characteristic, including but not limited to sex, race, color, ethnicity, national origin, age, religion, disability, sexual orientation, veteran status, gender identity, or pregnancy. Salary $83,330.00 – $115,982.00 #J-18808-Ljbffr City of New York