Loading profile…
Jose Luis Ossio Bejarano
Looking for a jobData Engineer & Data Analyst
Data Engineer at Real Men Apparel Company who built Snowflake pipelines and an Amazon Ads bid-management engine.
BoliviaData Engineer & Data Analyst at Real Men Apparel Company
Experience
Data Engineer & Data Analyst
Build and maintain production ETL/ELT pipelines in R and SQL ingesting Amazon, Shopify, TikTok Shop, and warehouse data into Snowflake. Own day-to-day reliability of the production pipeline and deliver multi-channel SQL and Power BI analyses for leadership.
RSQLSnowflakeETLELTAPI IntegrationData QualityPower BIAmazon SP APIShopifyTikTok Shop
Data Engineer Consultant
Designed and built the company's Snowflake data platform from scratch using a three-layer medallion architecture with RBAC, ingesting Shopify, Amazon, TikTok Shop, and Odoo data. Built automated reporting and a Python bid-management engine on the Amazon Ads API that reduced ACoS from 35% to 22% and raised ROAS from 2.9x to 4.6x.
SnowflakeMedallion ArchitectureRBACPythonAds APIsOAuthShopifyTikTok ShopOdooPower BIData ModelingETL
Data Science Consultant
Built customer behavior models (classification, XGBoost, grid-search tuning) that informed targeting decisions and contributed to a 35% increase in average customer spend. Segmented customers with K-Means, DBSCAN, and hierarchical clustering after full EDA.
PythonXGBoostClassificationK MeansDBSCANHierarchical clusteringEDAMachine Learning
Business Development Manager
Designed Salesforce and Power BI dashboards for sales goals and annual forecasting, achieving a 17% revenue gain in the first quarter after rollout. Cut department response time by 50% with a task management system built on SharePoint, Salesforce, and automated workflows.
SalesforcePower BISharePointWorkflow AutomationForecastingDashboarding
Education
Universidad Autónoma Gabriel René Moreno
Graduated with a Bachelor of Science in Electromechanical Engineering via Academic Excellence modality.