Avanade

Data Engineer

DEPT®

- Architected and implemented data architecture of dbt on Databricks with CICD pipeline on CodeBuild for the client.
- Developed data pipelines to ingress and egress Salesforce data and ad channel data. Applied unit tests.
- Architected a set of PowerBI reports to visualize critical KPIs for top management.
- Modeled business processes according to Kimball's best practices and created data models. (SAP ERP data, Salesforce data, SAP Ecom data)
- Implemented Prefect and Airflow orchestration jobs to schedule ELT tasks.
- Set up data platform infrastructure as a code with Terraform. (Databricks on AWS)
- Reviewed client’s data landscapes and prepared data migration roadmap as a data tech lead.
- Executed data discoveries for customers as a data consultant and recommended action points based on findings.
- Built partnerships with dbt labs & Databricks. Organized dbt meetup in Berlin.

Van Caem Klerks Group

I was hired as the first person to set up the Business Intelligence department at Van Caem for the purpose to become a data-driven company. I made foundations to start the data transformation.
Data Platform implementation (selected data partner, helped them with successful implementation. (Azure Data Lake, ADF, Databricks, dbt tool, Azure SQL)

· advised, defined, and implemented new pricing methods across divisions. Pricing is now made faster and better. (SQL, dbt, Python, Azure Functions, Power Automate, and PowerBI) delivering dbt models - price lists, replenishment lists, sales, purchases, etc.,
· saved money by scheduling jobs running on Databricks using AzureDevops and CI/CD pipelines.
· encouraging colleagues and other departments to work Agile and utilize capabilities of Azure DevOps.
· delivering PowerBI reports,
implemented Data Warehouse demo infrastructure (utilized Azure Data Factory),
· helping other departments (trade, e-commerce, business developers, support) with business processes · explanation and solving ad-hoc requests.
· acting as a lead to my colleagues who have less experience started Excel training sessions across the whole company implemented a dashboard to collect offers from suppliers to help traders quickly choose the best offer.
· Scrapped competitor prices from the website to incorporate in the database.

Analytics Engineer / Business Data Analyst

Operose Health

· Implemented Weekly Services' Dashboard for Ops Team
· Created PowerBI Dashboard to summarize Mental Health Assessments (well-being scores, conversion rate, surveys)
· Advised and created a solution to gather well-being patient assessments and the form on how it can be stored. - Office 365 Form with Power Automate workflow
· Enhanced my data load pipeline to load .csv files automatically
and in parallel to make it scalable. - IPython Clusters
· Prepared a ETL solution to load automatically .csv files directly to the database in parallel with Python. Used IPython Clusters and configuration table in the database.
· Utilizing Git repositories in Azure DevOps.
· Responding to ad-hoc reporting requests.

Business Intelligence Analyst

· Automated month-end excel reports with Python (saved 3 working days every month).
·Implemented PowerBI dashboard which saved 1 day of work every month for HR department.
· Implemented my own ETL process in Python to load .csv files into the database
· Advised solutions for colleagues in another office on how they can improve their processes.
· Cross training with other colleagues on Data Warehousing, Python, SSIS, PowerBI, SSAS, Azure, Azure DevOps.
· Contact with CCGs (external people) and providing contractual reports for them.
· Created interactive what-if forecasting analysis to reduce caseload in booking team.
· Providing ad-hoc reports - SQL, Excel
· Process documentation in Visio

Junior Analyst | Developer

Lightology

· Successfully implemented QlikSense BI dashboards - I was responsible for whole ETL process, visualisations and administration (section access).
· Implemented monthly pdf dashboards to measure Sales consultants performance - Python reports
· Forecasted inventory stock using ARIMA method with Python. (In the same time I tried to use MLP method).
· Utilized US Census API to enhance the reporting
· Scrapped company's website to get updated product categories
· Preparing ad-hoc reports - SQL and Excel
· Prepared Market Basket Analysis to show what products are sold usually together to improve sales. - MLxtend library.

Contractor

Wroclaw University of Economics

• Taught Students basics of SAP ERP system.
• Showed Students fundamentals of SAP architecture and basic processes 
(Sales and Distribution SD, Materials Management MM, Warehouse Management WM, Production Planning PP).

Lecturer

SophScope Ltd.

• Worked on SAP ALV reports on different customers’ systems. Generated new reports and modified already created reports.
• Created report on the length of the railway tracks depending on the given condition for Polish State Railways which was used in the solution presentation. 
• Programmed in ABAP programming language.
• Created SAP Enhancements to add new features to standard SAP system
• Set up data services in SAP Cloud Platform. Input and read data in json format from mobile application.
• Set up SAP HANA XS from scratch on server for testing purposes.
• Created token assignment with SAP Cloud Platform which allowed to use tokens in log in process from mobile application.

ABAP Programmer

Dolnośląskie Centrum Onkologii (Oncology Center)

• Analyzed two databases to combine data from each to associate cost data with medical and administrative data.
• Calculated costs of medical operations used data from two databases and visualized it with QlikSense software. Qlik was used also in the data transformation process.
• Calculated costs of hospital’s pharmacy and showed it with QlikSense.

BI Analyst

- Experienced data engineer with 5+ years of experience in the data industry and architecting solutions.
- Proven track record of success by leading data discoveries, architecting data infrastructure solutions, building and maintaining data pipelines, developing data models, and creating data visualizations.
- Expertise in various technologies, including Databricks, dbt, Python, SQL, PowerBI, Azure, and AWS.
- Strong analytical and problem-solving skills.
- Passion for supporting customers in solving business problems with suitable and effective data solutions.
- Eager to contribute and grow my expertise in topics such as data architecture, data quality, data governance, data modeling, data pipelines, data visualization, data management, and data security

Taplio

Igor Dabrowski's Linkedin Analytics

Want to drive more opportunities from LinkedIn?

Taplio

.css-1jgreyo{background-image:linear-gradient(284deg, rgba(39,43,72,1) 0%, rgba(33,47,183,1) 100%);color:transparent;-webkit-background-clip:text;background-clip:text;}Igor Dabrowski's Linkedin Analytics

Want to drive more opportunities from LinkedIn?

Igor Dabrowski's Linkedin Analytics