Business Systems Data Analyst

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.

Requirements:

• 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.

Qualifications:

• 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.