Senior Data Engineer & Database Architect

Piotr Przybyłek

Gdańsk, **-***, Poland +48-507-***-*** *****.*********@*****.*** LinkedIn

PROFESSIONAL SUMMARY

Database Architect / Senior Data Engineer with 15+ years of hands-on experience across enterprise database platforms — Microsoft SQL Server and T-SQL (primary), Oracle (RDBMS, PL/SQL, OLAP), PostgreSQL, Azure SQL, MySQL, and MongoDB — including prior lead-designer ownership of an enterprise database architecture built from scratch (a multi-country Management Information System Data Mart at Nordea Bank). Defines database design standards, patterns, and reference designs; reviews and approves others' database and solution designs; writes Architecture Decision Records and decision documents; and evaluates and recommends technologies. Architecture-level work on performance, scalability, and security/access-control design (indexing, partitioning, capacity planning, encryption, query optimization). Has taken part in modernizing legacy platforms and moving BI/data-warehouse workloads to cloud (Azure Databricks, ADLS, Azure SQL), and designs on Azure with exposure to AWS. Automates with Python, PowerShell, and Bash, with Azure DevOps CI/CD and Bicep Infrastructure as Code. Some exposure to HA/DR (Always On Availability Groups, failover clustering, backup/recovery). Collaborates with database, infrastructure, security, application, and data engineering teams, and mentors junior and mid-level developers. Fluent English. MSc in Information Technology (Software Engineering & Databases), Gdańsk University of Technology.

PROFESSIONAL EXPERIENCE

PowerBI / Tabular Model Architect — Alfalaval January 2025 – July 2026

•Developed and optimized ETL pipelines in Azure Databricks (PySpark, Delta Lake, Unity Catalog), performing data analysis and transformation, reading/writing to Azure Data Lake Storage and Delta tables (Microsoft Fabric OneLake).

•Designed dimensional data models (star schema, conformed dimensions), including data transformation, mapping, and validation logic feeding downstream reporting and analytics.

•Maintained data quality through automated validation and monitoring, with alerting and root-cause analysis for pipeline/dataset issues.

•Applied Git/Azure DevOps CI/CD with code review and DEV/TEST/PROD environment separation; used Bicep for Infrastructure as Code.

Data Warehouse / ETL / OLAP / BI Developer & Administrator — Lyreco (successor of Staples) October 2022 – February 2024

•Designed dimensional (Kimball-style) data models in SSAS; developed and maintained ETL packages in SSIS, and complex stored procedures, functions, and views in T-SQL, integrating varied source systems, including SQL Server, Oracle, and SharePoint.

•Managed job scheduling and monitoring via SQL Server Agent; administered the Power BI/Microsoft Fabric ecosystem and applied CI/CD deployment pipelines (Azure DevOps, Git) with environment separation and controlled releases.

Data Warehouse / ETL / OLAP / BI Developer & Administrator — Volvo August 2021 – September 2022

•Worked extensively with Data Vault modeling alongside Kimball-style dimensional (Tabular/Multidimensional) data models in SSAS; developed ETL packages in SSIS and complex T-SQL in SQL Server.

Data Warehouse / ETL / OLAP / BI Developer & Administrator — Staples October 2016 – March 2021

•Performed architecture-level SQL Server performance, scalability, and security work — indexing/partitioning strategy, capacity planning, encryption and access-control design, and query optimization; implemented data validation and quality checks within ETL processes, with alerting and root-cause analysis.

•Traced data lineage across ETL processes, including reverse-engineering legacy pipelines, and authored technical documentation covering data flow and definitions.

•Built and integrated ETL processes across multiple legacy and enterprise source systems using Oracle PL/SQL and Informatica; orchestrated ETL workflows using Apache Airflow; developed Python automation tooling.

PhD Finalization (Independent Research) February 2024 – September 2024

•Extensive use of Python (Pandas, NumPy, PyTorch, scikit-learn) for data analysis and machine-learning data preparation, working with both structured and unstructured data (e.g. an insurance-documents project); hands-on with MongoDB (document modelling and querying), PostgreSQL, Redis, and Docker containers.

