Marek Rozenbajger, Developer in Gdańsk, Poland

Marek Rozenbajger

ETL Development Developer

Location
Gdańsk, Poland
Toptal Member Since
June 18, 2020

Marek has spent his professional life with databases. He boarded the big data ship three years ago. Marek now focuses on modeling and designing data lakehouses on Microsoft Cloud platforms: Azure Databricks, ADLS, and ADF. Throughout his 16-year career, he has worked as a data architect, senior consultant, and programmer. He has worked for UBS, Nordea, BP, Honda, and Motorola, among others. Marek has over a decade of experience working in distributed teams.

Marek is available for hire
Hire Marek

Portfolio

Fincent Inc
Relational Databases, Data Warehouse Design, PostgreSQL, Database Modeling...
UBS
Microsoft SQL Server, Python 3, PySpark, Azure Databricks, Azure...
Honda
SQLite, .NET, SQL, Windows Forms (WinForms), C#, Microsoft Visual Studio...

Experience

SQL - 17 yearsDatabase Modeling - 17 yearsT-SQL (Transact-SQL) - 16 yearsData Modeling - 13 yearsData Warehousing - 13 yearsETL Development - 13 yearsData Warehouse Design - 9 yearsData Lake Design - 3 years

Location

Gdańsk, Poland

Availability

Full-time

Preferred Environment

Git, Visual Studio, Windows Server, Microsoft SQL Server

The most amazing...

...thing I've designed was a data lakehouse with 30 bitemporal, slow-changing dimensions and late-arriving facts of different granularity with M2M relationships.

Work Experience

2021 - 2022

Data Engineer

Fincent Inc
  • Designed a complete data platform, including the dimensional model, data lake, orchestration, and ELT pipelines. Used Postgres, Apache Airflow, S3, and Python for the tech stack.
  • Provided architectural documentation of the solution with guidelines for usage and future extensions.
  • Performed the MVP implementation of the data platform. Used MWAA for orchestrating ELT, RDS for metadata database, and S3 for storage.
Technologies: Relational Databases, Data Warehouse Design, PostgreSQL, Database Modeling, Sparx Enterprise Architecture, Python 3, Data Lake Design, Data Warehousing, Amazon Web Services (AWS), Pandas, ETL, Apache Airflow, UML, Git, JSON, Data Modeling, Python, REST APIs, ETL Development, ELT, Data Pipelines, Data Lakes, ETL Tools, Big Data Architecture, Database Architecture, Data Architecture, RDBMS, Databases, SQL, Database Design, Amazon RDS, System Administration, Consulting, Data Management, Normalization, SQL Stored Procedures, Database Structure, Database Transactions, Transactional Data
2016 - 2022

Senior BI Consultant | Data Architect

UBS
  • Designed serverless architecture for Azure data lakehouse with Power BI, Azure Databricks, Azure Functions, ADLS Gen2, and Azure Data Factory. Used Spark SQL, Python, and PowerShell programming.
  • Provided data modeling and profiling activities for projects and created visual models of data flows and interactions with UML, DFD, and ERD.
  • Designed and implemented state machine-based orchestration for the data lake.
  • Supported and extended Microsoft SQL Server data warehouses.
  • Created end-to-end CI/CD automation for Microsoft SQL server data warehouse.
Technologies: Microsoft SQL Server, Python 3, PySpark, Azure Databricks, Azure, Microsoft Power BI, SQL Server BI, UML, Spark, Spark SQL, Windows PowerShell, Azure Data Factory, Azure Functions, Data Warehousing, Data Warehouse Design, Data Lake Design, Database Modeling, Bitemporality, ELT, ETL, Relational Databases, T-SQL (Transact-SQL), Windows Server 2012, Continuous Integration (CI), Databricks, JSON, Data Modeling, Python, REST APIs, OData, ETL Development, Pandas, Data Pipelines, Azure Data Lake, Data Lakes, Big Data, ETL Tools, Big Data Architecture, BI Reporting, Business Intelligence (BI), Database Architecture, Data Architecture, SQL Server DBA, RDBMS, Databases, Oracle, SQL, Database Design, SQL Server 2016, Reports, Consulting, Data Management, Data Visualization, Data Wrangling, Normalization, SQL Stored Procedures, Database Optimization, Database Structure, Database Transactions, Transactional Data
2020 - 2021

Database Consultant

Honda
  • Reverse engineered a legacy Microsoft Access-based ERP system; no source code was available.
  • Designed a new solution that improved on the original. The application consisted of Windows Forms UI, relational database, and reports' components.
  • Went through complete SDLC cycle: implemented the design, tested, and released it. The client was pleased and requested several new features to be added as a separate project.
