Senior Reporting & Analytics Analyst

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 ServiceNow 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 capabilities.

 Qualifications:

•  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.
• Experience with SSRS or legacy report migration is preferred; familiarity with Microsoft Fabric or Azure data services is a plus.
• Elite 3E experience, particularly its financial data model and reporting, is preferred, not required. Experience in a law firm or other professional services environment is also preferred.
• Familiarity with financial processes such as time entry, billing, accounts receivable, accounts payable, general ledger and client/matter management is preferred.

 Education / Experience:

 5+ years of professional experience in business intelligence, reporting or a related field. Bachelor's degree in information systems, computer science, data analytics or a related discipline, or equivalent practical experience.

 Skills & Abilities:

•  Power BI report development, DAX, Power Query, dimensional data modeling and semantic models.
• SQL queries and joins, data reconciliation, query optimization and reporting performance troubleshooting.
• Root-cause analysis across reports, databases and source applications; controlled testing before production changes.
• Clear communication with technical and business stakeholders; documentation of requirements, data definitions and support procedures.
• Prioritizing production support alongside project work; ability to learn financial processes and flex into financial systems support without losing the primary BI focus.

 Competencies:

•  Analytical Ability, Judgment and Problem Solving
• Organizational Skills
• Client Service
• Technical and Business Acumen