Data Engineer
Job Description
This entry-level Data Engineer role supports Microsoft SQL Server environments and assists with Aderant financial application support.
Responsibilities
- Provide day-to-day support for Microsoft SQL Server environments using 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 tasks, and data integrity validation.
- Troubleshoot database issues by collecting supporting details and escalating 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 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 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 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.
- 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 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.
Technology
- 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
Work Location & Schedule
- Dallas, TX (hybrid)
- Two days per week in the office
- 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.
- Requires extended computer use, review of detailed technical information, and communication with users, team members, and vendors.
- Occasionally may require more than 40 hours per week or irregular hours to support maintenance, releases, and other business needs.
Additional Information
- Position summary: Supports Microsoft SQL Server databases, queries, interfaces, and related application integrations, with secondary responsibility for the firm’s Aderant financial applications. Assists with database support, troubleshooting, testing, documentation, application administration, and routine configuration under senior guidance.
- FLSA: Exempt
- Reports to: Director of Application Development
- Department: Information Technology