Juraj is available for hire
Hire JurajJuraj Jarabek
Verified Expert in Engineering
Data Engineer and Developer
Dublin, Ireland
Toptal member since October 14, 2024
Bio
Juraj is a senior data engineer with eight years of experience in analytics engineering, advanced analytics, and business intelligence, as well as a background in software engineering. He has a deep knowledge of warehousing concepts and cloud architectures, including Data Build Tool (dbt), Snowflake, Google Cloud Platform (GCP), SQL, and Python. Juraj is also familiar with infrastructure as code (IaC), Terraform, workflow management and orchestration, and Java.
Portfolio
The University of Melbourne
Data Build Tool (dbt), Snowflake, dbt Cloud, GitHub, SQL, Python, Workday...
Wesfarmers
BigQuery, Data Build Tool (dbt), Snowflake, ETL, ELT, Teradata, SAP, SAP HANA...
Emark
SQL, Python, BigQuery, Google Cloud Platform (GCP), Snowflake, Teradata, Oracle...
Experience
- SQL - 10 years
- Python - 10 years
- ETL - 10 years
- Data Warehousing - 8 years
- Data Modeling - 8 years
- Snowflake - 6 years
- Google Cloud Platform (GCP) - 4 years
- Data Build Tool (dbt) - 4 years
Work Experience
Senior Data Engineer
2024 - 2024
The University of Melbourne
- Spearheaded the integration of Workday data into a new data warehouse via SOAP APIs.
- Helped with the data migration of legacy on-prem systems to Snowflake, ensuring transition and integration with cloud-native services.
- Built advanced models, tests, and frameworks in Data Build Tool (dbt), following software engineering principles and branching strategies.
Technologies: Data Build Tool (dbt), Snowflake, dbt Cloud, GitHub, SQL, Python, Workday, Workday API, Integration, Amazon S3 (AWS S3), SOAP APIs, Visual Studio Code (VS Code), ETL, Data Warehousing, Data Migration, Agile Software Development
Data Engineer
2023 - 2024
Wesfarmers
- Engineered the data migration of legacy on-prem systems in Teradata to Google Cloud Platform (GCP) and Snowflake, ensuring a smooth transition and integration with cloud-native services.
- Built advanced transformation models, macros, and tests following software engineering workflows.
- Developed and maintained complex BI and advanced Data Build Tool (dbt) analytics in Looker for the data and digital team, significantly increasing data observability.
Technologies: BigQuery, Data Build Tool (dbt), Snowflake, ETL, ELT, Teradata, SAP, SAP HANA, Python, SQL, Google Cloud Platform (GCP), Bitbucket, Google Cloud Composer, Google Cloud Storage, Visual Studio Code (VS Code), Data Warehousing, GitHub, Looker, Data Migration, Data Visualization
Senior BI Specialist
2021 - 2023
Emark
- Achieved 100% year-over-year growth for the company.
- Received the Qlik Sense Business Analyst and Qlik Sense System Administrator certifications.
- Built advanced ETL and ELT pipelines and scalable data warehouses on-prem and cloud, leveraging BigQuery, Snowflake, PostgreSQL, Microsoft SQL Server, Oracle, and MySQL.
Technologies: SQL, Python, BigQuery, Google Cloud Platform (GCP), Snowflake, Teradata, Oracle, MySQL, PostgreSQL, REST, REST APIs, ETL, ELT, Data Modeling, Data Warehousing, Data Transformation, Consulting, Microsoft SQL Server, Visual Studio Code (VS Code), Data Build Tool (dbt), GitHub, Looker, Qlik Sense, Google Cloud Storage, Data Migration, Data Visualization
BI Specialist
2019 - 2021
Emark
- Built ETL and ELT data pipelines for diverse customers in various industries.
- Administered and managed enterprise-scale Qlik environments, both as SaaS and on-prem solutions.
- Implemented advanced Qlik Sense BI solutions and related products for customers from various industries.
Technologies: ETL, ELT, SQL, Python, BigQuery, Snowflake, Qlik Sense, Visual Studio Code (VS Code), Data Build Tool (dbt), Google Cloud Platform (GCP), Data Warehousing, GitHub, Data Migration, Data Visualization
Technical Consultant
2017 - 2018
SAP
- Proposed features for the "Signavio Process Intelligence" solution, a process mining market leader.
- Delivered consulting projects in the field of process mining.
- Analyzed procure-to-pay (P2P) and order-to-cash (O2C) issues-to-resolution and other business processes, detecting inefficiencies that led to process improvements.
Technologies: Process Mining, Signavio BPM, Business Process Management (BPM), SQL, Python, ETL, Visual Studio Code (VS Code), Google Cloud Platform (GCP), Data Warehousing, GitHub, Qlik Sense, Data Visualization
Data Scientist
2016 - 2017
Microsoft
- Built software for automated analysis of business processes.
- Introduced new features as part of the R&D department.
- Helped customers find bottlenecks in their business processes.
Technologies: Process Mining, Consulting, Business Process Modeling, Business Process Management (BPM), Databases, SQL, Python, Visual Studio Code (VS Code), ETL, Data Warehousing, GitHub, Qlik Sense, Data Visualization
Project History
Workday Integration into Snowflake
This project involved integrating Workday into Snowflake using Workday's SOAP API for seamless HR, finance, and operations data ingestion. I leveraged dbt Cloud to transform and model the data, ensuring efficient ETL processes and real-time availability for analytics. This integration enhanced reporting capabilities, improved decision-making, and provided deeper operational insights.
Core Metadata Dashboard in Looker
I developed a comprehensive dashboard that analyzes dbt core metadata, delivering valuable insights into the performance and health of data pipelines. The dashboard visualizes key metrics such as model builds, test results, and execution times, empowering teams to optimize workflows, reduce errors, and enhance data reliability. The solution helps drive massive business value through improved decision-making and operational efficiency.
Data Migration from Legacy On-prem to BigQuery
This successful data migration project involved moving critical data sets from a legacy on-premise Teradata system to BigQuery on GCP. I streamlined the migration process by optimizing data structures, ensuring data integrity, and minimizing downtime, which improved scalability, cost efficiency, and access to advanced cloud-native analytics capabilities.
Data Migration from BigQuery to Snowflake
I led a data migration from BigQuery to Snowflake, leveraging dbt for data transformation, Google Cloud Storage for efficient data transfer, and Python and SQL to automate migration tasks. I also leveraged Snowflake pipes to streamline data loading and ensure minimal downtime, improving performance, scalability, and cost efficiency in the new environment.
Education
2014 - 2016
Master's Degree in Software Engineering
University of Tartu - Tartu, Estonia
2014 - 2016
Master's Degree in Software Engineering
Tallinn University of Technology - Tallinn, Estonia
2015 - 2015
Study Exchange Program in Software Engineering
University of North Carolina Greensboro - Greensboro, USA
2013 - 2013
Bachelor's Degree (Erasmus) in Information Technology
Tallinn University - Tallinn, Estonia
2010 - 2013
Bachelor's Degree in Information Technology
Brno University of Technology - Brno, Czech Republic
Certifications
SEPTEMBER 2021 - PRESENT
Qlik Sense System Administrator Certification
Qlik
JANUARY 2020 - PRESENT
Qlik Sense Business Analyst Certification
Qlik
Skills
Libraries/APIs
REST APIs, Workday API, SOAP APIs
Tools
dbt Cloud, BigQuery, Qlik Sense, GitHub, Looker, Signavio BPM, Bitbucket, Google Cloud Composer
Languages
SQL, Python, Snowflake
Paradigms
ETL, REST, Agile Software Development
Platforms
Visual Studio Code (VS Code), Google Cloud Platform (GCP), Oracle, SAP HANA
Storage
Databases, MySQL, PostgreSQL, Teradata, Microsoft SQL Server, Google Cloud Storage, Amazon S3 (AWS S3)
Frameworks
Hadoop
Other
Data Build Tool (dbt), Data Engineering, Data Warehousing, Data Migration, Data Visualization, Programming, Process Mining, Consulting, ELT, Data Modeling, Software Engineering, Android Development, Big Data, Machine Learning, Business Process Modeling, Business Process Management (BPM), Data Transformation, SAP, Workday, Integration
Collaboration That Works
How to Work with Toptal
Toptal matches you directly with global industry experts from our network in hours—not weeks or months.
1
Share your needs
Discuss your requirements and refine your scope in a call with a Toptal domain expert.
2
Choose your talent
Get a short list of expertly matched talent within 24 hours to review, interview, and choose from.
3
Start your risk-free talent trial
Work with your chosen talent on a trial basis for up to two weeks. Pay only if you decide to hire them.
Top talent is in high demand.
Start hiring