UpstaffSign up
Kaloyan K, Senior ETL, DWH and BI Engineer
Kaloyan K
🇧🇬Bulgaria (UTC+02:00)
Created AtUpstaffer since July, 2026
🔥 Get Kaloyan K rates & availability. We respond within one business day
Book a Call Download Profile PDF

Kaloyan K — Senior ETL, DWH and BI Engineer

Expertise in Data Engineer (13.0 yr.), Business Intelligence (BI) (7.0 yr.), Data Extraction and ETL (5.0 yr.).

 Last verified on July, 2026
English C1

Core Skills

SQL
SQL
13 yr.
dbt
dbt
2 yr.
Snowflake
Snowflake
3 yr.
Azure Data Factory
Azure Data Factory
4 yr.
Databricks
Databricks

Bio Summary

  • Over 15 years of expertise in designing and implementing ETL/ELT, high-availability databases and advanced BI solutions across cloud and on-premises platforms, including Snowflake, AWS, Azure, and SQL Server.
  • Proficient in SQL (T-SQL, PL-SQL), Python (NumPy, Pandas), MDX, and ETL tools such as dbt, SSIS, and Azure Data Factory, with strong experience in data warehouse architecture and migration projects.
  • Solid foundation in computer science with MSc in Microsoft Information Technologies and hands-on experience in Microsoft BI stack, cloud data engineering, and agile methodologies, including SCRUM and Azure DevOps.

Technical Skills

Programming Languages PL-Sql, Python
.NET Platform ASP.NET MVC
Java Libraries and Tools MDX
AI & Machine Learning NumPy, PandasAI, ScyPy
Python Libraries and Tools NumPy, Plotly, Seaborn
Salesforce Ecosystem Salesforce
Data Analysis and Visualization Technologies Azure Data Factory, Databricks, DataFrame library, PandasAI, Polars (pola.rs, DataFrame library), Power BI, Presto S3, Tableau
Databases & Management Systems / ORM AWS Redshift, dbt, Microsoft Azure SQL Server, Microsoft SQL Server, MySQL, Oracle Database, PL/SQL, PostgreSQL, Snowflake, SQL, SSAS, SSIS, SSRS, T-SQL
UI Frameworks, Libraries, and Browsers CSS, HTML
Cloud Platforms, Services & Computing AWS
Amazon Web Services AWS Lambda, AWS Redshift
Azure Cloud Services Azure App Service, Azure Data Factory, Azure DevOps, Azure DevOps Server, Databricks, Microsoft Azure SQL Server
Deployment, CI/CD & Administration CI/CD
Third Party Tools / IDEs / SDK / Services Excel, Office 365, PowerPoint, Power Query
Blockchain and Decentralized Software Foundry
Version Control Git, SVN
Collaboration, Task & Issue Tracking Jira
Scripting and Command Line Interfaces PowerShell
Platforms Salesforce, SAP, SharePoint
Methodologies, Paradigms and Patterns Scrum
Operating Systems Unix
Other Technical Skills DAX Studio, ex TFS Team Foundation Server, Visual Basic, XMLA

Work Experience

SENIOR DATA ENGINEER - Merck Group (Data delivery and maintainability through medallion architecture)

Duration: March 2022 – Current

Summary:

  • Large-scale modernization of enterprise data ecosystem by migrating legacy Qlik Sense ETL pipelines to a new high-availability Data Hub built on Snowflake and dbt
  • The project aimed to consolidate fragmented data processing into a unified, scalable, cloud-based architecture integrating with Palantir Foundry and Qlik SaaS, reducing technical debt and retiring on-premises dependencies

Responsibilities:

  • Designed entire DWH architecture from scratch with ELT/ETL using SQL across multiple data layers.
  • Led migration of numerous sources and tables from Salesforce and Qlik Sense code to dbt and Snowflake.
  • Developed complex integration layer logic with extensive business definitions.
  • Managed code and deployment using Azure DevOps.

Technologies: SQL, Snowflake, dbt, Azure DevOps, Salesforce, Qlik Sense, Palantir Foundry

BI, DWH CONSULTANT - eSports Technologies, US (Tactical Data Warehouse Architecture)

Duration: September 2020 – March 2022

Summary:

  • Established a comprehensive cloud-ready data warehouse infrastructure for a fast-growing startup, integrating operational, financial, and analytics business dimensions
  • The solution ensured real-time access, full governance, and automated reporting to support informed decision-making and advanced analytics readiness

Responsibilities:

  • Designed data architecture, modeling, and reconciliation of diverse data sources aiming for full automation.
  • Developed Power BI operational reports and dashboards for ETL process tracking and business metrics.
  • Implemented ELT automation and performance tuning on Amazon RedShift clusters.
  • Supported main data consumers using Tableau and Power BI.