Data Warehouse / ETL Developer — Acxiom October 2014 – August 2016

•Designed and maintained dimensional Data Mart / Data Warehouse schemas; built ETL processes in SQL and PL/SQL; developed Python-based AWS Lambda functions for application data processing, using DynamoDB, S3, and SQS.

Data Warehouse / Business Intelligence Developer — Infoprojekt June 2013 – September 2014

•Designed dimensional (star-schema) Data Mart / Data Warehouse schemas; built ETL processes in SSIS and Transact-SQL; built OLAP structures in SSAS (Tabular Model).

Data Warehouse Developer — Nordea Bank January 2010 – June 2013

•Lead designer and implementer of an enterprise database architecture for a Group Management Information System spanning four countries, built on Oracle OLAP (AWM), Oracle RDBMS, and OBIEE, created from scratch in an environment where architecture and processes were still developing.

•Made technical design decisions and defined scalable data ingestion and database design patterns for future source systems; authored metadata-driven database design standards and architectural documentation.

Founder — Own Company July 2008 – May 2009

•Co-founded and ran a web development company (PHP + MySQL, CodeIgniter/Kohana frameworks).

BI Intern — Comarch SA July 2007 – August 2007

•Practice focused on Business Intelligence techniques using the Microsoft BI stack (SSIS, SSAS, DTS).

EDUCATION

Gdańsk University of Technology — MSc, Information Technology: Software Engineering and Databases October 2004 – September 2009

Thesis: Comparing OLAP engines — Oracle OLAP option and SQL Server 2005 Analysis Services (a Business Intelligence solution for the faculty implemented in SSAS/SSIS 2005 and Oracle OLAP).

Gdańsk University of Technology — MSc, Management and Economics: Small Business Economics and Management February 2007 – January 2010

SKILLS

Database Architecture & Governance: Database design standards, patterns, and reference designs; design reviews and approvals; Architecture Decision Records; technology evaluation and platform recommendations; 0-to-1 enterprise database architecture (Nordea Data Mart); architectural documentation.

Database Platforms: Microsoft SQL Server and T-SQL (strong; advanced stored procedures, functions, views), Oracle (RDBMS, PL/SQL, OLAP), PostgreSQL and Azure SQL (intermediate to advanced), MySQL (many projects), MongoDB (hands-on), Redis, AWS DynamoDB.

Performance, Scalability & Security: Architecture-level indexing/partitioning strategy, capacity planning, query optimization, and encryption/access-control design; Azure Key Vault, RBAC/IAM, NSGs/firewalls/VNets, Entra ID.

High Availability & Disaster Recovery: Some exposure to Always On Availability Groups, failover clustering, and backup/recovery — not as primary owner/designer.

Cloud & Modernization: Azure (Databricks with Delta Lake and Unity Catalog, Data Lake Storage Gen2, Azure SQL, Azure Monitor/Log Analytics); AWS (Lambda, DynamoDB, S3, SQS); legacy-to-cloud BI/data warehouse modernization.

Automation, DevOps & IaC: Python, PowerShell, and Bash scripting; Azure DevOps (Repos/Pipelines) and Git CI/CD with DEV/TEST/PROD separation; Bicep for Infrastructure as Code; SQL Server Agent; Apache Airflow; Linux; database automation.

Data Modelling & ETL: Dimensional modelling (Kimball star schema, SCD2) and extensive Data Vault modelling; ETL in SSIS, Oracle PL/SQL, Informatica, and Databricks.

OTHER SKILLS

Strong communicator and stakeholder partner: leads technical discussions, makes architecture decisions, and explains them to engineers and senior business stakeholders; mentors junior and mid-level developers; works with international/UK-based teams.

LANGUAGES

Polish — native.

English — fluent (studies conducted in English; used daily in current role).

German — high-school exam level (currently needs refreshing).

INTERESTS

Financial markets and Forex; statistics, data mining, and neural networks; sailing (yacht navigator).

Contact this candidate