Business Systems Data Analyst

Job Details

  • ID#37678942
  • Address 10008 , New york city,

    New York

    New york city USA
  • Job type


  • Salary USD $155000.0 - $175000.0 per annum 155000.0 - 175000.0 per annum
  • Hiring Company

    Paul, Weiss, Rifkind, Wharton & Garrison LLP

  • Showed04th April 2022
  • Date03rd April 20222022-04-03T03:00:00-0400
  • Deadline02nd June 2022
  • Category

    Et cetera

Business Systems Data Analyst

Vacancy expired!

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.

Vacancy expired!

Similar jobs

Business Data Analyst

Atos Syntel Inc. - Business Data Analyst

Business Process / Data Analyst

Craftner - Business Process / Data Analyst

Business Systems Analyst

Chenoa Information Services - Business Systems Analyst

Business Analyst / Data Analyst

Element Technologies Inc. - Business Analyst / Data Analyst