Skip to main content
David GonzálezDG
Open to opportunities

David González

@davidgonzlez

BI & analytics specialist turning complex data into executive-ready insights with Power BI, SQL, and Python.

Mexico
Message

What I'm looking for

I’m looking for a BI/analytics role where I can build secure self-service dashboards, drive ETL and dimensional modeling, and translate data into executive decisions—using Power BI, SQL, and storytelling within a collaborative, Agile environment.

I’m a Business Intelligence & Information Delivery Specialist with 7+ years designing reporting and analytics solutions that turn complex data into clear business insights, including financial and payroll data for executive stakeholders. I specialize in Power BI (DAX, RLS) and advanced SQL, and I also use Python (pandas/EDA) to strengthen analysis and data storytelling.

I’ve delivered measurable operational impact—reducing report prep time by ~40% and eliminating ~80 hrs/month of manual consolidation. In my current role, I design Power BI dashboards for Weekly Business Review (WBR), implement row-level security and data governance protocols for secure access to sensitive financial data, and build ETL pipelines for high-volume shift and payroll data.

I also lead through delivery and cross-functional collaboration: at Kantar Worldpanel, I led analysts producing syndicated consumer panel and market research reporting, automated ingestion/transformation with SQL and Power Query, and applied SCRUM to bridge technical teams and business units through data storytelling. Earlier, I directed ETL/data migration and dimensional modeling work at Jugos del Valle (Star/Snowflake schemas) and supported performance-driven analytics at Qualitest and PepsiCo, including drill-down quality dashboards.

Experience

Work history, roles, and key accomplishments

IS
Current

Business Analytics Analyst

Inter-Con Security

Mar 2025 - Present (1 year 4 months)

Designed Power BI dashboards for weekly business reviews, gathering requirements with executive stakeholders to enable self-service reporting across U.S. territories. Implemented row-level security and data governance for secure access to sensitive financial data, and built ETL pipelines to eliminate manual payroll consolidation.

Kantar Worldpanel logoKW

Data & Delivery Team Leader

Jan 2024 - Mar 2025 (1 year 2 months)

Led a team delivering syndicated consumer panel and market research reports (market share, brand penetration, purchase behavior) for CPG clients. Automated data ingestion and transformation using SQL and Power Query, and implemented a SCRUM framework while delivering data storytelling to business units.

Jugos del Valle (PepsiCo) logoJP

Business Intelligence Leader

May 2023 - Dec 2023 (7 months)

Directed an ETL/data migration project to centralize sales and inventory data from multiple bottlers into a unified database using data warehousing principles. Designed star/snowflake schema dimensional models to support high-volume reporting and managed the project lifecycle through deployment.

Qualitest logoQU

Data Analyst

Mar 2022 - May 2023 (1 year 2 months)

Analyzed search-engine data patterns using quantitative methods to improve algorithm accuracy and error rates. Built drill-down quality dashboards using Google PLX.

PepsiCo logoPE

Data Analysis & Reporting Analyst

May 2021 - Jan 2022 (8 months)

Developed 10+ Power BI dashboards using advanced DAX and automated SQL/Power Query ETL to reduce manual work. Improved reporting efficiency through recurring dashboard delivery and ETL automation.

Education

Degrees, certifications, and relevant coursework

NL

Next IBS / Universitat de Lleida

Master in Big Data & Business Intelligence, Big Data & Business Intelligence

2019 - 2020

Master’s program in Big Data & Business Intelligence at Next IBS / Universitat de Lleida (2019–2020).

EE

Escuela Bancaria y Comercial (EBC)

Bachelor of Business Administration (BBA), Business Administration

2014 - 2018

Bachelor of Business Administration (BBA) at Escuela Bancaria y Comercial (EBC) from 2014 to 2018.

Get 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!

Sign up
Himalayas profile for an example user named Frankie Sullivan