Technologies: Amazon RedShift, S3, Lambda, Power BI, Tableau, Dataddo, Power Query, DAX

Senior DWH Developer & Tech Team Lead - The Stars Group, UK (Enterprise BI Solutions and Team Leadership)

Duration: June 2017 – September 2020

Summary:

  • Led the development and enhancement of enterprise BI solutions for the world’s largest online cardroom company, supporting over 70 million clients globally
  • Ensured SOX compliance and improved data mart accuracy while managing a remote development team in Bulgaria

Responsibilities:

  • Designed end-to-end BI architecture including ETL, data modeling, and reporting.
  • Led and trained a remote technical team to achieve self-sufficiency and productivity.
  • Developed using full Microsoft BI stack: SSIS, SSAS, SSRS, and Azure technologies.
  • Managed over 15 TB data warehouse on SQL Server and integrated Azure Data Factory and Data Lake for raw data extraction.
  • Ensured compliance with auditors and maintained documentation and coding standards.

Technologies: SQL Server 2016/2019, SSIS, SSAS, SSRS, Azure Data Factory, Azure SQL Database, Azure Analysis Services, Power BI, GIT, SVN, Jira

Snr Developer – Database and BI - Ladbrokes Coral (Company Merger and Data Transformation)

Duration: November 2016 – May 2017

Summary:

  • Led the data transformation and integration project following the merger of Ladbrokes and Coral, combining historical and current data sources to create unified analytical and reporting functions
  • The project resulted in the largest market share and retail presence in the UK betting industry

Responsibilities:

  • Transformed and integrated data from multiple source systems including SQL Server and Oracle.
  • Developed Microsoft BI platform solutions for combined analytics and reporting.
  • Collaborated with stakeholders to agree on source systems and data governance.

Technologies: Microsoft BI platform, SQL Server, Oracle

Snr Developer – Database and BI - Gala Coral Group, Gibraltar (UK) (Data Warehouse and BI Development)

Duration: January 2014 – November 2016

Summary:

  • Implemented presentation layer and contributed to building the data warehouse supporting multiple business teams including C-level executives
  • Supported the company’s rapid growth as a leading gaming operator in Europe with doubling revenues

Responsibilities:

  • Developed and maintained SQL Server and Oracle databases and data structures.
  • Created business logic, performance tuning, and automation scripts for reporting needs.
  • Developed MDX queries for analytical cubes supporting financial and CRM analysts.
  • Managed security access and data migration between Oracle and SQL Server.
  • Produced periodic reports and dashboards for Marketing, CRM, and Finance teams.
  • Utilized SharePoint 2013 BI features for reporting and documentation.

Technologies: SQL Server 2014, Oracle, T-SQL, PL-SQL, MDX, PowerShell, SharePoint 2013, SSRS, SSAS

Snr Developer – Database and BI (Finance Team) - Coral Interactive, Gibraltar (UK) (Finance Reporting and Data Reconciliation)

Duration: November 2012 – December 2013

Summary:

  • Supported the finance team by developing reports, reconciling data, and defining KPIs and business data dictionaries
  • Delivered over 50 reports including daily management packs and executive dashboards for a 24/7 gambling and casino interactive services business

Responsibilities:

  • Developed SSRS, SharePoint, and SSAS cube reports for finance and executive teams.
  • Performed data reconciliation between source systems, data warehouse, and reporting layers.
  • Developed Oracle 11g database objects in RAC environment and managed deployments.
  • Provided Excel reporting and training for BI users.

Technologies: Oracle 11g, SQL Server, SSRS, SSAS, SharePoint, T-SQL, MDX, PowerPivot, Excel

IT Business Intelligence Consultant - Flexware Innovation, US (Manufacturing BI Project)

Duration: September 2011 – March 2012

Summary:

  • Delivered a major BI project for a global manufacturing client that doubled company turnover by completing the project on time and under budget
  • Focused on performance tuning and building ETL packages and reports

Responsibilities:

  • Performed performance tuning including indexing and partitioning.
  • Developed SSIS ETL packages and SSRS reports based on requirements.
  • Utilized SharePoint 2010 for BI solutions.

Technologies: SQL Server, SSIS, SSRS, SharePoint 2010, T-SQL

Database Developer / Junior Analyst Programmer - ERA Environmental solutions, Canada (Environmental Consulting SaaS Solution Development)

Duration: July 2011 – March 2012

Summary:

  • Developed complex reports and database modules for a SaaS environmental consulting solution used by major automotive companies
  • Assisted in infrastructure and security model design

Responsibilities:

  • Developed complex stored procedures, functions, and chemical calculations in T-SQL.
  • Performed query analysis and optimization in a multi-tier architecture.
  • Assisted with production server updates and Active Directory security model design.
  • Contributed to ASP.NET and Visual Basic.NET tasks and debugging.
  • Managed development using Team Foundation Server 2010.

