A

Alera Group

Provides employee benefits, risk, wealth management

Senior Data & AI Engineer - Population Health Analytics

Data EngineeringPosted on Nov 13
Full-timeRemote in USARemote

About the Job

Requirements

  • At least 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.
  • 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.

Responsibilities

  • Build automated data-quality and validation controls across healthcare claims, eligibility, pharmacy, biometric, wellness, and related datasets.
  • Enhance and support SQL Server, stored procedures, SSIS/ETL pipelines, data transformations, and BI refresh processes.
  • Develop configurable warning, failure, reconciliation, duplicate, and anomaly-detection rules.
  • Improve monitoring, logging, exception handling, and root-cause identification across data pipelines.
  • Automate file ingestion, schema validation, field mapping, and data normalization.
  • Build reusable data services and APIs to 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 around PHI and sensitive healthcare data.
  • 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.

Desired Qualifications

  • 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.
  • Experience with evaluation, hallucination controls, traceability, and human review.
  • Experience building AI capabilities on top of governed enterprise data.
  • Healthcare and employee benefits experience, including 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, and HIPAA, PHI, and healthcare data privacy.

About the Company

Alera Group

Provides employee benefits, risk, wealth management

Alera Group provides tailored employee benefits, risk management, and wealth management services to businesses, nonprofits, and individuals across the United States. It combines national-scale resources with a local office network to deliver personalized consulting, pricing, and advisory services for insurance, benefits, and retirement plans. The firm differentiates itself through its national reach paired with strong local relationships and industry-specific expertise, offering programs such as compliance consulting, workplace wellness, and reference-based pricing to control healthcare costs. Its goal is to help clients navigate complex insurance and financial landscapes, stay compliant, and achieve their benefits and wealth objectives.

Company size
1,001-5,000
Company stage
Debt Financing
Total funding
$4.3B
Headquarters
Deerfield, IL
Founded
2017

Recently Posted Jobs

Explore more opportunities at Alera Group

See more jobs