1+ months

Senior Financial Systems Data Specialist

Orrick, Herrington & Sutcliffe LLP
Remote (US - CA) Work Remotely

Are you a self-starter with a high level of initiative and drive? Would you like to work within a highly skilled team of legal finance and analytics professionals being innovative and creative and making this position a unique opportunity? This may the position you for you!

Orrick has an exciting opening for a Senior Financial Systems Data Specialist.  This position could be based in any of our US offices (Austin; 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.

What will you do? As a Senior Financial Systems Data Specialist, you will be responsible for establishing and maintaining the core financial systems custom data groundwork used for reporting, dashboarding, and analysis. The role encompasses a wide range of responsibilities and expert qualifications in finance & accounting relational databases.  A keen ability to analyze, calculate and fine tune results for consumption by various firm-wide platforms is critical. You will have advanced knowledge of accounting concepts and finance data, complimented by the ability to perform complex calculations. You will further be able to apply these skills to create custom results utilizing advanced SQL.

What responsibilities will you have?

  • Maintain financial data integrity by identifying and correcting problems, as well as providing solutions for procedures that impact finance data
  • Advanced SQL development and expansion of core financial systems databases
  • Strategic compilations of finance data into views, tables, procedures, etc. to facilitate varying reporting, application, and dashboarding scenarios
  • Multi-database integrations (integration with interdepartmental data sources including HR, IT, Marketing and the like)
  • Ad-hoc data transformation
  • Developing, packaging and managing scheduled data update processes
  • Data refresh of multidimensional cube environment (SAP BPC) and reporting databases
  • Optimizing old/existing data update processes
  • Month-end closing
  • Troubleshooting data processing problems
  • Special projects – ad-hoc and planned – to assist with automation, mass updates, data cleanup, etc.
  • Collaborating with developers, DBA and business departments for custom data needs
  • Establish comprehensive documentation and standards
  • Bachelor’s degree in Computer Science, Information Sciences, Database Management or Finance/Accounting is preferred or equivalent work experience required.
  • 5+ years of experience designing and expanding SQL database content and subroutines/functions
  • 5+ years of experience working with finance data in an enterprise accounting system
  • Advanced knowledge of finance/accounting data and complex calculations
  • Expert SQL scripting and compilation
  • Expert and marked experience in an MS SQL Server environment
  • Ability to assess key aspects of a task and produce an optimized solution
  • Ability to think analytically and thrive in a fast paced, deadline driven environment – both collaboratively and independently
  • Ability to engage professionally with top-level leadership
  • Strong attention to detail, solid organizational, interpersonal, delegation and leadership skills
  • Team-oriented attitude with willingness to perform cross-functional tasks and cross-train colleagues via documentation and direct training with an eye toward skills redundancy
  • Strong time management skills and the ability to work under pressure in a dynamic, fast-paced environment
  • Ability to assume a leadership role as needed for projects and other independent tasks
  • Ability to adjust to rapidly changing deadlines and priorities
  • Excellent project management, fact gathering, and prioritization skills
  • Flexibility in scheduling to facilitate support urgencies, project timelines, month-end processing, etc.

As an added extra, you will also possess the following strengths:

  • Previous law firm experience is highly desired
  • SSIS, SSRS preferred
  • Experience with underlying data in legal financial systems (Aderant Expert/Elite Enterprise/3E)
  • Experience with general law firm finance technology
  • Experience with programming .NET, C#, Python, HTML, VB.NET is a definite plus
  • Power BI infrastructure and reporting knowledge a plus
  • Experience with cloud platforms and Azure solutions a plus
  • General knowledge of SAP BPC or other specific OLAP cube platforms a plus
  • Accounting knowledge including that which is related to international operations and intercompany transactions

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 sixth year in a row, Fortune named Orrick to its 2021 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

Orrick offers a collaborative work environment, competitive salary, and excellent benefits, from wellness and mindfulness programs to social impact opportunities, professional staff affinity group communities and generous paid time off. 

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

No phone calls please. 

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.



Posted: 2021-09-01 Expires: 2021-11-07

Before you go...

Our free job seeker tools include alerts for new jobs, saving your favorites, optimized job matching, and more! Just enter your email below.

Share this job:

Senior Financial Systems Data Specialist

Orrick, Herrington & Sutcliffe LLP
Remote (US - CA)

Join us to start saving your Favorite Jobs!

Sign In Create Account
Powered ByCareerCast