Data Engineer

Jackson Walker • Dallas, TX

2d

About The Position

The Data Engineer supports Microsoft SQL Server databases, queries, interfaces, and related application integrations, with secondary responsibility for the Firm’s Aderant financial applications. Under the guidance of senior team members, this entry-level position assists with database support, troubleshooting, testing, documentation, application administration, and routine configuration. The role partners 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.

The position also supports cash-application processes and client-account exception resolution, and helps maintain accurate revenue and receivable reporting, reconciliations, and month-end processes. It assists with application releases, upgrades, testing, deployment validation, and cross-team knowledge transfer. The role operates in a professional office environment and routinely uses a computer, telephone, and standard office equipment. Work may occasionally exceed 40 hours per week or involve irregular hours to meet monthly deadlines and other business needs.

Requirements

• Bachelor’s degree from an accredited college or university preferred; equivalent technical training or relevant experience will be considered.
• 1–3 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.
• Strong troubleshooting and organizational skills, with attention to detail.
• Effective communication skills and 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.

Nice To Haves

• Experience with Aderant Expert or another legal, financial, ERP, or enterprise application.
• Familiarity with billing, timekeeping, collections, or accounting workflows.
• Exposure to SQL Server Reporting Services (SSRS), SQL Agent jobs, Windows services, or application integrations.
• Familiarity with Subversion or Git, ticketing systems, and Agile project practices.

Responsibilities

• 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, gather supporting details, and escalate complex problems to senior staff.
• Support data imports, exports, scheduled jobs, interfaces, and integrations across Aderant and other Firm systems.
• Support 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 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 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.
• 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.

What This Job Offers

• Job Type: Full-time
• Career Level: Entry Level