Analytics Engineer

Ensemble RCM LLC is hiring a Senior Analytics Engineer to advance data, automation, and AI strategy for Revenue Cycle Management (RCM). This role focuses on analytics engineering rigor through scalable data modeling and transformation pipelines, with a strong emphasis on dbt running in a Databricks Lakehouse environment.

Responsibilities

• Design, develop, test, deploy, monitor, and continuously improve high-quality data models and transformation pipelines using dbt within a Databricks Lakehouse.
• Build scalable, maintainable, and reusable data models, macros, testing frameworks, and automation logic to support 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 and help lead technical design sessions, spike investigations, and data architecture reviews to ensure alignment with long-term platform and automation strategy.
• Conduct code reviews to support data model quality, promote modular and testable design, and mentor engineers through constructive feedback.
• Troubleshoot complex data issues across ingestion, transformation, and semantic layers, implementing sustainable long-term fixes.
• Promote analytics engineering excellence by advancing 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 provide guidance on potential impact.

Support the transformation of AR Follow-Up through structured datasets for:

• Account prioritization and scoring
• Denial categorization and trend analysis
• Aging analysis and performance tracking
• Workflow routing and automation logic

Requirements

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

Technologies

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

Benefits

• A comprehensive benefits package supporting physical, emotional, and financial health, including healthcare, time off, retirement, and well-being programs.
• Professional certification earning support relevant to the field, along with tuition reimbursement.
• Quarterly and annual incentive programs for employees who exceed expectations and raise the bar for themselves and the company.

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 working in regulated industries requiring data governance and compliance controls.
• Inquisitiveness and openness to innovation, including AI, to improve processes and reduce friction while enhancing patient and client experiences.

Travel Requirements

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

Compensation

This position pays $101,600 to $175,200 per year, based on experience.

Remote Location / Work Authorization

• This role 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. To request accommodation in the application process, contact [email protected].