Andres Ernesto Lopez, Developer in Madrid, Spain
Andres is available for hire
Hire Andres

Andres Ernesto Lopez

Bio

Ernesto is a senior analytics and business intelligence leader with 16+ years of experience in both hands-on and hands-off roles, helping companies turn data into smarter decisions, stronger performance, and measurable growth. He combines strategic thinking, technical expertise, and business vision to lead analytics initiatives, build executive dashboards, and improve data quality. He delivers insights that support marketing, sales, operations, and leadership teams.

Portfolio

Syntelli Solutions
Microsoft Power BI, Domo, Salesforce, Snowflake, IBM Cognos, SQL...
Anthology
Azure, Microsoft Power BI, Salesforce, HubSpot, Adobe Analytics, Azure SQL, SQL...
Colsubsidio
Business Intelligence (BI), SAP Predictive Analysis, SAP Analytics Cloud (SAC)...

Experience

  • SQL - 12 years
  • Data Analytics - 12 years
  • Sales Analysis - 10 years
  • Data Modeling - 10 years
  • Microsoft Power BI - 10 years
  • Marketing Analytics - 10 years
  • Adobe Analytics - 8 years
  • Domo - 6 years

Preferred Environment

Microsoft Power BI, Domo, Adobe Analytics, SAP Analytics Cloud (SAC), SQL, PostgreSQL, Salesforce, Zoho Analytics, HubSpot, 6sense

The most amazing...

...project I've led was a global BI framework for marketing performance, aligning KPIs, dashboards, and insights to improve decision-making across the company.

Work Experience

Analytics Manager

2024 - PRESENT
Syntelli Solutions
  • Delivered advanced analytics across structured and unstructured data, identifying performance trends, business drivers, and operational opportunities for executive stakeholders.
  • Built enterprise Power BI dashboards with advanced DAX, optimized semantic models, and calculation groups, improving KPI visibility and leadership decision-making.
  • Developed unified analytics datasets in Snowflake by integrating Salesforce and HubSpot data, strengthening the pipeline, forecasting, revenue, and marketing insights.
  • Created Adobe Analytics reporting for digital and marketing performance, improving visibility into web behavior, campaign impact, funnel performance, and optimization opportunities.
  • Presented analytical insights, forecasts, and strategic recommendations to senior stakeholders, influencing commercial, operational, and performance optimization decisions.
Technologies: Microsoft Power BI, Domo, Salesforce, Snowflake, IBM Cognos, SQL, Adobe Analytics, Business Insights, Data Analysis, Data Visualization, Business Intelligence (BI), Data Analytics, Data Engineering, Enterprise Reporting, Domo Analytics, Consulting, Data Extraction, Power BI Desktop, Data Integration, Databases, ETL, Power BI Report Server, Dashboards

Marketing Analytics and Operations Manager

2022 - 2026
Anthology
  • Led the global marketing analytics framework, aligning KPIs, ROI models, dashboards, and reporting standards to measure performance across campaigns, regions, and teams.
  • Owned executive-level analytics in Domo, Power BI, Salesforce, HubSpot, and Adobe Analytics, delivering visibility into pipeline impact, funnel performance, digital behavior, and marketing ROI.
  • Implemented 6sense, ABM analytics, and Adobe Analytics reporting, strengthening audience targeting, funnel visibility, digital performance, and revenue insights.
  • Managed the Global Marketing Data Lake, supporting its implementation, rollout, maintenance, data quality, and adoption as a trusted source for marketing reporting and insights.
  • Contributed to the migration from Eloqua to HubSpot, ensuring reporting continuity, clean data structures, platform adoption, and alignment between marketing operations and analytics.
  • Implemented 6sense and ABM analytics capabilities, improving account targeting, audience segmentation, campaign optimization, pipeline visibility, and revenue insights.
  • Acted as a strategic analytics partner to marketing leadership, agencies, and operations teams, translating business questions into dashboards, insights, recommendations, and measurable actions.