Technologies: SQLite, .NET, SQL, Windows Forms (WinForms), C#, Microsoft Visual Studio, Visual Basic for Applications (VBA), Git, .NET 4, Microsoft Excel, Database Modeling, Object-oriented Design (OOD), Object-relational Mapping (ORM), SQLite.NET, JSON, Data Engineering, Relational Databases, Microsoft Access, Data Analysis, Data Reporting, Database Architecture, RDBMS, Databases, Database Design, Reports, Consulting, Excel VBA, Normalization, Database Structure, Transactional Data
2018 - 2018

Database Consultant

The Dominion Group
  • Created a custom add-in for Excel 2010 and above. The add-in provides a set of functions that pull data from remote PostgreSQL instances over the Internet.
  • Tested the product with different Microsoft Office versions: 2010, 2016, 2019, 365.
  • Prepared documentation: PDF and user training videos.
  • Answered users' queries and provided support for the application.
Technologies: PostgreSQL, Excel-DNA, Microsoft Excel, Relational Databases, SQL, C#, Microsoft Visual Studio, .NET, Git, .NET 4, SQLite, Database Modeling, Object-oriented Design (OOD), Object-relational Mapping (ORM), ODBC, SQLite.NET, JSON, Data Engineering, Data Analysis, Data Reporting, Database Architecture, RDBMS, Databases, Database Design, Reports, Consulting, Excel VBA, Visual Basic for Applications (VBA), Normalization, Database Structure
2017 - 2018

Software Developer

Motorola Solutions
  • Worked with the key stakeholder on clarifying and documenting the requirements.
  • Designed the solution for a sophisticated near-real-time directory change monitoring service.
  • Prepared the documentation and provided support for service rollout.
Technologies: C#, SQLite, Azure Active Directory, Relational Databases, SQL, Microsoft Visual Studio, Windows Server, .NET, Git, .NET 4, Microsoft Excel, Database Modeling, Object-oriented Design (OOD), Windows Server 2012, SQLite.NET, JSON, Data Engineering, Data Analysis, Data Reporting, Database Architecture, RDBMS, Databases, Database Design, Reports, Database Structure
2016 - 2016

Database Consultant

Nordea Group
  • Carried out an audit of a bespoke database system.
  • Implemented a feasibility study of new requirements and risk analysis.
  • Provided a review of the system to the management of the project.
Technologies: Relational Databases, SQL, Microsoft Visual Studio, Microsoft Excel, Database Modeling, Data Engineering, Database Architecture, RDBMS, Databases, Database Design, Consulting, Normalization, Database Structure, Transactional Data
2012 - 2016

Data Architect | Solution Architect

BP p.l.c.
  • Designed and had a key role in the implementation of a data warehouse. Its purpose was to improve financial efficiency by providing reports and data for analysis.
  • Created and implemented the system architecture, database back-end, and ETL and WCF API design.
  • Developed the modeling process which concentrated on UML (use case, class, sequence diagrams) as well as data flow, and entity-relationship diagrams.
  • Built a database component that involved advanced programming features of Microsoft SQL Server such as CLR integration, distributed transactions, and XML processing.
  • Designed and managed the implementation of a self-service intranet site for managing IT services (such as mailboxes, user accounts, distribution lists, and VPN tokens) for 80,000 employees. The purpose of the site was to support the ITIL processes.
  • Designed and implemented the system architecture, database design, integration with external systems (LDAP, SOAP web services, REST web services, ODBC), WCF API of the back-end component, and long-running workflows.
  • Built a system using Windows Server 2008 R2 Standard, WCF SOAP web services, and an active directory with Kerberos authentication, IIS AppFabric 1.1, and C#.NET 4.0.
  • Prepared implementation documentation for the client.
  • Liaised with the client's technical authorities and infrastructure managers.
Technologies: C#.NET, Windows Server, Microsoft SQL Server, Relational Databases, SQL, SQL Server 2008, Azure Active Directory, UML, C#, SQL CLR, SQL Server 2012, Data Warehouse Design, SOAP, Microsoft Visual Studio, Windows Server 2008, .NET, Windows PowerShell, SQL Server Integration Services (SSIS), Test-driven Development (TDD), Git, .NET 4, Database Modeling, SQL Server Reporting Services (SSRS), SQL Server Data Tools (SSDT), LDAP, Kerberos, SSAS, Object-oriented Design (OOD), Object-relational Mapping (ORM), Sparx Enterprise Architecture, IIS, Subversion (SVN), Kimball Methodology, Continuous Integration (CI), OLAP, TeamCity, ODBC, MDX, JSON, Data Engineering, Windows Forms (WinForms), T-SQL (Transact-SQL), Data Warehousing, Data Modeling, REST APIs, ETL Development, ETL, SQL Server BI, Data Pipelines, ETL Tools, BI Reporting, Business Intelligence (BI), Database Architecture, Data Architecture, RDBMS, Databases, Database Design, Data Visualization, Data Wrangling, Normalization, SQL Stored Procedures, Database Structure, Database Transactions, Transactional Data
2008 - 2012

Database Administratior | SQL Developer

