Financial Reporting Analyst

Orrick currently has an excellent opportunity for a Financial Reporting Analyst . This position could be based in any of our U.S. offices and consideration given for 100% remote US locations . Are you looking to work in a dynamic team-oriented work environment? Are you a self-starter with a high level of initiative and drive? This may be the job you for you! Responsibilities:
Develop ad-hoc financial reporting for various firm functional areas including but not limited to Finance, Business Development, Attorney Development, Human Resources, Business Units, Practice groups and Firm Leadership
Creation of new reports and reporting tools using Power BI, PowerApps, SSRS, MS SQL, ASP.Net, Excel VBA and CMS DocuDraft
Automated and manual distribution of reporting through various industry and in-house tools and systems
Participation in the Month-End close process to include but not limited to financial system reconciliation, data verification and publication of reporting
Support and maintain in-house finance reporting software
Troubleshoot and/or improve existing reports
Assist with application upgrade projects
Play an active role in UI and back-end testing
Provide support and training for Finance and firm staff on tools and systems developed for financial reporting
Provide accurate and timely financial data reporting to various functional areas throughout the firm to support daily processes, financial analysis and special projects
Support financial tools and systems on and manage security rights for various user groups
Work with applications support group to provide high level troubleshooting and technical support to all firm users
Promote open communication with users and with department managers
Continually seek to improve the customer service provided to users by Business Systems Support Group Qualifications:
Bachelor of Science degree in Accounting/Finance, Computer Science, Business, Information Systems or related field or equivalent work experience
Three or more years of related experience is required; prior experience working in a professional services environment is desirable
Previous law firm experience strongly desired
General understanding of financial reporting and accounting principles
Experience with Power BI report design methods, standards and data structure desired
Expert knowledge of SSRS, MS SQL, stored procedures and Excel VBA
Knowledge of Aderant Expert/CMS DocuDraft desirable but not required
Familiarity with data transfer principles and techniques
Expert knowledge of Excel queries, pivot tables
Marked ability to meet project requirements and deadlines and to manage multiple projects simultaneously
Excellent oral and written communication skills
Advanced inter-personal skills; professional and customer-service oriented demeanor
Knowledge of Aderant Expert CMS, Elite Enterprise, Elite 3E or other professional services firm financial applications is highly desirable
Power BI and PowerApps skills a definite plus
Source control software (MS Visual SourceSafe, SourceGear and/or DevOps) preferred Who is Orrick? Orrick is a global law firm focused on delivering innovative solutions for four sectors: Technology & Innovation, Energy & Infrastructure, Finance and Life Sciences & HealthTech. Founded more than 150 years ago in San Francisco, Orrick today has offices in 25+ markets. We are recognized globally for delivering the highest-quality legal advice and for our culture of innovation and collaboration. Compensation and Benefits
New York City, Silicon Valley, and San Francisco $86,000 - $125,000
Washington DC, Los Angeles, Orange County, Santa Monica, Sacramento, Boston, and Seattle $79,000 - $125,000
All Other US Locations $74,000 - $96,000 Orrick is committed to providing a comprehensive, competitive, and thoughtful total compensation package to our attorneys and staff, wherever they work. This compensation and benefits information is based on the Orrick’s estimate as of the date of publication and may be modified in the future. The level of pay within the range will depend on a variety of job-related factors that may include, but not limited to, qualifications, relevant experience or education, particular skills or expertise, geography. Other compensation may include an annual discretionary merit bonus, which would be determined by Firm and individual performance. We offer a full range of elective health benefits including medical, dental, vision and life; robust mental well-being programs; child, family, elder, and pet care benefits; short- and long-term disability and industry leading parental leave benefits, health savings account contributions (w/applicable medical plan), flexible spending accounts, and a 401K program. This role will receive compensated time off through our Paid Time Off program and paid holidays. Please visit www.orrick.com for more information about the firm. How to Apply: If you are searching for a chance to create an impact, you have a little grit and you love working with a team, we want to talk with you. To submit your resume and cover letter for this position, please visit our Staff and Paralegal Opportunities Listings at www.orrick.com/Careers. Orrick accepts applications for this position on an ongoing basis, until filled. We are an Equal Opportunity Employer. Consistent with the SF Fair Chance Ordinance, an arrest and conviction record will not automatically disqualify a qualified applicant from consideration. Qualified applicants with criminal histories will be considered for the position in a manner consistent with the requirements of the Los Angeles Fair Chance Initiative for Hiring.