Data Engineer

Jackson Walker is hiring a Data Engineer to support Microsoft SQL Server and related application integrations, with secondary responsibility for Aderant financial applications, in a hybrid role based in Dallas, TX.

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 to support applications, troubleshooting, and operational needs.
• Assist with database monitoring, backups and restores, performance checks, security, and data integrity validation.
• Troubleshoot database-related issues by gathering supporting details, then escalate complex problems to senior staff.
• Support data imports/exports, scheduled jobs, 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, collect logs and supporting details, and escalate complex issues 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.
• 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.

Requirements

• Bachelor’s degree from an accredited college or university (preferred); equivalent technical training or relevant experience will be considered.
• Minimum 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 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.
• Preferred: 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.
• 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.

Technologies

• Microsoft SQL Server
• T-SQL
• SQL Server Reporting Services (SSRS)
• SQL Agent jobs
• Windows services
• Aderant Expert
• Expert Billing
• Expert Collections
• Entity Manager
• Subversion
• Git

Location & Work Arrangement

• Dallas, TX (hybrid): two days per week in the office and three days per week working remotely from home.

Work Conditions

• 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.
• May occasionally require more than 40 hours per week or irregular hours to support system maintenance, releases, and other business needs.

Additional Details

• Position Summary: Entry-level support for Microsoft SQL Server databases, queries, interfaces, and related application integrations; secondary responsibility for the Firm’s Aderant financial applications.
• FLSA: Exempt
• Reports To: Director of Application Development
• Department: Information Technology