Senior Data Engineer | Data Analyst | Python, SAS, Azure, AWS, Power BI
Aktualisiert am 23.05.2024
Profil
Mitarbeiter eines Dienstleisters
Remote-Arbeit
Verfügbar ab: 06.05.2024
Verfügbar zu: 100%
davon vor Ort: 100%
Skill-Profil eines fest angestellten Mitarbeiters des Dienstleisters
Spanisch
Muttersprache
Deutsch
Grundkenntnisse
English
Verhandlungssicher

Einsatzorte

Einsatzorte

München (+200km)
Deutschland
möglich

Projekte

Projekte

5 Monate
2024-01 - heute

Enhancing Client Retention Strategies with AI-Powered Dashboards and Predictive Analytics | Power BI, Python, Machine Learning

Data Engineer Microsoft Fabric Azure Power BI Premium ...
Data Engineer
  • Implementation of a machine learning models to predict customer churn probability based on business and master data of bank clients. The model aims to assist account management and marketing decision-making, enabling targeted customer engagement through customized marketing campaigns.

  • Building ETL pipelines in Azure Data Factory and Synapse to process data from diverse sources, including Synapse and Server SQL Pool (Apache Spark), using Power Query and DAX.

  • Designed and modelled financial dashboards in Power BI Premium to visualize historical CRM KPIs and analyze client segmentation and retention.
Jira Visual Studio Code Azure DevOps Git Python
Microsoft Fabric Azure Power BI Premium Azure Synapse Analytics Jupyter Notebooks
1 Jahr 6 Monate
2023-01 - 2024-06

Implementation of a framework for propagating optimized space planograms to multiple stores

Data Engineer SQL Penthao Jira ...
Data Engineer

  • Implemented a new database in PostgreSQL Azure.
  • Implemented framework in Python using Azure Functions Cloud Services and Azure API Management.
  • Coordination with FrontEnd team to define API endpoints set and API?s payload.
  • Documented business and technical requirements
  • Supported the User Acceptance Tests with analyses of errors, explanations of open questions, and technical adjustments

Penthao Jira Azure PostgreSQL Azure API Management Azure Functions
SQL Penthao Jira Azure PostgreSQL Azure API Management Azure Functions Python PySpark Django
Retail
6 Monate
2023-11 - 2024-04

Development data models and ETL in SAS and Power BI for private banking customer segmentation and strategic marketing

Data Engineer Power BI DAX Power Query ...
Data Engineer

  • Implementation of a SAS Data Mart for reducing and aggregating transactional data.
  • Improve ETL performance in the existing SAS Mart by 70% through performance optimization and aggregation techniques.
  • Development of a dashboard for data profiling to monitor data quality across various stages of the data transformation pipeline.
  • Creating financial dashboards in Power BI to visualize historical CRM key performance indicators (KPIs) and analyze customer segmentation, cash flows, profitability, and market penetration.
  • Building ETL pipelines to process data from diverse sources, including in-memory SQL databases (Tabular), Denodo, and SharePoint, using Power Query and DAX.
  • Analyze ETL pipelines to assess data sequencing and develop an automated Python tool for generating data lineage.
  • These tasks involve critical data management and analytics processes, contributing to informed decision-making within the organization.

SAS Enterprise Guide Microsoft Sharepoint Jira Denodo Git (GitHub) MS Power BI
Power BI DAX Power Query SAS Enterprise Guide Microsoft Sharepoint Jira Visual Basic Scripting (VBA) Denodo Azure DevOps Git (GitHub) Visual Studio Code (VSCode) Jupyter
München
3 Monate
2024-01 - 2024-03

Development a meta data system to enable end-to-end visibility into data sources and field-level lineage in DataHub

Data Engineer Jira Visual Studio Code Azure Kubernetes Services ...
Data Engineer

  • Implementation of an integrated field-level data catalog and data lineage via Data Hub on Azure Kubernetes Services
  • Assess to document data streams in hybrid architectures and provide visibility into business rules and transformations

Azure Kubernetes Services Data Hub
Jira Visual Studio Code Azure Kubernetes Services Azure DevOps Git Python
3 Monate
2023-08 - 2023-10

Development of reports of performance and status of stores planograms for Analytics Team

Power BI Data Analyst SQL MS Power BI
Power BI Data Analyst

  • Gathered requirements for the development of dashboards for logistic planning and performance monitoring of stores in Power BI.
  • Leveraged Power BI cloud functionalities to enhance the customer experience and strengthen data accuracy
  • Analyzed the reporting requirements issued by the Analytics Team Client and developed visual reports using Power BI and DAX for visualizing key performance indicators of the implemented planograms across all retail stores,
  • Extracted datasets from PostgreSQL Azure DB into PowerBI using DirectQuery
  • Documented the data lineage and redacted rich documentation, including data sources, data model, and DAX expressions

Power BI DAX SQL Power Query Jira Azure PostgreSQL
SQL MS Power BI
Retail / Space planning
6 Monate
2022-07 - 2022-12

Implementation of a ETL framework for ingesting old format planograms and transforming in an improved new data model

