Jakub Kiełbasiewicz, Data Warehousing Developer in Wrocław, Poland
Jakub Kiełbasiewicz

Data Warehousing Developer in Wrocław, Poland

Member since April 11, 2019
Jakub is a skilled business intelligence developer and consultant with more than a decade of experience looking forward to his next challenge. He loves working with databases - starting with modeling and design all the way through visualizations to query performance tuning.
Jakub is now available for hire

Portfolio

  • Aberdeen
    SQL Server, SSIS, C#, Python, AWS
  • Ryanair
    SQL, SSIS, C#, SSAS, MDX, DAX
  • Ryanair
    VBA, SQL, Python, R, Java, MDX, Tableau, PowerBI

Experience

Location

Wrocław, Poland

Availability

Part-time

Preferred Environment

SSMS, SQL Developer, Visual Studio, GITHub

The most amazing...

...project I've contributed to was managing a digital goods' warehouse.

Employment

  • Senior Data Engineer / Database Lead

    2019 - PRESENT
    Aberdeen
    • Maintained data quality.
    • Designed master data.
    • Designed and implemented ETL processes.
    • Provided query performance tuning.
    • Automated QA testing in Python.
    • Maintained the Elasticsearch cluster.
    • Led the migration to AWS RDS.
    • Integrated heterogeneous data sources.
    Technologies: SQL Server, SSIS, C#, Python, AWS
  • Business Intelligence Developer

    2019 - 2019
    Ryanair
    • Created ETL processes using SSIS/TSQL/C#.
    • Designed ETL data flows.
    • Accessed the data from various systems.
    • Modeled databases.
    • Performed data quality checks.
    Technologies: SQL, SSIS, C#, SSAS, MDX, DAX
  • ETL & Automation Analyst

    2018 - 2018
    Ryanair
    • Supported teams with accessing the data.
    • Provided complex SQL/MDX queries.
    • Resolved Tableau issues.
    • Automated internal processes to get the data.
    • Set up query performance tuning.
    Technologies: VBA, SQL, Python, R, Java, MDX, Tableau, PowerBI
  • Business Intelligence Consultant

    2017 - 2018
    Tech Data
    • Resolved ETL issues.
    • Created new ETL data flows.
    • Developed advanced TSQL solutions.
    • Automated tasks using Powershell/TSQL/SSIS.
    • Designed and maintained reporting environment.
    • Prepared reports and dashboards for high-level management.
    Technologies: SQL, TSQL, SSAS, SSIS, VBA, Python, Powershell, R, C#

Experience

  • Migration from Access to SQL Server (Development)

    I've helped a company to migrate their data from Access into SQL Server, During the task, I've managed to recreate various reports and procedures used by the company in Access.

  • Web App for Property Management - Rent/Sell/Buy (Development)

    I've taken part in an academic project to create a web-based application for property management, which allowed people to add offers, contact owners, etc.

    I was responsible for infrastructure (Azure stack) and the database.

  • Digital Goods Warehouse and Bookkeeping Web App (Development)

    I'm taking part in a big part-academic project which has entered academic projects competition. The application will be responsible for managing digital goods (like videos, pictures, etc.) and will allow people to keep their goods in one place and track all bookkeeping related to these goods.

    I'm responsible for infrastructure (Azure stack) and database - that's a huge challenge because every user has to have separate data storage solution and separate database, which has to be created dynamically when a user is creating a new account.

  • Tutoring (Development)

    I help people every day with their data-related troubles. It doesn't matter if it is for some academic project, master/bachelor thesis or solution for a company, every project is different and requires a different approach.

Skills

  • Languages

    SQL, MDX, T-SQL, Python, C#, Visual Basic for Applications (VBA), Visual Basic .NET (VB.NET)
  • Paradigms

    Database Design, ETL, Azure DevOps
  • Storage

    Databases, SQL Server Integration Services (SSIS), Database Modeling, PL/SQL, MySQL, SQL Server Analysis Services (SSAS), Google Cloud
  • Other

    Data Warehousing, Query Optimization, MicroStrategy, Data Engineering, Tableau Server, SOAP, AWS
  • Platforms

    Azure, Pentaho, Talend, Google Cloud Platform (GCP)
  • Frameworks

    Hadoop, Spark
  • Libraries/APIs

    PySpark
  • Tools

    Tableau, Microsoft Power BI, Git, Impala, Jenkins, TFS

Education

  • Bachelor's degree in Computer Science
    2016 - 2020
    Wroclaw University of Science and Technology - Wroclaw, Poland
  • Bachelor's degree in Economics
    2014 - 2017
    University of Wroclaw - Wroclaw, Poland
Certifications
  • Associate Cloud Engineer
    DECEMBER 2019 - DECEMBER 2021
    Google
  • Azure Administrator Associate
    FEBRUARY 2019 - PRESENT
    Microsoft
  • MCSA: SQL 2016 BI Development
    AUGUST 2018 - PRESENT
    Microsoft
  • MCSE: Data Management and Analytics
    JULY 2018 - PRESENT
    Microsoft
  • MCSA: SQL 2016 Database Development
    JUNE 2018 - PRESENT
    Microsoft
  • MCSA: SQL 2016 Database Administration
    SEPTEMBER 2017 - PRESENT
    Microsoft

To view more profiles

Join Toptal
I really like this profile
Share it with others