Data Engineer

What you’ll do

• Deliver day-to-day support for Microsoft SQL Server environments following established procedures and senior-level direction.
• Write, test, and maintain T-SQL queries, views, and stored procedures to support application needs, troubleshooting, and operational requirements.
• Assist with database monitoring, backups, restores, performance checks, security, and data integrity validation.
• Troubleshoot database-related issues by gathering supporting details and escalating complex problems to senior staff.
• Support data imports/exports, scheduled jobs, and interfaces and integrations across Aderant and other firm systems.
• Provide application support for Aderant Expert and related modules, including Expert Billing, Expert Collections, Entity Manager, and other supported applications.
• Assist with user access, security groups, application settings, templates, and routine configuration changes.
• Troubleshoot user-reported Aderant issues by collecting logs and supporting details, then escalate complex problems to senior staff or Aderant support.
• Support testing and validation for Aderant upgrades, patches, configuration changes, and integrations.
• Monitor Aderant scheduled jobs and interfaces, document failures, and assist with restart or recovery procedures.
• Maintain application support documentation, configuration records, test scripts, and operating procedures.
• Coordinate with Accounting, IT, vendors, and the project team to track Aderant issues through resolution.
• Assist with release preparation, test-environment refreshes, upgrade runbooks, deployment checklists, and post-change validation.
• Participate in knowledge transfer and cross-training across application development, database, infrastructure, and business teams.
• Perform other duties as assigned.

What you’ll bring

• Bachelor’s degree from an accredited college or university preferred; equivalent technical training or relevant experience will be considered.
• At least 2 years of experience in SQL Server support, database support, application support, systems administration, or a related technical role.
• Working knowledge of Microsoft SQL Server, relational database concepts, and the ability to write and troubleshoot basic T-SQL queries.
• Understanding of database troubleshooting, software testing practices, and application integrations.
• Ability to clearly document technical issues, procedures, and resolutions.
• Ability to handle confidential information and follow established security and change-control procedures.
• Aderant Expert (or another legal, financial, ERP, or enterprise application) preferred, with billing, timekeeping, collections, or accounting workflows preferred.
• Exposure to SSRS, SQL Agent jobs, Windows services, or application integrations preferred.
• Familiarity with Subversion or Git, ticketing systems, and Agile project practices preferred.
• Strong troubleshooting and organizational skills with attention to detail; effective communication and collaboration.
• Ability to ask questions, follow documented procedures, and escalate issues when appropriate, with curiosity and dependability.

Technologies you’ll work with

• Microsoft SQL Server, T-SQL, SSRS, SQL Agent jobs, Windows services
• Aderant Expert, Expert Billing, Expert Collections, Entity Manager
• Subversion, Git

Work schedule and environment

• Hybrid schedule: two days per week in the office and three days per week working remotely from home.
• Professional office environment with limited exposure to excessive noise or temperature variations; routinely uses a computer, telephone, and standard office equipment.
• Extended computer use, review of detailed technical information, and communication with users, team members, and vendors.
• Occasional need for more than 40 hours per week or irregular hours to support system maintenance, releases, and other business needs.

Position details: Exempt (FLSA). Reports to the Director of Application Development in the Information Technology department.