Location: New York,NY, USA
Job Title: Financial Systems Analyst
Location: New York City
Work Environment: Hybrid Work Week
Salary: $130K - $150K + Bonus, Top Shelf Benefits
Term: Full-time
3rd Party C2C/Transfer: No
Referral Fee: $500 - Refer qualified colleague, friends, or family.
The Financial Systems Analyst role is responsible for supporting the accounting applications and associated systems, including but not limited to, time entry, cost recovery, notification and financial reporting. In addition to the accounting system administration and support, the role will develop and execute ad hoc queries, custom reports, data workflow processes, etc.
Essential Duties & Responsibilities
Provide technical and application support to users of financial application
Detect and correct cost recovery upload errors
Build, optimize, deliver, and support new and existing reports and data visualization dashboards using Power BI and EDI based on requirements from functional expert/business owners
Assist in designing reports, solutions, and processes that increases optimization when possible
Develop data structures, SQL Views, stored procedures, and functions as needed for reporting/dashboard
Develop and support SSRS, Power BI Reports and dashboards to meet business needs
Generate standard and ad hoc reports via SQL and Reporting Services
Customize front end Elite 3E reports and metrics and delivering to the specifications required
Tracks, monitors, evaluates, and optimizes reporting and dashboards based on feedback from end-users.
Experience & Competencies
Experience working with accounting software required, experience with Elite 3e preferred
Strong SQL skills with proficiency in SQL development, SSRS and Power BI Tools are required
Ability to learn general functional and technical aspects of firm s Financial applications whenever required
Excellent analytical skills with the ability to communicate results
Strong interpersonal skills required to communicate with all other IT members, members of the firm and clients. Must have customer service attitude and ability to work well with other groups
Ability to work efficiently, independently, and effectively under pressure
Strong organizational skills, capability to schedule and coordinate multiple activities in results-oriented environment.
Must have customer service attitude and ability to work well with other groups
Superior understanding of the firm s goals and objectives, with demonstrated ability to apply technology in solving business problems.
Highly available and responsive to occasional after-hours issues, as the firm operates on a near 24x7 basis.
Education & Experience
College degree required
3+ of experience in a corporate IT role, preferably supporting and customizing financial systems.
Solid technical foundation and strong analytical skills with the ability to troubleshoot.
Experience with Microsoft SQL Server 2016 or higher is preferred.
Familiarity with Query tools and SQL Server Reporting Services
Extract Transform Load (ETL)
Knowledge of relational databases required.
XML experience preferred.
Advanced report writing experience using tools such as SQL Server Reporting Services (SSRS), Power BI, etc. required
Experience with core financial software applications, such as: Elite 3E, ChromeRiver, and Xcelerate strongly preferred
Experience with business and technical requirements analysis, business process modeling/mapping, methodology development, and data mapping required