It looks like you are in United States.
Would you like to go to https://onsiter.com/us/ instead?
Would you like to go to https://onsiter.com/us/ instead?
Might be available
(Updated 2023-03-30)BI/DWH utvecklare och analytiker
Stockholm, Sweden
Native Svenska, English
- Data warehouse (SQL)
- Power BI
- Qlik Sense
Skills (33)
RETAIL SALES
BI
Excel
Power BI
Business Intelligence
Power BI
SQL
DATA MODEL
ETL
FINANCE
PIPELINE
FORECASTS
Data lineage
BEST PRACTICES
STATISTICS
MAPPING
Big Data
Maintain Data Integrity
DATA INTEGRITY
CUSTOMER SERVICE
MARKOV
MATLAB
STEERING
PERFORMANCE MANAGEMENT
Procurement
Maintain Data
PRICING
SALES REPRESENTATIVE
SEMANTIC
OFFICE MANAGEMENT
BUYING
MONTE CARLO
Hedging
Summary
Business focused analyst and developer with passion for creating insights presented in a simple understandable way for optimizing and solving problems.
Experience from multiple roles covering sales, marketing, finance and management.
Looking for companies that are changing their business model, in need of insights or improving their analyses, reporting and data models.
Professional Experience
Data Manager
2021-01 - 2023-01
Role: Leading the Scandinavian affiliate in the global project to consolidate all countries into one platform, increasing the business to be more data driven and assisting with data engineering tasks.
* Acting as contact point for the global team and championing for the Winning with Data initiative to be more data driven by showing how data can improve the business.
* Creating a data warehouse solution on the Spark-based Palantir Foundry platform to simplify usage of different BI tools.
* Suggesting and creating reports and analysis on their business to increase insights and efficiency.
* Assisting the BI managers with expertise on improvements in their existing reports.
* Automatizing data flows to reduce manual labour and decrease reliance on individuals.
* Assisting in transitioning to a Power BI solution to replace their Qlik Sense solution.
* Acting as contact point for the global team and championing for the Winning with Data initiative to be more data driven by showing how data can improve the business.
* Creating a data warehouse solution on the Spark-based Palantir Foundry platform to simplify usage of different BI tools.
* Suggesting and creating reports and analysis on their business to increase insights and efficiency.
* Assisting the BI managers with expertise on improvements in their existing reports.
* Automatizing data flows to reduce manual labour and decrease reliance on individuals.
* Assisting in transitioning to a Power BI solution to replace their Qlik Sense solution.
Application Manager BI, Office Management
2019-01 - 2021-01
Role: Responsible for the corporate BI solution with focus on improving usability, stability and trustworthiness and creating a central data warehouse as the single point of truth.
* Working with each department to show how BI can improve their processes by creating Qlik Sense apps tailored for their needs with increased satisfaction.
* Working with the finance department reduced time spent on monthly P&L and reports for the board of directors resulting in reduced usage of Excel and increased focus on forecast and insights.
* Bought and implemented TimeXtender to simplify building and maintaining the data warehouse and to reduce dependence on key personnel.
* Working as architect and developer of the data warehouse resulting in a modular ETL solution with a conformed semantic layer which increased understanding, transparency and making it possible for future changes in sources of data.
* With focus on loading times leading to an improvement from reload every hour to every five minutes which resulted in reduction of manual errors in the systems by faster feedback to the organisation.
* Being a stakeholder during implementation of other system to maintain data integrity and structure for future needs.
* Working with each department to show how BI can improve their processes by creating Qlik Sense apps tailored for their needs with increased satisfaction.
* Working with the finance department reduced time spent on monthly P&L and reports for the board of directors resulting in reduced usage of Excel and increased focus on forecast and insights.
* Bought and implemented TimeXtender to simplify building and maintaining the data warehouse and to reduce dependence on key personnel.
* Working as architect and developer of the data warehouse resulting in a modular ETL solution with a conformed semantic layer which increased understanding, transparency and making it possible for future changes in sources of data.
* With focus on loading times leading to an improvement from reload every hour to every five minutes which resulted in reduction of manual errors in the systems by faster feedback to the organisation.
* Being a stakeholder during implementation of other system to maintain data integrity and structure for future needs.
BI Developer, Hive Streaming
2021-01 - 2021-01
Role: Managing the customer facing Power BI solution and assisting the data team with best practices in BI and architecture for their new lake house.
* Assisting in the architecture of the new lake house solution based on a Databricks' delta lake in Azure.
* Creating a more efficient data model in the Power BI data set reducing size with 70 %, increasing granularity and improving refresh speed.
* Improving the Azure Data Factory pipeline to the legacy data warehouse based on Azure SQL server.
* Mapping the data lineage down to the thrift big data files.
* Maintaining and supporting the customer facing Power BI solution.
* Assisting the business departments with ad-hoc reporting and analysis.
* Assisting in the architecture of the new lake house solution based on a Databricks' delta lake in Azure.
* Creating a more efficient data model in the Power BI data set reducing size with 70 %, increasing granularity and improving refresh speed.
* Improving the Azure Data Factory pipeline to the legacy data warehouse based on Azure SQL server.
* Mapping the data lineage down to the thrift big data files.
* Maintaining and supporting the customer facing Power BI solution.
* Assisting the business departments with ad-hoc reporting and analysis.
Senior Analyst
Eniro
2017-01 - 2019-01
Role: Strengthen the company in its implementation of the new subscription model by creating reports, analyses and insights focused on the new model.
* My analyses in procurement costs resulted in changes of the product portfolio and removal of an unprofitable product.
* My analyses on sales and product performance led to monthly deep dive presentations for the management team.
* Made a competitor analysis focused on long term profitability and evolution of the advertisement market for the steering committee.
* Creating an appreciated activity monitoring report for the team managers to track behavior of each sales representative.
* Creating an attribution model on marketing activities which required creating a custom R-package to retrieve data.
* Aiding finance by creating forecasts and reports.
* My analyses in procurement costs resulted in changes of the product portfolio and removal of an unprofitable product.
* My analyses on sales and product performance led to monthly deep dive presentations for the management team.
* Made a competitor analysis focused on long term profitability and evolution of the advertisement market for the steering committee.
* Creating an appreciated activity monitoring report for the team managers to track behavior of each sales representative.
* Creating an attribution model on marketing activities which required creating a custom R-package to retrieve data.
* Aiding finance by creating forecasts and reports.
Risk Analyst
Vattenfall Sales
2013-01 - 2017-01
Role: Pricing of risks involved in buying and selling electricity on fixed and variable rates and optimizing hedging of forwards and contract for differences.
* Optimizing the hedge portfolio using bias-variance tradeoff and delta hedging.
* Reporting P/L for price option.
* Developing and improving reports in Qlikview.
* Optimizing the hedge portfolio using bias-variance tradeoff and delta hedging.
* Reporting P/L for price option.
* Developing and improving reports in Qlikview.
Business Analyst - Performance Management team
Vattenfall Customer Service
2012-01 - 2013-01
Role: Represent Sweden in the European performance management team during the merger of the countries into one organisation with focus on harmonising reporting and definitions.
* Harmonizing definitions of KPI's across the countries to better compare performance.
* Senior support in implementing Genesys in Holland and Germany.
* Involved in COPC certification of the Swedish customer service.
* Frequent travels to Holland and Germany.
* Harmonizing definitions of KPI's across the countries to better compare performance.
* Senior support in implementing Genesys in Holland and Germany.
* Involved in COPC certification of the Swedish customer service.
* Frequent travels to Holland and Germany.
Workforce Management
Vattenfall Customer Service
2007-01 - 2012-01
Role: Member of WFM team driving the implementation of new way of working with focus on reporting.
* Responsible for creating and maintaining reports for the customer service in line with new way of working.
* Creating automatic reports to replace manual reporting resulting in reduction of a half FTE and minimizing errors.
* Forecasting, scheduling and allocating resources for 250 Customer Service agents.
* Participated in implementing, testing and administrating new contact center system.
* Responsible for creating and maintaining reports for the customer service in line with new way of working.
* Creating automatic reports to replace manual reporting resulting in reduction of a half FTE and minimizing errors.
* Forecasting, scheduling and allocating resources for 250 Customer Service agents.
* Participated in implementing, testing and administrating new contact center system.
Academic Background
Master of Science in Engineering Physics
KTH Royal Institute of Technology
2025-04 - 2025-04
Contact contractor
Need help finding an expert?
We can connect you with qualified experts matching your requirements.
or