Technologies: Azure, Microsoft Power BI, Salesforce, HubSpot, Adobe Analytics, Azure SQL, SQL, PostgreSQL, Marketing Analytics, Digital, 6sense, Paid Media, Stakeholder Management, Agile Project Management, Data Analytics, Vendor Coordination, Data Analysis, Data Visualization, Business Intelligence (BI), Data Engineering, Enterprise Reporting, Domo Analytics, Consulting, Data Extraction, Power BI Desktop, Data Integration, Databases, ETL, Power BI Report Server, Dashboards, Snowflake, Tableau

BI Coordinator

2020 - 2021
Colsubsidio
  • Led BI planning, design, maintenance, and quality control for dashboards, reports, and analytics solutions across SAP PSCD, SAP CRM, SAP BW, SAP BusinessObjects, and SAP Analytics Cloud.
  • Managed Adobe Analytics dashboards for digital and paid media performance, enabling stronger visibility into campaign results, channel behavior, acquisition initiatives, and marketing optimization.
  • Coordinated analytics and data governance initiatives for the business unit, ensuring data quality, consistency, documentation, and alignment with DAMA methodology and corporate standards.
  • Led statistical modeling and advanced analytics projects to support business plans, marketing strategies, acquisition initiatives, revenue expectations, and operational performance goals.
  • Managed end-to-end BI and analytics delivery using project management methodologies, coordinating internal and external teams to meet priorities, timelines, and service level agreements.
  • Served as the project manager for the corporate business warehouse, aligning stakeholders, SAP technologies, enterprise data assets, reporting needs, and data availability for decision-making.
Technologies: Business Intelligence (BI), SAP Predictive Analysis, SAP Analytics Cloud (SAC), Microsoft Power BI, DAMA, IT Project Management, Marketing Analytics, Adobe Analytics, SAP, SAP BW/4HANA, Data Analysis, Data Visualization, Data Analytics, Data Engineering, Enterprise Reporting, Domo Analytics, Microsoft Access, Consulting, Data Extraction, Power BI Desktop, Data Integration, Databases, ETL, Power BI Report Server, Dashboards, Snowflake, Tableau

Customer Intelligence Coordinator

2016 - 2019
oxoHotel
  • Led business intelligence and customer analytics initiatives, integrating internal and external data sources such as Oracle databases, Opera PMS, SQL, STR, and TravelClick.
  • Managed ETL, data mining, and data quality processes to support reliable reporting, customer intelligence, commercial analysis, and executive decision-making.
  • Led the corporate data warehouse implementation in Microsoft SQL Server and Azure, enabling centralized analytics, scalable reporting, and stronger business visibility.
  • Designed, planned, implemented, and maintained Power BI and Adobe Analytics dashboards to measure digital, marketing, sales, and customer performance.
  • Developed advanced analytics and statistical models to support marketing mix planning, sales strategies, market share growth, ROI, CPL, CPO, CLTV, and velocity analysis.
  • Implemented CRM, commercial systems, and strategic customer segmentation initiatives, strengthening customer understanding, business development, and data-driven decision-making.
Technologies: Microsoft Power BI, SQL, Adobe Analytics, Oracle BI, STR, TravelClick, Marketing Analytics, Finance Analytics, Business Intelligence (BI), Data Analysis, Data Visualization, Data Analytics, Data Engineering, Enterprise Reporting, Domo Analytics, Microsoft Access, Consulting, Data Extraction, Power BI Desktop, Data Integration, Databases, ETL, Power BI Report Server, Dashboards

Applications Developer I

2015 - 2016
Axity
  • Worked as a metrics and indicators lead, in charge of data analysis projects, indicators, apps, and dashboards to translate business needs into BI solutions.
  • Organized team members in different roles to prioritize project milestones according to project schedules and project management methodologies.
  • Handled BI architecture, internal (MySQL, MS SQL, Oracle), dashboards design, and implementation delivery and maintenance (Power BI, Excel).
  • Integrated BI solutions to respond to needs in core areas such as market intelligence and corporate management.
Technologies: Microsoft Power BI, SQL, Oracle, Oracle BI, Excel Expert, MySQL, Business Intelligence (BI), Data Analysis, Data Visualization, Data Analytics, Enterprise Reporting, Domo Analytics, Microsoft Access, Consulting, Data Extraction, Power BI Desktop, Data Integration, Databases, ETL, Power BI Report Server, Dashboards, Tableau

