Kalin Stefanov

Sr Data Engineer / Architect

Genf, Schweiz

Erfahrungen

Dez. 2024 - Bis heute
7 Monaten

Sr Data Engineer / Architect

Samsung Logistics

  • Architected and implemented a structured three-layer enterprise datawarehouse model in Azure, establishing a robust and scalable data environment.
  • Migrated legacy stored procedures to streamlined Azure Data Factory (ADF) pipelines, enhancing data processing efficiency.
  • Introduced comprehensive Git-based source control, ensuring rigorous version management and collaborative development practices.
  • Established automated data quality frameworks with proactive monitoring and alerting, significantly improving data integrity and reliability.
  • Spearheaded the design of an enterprise data model, enabling a self-service BI environment that empowered business teams with advanced analytics capabilities.
  • Developed and delivered insightful dashboards and reports in Power BI, transforming raw data into actionable business insights.
März 2024 - Dez. 2025
10 Monaten
Amsterdam, Niederlande

Sr Data Engineer / Manager

Booking.com

  • Played a key role in designing and building data marts (models) and pipelines for structured data in the Datalake, with a focus on SCM (suppliers) and marketing projects.
  • Led a migration team (4 FTE) to convert the existing ETL pipelines to a Snowflake environment, including data modeling.
  • Developed complex data pipelines in PySpark, Python, Airflow, and HQL (Hadoop Hive SQL) for large-scale data processing, with strong technical and architectural expertise.
  • Worked in an Agile Scrum team with over 30 multidisciplinary team members, ranging from business analysts to data scientists.
Feb. 2023 - Dez. 2023
11 Monaten
Den Haag, Niederlande

Sr Data Engineer / Architect

ANWB LLC

  • Played a dual role as Data Engineer and Solution Architect, leading the reengineering of data marts within the Road Assistance department to align with the strategic migration to the Snowflake environment.
  • Directed the reverse-engineering of the Customer Demand List (CDL) to optimize performance, exhibiting a strong blend of technical proficiency and architectural oversight.
  • Departed post-implementation phase due to budgetary constraints, after ensuring a robust foundation for the department’s data operations.
Mai 2019 - Jan. 2024
4 Jahren 9 Monaten
New York, Vereinigte Staaten

Sr Data Engineer

DaisTech LLC

Worked for 4.5 years for several US companies as self-employed. Gained solid knowledge and experience of cloud server technologies, Python programming language, data orchestration tools and big data.

Juli 2011 - Mai 2019
7 Jahren 11 Monaten
Amsterdam, Niederlande

Data Engineer & BI/DWH Consultant

Dais

Worked for 8 years on contracting basis for numerous organizations in the Netherlands and delivered high-quality service for improving clients’ data structure, information systems and business management.

Jan. 2010 - Aug. 2012
1 Jahr 8 Monaten
Amsterdam, Niederlande

Business Intelligence Consultant / Data Engineer

ING Bank Plc.

Design and development of a Data Warehouse solution for ING Retail SME customers.

Sept. 2008 - Aug. 2011
3 Jahren
Amsterdam, Niederlande

Data Engineer & BI/DWH Consultant

Ordina

Data Engineer & Business Intelligence Consultant at the VisionWorks team participating in several projects for ING Domestic Retail Bank, Rabobank Corp., SPIL GAMES LLC and UWV.

Juli 2007 - Sept. 2008
1 Jahr 3 Monaten
Amersfoort, Niederlande

MS BI Developer

BI4U Ltd.

Data Warehouse Developer of a generic Business Intelligence solution for the healthcare industry in the Netherlands.

Feb. 2007 - Juli 2007
6 Monaten
's-Hertogenbosch, Niederlande

Product Consultant

BWise Ltd.

Implementation of the BWise risk management product suite at various organizations and companies.

Nov. 2006 - Jan. 2007
3 Monaten
Amsterdam, Niederlande

Sybase Developer

ING Bank Plc.

Freelance contract at Corporate Credit Risk Management department of ING Bank Amsterdam as a SQL programmer (Sybase) and technical analyst.

Jan. 2005 - Aug. 2006
8 Monaten
Halfweg, Niederlande

Graduation intern

WilroffReitsma Ltd.

Built up a reporting system from scratch.

März 2003 - Sept. 2003
7 Monaten
Etten-Leur, Niederlande

Intern

ABB Benelux Plc.

Individual research on the software integration.

Sr Data Engineer

Boston Consulting Group

  • Reverse-engineered (Oracle DI, SQL Server) pipelines to Snowflake SQL.
  • Re-implemented as data mart views in Snowflake and automated the orchestration and feed of solutions’ pipelines through Fivetran.
  • Fulfilled the roles of a tech lead and liaison between business units and the tech support during the migration projects.

Sr Data Engineer

Meta Platforms Inc.

  • Designed and developed multiple data marts and dashboards for Infra department in cooperation with Data Scientists.
  • Pro-actively identified usable data points in order to facilitate mitigation responsive times for Oncall teams.
  • Proposed, designed and developed end-to-end solution including data analysis, data transformation logics, data pipelines, visualization, system test, UAT, presentation to partners.

Sr Data Engineer

Newsela Inc.

  • Migrated data warehouse for user activity tracking and product engagement from Redshift to Snowflake loaded by Loome data streams.
  • Optimized performance SnowSQL scripts resulting in 40% cost reduction in data processing expenses for the company.
  • Introduced automated data quality testing scheme to track and report on anomalies based on recent past record counts, and calendar-based exceptions.

Sr Data Engineer

Randstad Technologies

  • As a technical lead designed and created dimensional enterprise data model, migrated data, built new data pipelines and data marts, performed quality assurance testing, managed code reviews and releases for billing, staff placements, and customer domains in an Agile/SCRUM multi-disciplinary team responsible for enterprise business intelligence.
  • Reverse-engineered Talend ETL pipelines to SQL and shifted to an ELT tech stack based on an internally developed system which generates Apache Airflow code to process data on Google Cloud Platform (GCP) BigQuery.
  • Enhanced internally developed code generation system to handle configurations.

Sr Data Engineer

WarnerMedia (HBO)

  • Enabled marketing analytics by loading advertising data into Snowflake using data pipelines built with Apache Airflow, Python, and SnowSQL.
  • Created python-based solution for automated data quality verification and alerting.
  • Re-engineered existing data warehouse to a unified enterprise model to eliminate redundancy and promote reusability of well-defined conformed dimensions across department-specific data marts.
  • Provided guidance and mentorship to newly onboarded remotely based team members to decrease time to productivity.

Zusammenfassung

Senior technical engineer with 15+ years of experience helping companies to structure and leverage business data and information management systems to drive decision-making. Key strengths in business process consulting, data modeling and integration as well as data flow automation.

Always taking ownership and shows leadership. Good in project management, stakeholder management and multi-disciplinary global teamwork.

Sprachen

Niederländisch
Muttersprache
Englisch
Fortgeschritten

Ausbildung

Feb. 2016 - Apr. 2019

Open Universiteit

MSc in Business Process Management & IT, minor: Data Science & Analytics · Amsterdam, Niederlande

Feb. 2011 - Feb. 2013

University of Amsterdam Business School

Pre-Master of Science in Business Studies · Business Studies · Amsterdam, Niederlande

Okt. 2000 - Juli 2006

Hogeschool Inholland

Bachelor of Applied Science in Business Informatics · Business Informatics · Diemen, Niederlande

Zertifikate & Bescheinigungen

Permis Ci

Python Developer

SQL Developer