DataJobs.io
← Back to all jobs

Job Description

Alera Group is seeking a Senior Data & AI Engineer to modernize and automate Vital Incite’s population health analytics data infrastructure. The role will initially emphasize data quality, validation, ETL reliability, and BI readiness, with a longer-term focus on AI-enabled capabilities such as anomaly detection, report analysis, and predictive analytics.

Responsibilities

  • Design automated data-quality and validation controls across healthcare claims, eligibility, pharmacy, biometric, wellness, and related datasets.
  • Enhance and support SQL Server solutions, including stored procedures, SSIS/ETL pipelines, data transformations, and BI refresh processes.
  • Create configurable warning, failure, reconciliation, duplicate, and anomaly-detection rules to improve overall data trust.
  • Improve monitoring, logging, exception handling, and root-cause identification across data pipelines.
  • Automate file ingestion with schema validation, field mapping, and data normalization.
  • Build reusable data services and APIs that support analytics and future AI applications.
  • Partner with analysts and clinical teams to automate report review, insight generation, alert discovery, and population-health analytics.
  • Develop AI-assisted capabilities using LLMs, machine learning, and statistical anomaly detection where appropriate.
  • Maintain strong security, auditability, data lineage, and controls for PHI and sensitive healthcare data.

Requirements

  • 5+ years of data engineering or analytics engineering experience.
  • Advanced SQL Server and T-SQL skills.
  • Strong experience with ETL/data pipelines, ideally SSIS or comparable tools.
  • Experience with stored procedures, performance tuning, query optimization, and large datasets.
  • Experience with data validation, reconciliation, profiling, and quality-control frameworks.
  • Experience with Python for data processing, automation, APIs, or machine learning.
  • BI/data warehouse experience, preferably SSAS, Power BI, or similar tools.
  • Experience designing monitoring, exception handling, logging, and automated alerts.
  • API and structured-data integration experience, including CSV, Excel, JSON, and flat-file ingestion.
  • Experience with Git/source control and modern software development practices.
  • Ability to apply AI safely and practically to business and data workflows (not required to be an AI research scientist).
  • Experience with LLM APIs such as OpenAI, Azure OpenAI, Anthropic, or equivalent.
  • Experience with retrieval-augmented generation and structured LLM outputs.
  • Experience with machine learning or statistical anomaly detection.
  • Experience with prompt design and AI workflow orchestration.
  • Knowledge of evaluation, hallucination controls, traceability, and human review.
  • Experience building AI capabilities on top of governed enterprise data.

Technologies

  • SQL Server, T-SQL, SSIS, ETL
  • Python
  • SSAS, Power BI
  • Git
  • OpenAI, Azure OpenAI, Anthropic
  • LLM APIs, LLMs
  • Machine learning

Work Arrangement

Remote within the United States.

Success KPIs

  • Improve reliability and visibility of the existing data-refresh process.
  • Automate high-value QA and validation controls.
  • Reduce manual data investigation and file-mapping work.
  • Create reusable data-quality and monitoring capabilities.
  • Establish a trusted foundation for AI.
  • Begin delivering production AI use cases from the population-health roadmap.

Compensation

  • Salary Range: $160,000–$170,000 per year
  • Bonus Eligible: Yes

Benefits

  • Medical, dental, and vision insurance
  • Life and disability coverage
  • 401(k)
  • Generous paid time off
  • Professional development opportunities

Healthcare / Employee Benefits Data Focus

  • Commercial healthcare claims and eligibility data
  • Medical and pharmacy claims
  • Member-level population health analytics
  • Employer-sponsored health plans
  • Healthcare cost and utilization analytics
  • Clinical risk stratification
  • HIPAA, PHI, and healthcare data privacy

Similar Jobs