Juraj Jarabek, Developer in Dublin, Ireland
Juraj is available for hire
Hire Juraj

Juraj Jarabek

Verified Expert  in Engineering

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

Availability

Part-time

Preferred Environment

Data Build Tool (dbt), dbt Cloud, SQL, Python, Snowflake, BigQuery, Google Cloud Platform (GCP), GitHub

The most amazing...

...project I've successfully spearheaded is the integration of Workday into Snowflake for the University of Melbourne, which is ranked number 20 globally.

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

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

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

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 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

Experience

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, 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