Data/Finance Analyst
Job Description
Financial Reporting Analyst
Orrick currently has an excellent opportunity for a Financial Reporting Analyst. or Wheeling, WV) and consideration given for 100% remote US locations.
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.
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.
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.
- 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.
- 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.
Compensation and Benefits
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; 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.
Application Process
To submit your resume and cover letter for this position, please visit our Staff and Paralegal Opportunities Listings at Orrick accepts applications for this position on an ongoing basis, until filled.