Senior Data Engineer
The Stryze Group GmbH
(Konsumgüter und Handel, 50-250 Mitarbeiter)
Schlagwörter
Bigquery
Cloud Computing
Power Bi
SQL
SQL Server Reporting Services
SQL Server Integration Services
SQL Server Analysis Services
Skills
- expert knowledge of SQL (10+ years)
- full stack of Microsoft BI Services (SSIS, SSRS, SSAS, Machine Learning
and R Services) (10+ years)
- Cloud BI/DWH technologies: Bigquery, dbt, Looker, Airflow
- full stack of Microsoft BI Services (SSIS, SSRS, SSAS, Machine Learning
and R Services) (10+ years)
- Cloud BI/DWH technologies: Bigquery, dbt, Looker, Airflow
Projekthistorie
03/2021
-
bis jetzt
- 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
- 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
09/2013
-
02/2021
Senior Business Intelligence Developer
Friendsurance
(Versicherungen, 50-250 Mitarbeiter)
- 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
- 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
06/2011
-
08/2013
Business Intelligence Developer
sMeet Communications GmbH
(Internet und Informationstechnologie, 50-250 Mitarbeiter)
- data integration with SSIS and Talend from the different Sources (MySQL, CSV files, Excel files)
- multidimensional modeling of Cubes with SSAS
- dashboards and reports with SSRS
- Ad-hoc requests with T-SQL
- multidimensional modeling of Cubes with SSAS
- dashboards and reports with SSRS
- Ad-hoc requests with T-SQL
Reisebereitschaft
Nur Remote verfügbar
