Financial Systems Analyst - New York, United States - AMS Staffing Inc.
Description
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