Customer Service Analyst

2014 - 2015
Cable & Wirelless
  • Delivered BI analysis to support customer loyalty, retention, service continuity, and business performance strategies across customer service and sales operations.
  • Developed SQL-based data models and ETL processes to integrate customer, sales, service, and operational data for recurring reporting and performance analysis.
  • Supported SQL-based reporting and data integration workflows that could be consumed through BI dashboards and cloud-based analytics environments, including AWS-oriented data storage and reporting practices.
  • Analyzed customer behavior, service interactions, and business trends to detect retention risks, improvement opportunities, and performance gaps.
  • Contributed to dashboard planning, design, and implementation, including early BI visualization practices later aligned with tools such as Power BI and cloud-based analytics environments.
  • Supported the evolution of BI reporting practices by documenting KPIs, data sources, business rules, and reporting logic for customer service and sales analytics.
Technologies: SQL, Amazon Web Services (AWS), Power BI Desktop, Salesforce, SAP, Tableau

Sales Effectiveness Analyst

2013 - 2014
AstraZeneca
  • Analyzed sales force performance KPIs, CRM data, and market intelligence information to evaluate commercial strategies, measure achievement, and identify sales effectiveness opportunities.
  • Developed and delivered dashboards, reports, and executive summaries using SQL-based datasets, CRM information, and BI reporting tools to monitor sales performance, territory results, and market trends.
  • Managed CRM technical and functional operations, supporting data availability, user adoption, reporting accuracy, and consistency across sales and commercial performance processes.
  • Built and maintained ETL and data integration workflows to consolidate sales, CRM, and market intelligence data from internal and external sources for recurring business analysis.
  • Supported cloud-based reporting and data processing practices using Amazon Web Services AWS, improving access, organization, and usability of commercial datasets for sales performance analysis.
Technologies: Amazon Web Services (AWS), CRM, Salesforce, Tableau, Excel Expert

Database Marketing Analyst

2013 - 2014
Proximity BBDO
  • Integrated and modeled customer, campaign, and business data from internal and external sources using SQL-based workflows to support database marketing analysis and strategic planning.
  • Developed analytical tools, dashboards, and recurring reports to identify key business insights, campaign performance trends, customer behavior patterns, and opportunities for marketing optimization.
  • Supported cloud-based data storage, processing, and reporting practices using Amazon Web Services (AWS), contributing to more scalable access to marketing and customer datasets.
  • Monitored corporate KPIs and prepared executive-level reports to track business performance, marketing effectiveness, audience segmentation, and progress against strategic objectives.
  • Translated business and marketing information needs into structured data models, reporting logic, dashboards, and actionable insights for management decision-making.
Technologies: Amazon Web Services (AWS), Power BI Desktop, Tableau, Data Analysis

Experience

Enterprise Analytics and Executive KPI Reporting Modernization

At Syntelli Solutions, I led advanced analytics initiatives to transform complex business data into executive-level insights and actionable recommendations. The project involved analyzing structured and unstructured datasets, developing enterprise Power BI dashboards with advanced DAX, optimizing semantic models and calculation groups, and supporting the modernization of analytics reporting across Domo, Power BI, Snowflake, Salesforce, and Adobe Analytics.

I contributed to the reconciliation of historical KPIs and mission-critical reports, helped integrate Salesforce and HubSpot data into Snowflake for unified pipeline, forecasting, revenue, and marketing analytics, and delivered insights directly to senior stakeholders. My role combined hands-on analytics development with strategic leadership, improving KPI visibility, data quality, reporting consistency, and decision-making across commercial, marketing, and operational teams.

Global Marketing Analytics Framework and Data Lake Implementation

At Anthology, I led the development of a global marketing analytics framework designed to standardize performance measurement, improve reporting consistency, and connect marketing activity with business impact. I managed the Global Marketing Data Lake, supporting its implementation, rollout, maintenance, data quality, and adoption as a trusted source for marketing reporting and insights.

