Profileimage by Jaroslaw Syrokosz Data Architect, Data Management Consultant, Data Analyst, Data Warehouse Consultant from

Jaroslaw Syrokosz

available

Last update: 03.10.2023

Data Architect, Data Management Consultant, Data Analyst, Data Warehouse Consultant

Graduation: not provided
Hourly-/Daily rates: show
Languages: English (Limited professional) | Polish (Limited professional) | Spanish (Limited professional)

Attachments

Syrokosz-CV_031023.docx

Skills

I have been working for more than 15 years in international data engineering, warehousing and analytics projects (both on-prem and cloud-Azure or AWS). Over this time I have hold various roles like data and analytics engineer, data modeler or data architect. I used to interact with business and very technical stakeholders. In my work I always want to understand 'as-is' and 'to-be' solution for effective and high quality delivery of a solution or end product. Therefore, I put a lot of focus on effective communication and interaction with co-workers (very important for remote work scheme) or data analysis. I also like to deep dive into technology used during projects to get the best out of them.
As a data and analytics engineer I worked with various dwh technologies (Snowflake, Teradata, SAP Hana, SQL Server, Oracle), ETL/ELT pipelines languages (like SQL, Python, Bteq, Stored Procedures, C#, PowerShell, REST API, Jinja recently), and ETL/ELT tools (DBT, Data Stage, AbInitio, Informatica PowerCenter, getting familiar with Databricks and Coalesce). I have also performed many optimizations for SQL code, physical/logical data model, or load sequence. I have also trained and lead a group of data engineers. In the analytics environment I am skilled in tools like  MicroStrategy or Metabase.
As a data modeler I worked with Erwin and SAP Power designer for modeling semantic/business logical and physical layers for BI or data science usage. I have good knowledge of Kimball, Inmon or Data Vault modeling techniques, and follow new trends like Unified Star Schema.
As a data architect I took part of re-designing of a data warehouse for Data Vault architecture, worked with various scheduling tools (like ActiveBatch, AbInitio, Control-M, recently getting familiar with Airflow), implemented Data Quality Governance end-to-end (testing, DQ dashboard, Monitoring), or supported migration projects from legacy systems to new platforms.

Project history

09/2021 - 09/2022
Data Analytics Engineer
Lidl (Schwarz IT KG)

- Delivery of performance-optimized construction in data marts
- Conception, modeling, implementation, and further development of data warehouse

- SQL development for Teradata and Snowflake.
- Support of the business consultants with technical questions

Azure, Snowflake, Teradata, AbInitio, ActiveBatch, MicroStrategy, Confluence, JIRA, SQL, BTEQ, Python


06/2020 - 08/2021
Data Quality Governance Consultant, Data Warehouse Consultant
VTB Capital Bank Europe

 

1. DWH Efficiency Project

- Various architecture and design improvements

- Redesign ActiveBatch implementation

- Support work on new DWH architecture

 

2. Implementation of Data Quality Governance for Business Intelligence organization
- Implement Data Quality Management process
- Setup and configure data quality monitoring tool (BigEval)
- Setup analytical reports and data quality metrics


BiGeval, MS SQL Server (SSMS), Cognos Apparo Fast Edit, Power BI, Metabase, C#, PowerShell, Rest API, ActiveBatch, JIRA, Confluence


11/2018 - 10/2019
Data Modeler, Data Analytics Engineer, Tech Lead
Schwarz IT KG (Lidl)

Building a new business integration data layer to support more flexible, better and faster data
analytics and reporting.
Main tasks:
* data analysis and business documentation
* data modelling and mapping
* SQL coding

Teradata, MicroStrategy, AbInitio, SAP Power Designer, Jira

09/2018 - 10/2018
Data Warehouse Analyst
AIB Bank

Delivery of data quality framework to measure consistency and accuracy across all levels of
transformations for given metrics. This was a European Central Bank requirement.

Teradata, Statistics

10/2010 - 06/2018
Data Architect, Data Modeler, Data Analytics Engineer, Tech Lead, Senior Data Engineer
Nordea Bank AB

During various projects at Nordea I have gained business knowledge about credit risk (like Basel or
Nordea internal regulations), regulatory (like FinRep, or IFRS9), and management reporting (like
Customer Profitability or Management KPIs) data aspects. I have also accomplished many optimization
tasks for SQL and Teradata technology usage.

My positive attitude, good communication and friendly personality allowed me to created good
relationship during projects to many co-workers and client employees. The good relationship was very
important for me, as most of the time I worked remotely.
* Delivered end-to-end architecture solution proposal for credit risk analysis tools
* Provided deep data analysis at all data warehouse layers (stage, integration, access) for new
reporting tools and migration projects
* Managed team of 5-10 off-shore ETL developers
* Mentored junior consultants
* Designed and modeled access layers
* Created data mapping documents to be used by ETL developers
* Technology Advisor for developing Semantic Layers
* Optimized SQL code, load procedures, physical data model, logical data model, space consumptions
using various techniques and technology features.
* Developed various load procedures for Shared Business Semantic Layer (Star data model) from
Teradata LDM (3NF model)
Teradata, Essbase, Business Objects, SAP Hana, Data Stage, Jira, MS Office tools

01/2010 - 12/2012
Data Warehouse Consultant
Teradata Corporation

* Financial Services Industry expertise
* DW Architecture for BI applications
* SQL development
* Semantic Layer/Application LDM and PDM design

01/2009 - 01/2010
Business Intelligence Consultant
Microstrategy

Project delivery work such as: reports development, upgrades, migrations, testing, pre-sales,
project planning.

* Provided for Microstrategy product suite and its underlying technologies.
* Developed relationships with Microstrategy customers and partners
* Solved problems reported while using Microstrategy product suite through analytical
troubleshooting abilities.
* Prioritized and communicated product defects and enhancements to development teams

01/2007 - 01/2009
Business Intelligence Consultant
Hewlett-Packard

Technology Consultant for Business Intelligence and Data Warehouse technologies, such as Siebel
Analytics, Oracle Business Intelligence, Bea WebLogic, Oracle WebLogic, Fast Radar, Control-M,
Informatica PowerCenter.

* Managed communication between all projects' stakeholders
* Created and improved Change and Release Management processes for BI technologies
* Coordinated Change and Release Management procedures based on ITIL methodology

01/2006 - 01/2007
Security specialist
Orange - France Telecom Group


Certifications

Microsoft Certified: Azure Data Fundamentals
2023
SnowPro Core Certification
2023
dbt Developer
2023
Astronomer Certification for Apache Airflow Fundamentals
2023
Teradata 12 Certified Professional
2011

Local Availability

Open to travel worldwide
Profileimage by Jaroslaw Syrokosz Data Architect, Data Management Consultant, Data Analyst, Data Warehouse Consultant from Data Architect, Data Management Consultant, Data Analyst, Data Warehouse Consultant
Register