JUAN COMPTE ALVAREDO
Barcelona
Summary
Highly experienced BI Analyst with over 5 years specializing in advanced SQL, analytical modeling, and process automation, utilizing tools like Qlik Sense, Tableau, dbt, and Airflow. Proficient in the Microsoft stack, including SQL Server, SSIS, SSAS and Power BI. Proven track record as a Consultant for Western Union and a BI Architect at ConsumerAffairs, where I successfully led data migrations between platforms and drove optimization of critical company KPIs. Expertise spans across Marketing, Finance, and Lead Generation domains.
Overview
5
5
years of professional experience
Work History
Data Analyst
Biotech company
08.2024 - Current
- Maintained and migrated key company dashboards within a Biotech compant, optimizing performance by transitioning to a new database architecture
Business Intelligence Architect
ConsumerAffairs
Tulsa, OK
08.2021 - 08.2024
- Qlik Sense / Tableau Migration: Led the complete migration of dashboards from Qlik Sense to Tableau, concurrent with a Redshift to Snowflake transition. This project also involved redefining metrics and optimizing processes and data, resulting in significant improvements in data quality and visualization efficiency
- BI Architecture: Developed and maintained BI models for key metric generation, powering critical decision-making dashboards. Implemented company-wide key metric tracking, executed quality assurance (QA) and validation processes for new developments, and designed final models, collaborating closely with stakeholders and ensuring data quality
- User Flow: Developed a user flow analysis dashboard that calculated user visit times across various website journeys. This tool facilitated the identification of outdated flows, leading to a significant increase in lead conversion by redirecting traffic to active flows
BI Consultant
Monsun / Western Union
11.2020 - 07.2021
- Payment Maturity: Developed a project to optimize the payment notification strategy, implementing a system that analyzes user behavior and predicts the optimal time to send reminders. This resulted in a significant improvement in on-time payment rates and enhancing app engagement
- Cashier Performance: Collaborated with stakeholders to define the guidelines and metrics for a dashboard designed to analyze cash discrepancies by cashier and branch, considering various time windows. This tool facilitated the rapid detection of anomalies, enabling immediate corrective action and significantly reducing losses.
- Led a project to optimize cash-in-transit truck logistics for over 500 stores, implementing an enhancement to the predictive model that improved prediction accuracy by 17%.
BI Analyst
AABE (State Property Administration Agency)
Buenos Aires
02.2020 - 10.2020
- Developed dashboard to enhance decision-making across various agency departments.
- Data analysis. KPI's and metrics analysis. Query development in T-SQL. Auditing reports. Disclosure of report user requirements. Preparation of functional documentation and user manuals.
- Designed automated processes to facilitate seamless data transfers to web services.
Education
Chemical Engineering -
University of Buenos Aires
12.2020
Advanced Data Analytics -
Google
06.2023
Skills
- Business Intelligence (BI)
- Data Analytics
- Process Automation
- SQL Server
- T-SQL
- Power BI
- SSRS
- Microsoft Excel (Advanced)
- Revenue Management
- Microsoft Power Platform
- SSIS
- SSAS
- Qlik Sense
- Redshift
- Snowflake
- Data Warehousing
- ETL
- Python
- Pandas
- Scikit-learn
Languages
English: Advanced
Spanish: Native
Technologies
Python, R, Numpy, Pandas, ScikitLearn, SQL, Redshift, Snowflake, SQL Server, Tableau, Power BI, Qlik Sense, Spark, BigQuery
Accomplishments
Key Projects & Impact
1. Attribution Fix for Ad Spend (Meta timezone issue)- Resolved cost misallocation due to time zone mismatch in Meta ad data (Pacific vs. UTC).
- Corrected attribution logic by aligning ad group ID, session category, and conversion time.
- Restored trust in the Unit Economics dashboard, avoiding up to $2,000/day in incorrect campaign suspensions.
- Designed a privacy-compliant dashboard for validating brand-reported sales while meeting InfoSec PII regulations.
- Proposed proxy phone number solution via Twilio, improving traceability of calls.
- Led to creation of new B2B service line and doubled DTC revenue in 6 months.
- Rebuilt underperforming executive dashboard mixing granular data levels and lacking focus.
- Applied clarity-first principles: Top 3 KPIs, traffic-light color coding, consistent color palette.
- Led to a strategic decision to stop sending mortgage leads due to bot traffic.
- Processed 40k daily and 200k weekly keyword combinations from Google Analytics and consulting firm.
- Implemented Qlik ODAG to handle high data volumes and allow historical analysis.
- Empowered SEO analysts and Marketing stakeholders with performant, filterable dashboards.
- Replicated functionality of a $20K+ annual dashboard delivery tool (PDF/image to Slack) using existing stack.
- Integrated Tableau, dbt, Slack, and Airflow to create custom delivery workflow with zero licensing risk.
- Saved licensing costs and avoided compliance risks while maintaining visibility.
- Disagreed with VP’s decision to migrate from Qlik to Tableau but committed fully after decision.
- Took ownership of Tableau Cloud server, trained users, and absorbed user frustration post-migration.
- Ensured successful adoption across the company despite initial disagreement.
- Investigated sudden drop in Sell-Through Rate (STR) which contradicted Financial projections.
- Identified broken redirect links in brand flows as root cause of sales underperformance.
- Developed maturity curve model for sales performance over time and implemented monitoring solution.
Tech Stack: SQL (PostgreSQL, Redshift), Python, dbt, Airflow, Tableau, QlikSense, AWS (Glue, Lambda, S3), Twilio, Slack API
Languages
Spanish
Native language
English
Advanced (C1)
C1
Timeline
Data Analyst
Biotech company
08.2024 - Current
Business Intelligence Architect
ConsumerAffairs
08.2021 - 08.2024
BI Consultant
Monsun / Western Union
11.2020 - 07.2021
BI Analyst
AABE (State Property Administration Agency)
02.2020 - 10.2020
Chemical Engineering -
University of Buenos Aires
Advanced Data Analytics -
Google
Similar Profiles
Sahidatu Adabobiliga, PMPSahidatu Adabobiliga, PMP
Operations Assistant at Tiger Biotech Company LimitedOperations Assistant at Tiger Biotech Company Limited
Algene YandallAlgene Yandall
Quality Assurance Assistant at Fate Therapeutics, A Biotech CompanyQuality Assurance Assistant at Fate Therapeutics, A Biotech Company
Ramkishan GaddamRamkishan Gaddam
Research Associate at Riya Argo Biotech CompanyResearch Associate at Riya Argo Biotech Company
Teo Cheong ParkTeo Cheong Park
Volunteer at Cooperating VolunteersVolunteer at Cooperating Volunteers
Muhammad AFNAN ARSHAD NASREENMuhammad AFNAN ARSHAD NASREEN
Administrative Support Volunteer at Multigestion Mundial SLAdministrative Support Volunteer at Multigestion Mundial SL