Senior Reporting & Analytics Analyst

Fried Frank Business Services Opportunities•New York, NY

1d•$130,000 - $160,000

About The Position

The Senior Reporting & Analytics Analyst develops and supports the firm’s reports, dashboards, and data models, primarily using Microsoft Power BI and SQL. The role partners with Finance and other business services departments to turn reporting needs into accurate, usable solutions, resolve production reporting issues, and carry assigned reporting projects from requirements through testing and deployment. It supports modernization and simplification of legacy reporting, including SSRS migration and adoption of Microsoft Fabric where appropriate. Business intelligence is the primary focus, with data analysis, troubleshooting, and project support across financial systems, including Elite 3E and related integrations, as business needs require. The position works with stakeholders to define requirements and data definitions, maintains report access and security, documents reporting logic and support procedures, and provides guidance to report users. It also manages and triages ServiceNow requests for Analytics and Financial Systems and supports assigned financial systems enhancements and projects. The salary range listed for New York is $130,000–$160,000 USD; the actual offer depends on factors including qualifications, experience, education, certifications, and location.

Requirements

At least 5 years of professional experience in business intelligence, reporting, or a related field.
Hands-on experience developing and supporting Microsoft Power BI reports and semantic models, with strong DAX, Power Query, and SQL skills.
Experience translating business requirements into reporting solutions, validating results, and resolving production reporting issues.
Skills in Power BI report development, DAX, Power Query, dimensional data modeling, and semantic models.
Skills in SQL queries and joins, data reconciliation, query optimization, and reporting performance troubleshooting.
Ability to perform root-cause analysis across reports, databases, and source applications, and to conduct controlled testing before production changes.
Clear communication with technical and business stakeholders and ability to document requirements, data definitions, and support procedures.
Ability to prioritize production support alongside project work and learn financial processes while flexing into financial systems support without losing the primary BI focus.
Bachelor’s degree in information systems, computer science, data analytics, or a related discipline, or equivalent practical experience.

Nice To Haves

Experience with SSRS or legacy report migration.
Familiarity with Microsoft Fabric or Azure data services.
Elite 3E experience, particularly its financial data model and reporting.
Experience in a law firm or other professional services environment.
Familiarity with financial processes such as time entry, billing, accounts receivable, accounts payable, general ledger, and client/matter management.

Responsibilities

Design, build, and maintain Power BI reports, dashboards, and semantic models, including DAX measures, Power Query transformations, and reusable reporting logic.
Gather and document requirements for reporting solutions and assigned financial systems enhancements; confirm business needs, data definitions, and acceptance criteria with stakeholders.
Write and optimize SQL queries to analyze enterprise data, reconcile reporting results, and investigate data or integration issues across Elite 3E and related financial applications.
Provide secondary production support for Elite 3E and related financial applications; troubleshoot issues, coordinate resolution with team members and vendors, and test and validate fixes.
Diagnose and resolve reporting issues involving refresh failures, data accuracy, performance, calculations, and access; trace upstream dependencies and coordinate resolution with application, data, and infrastructure teams.
Migrate assigned legacy SSRS reports to Power BI, validate output, coordinate user acceptance testing, and support production deployment; identify reports that can be consolidated, simplified, or retired.
Maintain report access and row-level security according to approved requirements, including matter-level restrictions and information barriers where applicable.
Document report definitions, data sources, calculation logic, refresh schedules, testing results, and support procedures; provide practical guidance to report users.
Manage and triage ServiceNow intake for Analytics and Financial Systems requests; clarify requirements, assess urgency and business impact, route requests, maintain ticket records, communicate status, and escalate issues as appropriate.
Manage assigned reporting requests and project deliverables; maintain issue and task records, communicate progress and dependencies, and escalate matters of importance as appropriate.
Support assigned financial systems enhancements and projects through requirements gathering, data reconciliation, testing, documentation, and validation of reporting impacts.
Contribute to Microsoft Fabric and AI-assisted reporting initiatives as assigned, including preparing well-defined semantic models and testing new capabilities.