Sr. Business Intelligence Analyst

new york, New York

The Business Intelligent Analyst will use an in-depth and hands-on knowledge of enterprise data systems, software technology and report authoring to perform enterprise-scale data analysis and reporting across core Firm software systems. The Analyst will be responsible for the design, development, implementation and support of reports, dashboards and ad-hoc data analysis using the Microsoft SQL Server technology stack.

Responsibilities include, but are not limited to:

  • Design, build and implement reports, dashboards, ETLs, cubes and business intelligence solutions using SQL Server, SSIS, SSAS and SSRS
  • Develop, test, and deploy ETLs, SQL stored procedures and MDX/DAX queries to solve complex data analysis problems based on requirements from different teams
  • Design and implement reports and dashboards using PowerPivot, PerformancePoint and SharePoint technologies
  • Develop and maintain comprehensive business process knowledge of internal functional groups including Finance, eDiscovery, Records, Payroll, HR and Information Technology
  • Collaborate with Applications, Infrastructure, and DBA teams as well as business owners to design and build enterprise-scalable analysis platform and reports
  • Conduct proactive end-to-end monitoring of reporting platforms, identify business application opportunities for improvement and streamline operational processes
  • Troubleshoot and address technical issues with reports and source systems
  • Act as liaison to external vendors in conducting case management
  • Review and advise toward market developments, including upgrades, available features and functionality and new applications


  • Bachelor’s Degree in Computer Science, Information Systems or a related area
    3-5 years of experience as a Business Intelligence Analyst, Application
  • Developer or Software Engineer in executing all facets of the systems development life cycle
  • 3 years of hands-on experience in the design and development of business intelligence solutions using Microsoft SQL Server, SSIS, SSAS and SSRS
  • 3 years of hands-on database development experience in T-SQL, MDX, DAX and ETL platforms
  • Strong familiarity with the Microsoft technology suite, OLAP cubes, relational database management systems and enterprise application integration is required
  • Successful track record in applying technology to serve business functions
  • Ability to design and deliver highly scalable solutions which balance performance, reliability and maintainability
  • Strong professional and interpersonal skills including creative problem solving, effective written and verbal communications, planned and organized coordination of cross-functional teams, acute attention to detail and quality, and driven with the ability to self-manage
  • Ability to multi-task across projects/initiatives and deliver according to time and cost commitments
  • Hands-on experience in the development of front-end applications using SharePoint is a plus
  • Experience with Microsoft SharePoint, Elite Enterprise, Aderant, Oracle Cloud, Intapp Time/APS DTE and similar legal industry systems is a plus

Job keywords:

Files must be less than 2 MB.
Allowed file types: doc docx pdf.

Vertical Tabs