About this internship

Data Collection & Data Pipeline Engineering

  • Macroeconomic Extraction: Pulling historical consumer price indices (Headline CPI, Core CPI, and food/energy sub-indices) from databases like the US Bureau of Labor Statistics (BLS), Eurostat, or India's Ministry of Statistics and Programme Implementation (MOSPI).
  • Legislative Mapping: Building a structured database documenting exactly when statutory minimum wage increases were enacted across different states, provinces, or countries, including historical cash values.
  • Data Harmonisation: Cleaning and merging asynchronous datasets (e.g., aligning monthly inflation indices with irregular or annual statutory wage changes) using Excel.

 

Quantitative Analysis & Econometric Modeling

  • Real vs. Nominal Calculation: Deflating nominal wage increases against localized inflation to calculate the trajectory of actual worker purchasing power or real wages.
  • Elasticity & Lag Modeling: Writing statistical models to evaluate the pass-through effect, specifically analyzing how long it takes (3, 6, or 12 months) for a minimum wage hike to reflect in consumer prices.
  • Sectoral Disaggregation: Separating data by industry to analyze price adjustments in low-margin, labor-intensive sectors (e.g., hospitality, fast food, and retail) versus capital-intensive ones.
  • Regression Analysis Support: Running regression models (such as Difference-in-Differences or OLS) under senior guidance to isolate minimum wage effects from broader macroeconomic shocks like supply chain disruptions.

 

Data Visualisation & Dashboarding

  • Scatter & Trend Plotting: Building dual-axis charts, scatter plots, and time-series graphs to contrast wage growth timelines against inflation spikes.
  • Interactive Policy Dashboards: Constructing lightweight internal dashboards (using Tableau or Python Streamlit) that allow stakeholders to toggle between different states or regions to view their wage-to-inflation elasticity.

 

Policy Reporting & Synthesis

  • Literature Syntheses: Reviewing structural economic literature—balancing historical frameworks (like the Card-Krueger studies) with modern research on the wage-price spiral.
  • Policy Brief Drafting: Writing concise executive summaries that translate regression coefficients into straightforward terms for policy makers or corporate clients, outlining if the wage hike boosted demand or squeezed local business margins.

Courses included free