Eric Warren II

Led design and implementation of scalable data infrastructure for the Health Equity Tracker, an open-source epidemiological data platform supporting research and policy decisions across the United States.

Data Pipeline & ETL Development:

• Architected and implemented Python/Apache Airflow data pipelines to extract, transform, and load multiple CDC surveillance datasets (HIV/NHSS, gun violence/MIOVD, injury/WISQARS) at scale, ensuring data quality and regulatory compliance
• Designed ETL workflows for complex epidemiological datasets with validation frameworks and automated monitoring to detect data integrity issues
• Optimized pipeline performance, reducing processing times and cloud infrastructure costs by 60% while maintaining reliability for production research systems
• Database & Data Management:
• Designed and maintained relational database schemas for healthcare and epidemiological research data
• Implemented SQL optimization strategies for large-scale health datasets, improving query performance and reducing cloud storage costs
• Managed data versioning and documentation practices to support reproducible research workflows and audit compliance

Data Visualization & Analytics Infrastructure:

• Developed interactive data visualization dashboards using D3.js and Vega-Lite, enabling researchers to identify geospatial patterns and demographic disparities across health outcomes and social determinants
• Created data access APIs and dashboards supporting multiple stakeholder groups (researchers, policymakers, epidemiologists)

Research Support & Collaboration:

• Partnered with epidemiologists, biostatisticians, and public health researchers to translate research questions into data infrastructure solutions
• Ensured systems compliance with institutional data governance standards and research ethics requirements
• Documented system architecture and data lineage to support research reproducibility and institutional audits
• Mentored cross-functional teams on data quality standards and pipeline best practices

Cloud Infrastructure:

• Managed Google Cloud Platform infrastructure (BigQuery, Cloud Storage, Cloud Functions) for cost-effective, scalable research data management
• Implemented monitoring and alerting systems to ensure reliable, continuous operation of production research systems

• Developed high-quality, performant web and native applications using React, React Native, and GraphQL for mission-critical donation platform serving churches and nonprofits.
• Collaborated with Product and Engineering teams to implement features enabling streamlined contribution workflows
• Built responsive web interfaces and mobile applications with emphasis on user experience and performance

• Managed and optimized data systems for insurance claims processing and recovery analysis.
• Reviewed and processed medical bills for submission to the Michigan Catastrophic Claims Association (MCCA) with high accuracy and compliance
• Utilized Tableau to design and maintain interactive dashboards for real-time tracking of claim statuses, outstanding reimbursements, and recovery trends
• Analyzed claims data to identify patterns and optimize reimbursement processes