Experienced CaseAware Administrator - Remote

The Company

Friedman Vartolo LLP is a rapidly growing New York based real estate and default services law firm with 200+ employees across six states. The firm prides itself not solely on its superior legal product, but also on its innovative approach to business and problem solving. We offer a fresh, fast-paced energy, with a startup vibe.

The Position

We are seeking a CaseAware Administrator. CaseAware is a third-party case management platform that allows for complex legal processes to be defined and regulated through SQL queries and a variety of automation mechanisms.

Responsibilities

• Coordinating with legal and administrative departments to understand their processes and tasks
• Designing, modifying, and maintaining processes and data systems within our case management software, CaseAware, to assist with and streamline those processes and tasks.
• Writing SQL queries on a complex database for the purposes of guiding the systems within our case management system.
• Identifying and addressing process and data issues through proper channels
• Designing, modifying, and maintaining intelligent legal document templates with complex logic and mark-up for rendering by the CaseAware document generation engine.
• Designing, modifying, and maintaining long-term reporting systems in SQL and PowerQuery.
• Providing urgent ad hoc SQL reports to users on demand.
• Auditing our case management software for data errors (duplicate entries, error-causing characters, missing data, etc.) and logic errors (processes being misdirected).
• Mastering how to manage our case management software.

Qualifications

• Intermediate knowledge of SQL, ideally the MySQL dialect. There will be technical questions in the interview.
• Creative problem solver.
• Must love data.
• Experience with Excel PowerQuery very much preferred.
• Interested to learn about our legal and business processes.
• Familiarity with Microsoft Office, especially Excel.
• Advanced computer skills.
• Excellent oral and written communication. Ability to translate computer-talk into layman's understanding.
• Programming experience in python considered an asset. If so, you can assist in other projects.
• Professional and courteous communication with our colleague, who are the users of the systems we design.
• Learning and understanding our business and law processes.
• Detail oriented, thorough.

Compensation/Benefits

We offer a compensation package that will be commensurate with experience and a competitive benefits package including medical, dental, vision, flex spending, 401k and gym/fitness membership reimbursement.

Location

Garden City office, NYC Office, or remote