Open to opportunities

Mario Aristizabal

@marioaristizabal

Senior data analyst specializing in marketing mix modeling, predictive analytics, and scalable data pipelines for media optimization.

Colombia

Message

What I'm looking for

I’m looking for a role where I can apply MMM, predictive analytics, and scalable data pipelines to deliver clear measurement and forecasting—turning complex multi-channel data into actionable dashboards and strategic insights.

I’m an advanced analytics professional with 4+ years of experience across data science, econometrics, and data analytics. I specialize in Marketing Mix Models (MMM), predictive analytics, and scalable data pipelines that improve how organizations measure media contribution and make strategic decisions.

In my current Senior Data Analyst role at Publicis Global Delivery (Spark Foundry), I manage and preprocess MMM data, run exploratory and advanced statistical analysis, and conduct macroeconomic and seasonality analysis to strengthen model building. I also integrate and maintain automation for data ingestion and transformation using Python-based workflows.

Previously, I built and maintained dashboards compiling cross-media performance data (Video, Display, Social), and supported key KPI analysis using correlations, regressions, clustering, and benchmarking. I’ve worked extensively across marketing analytics stacks including Datorama and Amazon Marketing Cloud, translating complex, multi-channel datasets into decision-ready reporting.

Earlier in my career, I led financial auditing work with the Contraloría General de la República, evaluating KPI effectiveness in contracting processes and supporting projects across infrastructure, education, and public health. I also bring business analytics and visualization experience from roles in strategic planning and financial modeling, supported by strong tools like Python, SQL, Tableau, and Excel.

Experience

Work history, roles, and key accomplishments

Current

Senior Data Analyst

Current

Publicis Global Delivery (PGD)

Mar 2025 - Present (1 year 2 months)

Built and maintained data workflows for marketing mix modeling, including data preprocessing, exploratory analysis, and macro economic/seasonality analysis for Taco Bell; automated ingestion and transformation for scalable multi-channel measurement.

Python data preprocessing Seasonality Analysis Excel Statistical Modeling

Current

Business Analyst

Current

A&T Consulting SAS

May 2018 - Present (8 years)

Produced financial models and supported strategic planning and market research, delivering data visualizations in Excel and Tableau to inform business decisions.

Financial Modeling Strategic Planning Market Research Data Visualization Excel Tableau Business Analytics

Senior Data Analyst

Publicis Global Delivery (PGD)

Jul 2024 - Mar 2025 (8 months)

Built and maintained dashboards compiling data across media channels and analyzed core KPIs (correlations, regressions, clustering, benchmarking) to support reporting for Dole.

Dashboard Development KPI Analysis Correlational Regression Regression Modeling Clustering Benchmarking Channel Reporting Amazon Marketing Cloud (SQL)

Data Analyst

Publicis Global Delivery (PGD)

Feb 2023 - Jul 2024 (1 year 5 months)

Developed dashboards compiling video, display, and social data, and performed statistical analysis for main KPIs (correlations, regressions, clustering, benchmarking) while supporting multi-platform reporting.

Dashboard Development KPI Analysis Regression Modeling Correlational Regression Clustering Amazon Marketing Cloud (SQL)Excel Benchmarking

Financial Analyst

Contraloría General de la República

Aug 2020 - Feb 2023 (2 years 6 months)

Conducted financial analysis of public investment/royalties projects, evaluated KPIs in contracting processes, and audited government agencies across infrastructure, education, and public health; led an auditing team using Python, Excel, and Tableau.

Financial Analysis Royalties Auditing KPIs Python Excel Tableau Team Leadership Data Visualization

Market Research & Sales

Pomona Distributors

Mar 2017 - Apr 2018 (1 year 1 month)

Supported long-range sales growth through market research and strategic leadership by monitoring supply chain processes and building ongoing relationships with local businesses.

Market Research Sales Growth Relationship Building Excel Strategic Leadership

Data Analysis Intern

Gig Wage

Aug 2016 - Dec 2016 (4 months)

Partnered with the CEO on small-business lead generation by building a spreadsheet with 12,000 emails and researching potential partners and investors for venture-capital meetings.

Lead Generation Data Collection Venture Capital Excel

Intern

Proximity to Power

Aug 2016 - Dec 2016 (4 months)

Researched U.S. media outlets and health industry influencers, expanded client contact lists, and streamlined online enrollment processes for client websites using Excel.

Excel Market Research