Abhishikth D

About Abhishikth D

I am a Data Engineer currently working at Acacia Center for Justice, where I design and maintain reliable data ingestion and ETL pipelines supporting the Unaccompanied Children Program (UCP). My work focuses on building scalable data models and automated workflows that enable accurate reporting, applied research, and data-driven decision-making.I collaborate closely with research, program, and IT teams to resolve data integration, migration, and quality challenges, ensuring data accuracy while meeting strict security and federal compliance standards. I place strong emphasis on automation, documentation, and repeatable processes to reduce manual effort and improve operational reliability.I have experience integrating geocoding workflows into data pipelines to enhance spatial analysis and automate reporting outputs for stakeholders. I also develop quality control workflows to validate data and ensure consistent, high-quality reporting. My approach centers on building maintainable, secure, and well-documented data systems that support both immediate program needs and long-term organizational goals.

Experience

1. Data Engineer

   Acacia Center for Justice

   Sep 2024 — Present

   Designed, developed, and maintained robust data ingestion and ETL pipelines using AWS (Redshift, S3) and Apache Airflow, ensuring efficient and reliable daily data flows for the UCP program. Architected and implemented scalable data models, including star schema designs, to support comprehensive reporting and applied research analysis.Collaborated closely with the Acacia REDA team, program management, and IT to identify and resolve data integration, migration, and data quality challenges, ensuring accuracy, consistency, and compliance across systems. Automated scheduled workflows and repeatable processes using Apache Airflow, AWS Lambda, and GitHub Actions, streamlining data operations and minimizing manual intervention.Developed and maintained detailed technical documentation for data systems, ETL processes, and schema migrations to support cross-team collaboration and continuous improvement. Worked closely with IT to ensure all data ecosystems adhered to data security and federal compliance standards, protecting sensitive immigration data while integrating seamlessly with Acacia’s internal systems.Integrated geocoding workflows into data ingestion pipelines using Python geocoding libraries and APIs, transforming raw address data into standardized geographic coordinates to enable enhanced spatial analysis and mapping of immigration cases. Leveraged the SharePoint Graph API to automate data exports and integrate reporting outputs into SharePoint, ensuring stakeholders received timely and up-to-date insights.Developed and implemented a dedicated Quality Control (QC) DAG for the monthly reporting process to automate data validation and error detection, ensuring accurate and high-quality reports were delivered on schedule. Transitioned legacy R-based processes into automated Python-based Airflow DAGs, improving efficiency, reliability, and maintainability across data ingestion, transformation, and reporting workflows.

Education

• University of Cincinnati

  Master's degree, Information Technology

• Velagapudi Ramakrishna Siddhartha Engineering College

  Bachelor of Technology, electronics and communication

  2016 — 2020