Post Job Free
Sign in

Data Engineer - SQL, Python, Pipelines

Location:
Mexico
Posted:
November 19, 2026

Contact this candidate

Resume:

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).



Contact this candidate