[Hiring] Databricks Data Engineer SME @LMI

Role Description

LMI is seeking a skilled Databricks Data Engineer SME (DHA RevOS / Databricks, War Data Platform & Data Visualization) to serve as a senior technical lead responsible for designing, restructuring, and implementing the data foundation required for the Defense Health Agency (DHA) Revenue Cycle Operating System (RevOS).

This role will work directly within a Databricks-based War Data Platform (WDP) environment to:

• Assess existing DHA revenue-cycle data structures.
• Identify architectural and data-quality deficiencies.
• Redesign those structures into a scalable, governed, and reusable revenue-cycle data model.

The primary objective is to establish a connected data architecture representing the actual healthcare revenue-cycle workflow:

• Scheduling
• Eligibility
• Registration
• Authorization
• Patient Care
• Documentation
• Coding
• Charge Capture
• Claim
• Adjudication
• Payment
• Denial
• Follow-Up
• Recovery

The Senior Data Engineer SME will ensure DHA's existing data is reorganized around this workflow so individual encounters, charges, codes, claims, payments, denials, and recovery activities can be connected and traced through the entire revenue lifecycle.

The individual will also be responsible for ensuring the resulting Databricks data architecture directly supports:

• Production dashboards
• Operational visualizations
• RevOS SITREP views
• KPI reporting
• Drill-down analysis

In addition, this candidate will have demonstrated experience in collaborating with other data engineers and data scientists, and effective communication with clients.

Qualifications

• Active SECRET Clearance
• Bachelor's Degree and 10+ years of experience in enterprise data engineering, data architecture, data platform development, or related disciplines.
• Senior/SME-level hands-on experience with Databricks.
• Demonstrated experience using Databricks visualization and dashboard capabilities, including Databricks SQL and/or AI/BI dashboards.
• Ability to design the underlying Gold/semantic data structures required for enterprise-scale dashboards and operational reporting.
• Experience creating and optimizing SQL queries, datasets, and views that support interactive visualization and drill-down.
• Strong experience with:
• Apache Spark / PySpark
• SQL
• Python
• Delta Lake
• ETL / ELT
• Data pipeline orchestration
• Large-scale data transformation
• Demonstrated experience implementing Bronze / Silver / Gold medallion architectures.
• Strong experience designing normalized and analytical data models for complex enterprise environments.
• Demonstrated ability to evaluate and redesign or remediate poorly structured existing data environments.
• Experience designing canonical data models, conformed dimensions, enterprise keys, entity resolution, and reusable semantic structures.
• Strong knowledge of data-quality engineering, financial reconciliation, metadata, lineage, and data governance.
• Experience with Databricks Unity Catalog or equivalent enterprise data-governance/catalog technology.
• Experience building production-grade pipelines with automated testing, monitoring, logging, failure handling, and CI/CD.
• Ability to translate operational workflows into logical and physical data architectures and visualization-ready products.
• Experience supporting highly regulated, healthcare, financial, or Government environments.
• Ability to work with PHI, PII, CUI, and other controlled data under applicable security and privacy requirements.
• Ability to work across engineering, analytics, visualization, cybersecurity, product, architecture, and business-SME teams.
• Ability to meet applicable DHA/DoD security, privacy, access, and data-handling requirements.

Preferred Qualifications

• Prior experience with Advana and/or the current War Data Platform (WDP).
• Direct experience developing Databricks data products and dashboards in a DoD enterprise environment.
• Experience with DHA, MHS, or other DoD healthcare data.
• Experience with MHS GENESIS / Oracle Health/Cerner Millennium and/or Abacus.
• Healthcare revenue-cycle data experience involving encounters, coding, charge capture, claims, denials, adjudication, remittance, payments, AR, and revenue recovery.
• Familiarity with healthcare EDI transactions including 837, 835, 270/271, 276/277, and 278.
• Experience implementing Open Data Contract Standard (ODCS) or comparable machine-readable contracts.
• Experience with GitLab-based DevSecOps, infrastructure-as-code, automated testing, and secure promotion.
• Familiarity with Collibra or comparable enterprise data catalogs.
• Experience supporting financial auditability, reconciliation, lineage, and audit-remediation initiatives.
• Familiarity with DoD RMF, NIST, IL4/IL5 environments, and federal data-governance requirements.

Salary Range

Target Salary Range: $123,000 - $160,000

The salary range displayed represents the typical salary range for this position and is not a guarantee of compensation. Individual salaries are determined by various factors including, but not limited to location, internal equity, business considerations, client contract requirements, and candidate qualifications, such as education, experience, skills, and security clearances.

Job Locations

US-Remote