Technologies: SQL Server, T-SQL, ASP.NET, Visual Basic.NET, Team Foundation Server 2010, Active Directory

Trainee – Database and BI technologies - Flexware Innovation, US (Database and BI Development and Maintenance)

Duration: May 2010 – May 2011

Summary: Gained hands-on experience in database development, performance tuning, and maintenance tasks including SQL Agent jobs and stored procedures for BI technologies.

Responsibilities:

  • Developed stored procedures, functions, triggers, and queries.
  • Performed performance tuning and maintenance tasks.
  • Participated in user acceptance testing and SAP working skills.

Technologies: SQL Server, T-SQL, SQL Agent, SAP

Education

  • MSc Microsoft Information Technologies
    Scholarship Programme at Technical University of Varna
    September 2009 – July 2012
  • Cisco programme
    4 modules providing deep knowledge in computer networks world at Technical University of Varna
    September 2009 – February 2010
  • Bachelor's Degree in Computer Science and Technology
    Technical University of Varna, Bulgaria
    2005 – April 2009
  • Erasmus Scholarship Programme
    Development of a bachelor’s thesis at Otto-von-Guericke University, Germany
    April 2009 – September 2009

Certification

  • SnowPro Core Certified Professional
    Certification ID S0018898
  • SQL Server 2008 – Database development and management
  • SQL Server 2008 – Database administration and maintenance
  • Udemy courses
    30+ lifetime learner

How to hire with Upstaff

1

Talk to Our Talent Expert

Our journey starts with a 30-min discovery call to explore your project challenges, technical needs and team diversity.

2

Meet Carefully Matched Talents

Within 1-3 days, we’ll share profiles and connect you with the right talents for your project. Schedule a call to meet engineers in person.

3

Validate Your Choice

Bring new talent on board with a trial period to confirm you hire the right one. There are no termination fees or hidden costs.

Why Upstaff

Upstaff is a technology partner with expertise in AI, Web3, Software, and Data. We help businesses gain competitive edge by optimizing existing systems and utilizing modern technology to fuel business growth.

Real-time project team launch

<24h

Interview First Engineers

Upstaff's network enables clients to access specialists within hours & days, streamlining the hiring process to 24-48 hours, start ASAP.

x10

Faster Talent Acquisition

Upstaff's network & platform enables clients to scale up and down blazing fast. Every hire typically is 10x faster comparing to regular recruitement workflow.

Vetted and Trusted Engineers

100%

Security And Vetting-First

AI tools and expert human reviewers in the vetting process is combined with track record & historically collected feedbacks from clients and teammates.

~50h

Save Time For Deep Vetting

In average, we save over 50 hours of client team to interview candidates for each job position. We are fueled by a passion for tech expertise, drawn from our deep understanding of the industry.

Flexible Engagement Models

Arrow

Custom Engagement Models

Flexible staffing solutions, accommodating both short-term projects and longer-term engagements, full-time & part-time

Sharing

Unique Talent Ecosystem

Candidate Staffing Platform stores data about past and present candidates, enables fast work and scalability, providing clients with valuable insights into their talent pipeline.

Transparent

$0

No Hidden Costs

Price quoted is the total price to you. No hidden or unexpected cost for for candidate placement.

x1

One Consolidated Invoice

No matter how many engineers you employ, there is only one monthly consolidated invoice.

Kaloyan K, Senior ETL, DWH and BI Engineer
Ready to hire Kaloyan K
or someone with similar Skills?
Kaloyan K is available
for hire 🔥
Book a call with Kaloyan K
Looking for Someone Else? Join Upstaff access to All profiles and Individual Match
Start Hiring
Request Kaloyan K Rates & Availability
Attachment File attachment Arrow

Upload File. Drag and Drop or Browse

{# when reCAPTCHA is disabled server-side (staging/local test), drop the g-recaptcha binding so the button submits directly — keeps front/back in sync via one flag #}
At Upstaff we respect confidentiality, privacy and value your information.

Confidential (C) UPSTAFF LTD, England and Wales, #12727246 17 Montgomery Drive, Tavistock, United Kingdom PL19 8KX

Terms, conditions and legal information.

Thank you! 🎉

Your message has been successfully sent. We’ll review it and get back to you as soon as possible.

Create an account to save your details and track your applications.

Sign up
Download Candidate Profile (PDF)

Please leave your details and we'll email you the resume right away.

At Upstaff we respect your privacy.

Confidential (C) UPSTAFF LTD, England and Wales, #12727246 17 Montgomery Drive, Tavistock, United Kingdom PL19 8KX

Terms, conditions and legal information.