Data Engineer

Please note that Jackson Walker is not currently accepting search firm submissions in connection with this opening.

FLSA: Exempt

Reports To: Director of Application Development

Department: Information Technology

POSITION SUMMARY:

The Data Engineer supports Microsoft SQL Server databases, queries, interfaces, and related application integrations, with secondary responsibility for the Firm’s Aderant financial applications. Working under the guidance of senior team members, this entry-level position assists with database support, troubleshooting, testing, documentation, application administration, and routine configuration.

The position partners closely with Firm leadership, attorneys, practice and office leadership, Accounting and Finance, and other administrative teams to identify and resolve revenue-cycle issues, strengthen processes and controls, and improve financial performance.

ESSENTIAL DUTIES AND RESPONSIBILITIES:

SQL Server and Database Support

• Provide day-to-day support for Microsoft SQL Server environments under established procedures and senior-level guidance.
• Write, test, and maintain T-SQL queries, views, and stored procedures for application support, troubleshooting, and operational needs.
• Assist with database monitoring, backups, restores, performance checks, security, and data integrity validation.

• Troubleshoot database-related issues, collect supporting details, and escalate complex problems to senior staff.
• Support data imports, exports, scheduled jobs, interfaces, and integrations across Aderant and other Firm systems.

Aderant Application Support

• 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, collect logs and supporting details, and escalate complex problems to senior staff or Aderant support.
• Support testing and validation for Aderant upgrades, patches, configuration changes, and integration
• 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 project team members to track Aderant issues through resolution.Oversee cash-application processes to support timely, accurate posting of client payments and resolution of unidentified or unapplied receipts.
• Ensure appropriate review and resolution of credit balances, unapplied cash, duplicate payments, refunds, and other client-account exceptions in accordance with Firm procedures and controls.
• Coordinate with Accounting and Finance to support accurate revenue and receivable reporting, reconciliations, month-end processes, and appropriate segregation of duties

Application Maintenance and Release Support

• Assist with release preparation, test-environment refreshes, upgrade runbooks, deployment checklists, and post-change validation.
• Participate in knowledge transfer and cross-training with application development, database, infrastructure, and business teams.
• Perform other duties as assigned.

QUALIFICATIONS:

• Bachelor’s degree from an accredited college or university preferred; equivalent technical training or relevant experience will be considered.
• Minimum of two 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 document technical issues, procedures, and resolutions clearly.
• Ability to handle confidential information and follow established security and change-control procedures.
• Experience with Aderant Expert or another legal, financial, ERP, or enterprise application preferred.
• Familiarity with billing, timekeeping, collections, or accounting workflows preferred.
• Exposure to SQL Server Reporting Services (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 skills and the ability to work collaboratively.
• Ability to ask questions, follow documented procedures, and escalate issues when appropriate.
• Curiosity, dependability, and motivation to build expertise in SQL Server, Aderant, and enterprise application support.

WORK CONDITIONS:

This position operates in a professional office environment with limited exposure to excessive noise or temperature variations and routinely uses a computer, telephone, and other standard office equipment. The role requires extended computer use, review of detailed financial information, and communication with Firm leadership, attorneys, clients, and business professionals. Work may occasionally require more than 40 hours per week or irregular hours to meet recurring monthly deadlines and other business needs.

The above is intended to describe the general content of and requirements for the performance of this job. It is not to be construed as an exhaustive statement of essential functions, responsibilities, or requirements.

We are proud to be an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, age, veteran status, sexual orientation, gender identity, marital status, pregnancy, genetic information, or any other characteristic protected by law and will not be discriminated against on the basis of disability. It is our intention that all qualified applicants are given equal opportunity and that employment decisions be based on job-related factors.