Shearman & Sterling LLP is an established and growing international firm and as our Financial Systems Analyst, based in the mid-town New York City offices, you will have the opportunity to work as part of a global team that places the highest value on excellence and integrity. You will be a part of the Management Reporting & Analysis team and in this role you will be the “Go To” person that will provide financial data to all practices groups and departments, across all time zones. The right person for this role loves data, is an expert user of financial systems and has a passion for details. If you are excited about being a part of a team and you want to join a diverse, international organization then you should apply today.
Primary responsibility is to design and program custom financial reports as well as to analyze, support and refine existing reports and systems. Create and run ad-hoc reports requested by Management, Practice Groups and Offices. Analyze data to be able to aid Management in making crucial business decisions. Thorough knowledge of Elite’s Data Structure as well as the firm’s financial warehouses and reporting tools.
Essential Duties / Responsibilities:
Create and run custom SQL queries for running ad-hoc reports using knowledge of the Elite and related Financial systems, Financial Reporting Warehouses and SQL programming. This enables the development of rapid, customized, non-standard financial ad-hoc reporting.
Develop and update custom reports and systems using Microsoft Access, Excel and other reporting tools and methodologies in order to enhance and support firms standard reporting capabilities
Ensure optimum reporting and warehousing solution for firm’s financial reporting requirements by performing systems analysis and technical review of Financial Reports and Systems in production and in development, including 4gl source code and stored procedures containing business logic.
In order to obtain correct functionality, performance quality, efficiency and accuracy of new and enhanced reports, analyze and oversee the development and upgrades of custom reports, programs and financial systems.
Test the data of new and modified Custom Financial Reports and Systems to assure integrity of data of custom reports and systems.
Research new technologies and maintain proficiency in current technologies in order to use the optimum technical solutions.
Knowledge Skills and Attributes:
Working knowledge of Elite’s data structure as it pertains to financial and management reporting.
Complete expertise of the firm’s financial and management reporting Data Warehousing.
Knowledge of the firm’s financial and management reporting terminology and business rules.
Full life cycle software development and management experience.
Development and troubleshooting experience in a multi-tier, multi-user near-time system.
Education & Experience
Management and Financial reporting experience in a Law Firm or business environment
5-10 years of programming and systems analysis
BS in Computer Science or other technical degree
Internal Number: SHMSTL FS - Elite
About Shearman & Sterling
Shearman & Sterling has been advising many of the world's leading corporations and financial institutions, governments and governmental organizations for more than 140 years. We are committed to providing legal advice that is insightful and valuable to our clients. This has resulted in groundbreaking transactions in all major regions of the world including Asia, The Middle East, Europe, Latin America, and North America. Together, our lawyers work across practices and jurisdictions to provide the highest quality legal services, bringing their collective experience to bear on the issues that clients face. For example, underpinning the quality of our work firm-wide are our shared values. We take pride in the successes of our clients and in our contributions to them.