Data and analytics professional with 8+ years of experience building reliable pipelines, analytical models, self-service reporting, and decision-support tools from complex operational, customer, financial, demographic, and spatial data. Advanced SQL and Python practitioner with hands-on experience across Snowflake, AWS Redshift, SQL Server, PostgreSQL, Power BI, Tableau, dbt, APIs, and modern analytics workflows. Comfortable owning work end to end—from source-system discovery and data quality through transformation, modeling, analysis, automation, documentation, and stakeholder delivery.
Senior Data Analyst — Analytics Engineering & Decision Support
VIA Metropolitan Transit · San Antonio, TX
Aug 2024 – Present
Own end-to-end analytics for operations, planning, and executive leadership, translating ambiguous business questions into defined metrics, analytical approaches, and reusable reporting products.
Built and maintain production Python/SQL pipelines and self-service Power BI/GIS products, replacing recurring manual preparation with validated, repeatable workflows.
Design curated analytical tables and reporting models that combine vendor platforms, operational databases, mobile-app event data, workforce records, public datasets, and internal systems while preserving traceability to source.
Lead data-quality and metric-governance work including schema checks, record reconciliation, validation rules, exception handling, lineage notes, data dictionaries, and plain-language runbooks.
Conduct forecasting, customer-experience, behavioral, demographic, performance, and spatial analysis; support Microsoft Fabric modernization/testing and governed self-service access to internal data.
Service Analyst — Analytics, Forecasting & Data Products
Chicago Transit Authority · Chicago, IL
May 2023 – Aug 2024
Built self-service dashboards adopted by users across operations, scheduling, and planning, improving access to recurring performance metrics and reducing routine analyst requests.
Automated four recurring analytical workflows using Python, SQL, and AWS Redshift, recovering 4–6 hours per reporting cycle while improving consistency and reproducibility.
Developed forecasting, scenario, performance, behavioral, and geospatial analyses from large operational, customer-demand, demographic, and external datasets to support resource allocation and planning decisions.
Partnered with cross-functional teams to define success measures, investigate unexpected changes, validate assumptions, and translate findings into decision-ready recommendations.
Data Engineer / Data Analyst — Client Analytics & Data Products
mySidewalk · Kansas City, MO / Remote
Aug 2022 – May 2023
Built Snowflake, Python, and SQL pipelines that acquired, standardized, and refreshed large public datasets spanning demographic, labor, health, economic, infrastructure, and community indicators for client-facing products.
Partnered with clients and internal product teams to define KPIs, analytical requirements, and data products; developed dashboards, Flask tools, and interactive applications used by 100+ users.
Monitored releases for schema drift, missing values, geographic coverage, and anomalies; built fuzzy-matching and geocoding workflows to convert inconsistent records into reliable analytical datasets.
Performed customer-experience and demographic segmentation analysis, forecasting, statistical analysis, and location-based research for public-sector and community-focused clients.
Data Analyst — Strategy, Performance & Public Data
City of Dallas · Dallas, TX
Jun 2021 – Aug 2022
Built reproducible Python/SQL workflows that reconciled large, inconsistent multi-file state and federal datasets into standardized analytical tables for recurring reporting and strategic analysis.
Designed KPI frameworks, dashboards, benchmarking analyses, and statistical/geospatial models used to identify performance gaps, trends, safety risks, and investment priorities.
Delivered validated outputs through Power BI, Tableau, ArcGIS Online, and public-facing analytical products while documenting data limitations and business logic.
Data Engineer / GIS Analyst — Market & Infrastructure Analytics
Modus LLC · Portland, OR / Remote
Mar 2020 – Jun 2021
Built Azure, Python, SQL, and enterprise GIS workflows for clients including Verizon, AT&T, and Google, integrating Salesforce sales/work-order records with assets, parcels, demographic, infrastructure, permitting, zoning, and rights-of-way data.
Developed market-segmentation and location-intelligence analyses that ranked expansion opportunities and translated complex commercial, spatial, and infrastructure data into client recommendations.
Automated spatial and data-quality workflows in ArcGIS Pro and QGIS, resolving schema, coordinate, and source-quality issues while documenting repeatable methods for client teams.
Business Analyst / Data Engineer — Enterprise Reporting
Opus Agency · Portland, OR
Jan 2018 – Mar 2020
Integrated Salesforce CRM, workforce, finance, legal, and marketing-platform data using SQL Server, Azure, Python, and APIs to support revenue, budgeting, client delivery, and executive reporting.
Designed relational structures, recurring data flows, operational KPIs, and Power BI/Tableau reporting; investigated anomalies and documented business logic so outputs remained traceable and maintainable.
Selected Technical Work
Analytics engineering portfolio: Built a reproducible PostgreSQL analytical warehouse with dimensional facts/dimensions, validated marts, customer RFM and cohort models, business-analysis notebooks, and a documented Power BI semantic model.
High-volume ingestion and warehousing: Automated source extraction, validation, incremental loading, exception handling, and SQL warehousing for an operational dataset exceeding 137 million records across 860+ service days.
Behavioral and location analytics: Built Python/SQL/GIS workflows that reconstruct activity patterns from mobile-app event data, validate spatial records, enrich results with contextual data, and publish analysis-ready outputs.
Data quality and governance: Designed repeatable validation suites covering row counts, schema expectations, business-rule reconciliation, freshness, lifecycle checks, and documented exceptions so downstream metrics remain trustworthy.
Analytical delivery: Build end-to-end products that move from raw source data through modeled datasets to Power BI/Tableau dashboards, automated reports, interactive web tools, and plain-language documentation for non-technical users.
Education
Master of Urban Planning Portland State University
B.A., Economics & Finance Texas A&M University–Corpus Christi