Skip to content
×

Financial Systems and Business Intelligence Analyst

Job in New York, New York County, New York, 10261, USA
Listing for: Sullivan & Cromwell
Full Time position Listed on 2026-11-21
Job specializations:
Salary/Wage Range or Industry Benchmark: 90000 - 120000 USD Yearly USD 90000.00 120000.00 YEAR

Job Description & How to Apply Below

Financial Systems and Business Intelligence Analyst Location New York Job Code 1398 # of openings 1

Sullivan & Cromwell (“S&C”) is seeking an analyst who builds and improves the technology behind financial reporting. Within our legal professional services environment, you will write SQL queries, develop reports and analytical datasets, automate recurring processes, and troubleshoot data and reporting issues. Your work will help Finance deliver accurate, timely information for management decisions.

The role combines hands‑on technical delivery with an understanding of financial data. You will translate reporting needs into working solutions, reconcile results to source systems and accounting controls, and document how those solutions operate.

Responsibilities
  • Assist with the preparation and delivery of weekly, monthly, and ad hoc management reporting.
  • Write, maintain, and troubleshoot SQL queries to extract, join, aggregate, and validate data for recurring and ad hoc financial reporting.
  • Build and enhance reports, dashboards, and reusable datasets in business intelligence and financial reporting tools; maintain clear definitions for calculations and reporting measures.
  • Automate data preparation, reconciliation, and report production using Python, R, SQL, or other approved scripting and workflow tools.
  • Support data pipelines and scheduled reporting processes; investigate failed refreshes, missing records, duplicate data, and differences between source systems and reports.
  • Support and enhance financial systems and SaaS or cloud reporting applications, partnering with Finance, IT, and vendors on testing, troubleshooting, and controlled changes.
  • Translate stakeholder requests into data requirements, mappings, calculations, and acceptance criteria; test results before reports or changes are released.
  • Develop financial analyses and forecasting models for client and matter profitability, revenue, and compensation planning, using methods appropriate to the business question.
  • Document query logic, data sources, reconciliations, and operating procedures; explain findings and system issues clearly to nontechnical stakeholders.

In addition, responsibilities related to maintaining firm and client information are to be adhered to by all employees. This includes complying with the firm’s information security policies, protecting firm assets from unauthorized access, disclosure, modification, destruction or interference, and reporting security events or potential events or other security risks to management.

Required Qualifications
  • 3–5 years of relevant experience in business intelligence, financial systems, data analytics, reporting development, or a closely related technical role.
  • Hands‑on SQL proficiency, including joins, common table expressions, aggregate functions, and window functions; ability to explain query logic and diagnose incorrect results.
  • Experience developing and maintaining reports or dashboards in Power BI, Tableau, Dodeca, or a comparable reporting platform, including the underlying data preparation and calculations.
  • Experience building or maintaining a repeatable automated data or reporting process using Python, R, SQL, or a comparable approved tool.
  • Understanding of relational data structures, data transformation, reconciliation, and validation controls; ability to trace a reported figure back to its source.
  • Strong Excel skills for modeling, analysis, and reconciliation, together with experience delivering solutions through databases, reporting platforms, or scripts.
  • Working knowledge of financial reporting concepts and ability to learn how revenue, expenses, profitability, and compensation are represented in business systems.
  • Ability to document technical work, gather business requirements, and…
To View & Apply for jobs on this site that accept applications from your location or country, tap the button below to make a Search.
(If this job is in fact in your jurisdiction, then you may be using a Proxy or VPN to access this site, and to progress further, you should change your connectivity to another mobile device or PC).
View / Apply for Jobs
Matching My Jurisdiction

Search for further Jobs Here:

SEARCH JOBS: 10+ Million Listings
(Try combinations for better Results! Or enter less keywords for broader Results)
Education Level
Experience Level (years)
Posted in last:
Salary