JESÚS OMAR VILLASEÑOR CARRILLO
Guadalajara, Jalisco, Mexico Phone: +52-331-***-**** ****.******************@*****.***
linkedin.com/in/dharmanet
PROFESSIONAL SUMMARY
Data engineer with 5 years building data pipelines and analytics solutions in government and
consulting, and 23+ years in the Mexican public sector. I design and maintain scalable pipelines
and transformations in SQL and Python, integrate data from multiple sources, and build
dashboards and KPIs for technical and non-technical stakeholders. Strong hands-on Python,
SQL, BigQuery, ETL/ELT pipelines (Sling, dbt) and real-time data ingestion from APIs and web
sources, with monitoring and automation. Able to ramp up quickly on Databricks and Snowflake
from BigQuery and dbt. Co-founder of DATVRA, a data and govtech consultancy.
PROFESSIONAL EXPERIENCE
Data Engineer — DATVRA — Data & Govtech Consultancy July 2024 – Present
Co-founder of DATVRA. Design and maintenance of the data pipeline for Orona, an electoral-
analytics product integrating federal and state historical data since 1991: layered ingestion
and transformation (Sling, dbt), PostgreSQL/AWS, DuckDB/Parquet, geospatial processing
(GeoPandas).
Integration, transformation, and analysis of information from multiple sources and formats:
harmonizing databases from different formats and sources, from extraction to
transformation.
Build and maintain dashboards and tracking (Vigia): executive and operational reporting
from the data Nexvra prepares.
Custom RAG architecture connected to foundational model APIs (Claude/Anthropic) to
automate analysis, model auditing, and synthetic-content detection during campaigns.
Department Head — Zapopan City Council October 2024 – Present
Route-optimization model for a 200+ vehicle waste-collection fleet: geospatial centroids,
demand-based allocation, and real-time traffic penalty modeling (Google API).
Vehicle-fleet compliance system (AppSheet, Docker on Google Cloud Run, FastAPI, React)
with automated official-document generation; cut the annual fleet review cycle from 2
months to 2 weeks.
Automated vehicle-fine detection system (monthly scraping, React, FastAPI, PostgreSQL) that
reduced a two-week manual data-entry process to under one day.
Address-cleaning and geocoding pipeline in BigQuery (regex rules + Google Geocoding API)
for citizen-reported park and garden maintenance requests.
Data Analysis Advisor — State Deputy Campaign, District 12, Jalisco January 2024 – June
2024
Interactive dashboards and strategic maps (Plotly, Streamlit) to communicate findings to
decision-makers.
Gathered reporting requirements from the campaign team; built a hybrid scoring algorithm
(official data + qualitative variables) to prioritize resources.
Linear regression models and real-time PREP election-results monitoring, closing with a 5%
final margin of error.
Internal Auditor — Secretaría del Sistema de Asistencia Social, Jalisco September 2022 –
October 2024
Audited the Recrea, Educando para la Vida program (1.1M+ beneficiaries across 9,007
schools in 125 municipalities), cross-referencing large-scale databases to validate compliance
with the beneficiary registry and detect duplicate records.
Developed Python/SQL scripts to automate regulatory compliance checks and standardize
the internal control framework.
Designed and tracked program compliance indicators based on beneficiary registries and
operating rules.
Administrative Director — Instituto Jalisciense de la Vivienda October 2021 – September
2022
Designed and implemented a centralized data repository (administrative Data Lake) to
eliminate information silos between departments; administrative data modeling.
Automated compliance with the Archives Law using Python, resolving a 15-year legal
backlog.
Led Human Resources, Materials, Procurement, and Legal departments.
Director of Material Resources — Tonalá City Council, Jalisco May 2019 – October 2021
Led the Annual Purchasing Plan and coordinated 26 municipal public tenders; created 2
Municipal Purchasing Plans.
Coordinated material resources and implemented operational efficiency strategies.
PREVIOUS EXPERIENCE
Head of Agreements and Monitoring, Tonalá City Council (October 2018 – May 2019); Co-
founder, Tres 2-B Consultores (November 2016 – Present), consulting for the transportation
sector; Research Advisor, Canal 44, University of Guadalajara (2016); Jalisco State Mobility
Secretariat (2006 – 2015): mobility projects and road safety training; participant in the first WHO
working group on Road Safety Legislation, Geneva, Switzerland (August 2012).
TECHNICAL SKILLS
Pipelines: SQL (advanced), Python (Pandas, GeoPandas, SQLAlchemy), ETL/ELT pipelines
(Sling, dbt), API integrations, real-time ingestion and monitoring.
Cloud & warehouses: BigQuery, PostgreSQL, DuckDB/Parquet; AWS (RDS, EC2, S3), Google
Cloud Run; able to ramp up quickly on Databricks and Snowflake from BigQuery and dbt.
Streaming & ML (working knowledge): real-time election-results monitoring (PREP), linear
regression models, geospatial processing (GeoPandas); familiar with streaming concepts
through API and event-data pipelines.
Dashboards & KPIs: Looker, Plotly, Streamlit, Power BI (basic); KPI reporting and data
visualization best practices.
Engineering practices: Git, GitHub, Docker, FastAPI, code review and documentation.
Public management: regulatory compliance, auditing and internal control, public tenders
and procurement.
EDUCATION
Master in Local Government Management — University of Guadalajara — 2019 – 2021
(Completed).
Bachelor's Degree in Political Studies and Government — University of Guadalajara — 2003 –
2007 (Graduated).
Diploma in Instructional Design — National Security System — 2010.
LANGUAGES
Spanish: native. English: intermediate B1 (Cambridge).