Business Systems Data Analyst

Business Systems Data Analyst
Full Time

Job Description

The Business Systems Data Analyst will be responsible for overseeing the Firm's Database environment, Business Intelligence platform and Data Warehouse.

This position, reporting directly to the IS Applications Director, will ensure that all critical data assets are stable, healthy, secure and continually improved. In addition, the BSDA will own the overall Data Architecture and contribute to the maintenance and development of systems integrations, reports and dashboards.


  • Work closely with the Practice and Business Systems Management Team to develop and maintain a Data Strategy roadmap.

  • Meet with Subject Matter Experts, Product Managers and Application Developers to gather business requirements.

  • Design, model and develop across both Relational Databases and Data Warehouse.

  • Develop SQL views, stored procedures and tables.

  • Maintain, monitor, upgrade and secure the SQL Server platform in partnership with established vendor.

  • Support, upgrade and maintain the Microsoft Reporting Server portal.

  • Develop ETL (extract, transform and load) processes to populate Data Marts and Warehouses.

  • Develop systems integrations across between traditional databases and modern Cloud APIs.

  • Follow established Software Development Lifecycle (SDLC) activities including Analysis, Design, Development, UAT, Pilot, Testing & lessons learned.

  • Troubleshoot data integrations/data feeds between systems.

  • Create reports and dashboards using technologies such as PowerBI and Microsoft Reporting Services.

  • Maintain required SDLC documentation, test scripts, training materials etc.

  • Document databases models, system processes, and maintenance procedures.


  • Familiarity with Law Firm data concepts such as Clients, Matters, and Timekeepers.

  • 5+ Years' Experience in SQL Server Database Management

  • 5+ Years' Experience in SQL Server Database Development and SQL scripting (T-SQL)

  • 5+ Years' Experience in ETL development using Microsoft SQL Server Integration Services (SSIS)

  • 5+ Years' Experience developing reports and dashboards using PowerBI and Microsoft Reporting Services (SSRS)

  • Experience with IntApp Integration Builder

  • Must be detail oriented

  • Must have strong customer service skills

  • Must be results and goal oriented

  • Must be able to work in high-paced environment with time sensitive deadlines

DISCLAIMER STATEMENT: The preceding job description has been designed to indicate the general nature and level of the work performed by employees within this classification. It is not designed to contain or be interpreted as a comprehensive inventory of all duties, responsibilities and qualification required of employees assigned to this job.

Dice Id : 10120399
Position Id : 21000290-487
Originally Posted : 1 week ago
Have a Job? Post it

Similar Positions

Business Systems Data Analyst
  • DBI Staffing
  • New York, NY, USA
Senior Data Developer
  • AMS Staffing Inc.
  • New York, NY, USA
Fulltime Database Developer role -- with Retail banking exp
  • Nutech Information Systems
  • New York, NY, USA
Database Developer
  • Data Processing Resources
  • New York, NY, USA
Senior SQL Server Developer / Data Architect
  • Velocity Search Group Inc.
  • New York, NY, USA
Data Engineer - G
  • Next Step Systems
  • New York, NY, USA
SQL report writer/PowerBI
  • Confidential Company
  • New York, NY, USA
Data Scientist
  • Amida Care
  • New York, NY, USA
  • Staffing Solutions USA
  • New York, NY, USA
SQL Database Developer
  • Engage Partners, Inc.
  • New York, NY, USA