BP p.l.c.
  • Migrated a reporting platform from the Microsoft SQL Server 2000 to the 2005 version and later to 2008 R2.
  • Designed and implemented new data feeds into the reporting system.
  • Designed new reports for mid-level managers and enriched the existing ones with additional data.
  • Maintained and adapted the system to new requirements and a changing environment.
Technologies: VB, C#, Microsoft SQL Server, Relational Databases, SQL, SQL Server 2008, SQL CLR, Microsoft Visual Studio, Windows PowerShell, SQL Server Integration Services (SSIS), PostgreSQL, Database Modeling, SQL Server Reporting Services (SSRS), LDAP, SSAS, Object-oriented Design (OOD), Database Administration (DBA), Subversion (SVN), ODBC, MDX, T-SQL (Transact-SQL), Data Analysis, Data Reporting, Business Intelligence (BI), Database Architecture, SQL Server DBA, RDBMS, Databases, Oracle, Database Design, System Administration, Reports, Visual Basic, Normalization, SQL Stored Procedures, Database Optimization, Database Structure, Database Transactions
2006 - 2008

Microsoft Access Database Developer

Ideal Shopping Direct
  • Developed applications for stock control, EDI, work time and performance monitoring with Microsoft Access (VBA) and Microsoft SQL Server (backend).
  • Created reports from the collected data with Microsoft Access and Excel (automatic generation of spreadsheets from VBA code).
  • Improved several manual processes with the help of self-developed applications.
Technologies: SQL Server 2000, Microsoft Excel, Microsoft Access, Visual Basic for Applications (VBA), Relational Databases, SQL, Visual Basic .NET (VB.NET), Database Modeling, Database Architecture, RDBMS, Databases, Database Design, Reports, Data Visualization, Visual Basic, Excel VBA, Normalization, Database Structure

Experience

Sample Data Warehouse Snowflake Schema ERD

Part of a larger model, implemented tables for storing information on computers. The model leverages slowly changing dimensions of types 2 and 1. This is an example of a fully normalized schema from before MPP days.

Sample 3NF Entity Relationship Diagram

A relational third normal form model of a schema designed to store computer hardware information. A strictly normalized model implemented on the MS SQL platform a while ago. The system lasted a good couple of years and is rumored to still function.

Sample Data Dictionary

A data dictionary containing a description of a computer and user database. This stub was generated from Visual Paradigm software, which I used back in the day. Currently, I prefer Sparx EA, but this shows a pretty neat data dictionary.

Skills

Languages

T-SQL (Transact-SQL), SQL, UML, C#, Python 3, MDX, Visual Basic for Applications (VBA), Visual Basic .NET (VB.NET), Python, Visual Basic, Excel VBA

Tools

Microsoft Access, Microsoft Excel, SSAS, Spark SQL, Apache Airflow, Microsoft Visual Studio, GitHub, Git, Microsoft Power BI, SQL Server BI

Paradigms

Database Design, Object-oriented Design (OOD), Object-relational Mapping (ORM), ETL, Business Intelligence (BI), Kimball Methodology, Continuous Integration (CI), OLAP

Storage

Microsoft SQL Server, Database Modeling, Relational Databases, SQL Server Data Tools (SSDT), SQL Server 2008, SQL Server Reporting Services (SSRS), Data Pipelines, Database Architecture, RDBMS, Databases, SQL Server 2016, SQL Stored Procedures, Database Structure, Database Transactions, SQLite, PostgreSQL, Database Administration (DBA), Azure Active Directory, SQL Server 2012, SQL CLR, JSON, Data Lake Design, SQL Server Integration Services (SSIS), Data Lakes, SQL Server DBA

Other

Data Engineering, Data Warehousing, Data Modeling, ETL Development, ETL Tools, Data Reporting, Data Architecture, Data Wrangling, Normalization, Transactional Data, Kerberos, LDAP, OData, Azure Data Factory, Data Analysis, BI Reporting, Reports, Data Warehouse Design, Sparx Enterprise Architecture, SOAP, Big Data Architecture, Azure Databricks, Bitemporality, ELT, Azure Data Lake, Big Data, Amazon RDS, System Administration, Consulting, Data Management, Data Visualization, Database Optimization

Frameworks

Windows PowerShell, .NET, Spark

Libraries/APIs

ODBC, SQLite.NET, PySpark, Windows Forms (WinForms), REST APIs, Pandas

Platforms

Windows Server, Windows Server 2008, Windows Server 2012, Databricks, Azure, Azure Functions, Amazon Web Services (AWS), Oracle

Education

2008 - 2012

Bachelor's Degree in Computer Science

The School of Banking and Management in Kraków - Kraków, Poland

Certifications

JANUARY 2010 - PRESENT

MCP: Windows Server

Microsoft

JANUARY 2010 - PRESENT

MCTS: SQL Server 2008

Microsoft

JANUARY 2009 - PRESENT

ITIL Foundation

Asseco Data Systems