08/10/2026 updated

**** ******** ****
100 % available

BI Consultant | Data Engineer | Azure & Microsoft Technologies Specialist

Praha 6, Czech Republic
Only remote
Master's degree in International Business (Ing.) - Vysoká škola ekonomická v Praze
Praha 6, Czech Republic
Only remote
Master's degree in International Business (Ing.) - Vysoká škola ekonomická v Praze

Profile attachments

CV Tomas Kolar.pdf

About me

Available for 0.5 FTE (3 days/week)

Business Intelligence & Data Analytics
Expertise in designing and implementing BI solutions using Power BI and Tableau. Development of dashboards, reports, and data visualizations to provide actionable insights for stakeholders. Experience with report migration from Tableau to Power BI and implementation of Row-Level Security (RLS) and Object-Level Security (OLS).

Cloud Data Engineering (Azure & Snowflake)
Hands-on experience with Azure Data Factory, Azure Synapse, and Microsoft Fabric for building and managing cloud-based data solutions. Administration and management of Azure cloud environments. Building and maintaining cloud-based data marts in Snowflake, ensuring scalable and efficient data storage and retrieval.

ETL Pipeline Development & Data Integration
Design and implementation of advanced ETL pipelines using Keboola with SCD2 patterns to ensure data consistency and historical accuracy. Management of the entire data lifecycle including extracting, transforming, and integrating data from various sources such as databases, Excel files, and online repositories.

PySpark & Python Automation
Development of Python scripts to automate key tasks such as customer evaluations, migration wave assignments, and data output generation. Data transformation and orchestration using PySpark notebooks within the Medallion architecture.

SQL
Proficient use of SQL including DDL commands and writing to tables for data transformation and orchestration across various platforms and environments.

SAP ERP & Process Mapping
Experience as a Functional Expert in SAP ERP implementation in the area of order management and finance. Process mapping using BPMN tool Signavio and defining requirements and acceptance criteria using JIRA.

Alteryx & Data Warehouse Design
Preparation of data using Alteryx and design of data warehouses optimized for reporting purposes, including solutions for energy monitoring dashboards based on IoT device data.

Supply Chain & Planning Analytics
Analysis of goods flow through BI reports (QS, Power BI, Tableau) and demand planning using historical data. Experience in supply planning, inventory management, and benchmarking with suppliers.

Microsoft Certifications (PL-300, DP-600, AZ-104, AZ-305, SnowPro Core)
Holder of multiple Microsoft certifications including Power BI Data Analyst (PL-300), Fabric Analytics Engineer Associate (DP-600), Azure Administrator (AZ-104), Azure Solutions Architect (AZ-305), and Snowflake SnowPro Core.

Experience

Professional experience0 - 5 years
Freelancer since2024

Languages

GermanGoodEnglishFluent

Project history

BI Consultant - Azure Cloud Migration Datamart

Česká spořitelna a.s.
Managing the entire data lifecycle including extracting, transforming, and integrating data. Building and maintaining a cloud-based data mart in Snowflake. Designing and implementing advanced ETL pipelines in Keboola using SCD2 patterns. Developing Python scripts for automation. Utilizing Tableau for tracking and reporting on migration progress.

BI Consultant

Billigence PTY LTD
Working as a BI Consultant with focus on data integration, cloud-based data solutions, ETL pipeline development, Python automation, and data analysis and reporting across multiple client projects.

BI Consultant - Interactive Reporting Lakehouse

Project CME
Implemented a reporting platform in Azure Synapse and led migration to Microsoft Fabric. Utilized the Medallion architecture with PySpark notebooks. Responsible for data transformation and orchestration using PySpark and SQL. Integrated data from various source systems using Azure Data Factory with Power BI report outputs.

BI Consultant - Energy Monitoring Dashboard

Project Tanix
Created Tableau dashboards based on IoT device data for measuring energy consumption at store branches. Analyzed client requirements and designed customized solutions. Prepared data using Alteryx and designed a data warehouse for reporting. Trained users and set up the Tableau Cloud environment.

BI Consultant - Report Migration from Tableau to PBI

OAKS Consulting
Migrated reports from Tableau to Power BI as part of a Proof of Concept. Trained users and shared best practices. Designed and implemented solutions for sharing reports with external clients. Configured access security using RLS and OLS.

BI Consultant - Data Quality Report

Projekt Mondelez
Analyzed business requirements and created a report for monitoring data quality in the SAP system. Applied business rules for individual attributes in DAX. Created a report displaying violations of business rules and problematic areas.

Functional Expert

IKEA Purchasing Services spol. s.r.o.
Member of the scrum team for SAP ERP implementation in order management and finance. Process mapping using BPMN tool Signavio, defining requirements and acceptance criteria in JIRA. Designing future processes and ways of working from a business perspective.

Supply Planner

IKEA Purchasing Services spol. s.r.o.
Follow-up and analysis of goods flow through BI reports (QS, PowerBI, Tableau). Training and supporting suppliers in order management. Benchmarking with other suppliers and proposing optimization of production processes. Managing projects for product introduction and discontinuation. Implementing savings of 1.7M EUR.

Planning Analyst

Nutricia a.s.
Part-time job during studies. Communication with factories within supply planning. Maintaining optimal inventory levels and ensuring FIFO compliance. Creating forecasts within the demand planning process. Project management within activity management for new products and packaging changes.

Internship in Automotive Industry

TPCA - Toyota Peugeot Citroën Automobile Czech s.r.o.
Internship in the internal logistics department. Supported the project team in processing documentation. Created an Excel file to visualize the internal flow of materials and capture individual operations from material receipt to consumption on the production line.

Contact form

Log in to get in touch

You need to be logged in to use the contact form.

Sign upLog in