Finance Business Intelligence Developer

Orrick currently has an excellent opportunity for a Finance Business Intelligence Developer. This position could be based in any of our U.S. offices (Austin; Chicago; Boston; Houston; Los Angeles; New York; Menlo Park; Orange County; Portland; Sacramento; San Francisco; Santa Monica; Seattle; Washington DC; or Wheeling, WV) and consideration given for 100% remote US locations.

As a Finance Business Intelligence Developer, your role will involve developing, organizing, and maintaining finance business interfaces including dashboards, data visualizations, regular and impromptu reports, and data querying tools. Your responsibilities will include:

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
• Design and develop finance reports, applications and dashboards utilizing the MS Power Platform (Power BI, PowerApps, etc.), SSRS, MS SQL, ASP.Net, Excel VBA, C#, Python
• Automated 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 and dashboards
• 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
• Contribute to the team's overall initiative to improve and streamline financial reporting through innovative thinking, introduction of new technologies, and team training exercises

• Strong understanding of financial reporting and accounting principles
• Experience with MS Power platform design ideologies, standards, and structure required
• Power BI and PowerApps skills required
• Expert knowledge of SSRS, MS SQL, stored procedures, and Excel VBA
• Working knowledge of DAX calculations, queries, and formulas
• Experience with Aderant Expert/CMS desirable but not required
• Familiarity with data transfer principles and techniques
• Expert knowledge of Excel queries, pivot tables
• Excellent oral and written communication skills
• Advanced inter-personal skills; professional and customer-service oriented demeanor
• Bachelor of Science degree in Accounting/Finance, Computer Science, Business, Information Systems or related field is desired. 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

Preferred Skills include:

• Knowledge of Aderant Expert CMS, Elite Enterprise, Elite 3E or other professional services firm financial applications is highly desirable
• Marked ability to meet project requirements and deadlines and to manage multiple projects simultaneously
• Source control software (MS Visual SourceSafe, SourceGear, DevOps)

Who is Orrick? Orrick is a global law firm focused on serving the technology & innovation, energy & infrastructure and finance sectors. Founded more than 150 years ago in San Francisco, Orrick today has offices in 25+ markets worldwide. We are recognized worldwide for delivering the highest-quality legal advice through our diverse teams and for our culture of innovation and collaboration. Financial Times selected Orrick as the Most Digital Firm of 2020, and in the past five years, the Most Innovative Law Firm of the Year three times and runner-up twice. For the ninth year in a row, Fortune named Orrick to its 2024 list of the 100 Best Companies to Work For. Learn more about our awesome employee experience here: Fortune 100 Great Place To Work certified company.

Compensation and Benefits

The expected salary range for this position is:

• California Major Markets* $88,000 to $144,000
• New York City $88,000 to $144,000
• National $80,000 to $120,000

* California Major Markets includes San Francisco, Silicon Valley, Los Angeles, Orange County, Santa Monica. All other California locations fall within National range.

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 insurances; robust mental well-being benefits; child, family, elder, and pet care benefits; short- and long-term disability benefits; a health savings account (w/applicable medical plan), flexible spending accounts, long-term care insurance, and a 401K program. This role is eligible to employees will receive compensated time off through our Paid Time Off program, generous Parental leave benefits, 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.

#LI-DNI