A law firm is looking for a Financial Systems Analyst to join their team in NYC.Compensation: $110,000 - $120,000 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.
QUALIFICATIONS: - 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 AND/OR 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
#LI-ML1
24-02199