19772 – Senior Business Intelligence Analyst

The Senior Business Intelligence 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. Responsibilities include and are not limited to 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 Reporting tools such as Excel, PowerPivot, SQL Reporting Services, Power BI, Tableau etc.
  • 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
  • 5 -7 years of experience as a Business Intelligence Analyst, Application Developer or Software Engineer in executing various facets of the systems development life cycle
  • 5 – 7 years of hands-on experience in the design and development of business intelligence solutions using Microsoft SQL Server, Power BI, 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
  • Strong quantitative skills, ability to analyze complex, multi-faceted problems, credentials in Accounting, Finance, or Economics a plus
  • 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
  • Successful track record in applying technology to serve business functions
  • Set priorities and manage multiple assignments simultaneously
Job Category: Development/Analysis
Job Type: Direct-hire/Full-time
Job Location: NY/Remote
Salary: $150K + Bonus

Apply for this position

Allowed Type(s): .pdf, .doc, .docx