Konstantinos Gkaravelos

I help businesses and data teams to replace manual Excel reporting and build BI-ready data pipelines and reliable reporting systems. After two years as a data analyst, I transitioned to analytics engineering because I became more interested in the data behind the dashboards and the layer between raw data and the final report. I designed and built a production-style food data lakehouse that solves a real problem. Open Food Facts is a public API with 3M+ product records but zero analyst-ready tables. Nutrichain Open Food Lakehouse is a portfolio project demonstrating my skills in analytics engineering. It turns that raw API into a trusted, queryable lakehouse on Databricks: - Engineered an end-to-end batch ingestion pipeline in Python fetching paginated JSON from the Open Food Facts API, landing raw data into a Bronze Delta Lake table with run-level metadata, hash keys, and audit logging for full lineage traceability - Orchestrated daily pipeline runs using Apache Airflow with task dependencies, retry logic, and Databricks Secrets for API key management — targeting ≥95% job success rate - Transformed Bronze data through a Silver layer using dbt on Databricks: deduplication on business keys, type casting, null handling, and schema validation across 500K+ records from 170+ countries - Modelled a Kimball-style star schema in the Gold layer with dbt (fact_product_nutrition + dim_brand, dim_category, dim_nutriscore, dim_country) connected directly to Power BI via Databricks SQL

Contracted to execute a critical master data integration project following a company acquisition, specifically handling the Greek and French markets: - Tasked with identifying and resolving duplicate customer records between an 8,000-record acquired database and a 514,000-record enterprise database - Engineered custom Excel macros and utilized advanced data functions to automate the matching of customer names, addresses, and IDs across both datasets - Successfully mapped and deduplicated the required records, ensuring a clean migration into the parent company's master database

Selected for an intensive, hands-on data analytics and business intelligence training program, culminating in an end-to-end capstone engineering project: - Designed and built a local data warehouse from an OLTP source database, structuring the data into a STAR schema for analysis - Engineered SQL-based ETL pipelines to extract, transform, and load the data, applying quality checks for null handling and primary key validation - Developed a multiclass classification machine learning model (Python, Scikit-learn) to forecast sales performance - Built the final visualization layer using Power BI and DAX to present the findings - Documented the whole pipeline providing clear code and demonstrating end-to-end ownership of the full data engineering lifecycle

Acted as the primary data analyst for the supply operations team, translating raw metrics into actionable sales insights: - Designed and engineered custom SQL data models and analytical tables in the database — forming the single source of truth for all sales reporting across the organization. Optimized query performance to reduce report latency - Delivered 100+ production dashboards across Power BI, Metabase, and Tableau — each built on top of engineered SQL data models, ensuring consistent metric definitions across reporting surfaces - Designed and analyzed sales incentive and compensation plans based on robust performance metrics, directly aligning seller activities with key business objectives and driving revenue growth - Systematically evaluated seller performance metrics to identify top performers - Optimized the core sales process by leveraging Salesforce Lightning, streamlining workflows to increase sales team efficiency

Supported the sales operations team by cleaning CRM data and automating manual tracking processes: - Engineered a complex Excel-based analytical engine to automate pipeline management, leveraging Power Query, DAX, and Macros to process 20,000+ records, reducing average analysis time by 20% and improving forecast accuracy - Transformed raw sales data into actionable strategic recommendations, directly influencing process improvements that enhanced sales team efficiency and conversion rates - Designed and automated interactive KPI dashboards to monitor the entire sales funnel, replacing manual reporting and providing real-time visibility into quota attainment, pipeline health, and outbound activity for leadership

Supported the account team during my internship at the most famous agency of the Greek advertising world: - Analyzed social media performance metrics to identify engagement trends, leading to a data-informed content strategy that increased average client engagement by 5% - Leveraged performance data from ad campaigns to optimize copywriting and visual content, resulting in more effective ads and improved client satisfaction - Synthesized campaign data and client feedback into compelling presentations, effectively communicating analytical findings and strategic recommendations to stakeholders - Cultivated strong client relationships through proactive communication and data-backed reporting, leading to a 150% increase in accounts managed