Job #: 1447

Title: Business Intelligence Analyst


  • Other
  • New York City, NY
  • Job Type:

  • Permanent
  • Function:

  • Business Intelligence
  • Salary Range:
  • $125,000 to $150,000

    • Anywhere
    • Posted 2 years ago
    • This position has been filled

    ​Momentum is looking for a BI Analyst.

    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
    • Experience in business analysis is a plus