Financial Systems and Business Intelligence Analyst — New York, NY
Зарплата не указана
Откликнуться96HUjGrx & t2rgADru (“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 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.
Work Environment
The work environment characteristics described here are representative of those an employee encounters while performing the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.
Compensation
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 F7XmZDAa & W7rDjrk5 SMa | Careers | Professional Staff | Employee Benefits .