Data Engineer Jira Azure PostgreSQL Azure Functions ...
Data Engineer

  • Retail companies used to work with traditional space planning software. To avoid increase complexities in the transition to a new space planning software, a new ETL framework had to be developed leveraging a containerized Docker environment in Amazon Web Services (AWS) Coud
  • Implemented a new database in PostgreSQL Azure.
  • Implemented ETL in Python using Azure Functions Cloud Services and Azure API Management.
  • Documented business and technical requirements
  • Supported the User Acceptance Tests with analyses of errors, explanations of open questions, and technical adjustments

Jira Azure PostgreSQL Azure Functions Docker
Jira Azure PostgreSQL Azure Functions SQL Python AWS Azure Docker
Retail
1 Jahr
2022-01 - 2022-12

Develop a Radar Signal Processing and Analysis at the Jicamarca Radio Observatory in Peru

Data Analyst
Data Analyst

  • Processed data from the Radar Acquisition System.
  • Implemented radar processing algorithms in Matlab to calculate final radar-derived parameters and performance metrics.
  • Created a user-friendly graphical interface in Matlab GUI for visualizing processed data (range, time, intensity) and enabling date and subsystem selection.
  • Integrated the program seamlessly with the Radar Acquisition System for daily batch data transfer.
  • Offered technical support and customized adjustments to meet user needs.
  • Documented detailed technical specifications and program requirements.

MATLAB
Engineering
6 Monate
2022-01 - 2022-06

Development of Reports of performance of 711 stores

Data Analyst SQL Python PySpark ...
Data Analyst

  • Analyzed the reporting requirements issued the Sales Analytics Team Client and developed reports using Power BI and DAX for visualizing performance indicators in the sales transactions of more than 1000 711 stores in the Philippines.
  • Developed ETL in AWS Glue using PySpark to prepare the dataset for analysis.
  • Implemented new AWS Redshift database for processed transactions' data.
  • Documented business and technical requirements

AWS Redshift AWS Glue PowerBI
SQL Python PySpark AWS Redshift AWS Glue PowerBI DAX Atlassian JIRA
Retail

Position

Position

  • Data Engineer
  • Power BI Data Analyst
  • Python Developer
  • ETL Developer Python / SAS / Azure Data Fabric / AWS

Kompetenzen

Kompetenzen

Programmiersprachen

Python
Experte
SAS
Fortgeschritten
Power BI
Fortgeschritten
PostgreSQL
Fortgeschritten
AWS
Fortgeschritten
Azure
Fortgeschritten

Branchen

Branchen

· Reporting & Analytics

· Logistics planning

· Cost Analysis

· Private Banking

· System Integration

Einsatzorte

Einsatzorte

München (+200km)
Deutschland
möglich

Projekte

Projekte

5 Monate
2024-01 - heute

Enhancing Client Retention Strategies with AI-Powered Dashboards and Predictive Analytics | Power BI, Python, Machine Learning

Data Engineer Microsoft Fabric Azure Power BI Premium ...
Data Engineer
  • Implementation of a machine learning models to predict customer churn probability based on business and master data of bank clients. The model aims to assist account management and marketing decision-making, enabling targeted customer engagement through customized marketing campaigns.

  • Building ETL pipelines in Azure Data Factory and Synapse to process data from diverse sources, including Synapse and Server SQL Pool (Apache Spark), using Power Query and DAX.

  • Designed and modelled financial dashboards in Power BI Premium to visualize historical CRM KPIs and analyze client segmentation and retention.
Jira Visual Studio Code Azure DevOps Git Python
Microsoft Fabric Azure Power BI Premium Azure Synapse Analytics Jupyter Notebooks
1 Jahr 6 Monate
2023-01 - 2024-06

Implementation of a framework for propagating optimized space planograms to multiple stores

Data Engineer SQL Penthao Jira ...
Data Engineer

  • Implemented a new database in PostgreSQL Azure.
  • Implemented framework in Python using Azure Functions Cloud Services and Azure API Management.
  • Coordination with FrontEnd team to define API endpoints set and API?s payload.
  • Documented business and technical requirements
  • Supported the User Acceptance Tests with analyses of errors, explanations of open questions, and technical adjustments

Penthao Jira Azure PostgreSQL Azure API Management Azure Functions
SQL Penthao Jira Azure PostgreSQL Azure API Management Azure Functions Python PySpark Django
Retail
6 Monate
2023-11 - 2024-04

Development data models and ETL in SAS and Power BI for private banking customer segmentation and strategic marketing

Data Engineer Power BI DAX Power Query ...
Data Engineer

  • Implementation of a SAS Data Mart for reducing and aggregating transactional data.
  • Improve ETL performance in the existing SAS Mart by 70% through performance optimization and aggregation techniques.
  • Development of a dashboard for data profiling to monitor data quality across various stages of the data transformation pipeline.
  • Creating financial dashboards in Power BI to visualize historical CRM key performance indicators (KPIs) and analyze customer segmentation, cash flows, profitability, and market penetration.
  • Building ETL pipelines to process data from diverse sources, including in-memory SQL databases (Tabular), Denodo, and SharePoint, using Power Query and DAX.
  • Analyze ETL pipelines to assess data sequencing and develop an automated Python tool for generating data lineage.
  • These tasks involve critical data management and analytics processes, contributing to informed decision-making within the organization.

