Analytics Engineer

Ensemble RCM LLC is advancing data, automation, and AI strategy in Revenue Cycle Management (RCM). As a Senior Analytics Engineer (remote, Austin, TX), you will help build production-grade analytics engineering foundations using dbt on a Databricks Lakehouse, transforming operational needs into reliable data models, transformation pipelines, and structured datasets that support intelligent AR Follow-Up.

What you’ll do

• Design, develop, test, deploy, monitor, and continuously improve high-quality data models and transformation pipelines using dbt in a Databricks Lakehouse environment.
• Build scalable, maintainable, and reusable data models, macros, testing frameworks, and automation logic aligned to cross-functional AR Follow-Up needs.
• Collaborate with operational and product stakeholders to translate AR workflows into technical designs and incremental deliverables that enable automation and intelligent prioritization.
• Partner with data architecture to establish and advocate for analytics engineering standards, including modeling conventions, naming patterns, and testing best practices.
• Participate in technical design sessions, spike investigations, and data architecture reviews to ensure alignment with long-term platform and automation strategy.
• Conduct and participate in code reviews to maintain data model quality, support modular and testable design, and provide mentorship through constructive feedback.
• Troubleshoot complex data issues across ingestion, transformation, and semantic layers to drive sustainable fixes.
• Promote analytics engineering excellence through automation, observability, data quality testing, governance, and continuous improvement.
• Design and optimize Delta Lake tables and Spark workloads for performance, scalability, and cost efficiency.
• Evaluate emerging tools, frameworks, and vendor solutions in the modern data ecosystem and advise on potential impact.
• Support AR Follow-Up transformation with structured datasets for examples such as:
  • Account prioritization and scoring
  • Denial categorization and trend analysis
  • Aging analysis and performance tracking
  • Workflow routing and automation logic

What you bring

• Bachelor’s degree in computer science, Engineering, Mathematics, Statistics, or a related technical field.
• 5+ years of experience in analytics engineering, data engineering, or building production-grade BI/data solutions.
• Strong hands-on experience with dbt in a modern ELT environment (or similar framework).
• Experience with Databricks, Spark, and Delta Lake (or comparable distributed data platforms).
• Advanced SQL expertise and experience optimizing large-scale data transformations.
• Deep knowledge of analytics engineering best practices, including automated testing, CI/CD, modular design, observability, and governance.
• Ability to build scalable data models in distributed or cloud-based architectures.
• Strong communication skills to translate complex technical concepts to diverse stakeholders.
• Curiosity and interest in enabling AI, ML, or intelligent automation initiatives.
• Knowledge of data architecture principles, modeling patterns, and analytics engineering best practices.

Technologies you’ll work with

dbt, Databricks Lakehouse, Databricks, Spark, Delta Lake, SQL, CI/CD

Compensation

This position pays USD 101,600 - 175,200 per year, based on experience.

Benefits

• Comprehensive benefits package supporting the physical, emotional, and financial health of you and your family, including healthcare, time off, retirement, and well-being programs.
• Professional certification opportunities relevant to your field, plus tuition reimbursement.
• Quarterly and annual incentive programs for employees who go beyond and keep raising the bar for themselves and the company.

Remote location and travel

This is a remote position (Austin, TX). Candidates must be willing and able to travel and work onsite at client, temporary, or corporate office locations as business needs require.

Work authorization

Due to business, operational, payroll, and regulatory requirements, this position is limited to individuals who reside and are authorized to work within the United States. Applications generated from outside the United States will not be considered. Individuals may reapply when located within the United States.

Accommodations

Ensemble provides reasonable accommodations to qualified individuals with disabilities in accordance with the Americans with Disabilities Act and applicable state and local law. If you require accommodation in the application process, contact [email protected].

Preferred skills

• Experience working with healthcare revenue cycle management data (claims, remittances, denials, payments, AR aging).
• Familiarity with AR Follow-Up workflows, operational work queues, or denial management processes.
• Experience supporting automation, workflow optimization, or rule-based systems.
• Exposure to ML feature engineering, model enablement, or AI-driven insights within Databricks.
• Experience in regulated industries requiring strong data governance and compliance controls.
• Inquisitive mindset and openness to innovation, including AI, to explore better processes and reduce friction while improving patient and client experiences.