Ferrán Larios
@ferrnlarios
I’m a data analyst building end-to-end BigQuery pipelines, attribution models, and automated dashboards that drive daily business decisions.
What I'm looking for
I’m a Data Analyst with a background in Actuarial Science and 3+ years building end-to-end data pipelines, attribution models, and automated dashboards in BigQuery and Looker. My focus is connecting data to decisions—productionizing systems that marketing, finance, and operations teams rely on daily, not just delivering one-off analyses.
At El Puerto de Liverpool, I designed and productionized an end-to-end clienteling data pipeline in BigQuery—from schema design to scheduling and IT handoff—feeding real-time customer profiles to sales associates across cosmetics stores. I also built a campaign attribution dashboard for Financial Products (credit card requests, account openings, and activations) and automated data quality monitoring across ~1M customer records, using proactive alerts to eliminate manual QA cycles.
Previously at Mercado Libre, I developed a reusable BigQuery SQL query library to automate KPI calculations across strategic planning workflows and built Looker reports used in weekly business reviews by senior leadership. I’ve continued to refine my approach through operations work using Python to automate recurring reporting and reduce manual effort, helping set the foundation for later pipeline building.
Experience
Work history, roles, and key accomplishments
Customer Experience Data Analyst
El Puerto de Liverpool
Mar 2024 - Present (2 years 4 months)
Designed and productionized an end-to-end clienteling data pipeline in BigQuery, feeding real-time customer profiles for cosmetics store sales associates. Built a campaign attribution dashboard and automated data quality monitoring and recurring BigQuery/Looker reporting to reduce manual work.
Advanced Analytics Intern
Mercado Libre
Sep 2023 - Mar 2024 (6 months)
Built a reusable BigQuery SQL query library to automate KPI calculation across strategic planning workflows. Created and maintained Looker reports for weekly business reviews and contributed to statistical testing and experimentation initiatives.
Operations Analyst
MEDWAG
Aug 2022 - Aug 2023 (1 year)
Automated recurring operational reports using Python to improve KPI accuracy and reduce manual reporting time.
Education
Degrees, certifications, and relevant coursework
Universidad Anáhuac
Bachelor of Science in Actuarial Science, Actuarial Science
Earned a Bachelor's degree in Actuarial Science in Mexico City.
Google HQ (Looker)
Looker Explorer & Looker Developer, Business Intelligence
Completed Looker Explorer and Looker Developer training at Google HQ in Mexico City.
Various platforms
SQL for Data Analysis, Data Analysis
Completed coursework covering SQL for data analysis.
Various platforms
Data Science Fundamentals, Data Science
Completed coursework covering data science fundamentals.
Various platforms
Python for Data Analysis, Data Analysis
Completed coursework covering Python for data analysis.
Tech stack
Software and tools used professionally
Availability
Location
Authorized to work in
Job categories
Interested in hiring Ferrán?
You can contact Ferrán and 90k+ other talented remote workers on Himalayas.
Message FerránGet matched with your dream remote job
Sign up now and join over 250,000+ remote workers who receive personalized job alerts, curated job matches, and more for free!