I developed and deployed executive dashboards in Domo, Power BI, Salesforce, HubSpot, and Adobe Analytics, providing visibility into campaign performance, funnel behavior, digital engagement, pipeline contribution, and marketing ROI. I also supported the migration from Eloqua to HubSpot and implemented 6sense and ABM analytics capabilities to strengthen account targeting, segmentation, and revenue insights. My role combined analytics leadership, hands-on dashboard development, data governance, and strategic partnership with marketing leaders, agencies, and operations teams.

Enterprise BI, Digital Analytics, and Corporate Business Warehouse Transformation

At Colsubsidio, I led a high-impact BI and analytics transformation to strengthen enterprise reporting, improve digital performance visibility, and enable data-driven decision-making across the business unit. I planned, designed, maintained, and quality-controlled dashboards, reports, transactions, and analytics solutions using SAP PSCD, SAP CRM, SAP BW, SAP BusinessObjects, SAP Analytics Cloud, and Adobe Analytics.

I managed digital and paid media reporting in Adobe Analytics, enabling stronger measurement of campaign performance, acquisition initiatives, channel behavior, and marketing optimization. I also led advanced analytics and statistical modeling projects to support corporate business plans, revenue goals, acquisition strategies, and operational performance. As project manager for the corporate business warehouse, I coordinated stakeholders, internal and external teams, timelines, data quality standards, and governance practices aligned with DAMA methodology, improving the reliability, availability, and business value of enterprise data assets.

Education

2017 - 2018

Specialization in Business Intelligence Project Management

Politécnico Grancolombiano - Colombia

2010 - 2016

Bachelor's Degree in Business Administration

UNAD - Colombia

Certifications

MAY 2026 - PRESENT

Data Analysis Using Domo

Udemy

MAY 2026 - PRESENT

Adobe Analytics Mastery: Workspace, Segmentation, and Metrics

Udemy

DECEMBER 2025 - JANUARY 2027

HubSpot Marketing Hub Software

HubSpot

DECEMBER 2025 - JANUARY 2027

HubSpot Reporting

HubSpot

FEBRUARY 2025 - PRESENT

EF SET English Certificate 72/100 (C2 Proficient)

Education First

Skills

Tools

Microsoft Power BI, Domo, Adobe Analytics, Microsoft Access, Power BI Desktop, Power BI Report Server, Tableau, IBM Cognos, SAP Predictive Analysis

Languages

SQL, Snowflake

Paradigms

Business Intelligence (BI), ETL, Agile Project Management

Industry Expertise

Project Management, Marketing

Storage

Data Integration, Databases, PostgreSQL, Azure SQL, SAP BW/4HANA, MySQL

Platforms

Zoho Analytics, HubSpot, Amazon Web Services (AWS), Salesforce, Azure, Oracle

Other

Data Modeling, Data Analytics, Marketing Analytics, Domo Analytics, Sales Analysis, Enterprise Reporting, Data Analysis, Data Visualization, Consulting, Data Extraction, Dashboards, SAP Analytics Cloud (SAC), Data Engineering, 6sense, Business Analysis, Stakeholder Management, Corporate KPIs, Sales, Finance, Digital, Paid Media, Vendor Coordination, DAMA, IT Project Management, SAP, Business Insights, Oracle BI, STR, TravelClick, Finance Analytics, Excel Expert, Funnel Analysis, Paid Media Performance, Marketing Automation, Email Marketing, Customer Relationship Management (CRM), HubSpot Marketing Hub, Marketing Operations, Campaign Performance, English, CRM, Account-based Marketing (ABM), Data Quality Governance

Collaboration That Works

How to Work with Toptal

Toptal matches you directly with global industry experts from our network in hours—not weeks or months.

1

Share your needs

Discuss your requirements and refine your scope in a call with a Toptal domain expert.
2

Choose your talent

Get a short list of expertly matched talent within 24 hours to review, interview, and choose from.
3

Start your risk-free talent trial

Work with your chosen talent on a trial basis for up to two weeks. Pay only if you decide to hire them.

Top talent is in high demand.

Start hiring