Applications Analyst in New York, NY at Open Systems Technologies

Date Posted: 1/5/2020

Job Snapshot

Job Description

A leading law firm is seeking an Applications Analyst to join their team in New York, NY.


  • Create, refactor, validate and deploy custom desktop and web applications
  • Engage on projects to refine requirements from an application perspective
  • Install, customize, upgrade, test and deploy third party vendor applications
  • Provide second level IT support to user community for various custom and vendor applications
  • Assist in the creation of documentation to support current and future applications


  • Must have a Bachelor’s degree in Computer Science, or related field
  • Strong programming capabilities in SQL Server 2012 and above – Stored Procedures, Functions, Triggers, Views, Transactions, Data Flow with strong understanding of SQL databases – querying data, troubleshooting, Indexing, etc.
  • Strong Problem-Solving skills – dig into the available SQL Database resources (tables or views) and mine the data required for reports or debug them by identifying data related solutions
  • Experience with debugging and Performance Tuning of SQL code, Stored Procedures, Functions and Indexes
  • Ability to build and maintain BI Solutions and dashboards using the Microsoft BI Stack
  • Proficiency in excel with excellent understanding of advanced formulas, pivot tables and writing/editing custom macros in VBA
  • Experience with Client Reporting – Developing User friendly reports based on User requirements to meet Client expectations; Should be able to perform Adhoc reporting and exploratory data analysis upon request
  • Expertise in SQL Reporting Services (SSRS/SSIS) and Crystal Reports
  • Strong communication skills in terms of Technology as well as Business Communication
  • Experience with Legal Management System(s) and DB2 is plus
  • Experience with Tableau/Power BI is a plus
  • Experience with third party and custom Microsoft .Net (ASP.Net, C# and VB.Net) application development is plus
  • Technical experience with various applications commonly used in a legal or professional environment is a plus
  • Additional training/certification in relevant area of study is a plus
Job keywords: