Top expert badge
Recommended expert
Profile header background

Kalin Stefanov

Sr Data Engineer / Architect

Kalin Stefanov
Profile header overlay
Geneva, Switzerland

Experience

Dec 2024 - Present
1 year 4 months
Netherlands

Sr Data Engineer / Architect

Samsung Logistics

Expertise details
Position Summary
Sr Data Engineer / Architect at Samsung Logistics
Industries
Transportation
Business Areas
Business Intelligence
Information Technology
  • Architected and implemented a structured three-layer enterprise data warehouse 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.
  • Technologies: Azure Data Factory (ADF), Azure, MS-SQL, DataVault 2.0, Git, Power BI, data quality automation, Agile/Scrum, data modeling, self-service BI, stakeholder management.
Mar 2024 - Dec 2024
10 months
Amsterdam, Netherlands

Sr Data Engineer / Manager

Booking.com

Expertise details
Position Summary
Sr Data Engineer / Manager at Booking.com
Industries
Information Technology
Tourism
Business Areas
Information Technology
Marketing
Supply Chain Management
  • Designed and built data marts (models) and pipelines for structured data in the data lake, with a focus on supply chain management (suppliers) and marketing projects.
  • Led a migration team (4 FTE) to convert 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, providing strong technical and architectural expertise.
  • Worked in an Agile Scrum team with over 30 multidisciplinary team members, ranging from business analysts to data scientists.
  • Technologies: Airflow, DBT, SQL, Python, Spark, Snowflake, Grafana, Visual Studio Code, Hadoop, Perl, Bash UNIX scripting, stakeholder management.
Feb 2023 - Dec 2023
11 months
The Hague, Netherlands

Sr Data Engineer / Architect

ANWB LLC

Expertise details
Position Summary
Sr Data Engineer / Architect at ANWB LLC
Industries
Automotive
Business Areas
Business Intelligence
Information Technology
  • Acted as both Data Engineer and Solution Architect, leading the reengineering of data marts within the Road Assistance department to align with the strategic migration to a Snowflake environment.
  • Directed the reverse-engineering of the Customer Demand List (CDL) to optimize performance, combining strong technical proficiency and architectural oversight.
  • Completed the implementation phase and departed due to budgetary constraints after establishing a robust foundation for the department’s data operations.
  • Technologies: Snowflake SQL, Azure, MS-SQL, SSIS ETL, Upsolver, Jira, Agile/Scrum, DevOps, DataVault 2.0, QlikView, Power BI, DataHub, data quality automation, data science, hackathons, AI/ChatGPT.
May 2019 - Jan 2024
4 years 9 months
New York, United States

Sr Data Engineer

DaisTech LLC

Expertise details
Position Summary
Sr Data Engineer at DaisTech LLC
Industries
Information Technology
Business Areas
Business Intelligence
Information Technology
  • Worked for 4.5 years for several US companies as a self-employed data engineer.
  • Gained solid knowledge and experience of cloud server technologies, Python programming language, data orchestration tools and big data.
Jul 2011 - May 2019
7 years 11 months
Amsterdam, Netherlands

Data Engineer & BI/DWH Consultant (self-employed)

Dais

Expertise details
Position Summary
Data Engineer & BI/DWH Consultant (self-employed) at Dais
Industries
Information Technology
Professional Services
Business Areas
Business Intelligence
Information Technology
  • Worked for 8 years on a contracting basis for numerous organizations in the Netherlands.
  • Delivered high-quality services for improving clients’ data structures, information systems and business management.
Jan 2011 - Aug 2012
1 year 8 months
Amsterdam, Netherlands

Business Intelligence Consultant / Data Engineer

ING Bank Plc.

Expertise details
Position Summary
Business Intelligence Consultant / Data Engineer at ING Bank Plc.
Industries
Banking and Finance
Business Areas
Business Intelligence
Information Technology
  • Served as a Business Intelligence Consultant and Data Engineer across several projects within ING Bank.
  • Contributed to data warehouse design, data migration, analytics and CRM initiatives.
Sep 2008 - Aug 2011
3 years
Amsterdam, Netherlands

Data Engineer & BI/DWH Consultant

Ordina

Expertise details
Position Summary
Data Engineer & BI/DWH Consultant at Ordina
Industries
Information Technology
Professional Services
Business Areas
Business Intelligence
Customer Service
Information Technology
  • Data Engineer and Business Intelligence Consultant within the VisionWorks team.
  • Participated in several client projects focused on customer intelligence, CRM and data warehousing.
Jul 2007 - Sep 2008
1 year 3 months
Amersfoort, Netherlands

MS BI Developer

BI4U Ltd.

Expertise details
Position Summary
MS BI Developer at BI4U Ltd.
Industries
Healthcare
Business Areas
Business Intelligence
Information Technology
  • Developed a generic business intelligence data warehouse solution for the healthcare industry in the Netherlands.
  • Technologies: SQL Server 2005, SSRS, SSIS, SSAS, SSMS, healthcare (Zorg), DBC, Intelligence Factory, Kaizen, lean management.
Feb 2007 - Jul 2007
6 months
's-Hertogenbosch, Netherlands

Product Consultant

BWise Ltd.

Expertise details
Position Summary
Product Consultant at BWise Ltd.
Industries
Information Technology
Business Areas
Information Technology
  • Implemented the BWise risk management product suite at various organizations.
  • Worked on governance, risk and compliance solutions.
  • Technologies and domains: Basel II, SOX, ITIL, Crystal Reports.
Nov 2006 - Jan 2007
3 months
Amsterdam, Netherlands

Sybase Developer

ING Bank Plc.

Expertise details
Position Summary
Sybase Developer at ING Bank Plc.
Industries
Banking and Finance
Business Areas
Business Intelligence
Finance
Information Technology
  • Worked at the Corporate Credit Risk Management department as a SQL programmer (Sybase) and technical analyst.
  • Supported risk modeling and reporting for credit risk metrics.
  • Technologies and domains: PD (Probability of Default), EAD (Exposure at Default), LGD (Loss Given Default), risk modeling, Sybase SQL, Perl.
Jan 2006 - Aug 2006
8 months
Halfweg, Netherlands

Graduation Intern

WilroffReitsma Ltd.

Expertise details
Position Summary
Graduation Intern at WilroffReitsma Ltd.
Industries
Information Technology
Business Areas
Business Intelligence
Information Technology
  • Built a reporting system from scratch for finance and operations.
  • Technologies: DTS, MS-SQL, SSRS, SQL Server 2000.
Mar 2003 - Sep 2003
7 months
Etten-Leur, Netherlands

Intern

ABB Benelux Plc.

Expertise details
Position Summary
Intern at ABB Benelux Plc.
Industries
Energy
Manufacturing
Business Areas
Information Technology
Research and Development
  • Conducted individual research on software integration within the organization.
Boston, United States

Sr Data Engineer

Boston Consulting Group

Expertise details
Position Summary
Sr Data Engineer at Boston Consulting Group
Industries
Professional Services
Business Areas
Business Intelligence
Information Technology
  • Reverse-engineered Oracle DI and SQL Server pipelines to Snowflake SQL.
  • Re-implemented logic as data mart views in Snowflake and automated orchestration and feeding of solution pipelines through Fivetran.
  • Served as tech lead and liaison between business units and technical support during migration projects.
  • Technologies: Snowflake SQL, Fivetran, MS-SQL Server, MySQL, GitLab, PL/SQL, Oracle, SAP Enterprise, Slack, Jira.
Amsterdam, Netherlands

Regulatory Reporting Specialist

ING Bank Plc.

Expertise details
Position Summary
Regulatory Reporting Specialist at ING Bank Plc.
Industries
Banking and Finance
Business Areas
Business Intelligence
Finance
Project Management
  • Redesigned and reworked a mis-performing regulatory reporting system.
  • Acted as Scrum Master and technical lead in SQL and reporting for regulatory domains.
  • Technologies and domains: IFRS 9, Liquidity Coverage Ratio (LCR), Oracle PL/SQL, SAP, Dutch National Bank (DNB), European Central Bank (ECB), MiFID II, FINREP, COREP.
Amsterdam, Netherlands

Data Warehouse Specialist / Project Manager

ING Domestic Retail Bank Plc.

Expertise details
Position Summary
Data Warehouse Specialist / Project Manager at ING Domestic Retail Bank Plc.
Industries
Banking and Finance
Business Areas
Business Intelligence
Information Technology
Project Management
  • Designed and developed a data warehouse solution for ING Retail SME customers.
  • Worked on data and information analysis, SME CRM, customer segmentation and proof-of-concept implementations.
  • Technologies: MS-SQL, data modeling, CloverETL, MySQL, Pentaho, Talend.
Amsterdam, Netherlands

BI / SQL / CRM Specialist / Data Mining & Analytics Consultant

ING Domestic Retail Bank Plc., Customer Intelligence Department

Expertise details
Position Summary
BI / SQL / CRM Specialist / Data Mining & Analytics Consultant at ING Domestic Retail Bank Plc., Customer Intelligence Department
Industries
Banking and Finance
Business Areas
Business Intelligence
Marketing
  • Worked on upgrading the Customer Intelligence platform.
  • Delivered BI, SQL and CRM solutions as well as data mining and analytics consulting.
  • Technologies: SAS, PL/SQL, multi-channel campaign management, CRM, Oracle, Tango, marketing intelligence.
Amsterdam, Netherlands

BI / SQL / CRM Specialist / Data Mining & Analytics Consultant

ING Domestic Retail Bank, Customer Intelligence Department

Expertise details
Position Summary
BI / SQL / CRM Specialist / Data Mining & Analytics Consultant at ING Domestic Retail Bank, Customer Intelligence Department
Industries
Banking and Finance
Business Areas
Business Intelligence
Information Technology
Marketing
  • Contributed to the upgrade of the Customer Intelligence platform.
  • Provided BI, SQL, CRM and data mining expertise.
  • Technologies: SAS, PL/SQL, multi-channel campaign management, CRM, Oracle, Tango, marketing intelligence.
Amsterdam, Netherlands

Sr BI Developer

KASBANK Plc.

Expertise details
Position Summary
Sr BI Developer at KASBANK Plc.
Industries
Banking and Finance
Business Areas
Business Intelligence
Information Technology
  • Implemented a data warehouse solution supporting custodial banking operations.
  • Led BI work within an Agile/Scrum framework.
  • Technologies and domains: MS-SQL, Kimball methodology, BI framework design, SSIS ETL, C#, ISIN, custodian banking.
Menlo Park, United States

Sr Data Engineer

Meta Platforms Inc. (Facebook)

Expertise details
Position Summary
Sr Data Engineer at Meta Platforms Inc. (Facebook)
Industries
Information Technology
Media and Entertainment
Business Areas
Business Intelligence
Information Technology
  • Designed and developed multiple data marts and dashboards for the Infrastructure department in cooperation with data scientists.
  • Proactively identified usable data points to facilitate mitigation response times for on-call teams.
  • As an end-responsible tech lead, proposed, designed and developed an end-to-end solution including data analysis, data transformation logic, data pipelines, visualization, system testing, UAT and presentations to partners.
  • Technologies: Presto SQL, Unidash, Python, big data, data lake, Hive, on-call operations, infrastructure analytics.
The Hague, Netherlands

Sr MSBI Developer / Data Analyst / DWH Modeler

NIBC NV

Expertise details
Position Summary
Sr MSBI Developer / Data Analyst / DWH Modeler at NIBC NV
Industries
Banking and Finance
Business Areas
Business Intelligence
Finance
Information Technology
  • Participated in more than 7 enterprise data projects in various roles including MSBI development, data analysis and data warehouse modeling.
  • Focus areas included regulatory reporting and data virtualization.
  • Technologies and domains: Anacredit, DGS, VIA, cost allocation models, data virtualization.
New York, United States

Sr Data Engineer

Newsela Inc.

Expertise details
Position Summary
Sr Data Engineer at Newsela Inc.
Industries
Education
Business Areas
Business Intelligence
Information Technology
  • Migrated the data warehouse for user activity tracking and product engagement from Amazon Redshift to Snowflake, loaded by Loome data streams.
  • Optimized performance of SnowSQL scripts, resulting in a 40% reduction in data processing expenses.
  • Introduced an automated data quality testing scheme to track and report anomalies based on recent record counts and calendar-based exceptions.
  • Technologies: Snowflake SQL, SOA, Python, Looker, Loome, Fivetran, Kinesis, Amazon Web Services (AWS), Redshift, JSON, enterprise data integration, data lake, data marts and data modeling.
Utrecht, Netherlands

Data Engineer / Marketing Software Integration Specialist

Rabobank Corp.

Expertise details
Position Summary
Data Engineer / Marketing Software Integration Specialist at Rabobank Corp.
Industries
Banking and Finance
Business Areas
Information Technology
Marketing
  • Worked on marketing software back-end integration within Rabobank CRM.
  • Implemented SmartFocus-based marketing campaign management.
  • Technologies: marketing campaign management, SAP, CRM, SQL, HP NeoView, SmartFocus.
Atlanta, United States

Sr Data Engineer

Randstad Technologies

Expertise details
Position Summary
Sr Data Engineer at Randstad Technologies
Industries
Professional Services
Business Areas
Business Intelligence
Information Technology
Quality Assurance
  • As a technical lead, designed and created a dimensional enterprise data model, migrated data, built new data pipelines and data marts, performed quality assurance testing and managed code reviews and releases for billing, staff placements and customer domains.
  • Worked within an Agile/Scrum multidisciplinary 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 generating Apache Airflow code to process data on Google Cloud Platform (GCP) BigQuery.
  • Enhanced the internally developed code generation system to handle configurations.
  • Technologies: BigQuery, Python, Airflow, data marts, Spinnaker, GitLab, Talend, Oracle, SQL, SOA.
Hilversum, Netherlands

Open Source DWH Designer and Developer

SPIL Games LLC

Expertise details
Position Summary
Open Source DWH Designer and Developer at SPIL Games LLC
Industries
Media and Entertainment
Business Areas
Business Intelligence
Information Technology
  • Designed and developed an open source data warehouse as a proof-of-concept for online games portals.
  • Technologies: open-source BI, Pentaho, Google Analytics.
Wognum, Netherlands

Team Lead BI

Simon Loos Ltd.

Expertise details
Position Summary
Team Lead BI at Simon Loos Ltd.
Industries
Transportation
Business Areas
Business Intelligence
Logistics
  • Led the implementation of a data warehouse solution supporting transport and logistics operations.
  • Technologies and domains: MS-SQL, Kimball methodology, cost-effective planning, transport and logistics analytics, SSRS, Agile/Scrum.
Amersfoort, Netherlands

Senior Software Developer Sybase

Stater Plc.

Expertise details
Position Summary
Senior Software Developer Sybase at Stater Plc.
Industries
Banking and Finance
Business Areas
Finance
Information Technology
  • Performed SEPA redesign and modification of a mortgage maintenance system.
  • Technologies and domains: Sybase, SQL, Uniface, VMS, SEPA, private mortgages, credit risk, direct debit batch processing, XML.
Antwerp, Belgium

Senior Microsoft BI Developer

Telenet Plc.

Expertise details
Position Summary
Senior Microsoft BI Developer at Telenet Plc.
Industries
Telecommunication
Business Areas
Business Intelligence
Information Technology
  • Upgraded the Network Capacity Data Warehouse for a telecommunications provider.
  • Technologies and domains: MS-SQL, VB.NET, data archiving, HFC networks, capacity planning, telecom.
Amsterdam, Netherlands

Data Warehouse Developer & Test Specialist

UWV

Expertise details
Position Summary
Data Warehouse Developer & Test Specialist at UWV
Industries
Government and Administration
Business Areas
Business Intelligence
Information Technology
Quality Assurance
  • Developed ETL and reporting for the Polis+ system.
  • Performed data modeling and testing for social security and payroll-related data.
  • Technologies: MS-SQL, SSIS, SSRS, data modeling, PolisPlus, Policy Administration, Wage Tax Liability.
Amersfoort, Netherlands

Sr MS Developer

Volkswagen Pon Financial Services

Expertise details
Position Summary
Sr MS Developer at Volkswagen Pon Financial Services
Industries
Automotive
Banking and Finance
Business Areas
Information Technology
  • Designed and developed a custom-made sensitive data anonymization tool.
  • Technologies: GDPR, MS-SQL, SSIS, C#, VB.NET.
Hilversum, Netherlands

Software Engineer SQL

WSW

Expertise details
Position Summary
Software Engineer SQL at WSW
Industries
Banking and Finance
Real Estate
Business Areas
Business Intelligence
Finance
Information Technology
  • Designed and developed a new software solution for real estate associations’ financial and business risk models.
  • Technologies and domains: S&P matrix, T-SQL, SSIS framework, data quality management (DQM), master data management (MDM), QlikView.
New York, United States

Sr Data Engineer

WarnerMedia (HBO)

Expertise details
Position Summary
Sr Data Engineer at WarnerMedia (HBO)
Industries
Media and Entertainment
Business Areas
Business Intelligence
Information Technology
  • Enabled marketing analytics by loading advertising data into Snowflake using data pipelines built with Apache Airflow, Python and SnowSQL.
  • Created a Python-based solution for automated data quality verification and alerting.
  • Re-engineered an existing data warehouse to a unified enterprise model to eliminate redundancy and promote reusability of conformed dimensions across department-specific data marts.
  • Provided guidance and mentorship to newly onboarded remote team members to decrease time to productivity.
  • Technologies: Snowflake, Python, GitHub, JSON, Airflow, data modelling, Agile/Scrum, team leadership.
Amsterdam, Netherlands

Data Analyst / Audit & Financial Data Validation and Test Specialist / SQL Server and SSIS Developer

WestlandUtrecht Bank Plc.

Expertise details
Position Summary
Data Analyst / Audit & Financial Data Validation and Test Specialist / SQL Server and SSIS Developer at WestlandUtrecht Bank Plc.
Industries
Banking and Finance
Business Areas
Audit
Finance
Information Technology
  • Managed data migration and transformation of ING Bank accounts to WestlandUtrecht Bank.
  • Performed data analysis, audit, financial data validation and testing.
  • Developed ETL processes using SQL Server and SSIS.
  • Technologies: MS-SQL, data migration, Europort+, ETL, Syntel, hash totals, conversion, data quality.
Alphen aan den Rijn, Netherlands

Marketing Intelligence Specialist

Wolters Kluwer Plc.

Expertise details
Position Summary
Marketing Intelligence Specialist at Wolters Kluwer Plc.
Industries
Professional Services
Business Areas
Business Intelligence
Marketing
  • Worked on marketing intelligence initiatives using enterprise campaign and reporting tools.
  • Technologies: Unica, IBM, Cognos, Oracle, Informatica PowerCenter, campaign management.

Industry Experience

See where this freelancer has spent most of their professional time.

Experienced in Information Technology, Professional Services, Banking and Finance, Transportation, Tourism, and Automotive.

Information Technology
Professional Services
Banking and Finance
Transportation
Tourism
Automotive
Profile match chart

Business Area Experience

See which departments and functions this freelancer has contributed to most.

Experienced in Information Technology, Business Intelligence, Customer Service, Marketing, Supply Chain Management, and Research and Development.

Information Technology
Business Intelligence
Customer Service
Marketing
Supply Chain Management
Research and Development
Profile match chart

Summary

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.

Certified as a SQL and Python developer. MSc in Business Management. Always taking ownership and shows leadership. Good in project management, stakeholder management and multi-disciplinary global teamwork.

Languages

Dutch
Native
English
Advanced

Education

Feb 2016 - Apr 2019

Open Universiteit

MSc in Business Process Management & IT (minor: Data Science & Analytics) · Business Process Management & IT · Amsterdam, Netherlands

Feb 2011 - Feb 2013

University of Amsterdam Business School

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

Oct 2000 - Jul 2006

Hogeschool Inholland

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

Certifications & licenses

SQL And Python Developer

Statistics

Experience

Total positions 33
Experience in Information Technology 17 y
Avg length 8 m
Longest experience 7 y 10 m

Global Experience

Countries worked in 3 (Netherlands, United States, Belgium)
Primary country Netherlands

Expertise

Recent roles Sr Data Engineer / Architect, Sr Data Engineer / Manager, Sr Data Engineer
Main industries Information Technology, Professional Services, Banking and Finance
Main business areas Information Technology, Business Intelligence, Customer Service

Qualifications

Highest degree Master
Certifications earned 1

Profile

Created
Need a freelancer? Find your match in seconds.
Try FRATCH GPT
More actions

Frequently asked questions

Do you have questions? Here you can find further information.

Where is Kalin based?

Kalin is based in Geneva, Switzerland.

What languages does Kalin speak?

Kalin speaks the following languages: Dutch (Native), English (Advanced).

How many years of experience does Kalin have?

Kalin has at least 20 years of experience. During this time, Kalin has worked in at least 11 different roles and for 11 different companies. The average length of individual experience is 2 years and 8 months. Note that Kalin may not have shared all experience and actually has more experience.

What roles would Kalin be best suited for?

Based on recent experience, Kalin would be well-suited for roles such as: Sr Data Engineer / Architect, Sr Data Engineer / Manager, Sr Data Engineer.

What is Kalin's latest experience?

Kalin's most recent position is Sr Data Engineer / Architect at Samsung Logistics.

What companies has Kalin worked for in recent years?

In recent years, Kalin has worked for Samsung Logistics, Booking.com, ANWB LLC, and DaisTech LLC.

Which industries is Kalin most experienced in?

Kalin is most experienced in industries like Information Technology, Professional Services, and Banking and Finance. Kalin also has some experience in Transportation, Healthcare, and Automotive.

Which business areas is Kalin most experienced in?

Kalin is most experienced in business areas like Information Technology, Business Intelligence, and Customer Service. Kalin also has some experience in Marketing, Supply Chain Management, and Research and Development.

Which industries has Kalin worked in recently?

Kalin has recently worked in industries like Information Technology, Transportation, and Automotive.

Which business areas has Kalin worked in recently?

Kalin has recently worked in business areas like Information Technology, Business Intelligence, and Marketing.

What is Kalin's education?

Kalin holds a Master in Business Process Management & IT from Open Universiteit, a Master in Business Studies from University of Amsterdam Business School and a Bachelor in Business Informatics from Hogeschool Inholland.

Does Kalin have any certificates?

Kalin has 1 certificate: SQL And Python Developer.

What is the availability of Kalin?

The availability of Kalin needs to be confirmed.

What is the rate of Kalin?

Kalin's rate depends on the specific project requirements. Please use the Meet button on the profile to schedule a meeting and discuss the details.

How to hire Kalin?

To hire Kalin, click the Meet button on the profile to request a meeting and discuss your project needs.

Average rates for similar positions

Rates are based on recent contracts and do not include FRATCH margin.

1400
1050
700
350
Rate comparison chart
Market avg: 1130-1290 €
The rates shown represent the typical market range for freelancers in this position based on recent contracts on our platform.
Actual rates may vary depending on seniority level, experience, skill specialization, project complexity, and engagement length.