Business Analyst at City of New York in Manhattan, NY

Summary: The City of New York is dedicated to promoting the financial health and integrity of its government. The Business Analyst will work with the Bureau of Asset Management on IT initiatives, documenting business processes, implementing management plans, and reporting on project status and risks. Responsibilities: - Facilitate and capture business/technical requirements from existing systems for modernization - Deliver elements of system design migration rules, business rules, wireframes, or other detailed deliverables - Ensure project priorities are clearly communicated and understood - Identify opportunities to improve enterprise systems and business processes and help drive solutions - Serve as a liaison between business users and technical team, providing clear communication, translate technical jargon into business terms - Utilize SQL to extract, manipulate, and analyze large datasets from various databases, ensuring accurate and timely information for business decision-making and reporting - Leverage Power Query to cleanse, transform, and integrate data from multiple sources, creating efficient and automated data workflows for reporting and analysis Required Qualifications: - A baccalaureate degree from an accredited college including or supplemented by 24 semester credits in computer science or a related computer field and one year of satisfactory full-time computer software experience in computer systems development and analysis, 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 '1' above; or - Education and or/or experience equivalent to '1' or '2' above. College education may be substituted for up to two years of the required experience in '2' above on the basis that 60 semester credits from an accredited college is equated to one year of experience. In addition, 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 '1' above Preferred Qualifications: - Experience with multiple asset class and the investment financial space - Familiarity with .Net Code, SQL Data Base stored procedures and views - Experience with technology that supports multiple asset classes and functions in the financial services and investment space - Track record in re-engineering processes via the creation and implementation of technology tools - Proficiency in Microsoft Office 365 suite - Proficiency in storing, querying and manipulating data in MS SQL Server (SQL, Stored Procedures, Triggers, SSIS) is desired - Experience using Power Bi and Power Query Required Skills: SQL, Power Query, .Net Code Important Skills: Microsoft Office 365, MS SQL Server Nice-to-Have Skills: Business Analysis, Process Re-engineering, Data Manipulation, Communication Skills Benefits: Public Service Loan Forgiveness