Jose (Chema) Galvez.
I turn messy data into trustworthy databases and insights.
Analytics Engineer and BI specialist designing scalable systems that turn public data into usable, transparent tools.
Hi, my name is
About Me
I’m a BI and Analytics Engineer with background in economics and public policy. I replace manual reporting with scalable, version-controlled data models. My work has a special focus in applying software engineering principles to SQL workflows in order to build robust ETL pipelines and automated datasets.
While I can design and ship front-end dashboards, my focus is on the ETL/ELT infrastructure and Python pipelines that power them.
Here are a few technologies I've been working with recently:- Python
- SQL Server (SSMS)
- Github Actions
- Tableau &. Power BI
- FastAPI
- VisualCron
Projects
JavaScriptD3.jsData Journalism
How Much More Violent Is Mexico Since You Were Born?
Interactive journalistic piece exploring how violence in Mexico has evolved over time. Enter your birth year to generate a personalized, data-driven narrative of the country's security landscape across your lifetime.
PythonScikit-learnPandasMachine Learning
Stock Classification with Machine Learning
Four ML models calibrated to classify daily stock records into Buy, Hold, or Sell signals using technical indicators, company financials, and market metadata. Contrasts active vs. passive investing philosophies to assess the feasibility of automating investment decisions at the stock-day level. Data sourced and cleaned from official government and private reports.
PythonGeoPandaspygrisACS API
Parks & Rec — Open Space Equity Analysis
Analyzed open space access equity across Chicago by assigning land parcels to census tracts and producing socio-demographic statistics. Census tract geometries sourced via the pygris package; statistical data pulled from the American Community Survey API.
PythonScikit-learnPandasMachine Learning
Stock Classification with Machine Learning
Four ML models calibrated to classify daily stock records into Buy, Hold, or Sell signals using technical indicators, company financials, and market metadata. Contrasts active vs. passive investing philosophies to assess the feasibility of automating investment decisions at the stock-day level. Data sourced and cleaned from official government and private reports.
PythonGeoPandaspygrisACS API
Parks & Rec — Open Space Equity Analysis
Analyzed open space access equity across Chicago by assigning land parcels to census tracts and producing socio-demographic statistics. Census tract geometries sourced via the pygris package; statistical data pulled from the American Community Survey API.
HTMLD3.jsData Visualization
China's Solar Export Network
Static visualization exploring where China's solar technology exports flow — distinguishing between countries adopting the technology (e.g., Europe) and those becoming business partners through direct Chinese investment (e.g., UAE).
PythonGeoPandaspygrisACS API
Parks & Rec — Open Space Equity Analysis
Analyzed open space access equity across Chicago by assigning land parcels to census tracts and producing socio-demographic statistics. Census tract geometries sourced via the pygris package; statistical data pulled from the American Community Survey API.
HTMLD3.jsData Visualization
China's Solar Export Network
Static visualization exploring where China's solar technology exports flow — distinguishing between countries adopting the technology (e.g., Europe) and those becoming business partners through direct Chinese investment (e.g., UAE).
JavaScriptD3.jsData Journalism
How Much More Violent Is Mexico Since You Were Born?
Interactive journalistic piece exploring how violence in Mexico has evolved over time. Enter your birth year to generate a personalized, data-driven narrative of the country's security landscape across your lifetime.
HTMLD3.jsData Visualization
China's Solar Export Network
Static visualization exploring where China's solar technology exports flow — distinguishing between countries adopting the technology (e.g., Europe) and those becoming business partners through direct Chinese investment (e.g., UAE).
JavaScriptD3.jsData Journalism
How Much More Violent Is Mexico Since You Were Born?
Interactive journalistic piece exploring how violence in Mexico has evolved over time. Enter your birth year to generate a personalized, data-driven narrative of the country's security landscape across your lifetime.
PythonScikit-learnPandasMachine Learning
Stock Classification with Machine Learning
Four ML models calibrated to classify daily stock records into Buy, Hold, or Sell signals using technical indicators, company financials, and market metadata. Contrasts active vs. passive investing philosophies to assess the feasibility of automating investment decisions at the stock-day level. Data sourced and cleaned from official government and private reports.
Experience
Business Intelligence Intern
Metropolitan Family Services (MFS)
· Chicago, IL
Built data infrastructure and operational analytics tools to improve IT service tracking at a social services nonprofit.
- Engineered a nightly ETL pipeline in Python/PowerShell integrating MySQL and SQL Server backends, processing 15,000+ records with automated scheduling via VisualCron and implementing try/except error handling for zero data loss.
- Designed and delivered a Tableau dashboard surfacing SLA compliance, resolution time, and backlog trends to C-suite leadership, identifying a structural routing gap that had excluded an entire team from ticket attribution.
- Partnered with IT leadership to redesign the service desk intake process through stakeholder interviews and iterative prototyping, reducing misreported ticket resolution time from 7+ days to the 36-hour SLA target.
Financial Project Manager
Siemens AG
· Mexico City, Mexico
Delivered Power BI analytics and financial planning across 30+ energy distribution projects at a global technology company, improving reporting efficiency and gross margin performance.
- Developed two stakeholder-facing Power BI dashboards with DAX measures and data modeling for the Finance team, enabling real-time decision-making and reducing weekly reporting time by 5+ hours.
- Built and maintained automated Power BI dataflows using PowerQuery to ingest, transform, and load weekly financial data, engineering validation safeguards around inconsistently formatted upstream sources.
- Directed financial planning and forecasting across 30+ energy distribution projects, conducting business analysis in Excel and SAP that drove a 7% Gross Margin improvement.
Economics Intern
Energy Agency of the State of Puebla
· Puebla, Mexico
Led geospatial research to identify EV infrastructure gaps across 217 municipalities, producing the State of Puebla’s official 2022 EV Charger Deployment Plan.
- Analyzed vehicle registration, traffic, and tourism datasets across 217 municipalities to map EV infrastructure gaps and publish actionable deployment recommendations.
- Coordinated with government agencies and private sector partners to translate analytical findings into funded policy recommendations, achieving a 50% increase in EV charger installations statewide.
Education
September 2024 - June 2026
Master of Science in Computational Analysis and Public Policy
University of ChicagoRelevant Courses:
- Software Engineering, Pyhton Programing 1 & 2, Machine Learning, Computer Security and User Privacy, Databases, Program Evaluation,
Extracurricular Activities:
- Treasurer for the University of Chicago Mexican Association
Get in Touch
My inbox is always open. Whether you have a question or just want to say hi, I’ll make sure get back to you!