Financial Systems Engineer

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 theengineeringmanagement, support,and ongoing evolution of our core financial and practice management systems. This is a senior-level, hands-on engineering position requiring deep financial systemsexpertisecombined with the ability to support a broader portfolio of enterprise and legal technology solutions reporting tothe 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 coordinatetimelyrecovery 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 bothon-premiseandin 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 tomaintainresponsive 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 andvalidatedata integrity across environments.

• Support andmaintainboth 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 toensure quality and timeliness of vendor support.
• Produce and maintain clear documentation for system configurations, integrations, support procedures, release notes, and operational runbooks for audit and continuity purposes; mentor junior staff and share best practices.

• Apply accounting and auditing principles to ensure data integrity, internal controls, and audit trails are maintained; support month-end and year-end processing and resolve data issues affecting financial integrity.
• Identify opportunities for process improvement and automation to reduce manual effort, improve user experience, and strengthen controls and auditability.
• Participate in the after-hours on-call support rotation of the Applications team (see Working Conditions). Perform other…