Senior Data & AI Engineer, Population Health Analytics
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