Rodrigo Rosillo

Rodrigo Rosillo

About

Detail

Data Engineer & Business Intelligence Lead
Quito, Pichincha, Ecuador
Contact Rodrigo regarding: 
work
Full-time jobs
Starting at USD2.3k/month
Flexible work
Starting at USD15/hour

Timeline

work
Job
school
Education
folder
Project

Résumé

Jobs verified_user 0% verified
  • R
    Data Engineer & BI Lead
    Right Angle Media
    Nov 2023 - Mar 2025 (1 year 5 months)
    As a BI Analyst, I engineered Python and Airflow reporting pipelines that eliminated approximately 12 hours per week of manual work, integrating Meta, Google Ads, and TikTok APIs to centralize multi-channel performance data into SQL Server. I built and maintained over 10 Power BI dashboards that tracked key performance indicators such as ROAS, CPA, and CTR, which were consumed daily by account managers and C-suite executives. Additionally, I implemented upstream data-validation checks that identified and eliminated a recurring class of reporting errors caused by missing or malformed API fields. I effectively translated stakeholder requirements into data models, reducing ad-hoc query time by around 30%. My experience at Right Angle Media, a
  • R
    Data Engineer
    Right Angle Media
    Jan 2022 - Nov 2023 (1 year 11 months)
    • Designed and deployed 25+ end-to-end data pipelines (ingestion → transformation → load → cleaning → reporting) using Apache Airflow, SQL Server, and Python, reducing data latency from monthly/weekly to daily reports. • Built automated data flows for Oracle Responsys and advertising platforms, replacing manual CSV exports; standardized ETL code with modular Python, cutting new-pipeline onboarding time significantly. • Maintained SQL Server health of scheduled jobs ensuring 99%+ pipeline reliability across 25+ live dashboards. • Leveraged data storytelling techniques to effectively communicate insights derived from digital marketing data, enhancing stakeholder understanding and decision-making. My experience at Right Angle Media, a marke
Education verified_user 0% verified
  • D
    Data Engineer & Data Scientist
    Aug 2025 - Feb 2026 (7 months)
  • M
    Microsoft SQL Server Database Administration
    Aug 2021 - Oct 2021 (3 months)
  • U
    B.A. Major in Computer Science
    University of British Columbia (Canada)
    Jan 2021 - May 2021 (5 months)
    Graduated with Distinction
Projects (professional or personal) verified_user 0% verified
  • B
    Beauty Salon Website
    Apr 2026
    Developed and deployed a fully functional business website, utilizing Claude Code for efficient coding and project execution.
  • M
    Marketing Analytics Pipeline & Dashboard
    Mar 2026 - Apr 2026 (2 months)
    • Built an end-to-end marketing analytics pipeline ingesting simulated Meta, Google Ads, and TikTok ad data into a Snowflake medallion architecture (Bronze → Silver → Gold); authored 7 dbt models across staging and mart layers with explicit type casting, derived metrics (ROAS, CTR, CPA), and surrogate key generation via dbt_utils. • Implemented 43 automated data quality tests using dbt-expectations — including range checks on ROAS and spend — with GitHub Actions CI/CD blocking merges on test failures and auto-publishing dbt docs to GitHub Pages on every push to main. • Orchestrated the full pipeline with a daily Apache Airflow DAG (simulate → load → dbt run → dbt test) and built a three-page Power BI dashboard on the Gold layer coveri
  • A
    Algo-Trading Data Platform
    Jul 2025 - Mar 2026 (9 months)
    Architected a 7-phase production data pipeline: raw CSV → SHA-256-hashed data quality validation → Parquet data lake → dual backtesting engines (spot + isolated-margin futures) → live Binance WebSocket ingestion with reconnect → Dockerized deployment on AWS Lightsail with a host-side watchdog and Telegram alerting. Built a data quality framework that detects timestamp gaps, duplicates, and bar-count anomalies, generating auditable JSON + HTML reports; processed 5 years of SOLUSDT 30m OHLCV data (88,883 candles) with full SHA-256 data lineage tracking across raw and processed artefacts. Validated strategy robustness with 6-fold walk-forward evaluation, 2,000-resample bootstrap confidence intervals, and multi- regime analysis baseline results