Open to opportunities

Rafa RTS

@rafarts

Message

Data & Analytics engineer who builds reliable ELT pipelines and actionable business insights.

Mexico

Message

What I'm looking for

I seek roles where I can build scalable ELT pipelines and analytics models, collaborate with analysts and product teams, and deliver measurable business impact in a data-driven culture.

I am a data and analytics engineer focused on converting raw data into reliable, analytics-ready models using SQL, dbt, Python, and BI tools to drive measurable business outcomes like ROAS, CAC, and LTV/CAC.

I have built end-to-end ELT pipelines, implemented dbt warehouses with staging/intermediate/marts layers, created marketing attribution and LTV platforms, and delivered dashboards and reporting solutions in Power BI and Metabase to support executive decisions and operational monitoring.

Experience

Work history, roles, and key accomplishments

Current

Data & Analytics Engineer

Current

Portfolio / Freelance

Jan 2022 - Present (4 years 1 month)

Built a marketing attribution and LTV platform using MySQL, Python, and Power BI to deliver actionable metrics (ROAS, CAC, LTV/CAC) and created a dbt warehouse with staging, intermediate, and marts layers for analytics-ready datasets.

DBT SQL Python MySQL Power BI Data Modeling Git Documentation

Safety Supervisor

ISI Suministros e Instalaciones S.A. de C.V.

Jan 2022 - Oct 2024 (2 years 9 months)

Automated daily risk-tracking reports and standardized safety logs into analytics-ready datasets, improving incident traceability by ~30% and supporting planning/monitoring of high-risk tasks across multiple sites.

SQL Power BI Metabase Monitoring

Education

Degrees, certifications, and relevant coursework

Universidad del Valle de México

Bachelor of Science, Actuarial Science

Pursuing a Bachelor of Science in Actuarial Science with expected completion in 2026, focusing on actuarial logic, data analytics, and statistical modeling.