Financial Systems Engineer

Overview

Orrick currently has an excellent opportunity for a Financial Systems Engineer
. This position could be based in any of our U.S. offices
, preferably in our Wheeling, WV office, and consideration given for 100% remote US locations
.

We are seeking a Financial Systems Engineer to lead the engineering management, support, and ongoing evolution of our core financial and practice management systems. This is a senior-level, hands‑on engineering position requiring deep financial systems expertise combined with the ability to support a broader portfolio of enterprise and legal technology solutions reporting to the Manager of Database Administration.

• Administer, maintain, and optimize the firm's financial systems, including configuration, patching, upgrades, and day‑to‑day troubleshooting across core modules such as client billing, accounts payable/expense management, general ledger, purchasing, fixed assets, trust accounting, and time entry.
• Maintain user security, access management, and administration, ensuring role‑based controls and data‑governance standards are enforced.
• Monitor scheduled jobs, interfaces, and system health; proactively detect issues using operating‑system metrics, application logs, and performance‑monitoring tools, and coordinate timely recovery or permanent resolution.
• Provide advanced technical and functional support to end users (Finance staff, attorneys/professionals, billing coordinators), resolving issues through ticket close‑out and ensuring user satisfaction.

• Administer and maintain Microsoft SQL Server databases both on‑premise and in the cloud (e.g. Azure, AWS) supporting financial and related applications, ensuring data integrity, availability, and security.
• Develop and optimize SQL queries, stored procedures, views, and data endpoints, and perform query optimization, indexing, and performance tuning to maintain responsive system performance.
• Working knowledge of SQL Server Integration Services (SSIS).
• Support data warehouse / reporting initiatives, including optimized data models and ETL processes for financial applications, where applicable.
• Perform backup, restore, and disaster‑recovery procedures and validate data integrity across environments.

• Support and maintain both classic client/server applications and cloud‑hosted / SaaS platforms, including participation in modernization and cloud‑migration initiatives.
• Design, build, test, and maintain integrations and APIs between financial systems and complementary enterprise systems (time entry, expense management, DMS, CRM, HR, bank/ACH connections, e‑billing platforms), using REST APIs, middleware, flat‑file exchanges, or ETL pipelines as appropriate.
• Administer supporting Microsoft Windows Server environments, including familiarity with IIS, Power Shell, and Active Directory.

• Evaluate and implement system upgrades, patches, and new modules; plan and execute test plans including unit testing, system testing, UAT coordination, release validation, and defect triage.
• Manage change‑control processes, assessing the impact of proposed upgrades or new offerings and reporting findings to management before implementation; contribute to Change Advisory Board (CAB) discussions as required.

• Act as a technical liaison between Finance/Accounting, IT, and business stakeholders, translating business needs into functional and system requirements.
• Manage vendor relationships in accordance with service‑level agreements (SLAs), escalating issues as appropriate to ensure quality and timeliness of vendor…