k
konstant_gk

Konstantinos G.

@konstant_gk

Analytics Engineer with Analyst Background

França
Grego, Inglês, Francês, Espanhol, Português
Algumas informações são exibidas no idioma inglês.
Sobre mim
I am an Analytics Engineer with an Analyst background – I spent two years building dashboards for business teams and managing sales operations data. 📊 Over time, I became more interested in the data behind the dashboards. That pushed me toward analytics engineering. Whether you are a small business trying to automate a messy reporting process, or a larger data team that needs extra hands – just send me a message and I can step in and execute. 🚀 For more at www.konstantinos-gkaravelos.com ... Saiba mais

Habilidades

k
konstant_gk
Konstantinos G.
offline • 

Conheça meus serviços

BI Analytics
I will build an automated power bi dashboard from your database
A partir deUS$ 80 /projetoMais detalhes
Consultoria em Engenharia de Dados
I will automate reporting workflows using sql python and power bi
A partir deUS$ 70 /projetoMais detalhes

Portfólio

Experiência profissional

Self_Employed

Analytics Engineer

Self Employed • Freelance

Nov 2025 - Present • 6 mos

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

BD

Data Analyst

BD • Freelance

Jul 2025 - Oct 2025 • 3 mos

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