11.11.2024 aktualisiert
100 % verfügbar
Data Analyst
Berlin, Deutschland
Deutschland +2
MastersSkills
Data analysisPythonRExcelBIData VisualizationTableauTerraformSQLMySQLAzureawsGCPlookerGithubCI CDData Engineering
Business Intelligence Engineer
HelloFresh · Full-timeHelloFresh · Full-timeOct 2022 - Present · 2 yrs 2 mosOct 2022 to Present · 2 yrs 2 mosBerlin, GermanyBerlin, Germany
Finance
Led a data-driven project to understand and segment app users based on their engagement patterns. Applied machine learning techniques to analyze user behavior, resulting in valuable insights that informed business strategies and improved customer experience.
Catapult Data Migration of financial data assets from CDP to AWS Glue
Spearheaded the development of a sophisticated reporting framework using SQL to analyze and resolve inventory discrepancies, significantly enhancing inventory management practices.
Created and managed a dynamic dashboard in Tableau to monitor staff productivity at new distribution centers, driving significant improvements in operational efficiency.
Led the design and implementation of a robust data pipeline using Python for strategic cost calculation, which became pivotal in optimizing ingredient sourcing and pricing decisions.Finance Led a data-driven project to understand and segment app users based on their engagement patterns. Applied machine learning techniques to analyze user behavior, resulting in valuable insights that informed business strategies and improved customer experience. Catapult Data Migration of financial data assets from CDP to AWS Glue Spearheaded the development of a sophisticated reporting framework using SQL to analyze and resolve inventory discrepancies, significantly enhancing inventory management practices. Created and managed a dynamic dashboard in Tableau to monitor staff productivity at new distribution centers, driving significant improvements in operational efficiency. Led the design and implementation of a robust data pipeline using Python for strategic cost calculation, which became pivotal in optimizing ingredient sourcing and pricing decisions.
Skills: Python (Programming Language) · Amazon S3 · Tableau · Databricks · Airflow · Apache Impala · JetBrains DataGrip · Presto · Miro · tecton · gradioSkills: Python (Programming Language) · Amazon S3 · Tableau · Databricks · Airflow · Apache Impala · JetBrains DataGrip · Presto · Miro · tecton · gradio
Business Intelligence Manage
AUTO1 Group · Full-timeAUTO1 Group · Full-timeDec 2020 - Oct 2022 · 1 yr 11 mosDec 2020 to Oct 2022 · 1 yr 11 mosBerlin, GermanyBerlin, Germany
helped me get this jobLinkedIn helped me get this job
Finance
Segmentation of customers using customer behaviour based on frequency and recency providing insights for targeted marketing
Developed comprehensive borrowing base reports that supported the Corporate Finance team by leveraging asset-backed securities
Automated key retail operations reports using Python, reducing error rates by 30% and streamlining the refund process.Finance Segmentation of customers using customer behaviour based on frequency and recency providing insights for targeted marketing Developed comprehensive borrowing base reports that supported the Corporate Finance team by leveraging asset-backed securities Automated key retail operations reports using Python, reducing error rates by 30% and streamlining the refund process.
Skills: Python (Programming Language) · Amazon S3 · Tableau · Jenkins · Amazon Redshift · Talend · Redash · DBVisualizer · MYSQLSkills: Python (Programming Language) · Amazon S3 · Tableau · Jenkins · Amazon Redshift · Talend · Redash · DBVisualizer · MYSQL
Business Intelligence Analyst
Movinga · Full-timeMovinga · Full-timeMar 2020 - Dec 2020 · 10 mosMar 2020 to Dec 2020 · 10 mosBerlin, GermanyBerlin, Germany
Strategy and Insights team
Technologies: Tableau, SQL, Salesforce, Excel, Google sheets, Python, DBeaver, data analysis, data quality checks and SSIS
Designed and Maintained P&L flash and Cost report
Centralising reports across functional units to establish a single source of truth
Setting up of dispatching reports improve operation's visibility on auto-dispatches
Devising partner health score for determining the partners that are qualified and provide ease of dispatch
Sales Efficiency Trend analysis for Non-Cohort OpportunitiesStrategy and Insights team Technologies: Tableau, SQL, Salesforce, Excel, Google sheets, Python, DBeaver, data analysis, data quality checks and SSIS Designed and Maintained P&L flash and Cost report Centralising reports across functional units to establish a single source of truth Setting up of dispatching reports improve operation's visibility on auto-dispatches Devising partner health score for determining the partners that are qualified and provide ease of dispatch Sales Efficiency Trend analysis for Non-Cohort Opportunities
unior Business Intelligence Analyst
adspree mediaadspree mediaMay 2018 - Oct 2019 · 1 yr 6 mosMay 2018 to Oct 2019 · 1 yr 6 mosBerlin Area, GermanyBerlin Area, Germany
Marketing team
Technologies: Excel, Tableau, BigQuery, Google sheets, JIRA, R, Hotjar
Implemented fraud detection reports that highlighted discrepancies and prevented potential financial losses.
Performed predictive analytics using time-series data to forecast financial obligations, optimizing budget allocations.
Utilizing the Bag of Words model, conducted sentiment analysis on gamer feedback for games on our company’s site. This data-driven strategy enhanced our marketing campaigns’ effectivenessMarketing team Technologies: Excel, Tableau, BigQuery, Google sheets, JIRA, R, Hotjar Implemented fraud detection reports that highlighted discrepancies and prevented potential financial losses. Performed predictive analytics using time-series data to forecast financial obligations, optimizing budget allocations. Utilizing the Bag of Words model, conducted sentiment analysis on gamer feedback for games on our company’s site. This data-driven strategy enhanced our marketing campaigns’ effectiveness
Freelance (Self employed) · Part-timeFreelance (Self employed) · Part-timeApr 2017 - Mar 2018 · 1 yrApr 2017 to Mar 2018 · 1 yrBerlin, Germany · RemoteBerlin, Germany · Remote
As a freelance BI Analyst during my master’s, I collaborated with clients to design SQL queries for deep-diving into data trends and customer behavior. I built and refined dashboards that visualized key performance indicators, allowing clients to track metrics in real-time and make data-informed decisions. My work focused on optimizing data retrieval and crafting dashboards that clearly communicated insights to stakeholders.As a freelance BI Analyst during my master’s, I collaborated with clients to design SQL queries for deep-diving into data trends and customer behavior. I built and refined dashboards that visualized key performance indicators, allowing clients to track metrics in real-time and make data-informed decisions. My work focused on optimizing data retrieval and crafting dashboards that clearly communicated insights to stakeholders.
Skills: SQL · MYSQL · Microsoft Excel · LookerSkills: SQL · MYSQL · Microsoft Excel · Looker
Data Analyst
Infosys · Full-timeInfosys · Full-timeMay 2014 - Apr 2016 · 2 yrsMay 2014 to Apr 2016 · 2 yrsChennai Area, IndiaChennai Area, India
Technologies: Excel, Google Analytics, Oracle SQL
Channel wise performance analysis
Attribution analytics
Budget Allocation based on customer touchpoints
Weekly IBV Trend Analysis
HelloFresh · Full-timeHelloFresh · Full-timeOct 2022 - Present · 2 yrs 2 mosOct 2022 to Present · 2 yrs 2 mosBerlin, GermanyBerlin, Germany
Finance
Led a data-driven project to understand and segment app users based on their engagement patterns. Applied machine learning techniques to analyze user behavior, resulting in valuable insights that informed business strategies and improved customer experience.
Catapult Data Migration of financial data assets from CDP to AWS Glue
Spearheaded the development of a sophisticated reporting framework using SQL to analyze and resolve inventory discrepancies, significantly enhancing inventory management practices.
Created and managed a dynamic dashboard in Tableau to monitor staff productivity at new distribution centers, driving significant improvements in operational efficiency.
Led the design and implementation of a robust data pipeline using Python for strategic cost calculation, which became pivotal in optimizing ingredient sourcing and pricing decisions.Finance Led a data-driven project to understand and segment app users based on their engagement patterns. Applied machine learning techniques to analyze user behavior, resulting in valuable insights that informed business strategies and improved customer experience. Catapult Data Migration of financial data assets from CDP to AWS Glue Spearheaded the development of a sophisticated reporting framework using SQL to analyze and resolve inventory discrepancies, significantly enhancing inventory management practices. Created and managed a dynamic dashboard in Tableau to monitor staff productivity at new distribution centers, driving significant improvements in operational efficiency. Led the design and implementation of a robust data pipeline using Python for strategic cost calculation, which became pivotal in optimizing ingredient sourcing and pricing decisions.
Skills: Python (Programming Language) · Amazon S3 · Tableau · Databricks · Airflow · Apache Impala · JetBrains DataGrip · Presto · Miro · tecton · gradioSkills: Python (Programming Language) · Amazon S3 · Tableau · Databricks · Airflow · Apache Impala · JetBrains DataGrip · Presto · Miro · tecton · gradio
Business Intelligence Manage
AUTO1 Group · Full-timeAUTO1 Group · Full-timeDec 2020 - Oct 2022 · 1 yr 11 mosDec 2020 to Oct 2022 · 1 yr 11 mosBerlin, GermanyBerlin, Germany
helped me get this jobLinkedIn helped me get this job
Finance
Segmentation of customers using customer behaviour based on frequency and recency providing insights for targeted marketing
Developed comprehensive borrowing base reports that supported the Corporate Finance team by leveraging asset-backed securities
Automated key retail operations reports using Python, reducing error rates by 30% and streamlining the refund process.Finance Segmentation of customers using customer behaviour based on frequency and recency providing insights for targeted marketing Developed comprehensive borrowing base reports that supported the Corporate Finance team by leveraging asset-backed securities Automated key retail operations reports using Python, reducing error rates by 30% and streamlining the refund process.
Skills: Python (Programming Language) · Amazon S3 · Tableau · Jenkins · Amazon Redshift · Talend · Redash · DBVisualizer · MYSQLSkills: Python (Programming Language) · Amazon S3 · Tableau · Jenkins · Amazon Redshift · Talend · Redash · DBVisualizer · MYSQL
Business Intelligence Analyst
Movinga · Full-timeMovinga · Full-timeMar 2020 - Dec 2020 · 10 mosMar 2020 to Dec 2020 · 10 mosBerlin, GermanyBerlin, Germany
Strategy and Insights team
Technologies: Tableau, SQL, Salesforce, Excel, Google sheets, Python, DBeaver, data analysis, data quality checks and SSIS
Designed and Maintained P&L flash and Cost report
Centralising reports across functional units to establish a single source of truth
Setting up of dispatching reports improve operation's visibility on auto-dispatches
Devising partner health score for determining the partners that are qualified and provide ease of dispatch
Sales Efficiency Trend analysis for Non-Cohort OpportunitiesStrategy and Insights team Technologies: Tableau, SQL, Salesforce, Excel, Google sheets, Python, DBeaver, data analysis, data quality checks and SSIS Designed and Maintained P&L flash and Cost report Centralising reports across functional units to establish a single source of truth Setting up of dispatching reports improve operation's visibility on auto-dispatches Devising partner health score for determining the partners that are qualified and provide ease of dispatch Sales Efficiency Trend analysis for Non-Cohort Opportunities
unior Business Intelligence Analyst
adspree mediaadspree mediaMay 2018 - Oct 2019 · 1 yr 6 mosMay 2018 to Oct 2019 · 1 yr 6 mosBerlin Area, GermanyBerlin Area, Germany
Marketing team
Technologies: Excel, Tableau, BigQuery, Google sheets, JIRA, R, Hotjar
Implemented fraud detection reports that highlighted discrepancies and prevented potential financial losses.
Performed predictive analytics using time-series data to forecast financial obligations, optimizing budget allocations.
Utilizing the Bag of Words model, conducted sentiment analysis on gamer feedback for games on our company’s site. This data-driven strategy enhanced our marketing campaigns’ effectivenessMarketing team Technologies: Excel, Tableau, BigQuery, Google sheets, JIRA, R, Hotjar Implemented fraud detection reports that highlighted discrepancies and prevented potential financial losses. Performed predictive analytics using time-series data to forecast financial obligations, optimizing budget allocations. Utilizing the Bag of Words model, conducted sentiment analysis on gamer feedback for games on our company’s site. This data-driven strategy enhanced our marketing campaigns’ effectiveness
Freelance (Self employed) · Part-timeFreelance (Self employed) · Part-timeApr 2017 - Mar 2018 · 1 yrApr 2017 to Mar 2018 · 1 yrBerlin, Germany · RemoteBerlin, Germany · Remote
As a freelance BI Analyst during my master’s, I collaborated with clients to design SQL queries for deep-diving into data trends and customer behavior. I built and refined dashboards that visualized key performance indicators, allowing clients to track metrics in real-time and make data-informed decisions. My work focused on optimizing data retrieval and crafting dashboards that clearly communicated insights to stakeholders.As a freelance BI Analyst during my master’s, I collaborated with clients to design SQL queries for deep-diving into data trends and customer behavior. I built and refined dashboards that visualized key performance indicators, allowing clients to track metrics in real-time and make data-informed decisions. My work focused on optimizing data retrieval and crafting dashboards that clearly communicated insights to stakeholders.
Skills: SQL · MYSQL · Microsoft Excel · LookerSkills: SQL · MYSQL · Microsoft Excel · Looker
Data Analyst
Infosys · Full-timeInfosys · Full-timeMay 2014 - Apr 2016 · 2 yrsMay 2014 to Apr 2016 · 2 yrsChennai Area, IndiaChennai Area, India
Technologies: Excel, Google Analytics, Oracle SQL
Channel wise performance analysis
Attribution analytics
Budget Allocation based on customer touchpoints
Weekly IBV Trend Analysis
Sprachen
DeutschGrundkenntnisseEnglischMuttersprache
Projekthistorie
Company: HelloFresh
Role: Business Intelligence Engineer
Duration: Oct 2022 - Present
Project Type: Data Pipeline Development
Overview:
Led the design and deployment of a robust data pipeline to support strategic cost calculations for ingredient sourcing and pricing. This pipeline automated the flow of cost data from raw sources, enabling streamlined data ingestion and processing for accurate pricing analysis.
Key Achievements:
• Reduced manual data entry and improved data accuracy.
• Enabled real-time cost calculation, aiding in more competitive pricing strategies.
• Integrated with AWS Glue for scalable data processing.
Technologies Used: Python, AWS Glue, Amazon S3, Apache Airflow
Role: Business Intelligence Engineer
Duration: Oct 2022 - Present
Project Type: Data Pipeline Development
Overview:
Led the design and deployment of a robust data pipeline to support strategic cost calculations for ingredient sourcing and pricing. This pipeline automated the flow of cost data from raw sources, enabling streamlined data ingestion and processing for accurate pricing analysis.
Key Achievements:
• Reduced manual data entry and improved data accuracy.
• Enabled real-time cost calculation, aiding in more competitive pricing strategies.
• Integrated with AWS Glue for scalable data processing.
Technologies Used: Python, AWS Glue, Amazon S3, Apache Airflow
Company: HelloFresh
Role: Business Intelligence Engineer
Duration: Oct 2022 - Present
Project Type: Dashboard Development
Overview:
Developed and managed a comprehensive Tableau dashboard to monitor staff productivity across new distribution centers. This dashboard enabled real-time tracking of productivity metrics, allowing for actionable insights that led to a significant increase in operational efficiency.
Key Achievements:
• Enhanced productivity monitoring and optimized resource allocation.
• Improved decision-making at distribution centers, contributing to cost reductions.
• Integrated complex data sources, ensuring accurate real-time updates.
Technologies Used: Tableau, SQL, Databricks
Role: Business Intelligence Engineer
Duration: Oct 2022 - Present
Project Type: Dashboard Development
Overview:
Developed and managed a comprehensive Tableau dashboard to monitor staff productivity across new distribution centers. This dashboard enabled real-time tracking of productivity metrics, allowing for actionable insights that led to a significant increase in operational efficiency.
Key Achievements:
• Enhanced productivity monitoring and optimized resource allocation.
• Improved decision-making at distribution centers, contributing to cost reductions.
• Integrated complex data sources, ensuring accurate real-time updates.
Technologies Used: Tableau, SQL, Databricks
ompany: AUTO1 Group
Role: Business Intelligence Manager
Duration: Dec 2020 - Oct 2022
Project Type: Data Analysis
Overview:
Executed an in-depth segmentation analysis on customer behavior, using frequency and recency metrics to categorize customers and support targeted marketing strategies. This analysis informed the marketing team, leading to tailored campaigns and improved engagement.
Key Achievements:
• Provided insights that enhanced targeted marketing effectiveness.
• Increased customer engagement by informing personalized campaign strategies.
• Leveraged segmentation to identify key user groups and optimize outreach.
Technologies Used: SQL, Tableau, Redash
Role: Business Intelligence Manager
Duration: Dec 2020 - Oct 2022
Project Type: Data Analysis
Overview:
Executed an in-depth segmentation analysis on customer behavior, using frequency and recency metrics to categorize customers and support targeted marketing strategies. This analysis informed the marketing team, leading to tailored campaigns and improved engagement.
Key Achievements:
• Provided insights that enhanced targeted marketing effectiveness.
• Increased customer engagement by informing personalized campaign strategies.
• Leveraged segmentation to identify key user groups and optimize outreach.
Technologies Used: SQL, Tableau, Redash