Senior Data Engineer

7/2023 – offen

Tätigkeit als Data Engineer in Microsoft Stack (SQL Server, SSIS, Azure) und Projektleitung

Projektleitung / Teamleitung (IT), SQL Entwickler

3/2021 – 6/2023

- full installation and configuration of BI Server from the scratch
- creation and developments of Data Warehouse on MS SQL Server 2019
- migration from Microsoft SQL Server to Cloud BI/DWH technologies using Bigquery and dbt
- API creation to 3rd party services using Python: Amazon SP, Ebay, Shopify
- creation of ETL processes from the different Sources using SSIS
- creation of reports using AWS Quicksight and Looker
- strategic analysis with SQL queries and OLAP Cubes, recommendations for management and other departments of the company

Microsoft Business Intelligence, Microsoft SQL Server Analysis Services (SSAS), SQL Entwickler, Google Cloud

9/2013 – 2/2021

- Full installation and configuration of BI Server from the scratch
- Data Warehouse Creation and Improvement: SQL Server 2008/2012/2016 (including Stored Procedures, Functions, Indexes and Triggers)
- ETL: SSIS from the different Sources (PostgreSQL, Google Analytics, Google Sheets, Webservices, 3rd party services)
- OLAP: SQL Server Analysis Services (Multi-Dimensional Cubes)
- Reports: Dynamic SQL Server Reporting Services, MS Power BI
- Interface function to other departments of the company (marketing, product, CRM, finance), supporting and optimizing them strategically and operationally
- Python: API to 3rd party services: Mandrill, BingAds, Adwords, BiPRO
- Developing of own internal REST API using Python and Flask
- Machine Learning projects (Python): Random Forest (BAGGING), XGBoost and CatBoost (Gradient Boosting), TensorFlow Estimators and Keras (Deep Neural Networks); Clustering, Classification and Regression; Saving of trained Model to the files and Loading for the next usage
- Automation of Manual Processes: Automatic Import of the various sets of invoices from the different companies and sources (in the totally different file formats, columns structures and categorical features vocabularies in different sources) into one consolidated DB table; Automatic Matching of Imported Invoices to the existing Customers and Contracts; Dynamic SQL Automation Scripts
- Database Administration: MS SQL Server 2008/2012/2016, PostgreSQL
- WEB tracking: Google Analytics, GTM (Google Tag Manager), creation of Java-Script Tags
- Knowledge and experience in the whole technical BI infrastructure
- Active Directory Management, security administration, PowerShell scripting for export of data
- Automatic and Manual Documentation
- Maintenance, third party code optimization

Microsoft SQL Server Analysis Services (SSAS), Microsoft SQL Server Reporting Services (SSRS), ETL-Entwickler, SQL Entwickler, Google Analytics, Google Tag Manager