Open to opportunities

Mateo Heras

@mateoheras

Data Analyst building ETL pipelines and Power BI dashboards, delivering predictive forecasting and operational insights for multi-client aviation.

Canada

Message

What I'm looking for

I’m looking for a role where I can build reliable ETL, ship clear BI dashboards, and create predictive forecasting models in a collaborative team—using cloud data infrastructure and automation to turn operational data into measurable outcomes.

I’m a Data Analyst with 4+ years of experience across banking, operations, and aviation analytics, grounded in economics and peer-reviewed geospatial research. I’m currently at PrimeFlight Aviation Services at Toronto Pearson (YYZ), where I turn messy operational data into decisions-ready analytics.

I build ETL pipelines (Python, PostgreSQL) to consolidate data from disparate systems, then deliver Power BI dashboards tracking aircraft turnaround performance, grooming compliance, and staffing utilization. I also develop AI-assisted demand forecasting models (Python, Scikit-learn) that support workforce scheduling and shift planning.

To make insights timely, I’ve integrated Apache Kafka streams for near-real-time ingestion of flight status and gate assignment events. I’ve automated reporting workflows using Excel/VBA and Selenium, and I collaborate directly with airline clients to deliver SLA reporting and irregularity tracking (baggage, damage, delays).

Beyond aviation, I delivered end-to-end analytics for clients across retail, finance, and real estate—building geospatial regression models and Streamlit tools—and designed AWS pipelines (S3, Glue, Athena) for large batch datasets. I’m pursuing an MSc in Data Analytics to deepen my statistical modeling, big data infrastructure, and machine learning skills.

Experience

Work history, roles, and key accomplishments

Current

Data Analyst - Aviation

Current

PrimeFlight Aviation Services

Jan 2025 - Present (1 year 3 months)

Built Power BI dashboards for aircraft turnaround performance, compliance, and staffing utilization across multi-airline clients. Engineered Python/PostgreSQL ETL pipelines and near-real-time analytics with Apache Kafka, plus Scikit-learn demand forecasting to support workforce scheduling and shift planning.

Power BI Python scikit learn ETL PostgreSQL Forecasting Apache Kafka

Contract Data Analyst

Independent Clients

Jan 2022 - Jan 2024 (2 years)

Delivered end-to-end analytics for retail, finance, and real estate clients, including data wrangling, dashboard development, and predictive modeling. Built geospatial regression (spatial econometrics) for an academic publication and developed AWS-backed Streamlit apps for Monte Carlo simulation and credit risk prediction.

Geospatial Regression Data Wrangling Streamlit AWS S3 Glue Athena predictive modeling

Data Analyst (Retail Banking)

Banco Pichincha

Maintained BI reporting infrastructure for retail banking operations, including branch performance and product penetration dashboards. Analyzed customer segmentation to support marketing and product targeting strategies and collaborated with IT on data governance and ETL process documentation.

BI Reporting Dashboard Development Customer Segmentation Marketing Analytics Product Analytics Data Governance ETL Processes

Data Analyst (Banking)

Austro Bank Ecuador

Produced regulatory and executive reporting for loan portfolio, credit risk, and liquidity monitoring using SQL and Excel/VBA. Automated reconciliation workflows and supported internal audit with data extraction and anomaly-detection queries to reduce the end-of-month reporting cycle time.

SQL Reporting Regulatory Reporting Credit Risk Analytics Liquidity Monitoring Anomaly Detection

Education

Degrees, certifications, and relevant coursework

University of Niagara Falls Canada

Master of Science in Data Analytics, Data Analytics

Activities and societies: Capstone: predictive modelling and data pipeline design.

Pursuing a Master of Science in Data Analytics focused on machine learning, big data infrastructure, statistical modelling, and business analytics. Capstone includes predictive modelling and data pipeline design.

Universidad de Cuenca

Bachelor of Science in Economics, Economics

Activities and societies: Econometrics (R, Stata), time series, panel data, and cross-sectional regression.

Earned a Bachelor of Science in Economics with coursework in econometrics, time series, panel data, and cross-sectional regression. This academic foundation supported published geospatial research.