Might be available
(Updated 2020-05-30)Data analyst / BI Analyst
Berlin, Germany
Native Svenska, Fluent English, German
- Strong data visualization skills (Tableau, PowerBI, Google Data Studio)
- Experienced building ETL-processes (SQL, python, R, SAS)
- 5+ years experience in data analysis (forecasting, marketing, sales)
Skills (21)
Business Intelligence
SQL
CRM
BI
Tableau
SPOTFIRE
TABLEAU SOFTWARE
SAS Suite
SALES FORECASTING
POWER
MySQL
ETL
SAS
DATA ANALYTICS
Data Scientist
MS SQL DBA
MICROSTRATEGY
Python
QlikView
Spark
Hadoop
Summary
- 5 years professional experience from consulting and analytics
- Proficient in multiple programming languages (fluent in SAS, Python and SQL)
- Several years experience from data handling, preparation and design of data cubes and data management structure
- Strong skills in ETL process design for efficient data handling and assure high data quality
- Innovative and creative with analytic mindset and good presentation skills
Professional Experience
2019-11 - Present
Analytics project for a later-stage e-commerce startup, focusing on supporting product and business team to work more data
driven. Responsible for setting up efficient ETL-processes, reporting landscape and a clear KPI framework.
- Conversion analysis, customer segmentation and sales funnel optimization
- Analysis of marketing data to support marketing / product teams in decision taking
- Transformation and consolidation of data from different data sources
- Setup of Tableau dashboards for regular follow-up on KPIs and business targets
2018-05 - 2019-12
Design and implementation of a new KPI framework for standardized follow-up on marketing and sales activites. This included
customer segmentation analysis, improved customer insight and implementing self-service capabilities. SQL and SAS was used
to extract, analyze and prepare data. Data and insights was shared to business users with interactive dashboards in Spotfire.
- Developed a customer affinity matrix for product and service offerings based upon scoring models
- Improved follow-up on marketing activities through automated campaign tracking
- Automation of ETL-pipelines and data models for reporting processes
- Implementation of self-service BI-tools among business users
2017-06 - 2018-12
Implemented new reporting and analytic capabilities for follow-up on digital initiatives and CRM. ETL-pipelines were developed for improved data preparation. Visualization of data was shared with business users in dashboards with SAS Visual Analytics
- Segmentation and clustering of customers to enhance targeted campaigning
- Improved transparency and insight about revenue streams and product profitability
- Enhanced democratization of data through implementation of self-service BI-tools
- Automation of ETL-pipelines improved reporting processes and reduced manual processes
2016-01 - Present
Enhanced data analytics in the organization through implementation of advanced analytic techniques for demand forecasting, production planning and logistics optimization. Dashboards and standardized KPIs was implemented to increase data awareness and support management in daily operations and strategic questions.
- Increased production efficiency, less production bottle-necks and higher workforce utilization
- Product utilization increased by 10 % through improved forecasting models and logistics
- Increased transparency of revenue streams and product profitability
- Reduction of manual interfaces and automation of processes (invoicing, reporting, financial analysis)
2016-01 - 2017-01
Improved sales forecasting models and supported management in commercial decision taking. Special focus was on analyzing e-commerce-data to improve customer analytics in the digital channel.
- Improved sales forecasting accuracy, enabling quick follow up on sales deviations
- Increased efficiency in the reporting and budgeting process
- Deeper insight about customer behavior in the digital channel
- Implementation of standardized KPIs for follow up on e-commerce KPIs and marketing campaigns
2014-01 - 2015-01
Various consulting projects with focus on analysis of finance processes and development of IT-solutions for controlling, consolidation and reporting.
Project examples:
- Developed concepts and IT-solutions for financial consolidation and reporting
- Conducted benchmarking analysis of controlling and reporting processes
- Project management support during IT transformation of a large insurance company
Academic Background
2008-09 - 2013-12
2010-10 - 2012-05