System Administrator (Enterprise)
Summary
Systems administrator at law firm Redgrave LLP supporting the firm's financial systems environment, centered on Aderant Sierra and Intapp. Day-to-day covers system monitoring, user access administration, upgrades and patching, helpdesk support, integrations (Emburse, iTimekeep, e-billing), and reporting, using Microsoft SQL Server, SSRS, Power BI, Azure, and PostgreSQL.
The ideal candidate is a detail-oriented and resourceful financial systems professional who brings technical expertise in Aderant Sierra and Intapp, and a calm, solutions-oriented approach to every system challenge. They are expected to exercise sound judgment and independent decision-making to effectively diagnose and resolve complex issues across financial applications, databases, and integrated platforms, while minimizing disruption to attorneys and professional staff. With excellent organizational and communication abilities, this individual can translate technical concepts clearly for both technical and non-technical stakeholders — including Finance, Accounting, and firm leadership — while maintaining the highest standards of accuracy, confidentiality, and professionalism in a fast-paced legal environment.
POSITION OVERVIEW
The Systems Administrator is a key role supporting the Information Technology function, responsible for the day-to-day administration, support, and optimization of the firm’s financial systems environment, with a primary focus on Aderant Sierra and Intapp and its integrated platforms. Core responsibilities include system monitoring and performance management, user account and access administration, helpdesk support for finance system users, and coordination of system upgrades, patches, and configuration changes. This position plays a critical role in maintaining data integrity across financial platforms, ensuring seamless integrations between Aderant, Intapp, and third-party applications such as Emburse, iTimekeep, and document management systems, and supporting the reporting and analytics needs of the Finance and Accounting teams. Working closely with Finance, IT, and external vendors, the Systems Administrator serves as the primary liaison between business operations and technology, contributing to the overall reliability, security, and continuous improvement of the firm’s financial systems infrastructure
RESPONSIBILITIES & DUTIES
- System Monitoring & Optimization Ensure the smooth operation, stability, and performance of Aderant Sierra and associated financial systems by performing regular system health checks, monitoring scheduled jobs and background processes, and proactively identifying and resolving issues before they impact users. Recommend and implement system best practices to improve workflows, reduce inefficiencies, and enhance the overall user experience. Evaluate new application features and emerging technologies and make recommendations based on technical and business impact.
- User Account & Access Management Manage user accounts, roles, and permissions within Aderant Sierra and Intapp and integrated financial platforms, ensuring proper access controls, group-based permissions, and security compliance are maintained at all times. Support onboarding and offboarding of users, including access provisioning and deprovisioning. Assist with client intake and conflicts, pre-bill, billing, and financial workflows to ensure accuracy and operational continuity.
- System Updates Coordinate with the Aderant Cloud Team, Conflicts, Office of General Counsel, IT leadership, and external vendors to plan, test, and apply system upgrades, patches, and configuration changes with minimal disruption to firm operations. Participate in user acceptance testing (UAT) and quality assurance for all modifications to financial systems in test and production environments. Research product updates and execute plans for keeping systems current and within vendor support requirements.
- Helpdesk Support Serve as the primary point of contact for all Aderant Sierra and Intapp-related technical issues, troubleshooting system errors, workflow failures, and data inconsistencies across development, test, and production environments. Provide timely resolutions to service desk requests, escalating issues to vendors or senior IT staff when necessary, and communicating status updates to affected users and management throughout the lifecycle of an incident. Offer basic training and guidance to end users on financial system functionality as needed.
- System Security & Risk Management Ensure Aderant Sierra and Intapp and all supporting financial applications adhere to firm security policies, regulatory compliance requirements, and data privacy standards. Regularly review system logs, track access changes, and conduct security audits to identify vulnerabilities or potential risks. Assist in security incident response by investigating system issues, implementing corrective measures, and maintaining awareness of data security and confidentiality considerations relevant to legal and financial systems.
- Integration & Enhancements Maintain and support integrations between Aderant Sierra and Intapp and other firm platforms, including document management systems, time entry, expense management, payment, e-billing, and reporting tools. Develop and maintain SQL queries, stored procedures, and database views to support reporting, automation, and data integrity needs. Design, develop, and maintain financial and operational reports using SSRS and Power BI, including data modeling, dashboard configuration, and stakeholder-facing analytics. Identify and implement automation opportunities within Aderant Sierra and Intapp to streamline financial operations and enhance efficiency. Execute ETL processes including data transfers, validation, and reconciliation across financial systems.
- Cross-Functional Collaboration Work closely with Finance, Accounting, IT, and legal teams to ensure seamless system functionality and support firm-wide technology initiatives. Serve as the primary liaison between the Finance and IT departments, translating business requirements into practical technical solutions and maintaining a proactive, responsive working relationship with all stakeholders. Partner with vendors, consultants, and internal project teams during upgrades, implementations, and issue resolution. Maintain and update technical documentation, workflows, system configurations, and support procedures to ensure knowledge continuity across teams.
- Ad-Hoc Projects Participate in special projects and technology initiatives as assigned by management, including system implementations, process improvement efforts, and firm-wide financial systems enhancements. Contribute to change management and user enablement activities, supporting training, documentation, and testing as needed.
- Cloud-Hosted Applications and Databases Participate in the operational support of cloud-hosted applications and databases, including emerging firm technology and AI initiatives, based on business priorities. Collaborate with infrastructure, security, application, and development teams to troubleshoot issues across application, database, integration, and cloud layers.
- General Support Provide support to the Finance and IT teams with various financial systems tasks and projects as needed. Perform administrative and other duties as assigned; responsibilities may be added, deleted, or changed at any time at the discretion of management, formally or informally, either verbally or in writing.
KNOWLEDGE, SKILLS, AND ABILITIES
- Deep working knowledge of Aderant Sierra (or Aderant Expert) and Intapp, including system configuration, module support, user administration, and front-end and back-end customization.
- Working knowledge and understanding of security infrastructure and access administration.
- Strong Microsoft SQL Server proficiency, including the ability to write and optimize complex queries, stored procedures, views, and scripts for data retrieval, reporting, automation, and troubleshooting.
- Experience supporting financial systems integrations, including data flows between Aderant and Intapp and third-party platforms such as Chrome River/Emburse, iTimekeep, Onyx, BillBlast, and document management systems.
- Solid understanding of legal billing operations and financial workflows, including prebills, time entry, expense management, collections, and electronic billing (e-billing).
- Experience developing and maintaining financial and operational reports using SSRS; familiarity with Power BI for dashboards and data visualization is a plus.
- Ability to perform ETL activities, including data migration, validation, and reconciliation across financial platforms.
- Working knowledge of Windows Server environments, Active Directory, and basic network concepts as they relate to financial application performance and connectivity.
- Strong analytical and problem-solving skills, with the ability to investigate root causes across application, database, and infrastructure layers and implement effective, lasting solutions.
- Excellent verbal and written communication skills, with the ability to explain technical concepts clearly to non-technical users across Finance, Accounting, and firm leadership.
- High degree of professionalism, discretion, and the ability to handle sensitive financial and client data with strict confidentiality.
- Strong organizational skills with the ability to manage multiple concurrent priorities, self-direct work, and follow through to resolution with minimal supervision.
- Working knowledge of Microsoft Azure, including cloud resource monitoring, identity and access management, networking, security, and operational troubleshooting.
- Intermediate knowledge of PostgreSQL database administration, preferably Azure Database for PostgreSQL, including monitoring, backup and recovery, access management, performance troubleshooting, patching, and routine maintenance.
- Ability to diagnose issues across application, integration, database, and cloud infrastructure layers.
- Lead the efforts to remediate application, Database security vulnerabilities identified by firm tools in coordination with application owners.
REQUIRED QUALIFICATIONS
- Minimum of 5-8 years of hands-on experience supporting enterprise financial systems, with direct experience in Aderant Sierra and Intapp.
- Prior experience working in a law firm or professional services environment is required.
- Demonstrated proficiency in Microsoft SQL Server, including T-SQL scripting, query optimization, stored procedures, and database troubleshooting.
- Proven experience supporting financial workflows in a legal setting, including billing, time entry, expense management, and financial reporting.
- Experience coordinating and executing system upgrades, patches, and configuration changes in collaboration with vendors and IT leadership.
- Familiarity with financial systems integrations and experience maintaining data flows between enterprise platforms and third-party applications.
- Ability to develop and maintain SSRS reports and data extracts to support Finance and management reporting needs.
- Strong interpersonal skills with a demonstrated ability to serve as a liaison between Finance, IT, and external vendors.
- Proven reliability, sound judgment, and the ability to manage sensitive financial information with the utmost confidentiality.
- Availability for occasional after-hours, evening, or weekend support as system maintenance and operational needs require.
PREFERRED QUALIFICATIONS
- Bachelor’s degree in Information Systems, Computer Science, Finance, Accounting, or a related field; equivalent professional experience will be considered.
- Hands-on experience with Aderant-integrated applications, including Chrome River/Emburse, iTimekeep, Intapp (Time, Open, or Conflicts), BillBlast, and PreBill Viewer.
- Familiarity with Aderant’s Design Studio, DocuDraft, and Security Manager.
- Experience with Power BI, including data modeling, dataset management, workspace administration, and dashboard development.
- Knowledge of ETL processes, data migration strategies, and data governance principles within financial systems environments.
- Familiarity with legal practice management workflows, including matter management, new business intake, and conflicts processes.
- Experience supporting cloud-based applications and SaaS platforms, with working knowledge of Microsoft Azure, Microsoft Entra, Exchange Online, and SharePoint. Experience with Azure resource monitoring, identity and access management, security, networking, and operational troubleshooting is preferred.
- Intermediate hands-on experience administering PostgreSQL databases, preferably Azure Database for PostgreSQL, including monitoring, backup and recovery, access management, performance troubleshooting, and routine maintenance.
- Knowledge of cybersecurity principles, SOC 2 compliance, or data privacy requirements applicable to legal and financial systems.
- Familiarity with Power Apps or Power Automate for workflow automation and data capture solutions.
- Relevant industry certifications such as Microsoft Certified: Azure Administrator, CompTIA Security+, AWS Certified SysOps Administrator, RedHat Certified System Administrator (RHCSA), VMware Certified Professional – Data Center Virtualization (VCP-DCV), or equivalent are a plus.
PHYSICAL REQUIREMENTS
- Ability to work on a computer for extended periods, including typing, navigating financial system interfaces, executing SQL queries, and operating remote support and ticketing platforms.
- Ability to operate telephone, mobile devices, and other standard office equipment.
- Requires prolonged sitting, occasional standing, bending, and lifting of equipment as needed.
- Must have the ability to read and comprehend system logs, database outputs, financial reports, technical documentation, and vendor communications in both digital and printed formats.
- Must demonstrate the ability to be resourceful in seeking out information, diagnosing root causes across complex, multi-layered financial technology environments, and making sound judgments and decisions under pressure.
- Must effectively prioritize a dynamic workload with competing demands across multiple open issues and projects simultaneously, maintain focus and composure in a fast-paced legal environment, and take ownership of issues from initial identification through to resolution.
- Ability to communicate technical concepts clearly and professionally — both verbally and in writing — to Finance, Accounting, IT colleagues, and firm leadership at all levels.
- Must maintain strict confidentiality and exercise discretion when handling sensitive financial, client, and firm data at all times.
Please Note:
This job description sets forth the job’s principal duties, responsibilities, and requirements; however, it should not be construed as an exhaustive statement. Unless they begin with the word “may,” the essential duties, tasks, and responsibilities described above are “essential functions” of the job, as defined by the Americans with Disabilities Act.
Compensation & Benefits
The expected base salary range for this position is $115,000 - $155,000, commensurate with experience. Redgrave LLP offers a comprehensive benefits package including medical, dental, vision, 401(k), and paid time off.
In addition, due to the nature of the technical data and controlled materials involved in the client engagement you will support, access is restricted under U.S. export control regulations (ITAR/EAR) to U.S. citizens only and cannot be extended to lawful permanent residents or other protected individuals. Accordingly, Redgrave LLP will request documentation confirming citizenship status prior to your start date.
Redgrave LLP is an Equal Opportunity Employer
Skills
- Active Directory
- AI
- Analytics
- Automation
- AWS
- Azure
- Cloud
- Cybersecurity
- Data Governance
- Data Modeling
- Data Visualization
- ETL
- Financial Reporting
- Help Desk
- IAM
- Itar
- Microsoft Exchange
- Networking
- Performance Management
- PostgreSQL
- Power Automate
- Power Apps
- Power BI
- Process Improvement
- Regulatory Compliance
- RHEL
- SaaS
- Service Desk
- SharePoint
- SOC 2
- SQL
- SQL Server
- SSRS
- Virtualization
- VMware
- Windows Server
Sign in to read and join the discussion.