Senior Reporting & Analytics Analyst

Location: New York

At Fried Frank, we’re a community of 800 lawyers and 500 business services professionals across New York, Washington, DC, London, Frankfurt, and Brussels. We advise leading corporations, investment funds, and financial institutions on high-stakes M&A, securities, regulatory matters, real estate, and litigation. Our culture is grounded in our core values — excellence, integrity and collaboration — and is designed to foster continuous learning, meaningful mentorship, and lasting professional growth.

We are firmly committed to pro bono service and social justice, building on a proud legacy in civil rights. Our inclusive talent strategy is a core part of our broader talent management efforts and we remain steadfast in fostering a workplace where everyone has the opportunity to grow, thrive, and become their best professional and personal selves. Our business services professionals are integral to the firm’s success, driving innovation, operational excellence and exceptional client service across all areas of the firm.

We offer competitive compensation and a comprehensive benefits package, including comprehensive medical coverage, retirement plans and health and wellness initiatives designed to support your personal and professional wellbeing. We welcome passionate, driven individuals to join us, and be part of a team where you’ll be supported, inspired and empowered to build an exceptional career.

Position Summary:

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 translate reporting needs into accurate, usable solutions, resolves production reporting issues, and carries assigned reporting projects from requirements through testing and deployment. It supports the modernization and simplification of legacy reporting, including SSRS migration and adoption of Microsoft Fabric where appropriate.

While business intelligence is the primary focus, the role also provides data analysis, troubleshooting and project support across financial systems, including Elite 3E and related integrations, as business needs require.

Duties & 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 in accordance with 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 Service Now intake for Analytics and Financial Systems requests; clarify requirements, assess urgency and business impact, route requests to appropriate team members, maintain accurate ticket records, and 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…