SAS Enterprise Guide Microsoft Sharepoint Jira Denodo Git (GitHub) MS Power BI
Power BI DAX Power Query SAS Enterprise Guide Microsoft Sharepoint Jira Visual Basic Scripting (VBA) Denodo Azure DevOps Git (GitHub) Visual Studio Code (VSCode) Jupyter
München
3 Monate
2024-01 - 2024-03

Development a meta data system to enable end-to-end visibility into data sources and field-level lineage in DataHub

Data Engineer Jira Visual Studio Code Azure Kubernetes Services ...
Data Engineer

  • Implementation of an integrated field-level data catalog and data lineage via Data Hub on Azure Kubernetes Services
  • Assess to document data streams in hybrid architectures and provide visibility into business rules and transformations

Azure Kubernetes Services Data Hub
Jira Visual Studio Code Azure Kubernetes Services Azure DevOps Git Python
3 Monate
2023-08 - 2023-10

Development of reports of performance and status of stores planograms for Analytics Team

Power BI Data Analyst SQL MS Power BI
Power BI Data Analyst

  • Gathered requirements for the development of dashboards for logistic planning and performance monitoring of stores in Power BI.
  • Leveraged Power BI cloud functionalities to enhance the customer experience and strengthen data accuracy
  • Analyzed the reporting requirements issued by the Analytics Team Client and developed visual reports using Power BI and DAX for visualizing key performance indicators of the implemented planograms across all retail stores,
  • Extracted datasets from PostgreSQL Azure DB into PowerBI using DirectQuery
  • Documented the data lineage and redacted rich documentation, including data sources, data model, and DAX expressions

Power BI DAX SQL Power Query Jira Azure PostgreSQL
SQL MS Power BI
Retail / Space planning
6 Monate
2022-07 - 2022-12

Implementation of a ETL framework for ingesting old format planograms and transforming in an improved new data model

Data Engineer Jira Azure PostgreSQL Azure Functions ...
Data Engineer

  • Retail companies used to work with traditional space planning software. To avoid increase complexities in the transition to a new space planning software, a new ETL framework had to be developed leveraging a containerized Docker environment in Amazon Web Services (AWS) Coud
  • Implemented a new database in PostgreSQL Azure.
  • Implemented ETL in Python using Azure Functions Cloud Services and Azure API Management.
  • Documented business and technical requirements
  • Supported the User Acceptance Tests with analyses of errors, explanations of open questions, and technical adjustments

Jira Azure PostgreSQL Azure Functions Docker
Jira Azure PostgreSQL Azure Functions SQL Python AWS Azure Docker
Retail
1 Jahr
2022-01 - 2022-12

Develop a Radar Signal Processing and Analysis at the Jicamarca Radio Observatory in Peru

Data Analyst
Data Analyst

  • Processed data from the Radar Acquisition System.
  • Implemented radar processing algorithms in Matlab to calculate final radar-derived parameters and performance metrics.
  • Created a user-friendly graphical interface in Matlab GUI for visualizing processed data (range, time, intensity) and enabling date and subsystem selection.
  • Integrated the program seamlessly with the Radar Acquisition System for daily batch data transfer.
  • Offered technical support and customized adjustments to meet user needs.
  • Documented detailed technical specifications and program requirements.

MATLAB
Engineering
6 Monate
2022-01 - 2022-06

Development of Reports of performance of 711 stores

Data Analyst SQL Python PySpark ...
Data Analyst

  • Analyzed the reporting requirements issued the Sales Analytics Team Client and developed reports using Power BI and DAX for visualizing performance indicators in the sales transactions of more than 1000 711 stores in the Philippines.
  • Developed ETL in AWS Glue using PySpark to prepare the dataset for analysis.
  • Implemented new AWS Redshift database for processed transactions' data.
  • Documented business and technical requirements

AWS Redshift AWS Glue PowerBI
SQL Python PySpark AWS Redshift AWS Glue PowerBI DAX Atlassian JIRA
Retail

Position

Position

  • Data Engineer
  • Power BI Data Analyst
  • Python Developer
  • ETL Developer Python / SAS / Azure Data Fabric / AWS

Kompetenzen

Kompetenzen

Programmiersprachen

Python
Experte
SAS
Fortgeschritten
Power BI
Fortgeschritten
PostgreSQL
Fortgeschritten
AWS
Fortgeschritten
Azure
Fortgeschritten

Branchen

Branchen

· Reporting & Analytics

· Logistics planning

· Cost Analysis

· Private Banking

· System Integration

Vertrauen Sie auf GULP

Im Bereich Freelancing
Im Bereich Arbeitnehmerüberlassung / Personalvermittlung

Fragen?

Rufen Sie uns an +49 89 500316-300 oder schreiben Sie uns:

Das GULP Freelancer-Portal

Direktester geht's nicht! Ganz einfach Freelancer finden und direkt Kontakt aufnehmen.