About me

I am Zirui Huang , I go by Ray. I am currently a Data Scientist of Cambridge Systematics, Inc., a premier transportation consulting company.

I specialize in bridging the gap between robust data engineering and analytical science. I have experience transforming complex, large-scale data challenges—primarily within traffic and transit systems—into high-performance, intuitive systems. Using a modern tech stack, I build scalable ELT pipelines that turn raw records into production-ready assets.

My focus is on architecting reliable infrastructure to power everything from BI dashboards to Machine Learning models. I am particularly interested in the intersection of data and AI, developing RAG-based chatbots and MCP servers for intelligent data interaction. I ensure complex backend workflows deliver clear, actionable strategies that bring data to life.

Skillset

Data Engineering & Infrastructure

  • Pipeline Orchestration

    Dagster, Airflow

    design icon
    design icon
  • Extraction

    dlt (data load tool), Fivetran

    design icon
    design icon
  • Transformation

    dbt

    design icon
  • Storage

    DuckDB, PostgresSQL

    design icon
    design icon
  • Cloud Platforms

    GCP, AWS, MotherDuck, Snowflake

    design icon
    design icon
    design icon
    design icon

Data Science & Analytics

  • BI Dashboards

    Power BI, Tableau, Evidence.env

    design icon
    design icon
    design icon
  • Web Interface

    Streamlit

    design icon
  • Machine Learning

    Scikit-learn, PyTorch

    design icon
    design icon

Generative AI & Agents

  • LLM Integration

    MCP servers, LangChain, Hugging Face

    design icon
    design icon
    design icon
  • Vector Databases

    Chroma, Pinecone

    design icon
    design icon

Development & Workflow

  • Version Control

    Git, GitHub, GitHub Actions (CI/CD)

    design icon
    design icon
    design icon
  • DevOps

    Virtual Environments (uv), Docker

    design icon
    design icon

Clients

Resume

Education

  1. University of Arizona 🐻⬇️

    Ph.D. 2018 — 2023 Tucson, AZ, USA

    Major: Transportation (Advisors: Dr. Yi-Chang Chiu and Dr. Yao-Jan Wu)
    Minor: Computer Science (Advisor: Dr. Chicheng Zhang)
    Dissertation: "Investigating Incident-Induced Congestion for Personalized Travel Demand Management"

  2. Tongji University

    B.E. 2014 — 2018 Shanghai, China

    Major: Transportation Telematics Thesis: "Traffic Density Estimation based on Vehicles Speed Profile Data" 🏆 Best Undergraduate Thesis Papers

Experience

  1. Senior Professional Data Analyst

    Cambridge Systematics, Inc. 2023 — Present New York, NY, USA

    Nemo enim ipsam voluptatem blanditiis praesentium voluptum delenit atque corrupti, quos dolores et qvuas molestias exceptur.

  2. Research & Development Intern

    Metropia, Inc. 2022 — 2023 Houston, TX, USA

    Nemo enims ipsam voluptatem, blanditiis praesentium voluptum delenit atque corrupti, quos dolores et quas molestias exceptur.

Blog

Contact

Contact Form