Senior Data Engineer Job Brentwood area,Tennessee USA,IT/Tech

We have a hybrid work arrangement.

EOE: race/color/religion/sex/sexual orientation/gender identity/national origin/disability/vet

JOB SUMMARY

This position is the primary builder and steward of THA's data infrastructure. The role is responsible for designing, developing, and maintaining the ETL pipelines, database systems, and data integrations that power THA's member-facing programs and internal operations. The Data Engineer ensures the reliable delivery of healthcare data products, including the Health Information Network's quarterly hospital discharge data program and hospital quality reporting, and maintains the SQL Server environment that supports them.

This role requires a builder's mindset: someone equally at home designing a new pipeline from scratch, troubleshooting a failing one, and owning the server environment underneath both.

ESSENTIAL FUNCTIONS OF THE JOB

The ability to adapt to a changing work environment and meet challenges presented throughout the day.

ETL Development and Pipeline Maintenance: Design, develop, and maintain ETL (Extract, Transform, Load) processes and data pipelines. Build new integrations as THA programs require them and ensure existing manual and automated workflows run reliably across THA's data programs (Data Bank, IRF, HIP, etc). This is the primary and most time-intensive function of the role.

Health Information Network (HIN) Data Processing: Serve as the primary technical resource for quarterly processing of hospital UB-04 discharge data. THA member hospitals and multiple program areas (advocacy, patient safety, quality) depend on this data for strategic planning and compliance reporting. Coordinate with the Tennessee Department of Health on all related activities.

SQL Development and Database Engineering: Develop and optimize complex T‑SQL queries, stored procedures, views, functions, and triggers. Design and model new databases. Create and manage SQL Server objects and Agent jobs that automate routine operations.

External System Integrations: Build and maintain integrations with external data systems and vendors, including state agencies and national healthcare data sources (e.g., NHSN). Develop automated tools that facilitate data submission and exchange for member hospitals.

Reporting and Analytics Delivery: Develop and maintain reports and analytics products using Tableau, Power BI, and similar tools. Fulfill ad hoc data requests from THA staff and support data subscriptions that generate direct revenue for the organization.

SQL Server Administration: Manage SQL Server environments across development and production: patching and version upgrades, backup and recovery processes, storage and capacity planning, index management, query performance tuning, and user access (logins, connection strings, permissions).

Data Security and HIPAA Compliance: Implement and maintain appropriate controls, auditing, authentication, and encryption on all protected datasets. Handle all data in accordance with HIPAA requirements, THA data security policy, and applicable data release agreements.

Collaboration and Support: Work with IS/IT staff, program teams, and data analysts to understand data needs and translate them into reliable technical solutions.

Availability: Must be available in the office during regular office hours unless job responsibilities require otherwise, or a hybrid work arrangement is in place.

MARGINAL JOB FUNCTIONS

Provide guidance and support to application developers and data analysts.

Create and maintain documentation for all processes, system configurations, and changes.

DIMENSIONS

Dollar Value

Responsible for fulfilling special data requests and data subscriptions that generate over $275,000 in annual revenue for THA. Key technical role supporting the operation of the THA Health Information Network discharge data program, which generates nearly $1,100,000 in annual member dues.

Volume

Database servers: 5
Databases: 25
Direct database users: 8
Direct reports: 0

ORGANIZATION STRUCTURE

Positions reporting directly to this role, if any:
None

GUIDANCE AND DIRECTION

Health Insurance Portability and Accountability Act (HIPAA)
THA Information Security Policies and Procedures
THA…