Financial Systems and Business Intelligence Analyst

Sullivan & Cromwell LLP
New York, NY, United States
3 days ago
Apply on www.careerjet.com
Prepare application

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Experience level
Experienced
Experience required
3 years minimum
Compensation
$90,000 - $120,000
Working hours
Regular working hours

Tech stack

Microsoft Excel Amazon Web Services Data Analysis Microsoft Azure Business Systems Software as a Service Cyber Security Information Systems Databases Data Cleansing Data Transformation Relational Databases
+12 more
Database Queries R (Programming Language) Python (Programming Language) Oracle (Applications) Power BI SQL Databases Tableau (Software) Workflow Management Systems Information Technology Data Analytics Tools for Reporting Data Pipelines

Job description

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.

Requirements

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 communicate clearly with Finance and IT colleagues. Bachelor’s degree in Information Systems, Computer Science, Data Analytics, Finance, Economics, Statistics, Mathematics, Engineering, or a related field. Preferred Qualifications Experience with law-firm or professional-services financial data, including client and matter profitability, billing, collections, or compensation analysis. Experience supporting financial SaaS applications or cloud analytics environments, particularly Oracle; AWS or Azure experience is also relevant. Experience applying forecasting or statistical methods to a defined financial business problem. Relevant technical certifications or an advanced degree in information systems, analytics, data science, finance, or a related discipline.

Benefits & conditions

The annual base salary range for this New York City position is $90,000-$120,000. When determining a candidate’s compensation offer, elements unique to each person are taken into consideration including but not limited to skill set, experience level, performance, professional certifications, degrees and location, as well as the needs of the Firm. The total compensation package for this position may include overtime pay, discretionary bonuses and other benefits. For a more comprehensive list of employee benefits, please visit .

Apply for this position

This job is hosted externally. Click below to view the full posting and apply.

Apply on www.careerjet.com
Prepare application

Good distractions

Loading talks and stories from around this role…