Data Engineer

Data Engineer

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.

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 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.

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 follows a hybrid work schedule, with two days per week in the office and three days per week working remotely from home. The positions 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 technical information, and communication with users, team members, and vendors. Work may occasionally require more than 40 hours per week or irregular hours to support system maintenance, releases, 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.