Data Engineer

Welcome to Ovation Healthcare!

At Ovation Healthcare, we've been making local healthcare better for more than 40 years. Our mission is to strengthen independent community healthcare. We provide independent hospitals and health systems with the support, guidance and tech-enabled shared services needed to remain strong and viable. With a strong sense of purpose and commitment to operating excellence, we help rural healthcare providers fulfill their missions.

The Ovation Healthcare difference is the extraordinary combination of operations experience and consulting guidance that fulfills our mission of creating a sustainable future for healthcare organizations. Ovation Healthcare's vision is to be a dynamic, integrated professional services company delivering innovative and executable solutions through experience and thought leadership, while valuing trust, respect, and customer focused behavior.

We're looking for talented, motivated professionals with a desire to help independent hospitals thrive. Working with Ovation Healthcare you will have the opportunity to collaborate with highly skilled subject matter specialists and operations executives, in a collegial atmosphere of professionalism and teamwork.

Ovation Healthcare's corporate headquarters is located in Brentwood, TN. For more information, visit https://ovationhc.com.

Summary:

We're seeking an experienced Data Engineer with strong Revenue Cycle Management (RCM) domain knowledge to lead the design and optimization of data solutions supporting financial, operational, and reporting initiatives. This role requires deep SQL expertise, data warehousing experience, and advanced Power BI development skills.

What You'll Own:

• Design, write, and optimize complex, high-performance SQL queries
• Architect and maintain stored procedures, views, and reusable SQL functions (scalar & table-valued)
• Lead SQL Server development and performance tuning using SSMS
• Apply data warehousing principles to build scalable, reliable data models
• Develop enterprise-grade Power BI dashboards and reports for RCM analytics
• Create advanced DAX measures and optimized Power Query transformations
• Manage deployments, refresh schedules, and governance in Power BI Service
• Implement and enforce row-level security (RLS) and data access controls
• Translate RCM business requirements (billing, claims, payments, denials, AR) into technical solutions

What You Bring:

• Advanced SQL Server expertise with a strong performance-tuning focus
• Strong understanding of data warehousing and dimensional modeling
• Expert-level Power BI skills (DAX, Power Query, Power BI Service)
• Hands-on experience with RCM data (billing, claims, reimbursements, denials, AR aging)
• Advanced Excel skills for financial and operational analysis
• Experience supporting large, complex datasets in regulated environments
• Strong communication skills and ability to partner with business stakeholders

Working Conditions and Physical Requirements:

• Reliable high-speed internet connection is required for all remote/hybrid positions.

• Must have access to stable Wi-Fi with sufficient bandwidth to support video conferencing, cloud-based tools, and other online work-related activities.

• A HIPAA-compliant work environment is required, including a secure workspace free from unauthorized access or interruptions, no use of public Wi-Fi unless connected through a secure company-provided VPN, and compliance with all applicable HIPAA privacy and security regulations.