Bernd Steckenbauer - Business Data Analyst | PowerBI & Microsoft SQL Server

Q: Where is Bernd based?

Bernd is based in Berlin, Germany .

Q: What languages does Bernd speak?

Bernd speaks the following languages: German (Native), English (Advanced), Spanish (Intermediate), French (Elementary), Chinese (Elementary) .

Q: How many years of experience does Bernd have?

Bernd has at least 18 years of experience. During this time, Bernd has worked in at least 13 different roles and for 13 different companies . The average length of individual experience is 1 year and 4 months . Note that Bernd may not have shared all experience and actually has more experience.

Q: What is Bernd's latest experience?

Bernd's most recent position is Business Data Analyst | PowerBI & Microsoft SQL Server at think-cell Software GmbH .

Q: What companies has Bernd worked for in recent years?

In recent years, Bernd has worked for think-cell Software GmbH , Volvo Car Germany GmbH , Avantgarde Talents GmbH , and Korian Deutschland AG .

Q: Which industries is Bernd most experienced in?

Bernd is most experienced in industries like Media, Entertainment and Publishing , Automotive , and Information Technology (IT) . Bernd also has some experience in Banking and Finance , Healthcare , and Professional Services .

Q: Which business areas is Bernd most experienced in?

Bernd is most experienced in business areas like Business Intelligence , Finance , and Information Technology (IT) . Bernd also has some experience in Project Management , Accounting , and Operations .

Q: Which industries has Bernd worked in recently?

Bernd has recently worked in industries like Automotive , Information Technology (IT) , and Healthcare .

Q: Which business areas has Bernd worked in recently?

Bernd has recently worked in business areas like Business Intelligence , Information Technology (IT) , and Project Management .

Recommended expert

Berlin, Germany

Experience

May 2022 - Present

3 years 10 months

Berlin, Germany

Business Data Analyst | PowerBI & Microsoft SQL Server

think-cell Software GmbH

Performance optimization/reporting centralization by building data models using SSMS (SQL) & SSAS (DAX) & data integration via SSIS
Optimization and expansion of the current PowerBI dataset (running parallel until the SSAS data model was finished)
Expansion of current reporting (after building the SSAS data model, migrating the reporting to the SSAS source)
Regression analyses, cohort analyses, price/volume analyses, success analyses of strategy projects
Training internal colleagues

Jan 2022 - Present

4 years 2 months

Cologne, Germany

Business Data Analyst | PowerBI & Microsoft SQL Server

Volvo Car Germany GmbH

SSAS: Adjusting the central data model, calculating the needed measures and calculated columns with DAX (e.g., time intelligence, projections, rolling forecasts, etc.)
SSMS: Creating/optimizing views based on the existing DB structure to simplify the data model
SSIS: Integration of decentralized data sources (SQL Server, CSV, XLSX)
MS PowerBI: Creating automated, audience-specific daily reports for sales & marketing, after sales, production planning, finance, etc. (including exec summaries and detailed analyses)
PowerBI/modelling/DAX training for internal analysts
Project planning and management, as-is analysis, requirements management (1st step)

Dec 2020 - Oct 2021

11 months

Munich, Germany

Developer Microsoft PowerBI (part-time)

Avantgarde Talents GmbH

Developing a daily sales dashboard to manage account managers and recruiters
Data modeling, creating a data model
Developing relevant measures in collaboration with the KAM lead
Creating specific and flexible sales dashboards
Checking data consistency
Migrating to a new data source (2nd project)

Mar 2020 - Dec 2021

1 year 10 months

Munich, Germany

Team Lead Business Intelligence | Microsoft PowerBI

Korian Deutschland AG

Building the company-wide reporting and analytics system using Microsoft PowerBI (Desktop and Online Service) for the board of directors, executive management, regional/area and facility management, and departments like HR, operations, marketing
About 20 standard reports for all relevant user groups and special topics, e.g., balanced scorecards and forecasting models
Operating model for the accurate allocation of centrally booked costs
Creating a central data pool in the PowerBI Online Service by integrating data via PowerBI dataflows (data sources among others SAP BW, MS Dynamics, MS OneDrive, company network, industry systems like DAN, Cannyline, IS Social, Geocon)
Structuring and mapping financial and non-financial data from various source systems, including defining and creating primary and foreign keys
Modelling datasets based on the dataflows, including automated updates
Calculating the needed measures, including defining them with relevant stakeholders to align inconsistent calculation logic within the company
Creating audience-specific daily, weekly, and monthly reports on all relevant company topics (care, assisted living, outpatient services, HR scheduling, recruiting, marketing & sales), including automated updates
Conducting internal training and ongoing coaching of the four-member team, and building a PowerBI community within the company

Oct 2017 - Feb 2020

2 years 5 months

Munich, Germany

Senior Manager Business Intelligence & Controlling

Hubert Burda Media Holding KG – CFO Office

Product owner for the Burda Digital Data Hub (building a group-wide enterprise DWH including a self-service BI tool)
Leading a team of six internal and external developers
Acting as a link between the board, business unit MDs, profit center departments, and IT (requirements management, design, implementation, optimization, data provisioning)
Developing, optimizing, and automating distribution of audience-specific dashboards (board, management, departments) via Microsoft Power BI
Harmonizing measurement methods across the group, and analyzing, adjusting, and implementing a consistent posting logic
Data protection coordinator/ISO for the corporate controlling area

Sep 2015 - Sep 2017

2 years 1 month

Unterföhring, Germany

Senior Controller Digital Entertainment

ProSiebenSat.1 Digital GmbH

Creation of business cases and commercial implementation of new business models and strategic initiatives (e.g. business case for Joyn, investment case TVSmiles)
Coordination, operational support and monitoring of the entire planning process
Ongoing forecasts, regular variance analysis and discussions with departments to optimize specific websites (Prosieben.de, Sat1.de, etc.)
Development and optimization of controlling tools to analyze traffic and sales KPIs

May 2013 - Aug 2015

2 years 4 months

Munich, Germany

Manager Finance & Operations

Burda Intermedia Publishing GmbH

Automation of the entire monthly reporting (financials, business-specific KPIs)
Analysis and support in managing the business unit (performance analysis, business cases, profitability reviews, benchmarking, identifying potential)
Coordination, operational support and consolidation of audience reach and financial planning

Feb 2012 - Feb 2013

1 year 1 month

Munich, Germany

CFO Assistant

Your Family Entertainment AG

Monthly reporting including P&L, balance sheet, forecast, cash flow planning and relevant KPIs
Technical and content revision of the asset valuation system
Creation of the business and project plan for launching a free-to-air TV channel

Jul 2011 - Dec 2011

6 months

Guangzhou, China

Assistant to the Executive Chamber Manager

Deutsche Auslandshandelskammer Süd- & Südwestchina

Oct 2010 - Jun 2011

9 months

Munich, Germany

Working Student Business Intelligence

Scout24 Holding GmbH

Apr 2010 - Sep 2010

6 months

Munich, Germany

Working Student Product Management Multi-Asset Products

Wealth Management Capital Holding GmbH

Aug 2009 - Mar 2010

8 months

Munich, Germany

Working Student Group Accounting & Application Management

Scout24 Holding GmbH

Sep 2008 - Aug 2009

1 year

Nuremberg, Germany

Working Student Product Management & Sales Support

Cortal Consors, BNP Paribas

Jun 2006 - Aug 2007

1 year 3 months

Munich, Germany

Working Student Receivables Management

BMW Financial Services

Industries Experience

See where this freelancer has spent most of their professional time. Longer bars indicate deeper hands-on experience, while shorter ones reflect targeted or project-based work.

Experienced in Media and Entertainment (8 years), Automotive (6 years), Information Technology (5 years), Banking and Finance (2.5 years), Healthcare (2 years), and Professional Services (1 year).

Media and Entertainment

Automotive

Information Technology

Banking and Finance

Healthcare

Professional Services

Business Areas Experience

The graph below provides a cumulative view of the freelancer's experience across multiple business areas, calculated from completed and active engagements. It highlights the areas where the freelancer has most frequently contributed to planning, execution, and delivery of business outcomes.

Experienced in Business Intelligence (13.5 years), Finance (9.5 years), Information Technology (6 years), Project Management (5 years), Accounting (3 years), and Operations (2.5 years).

Business Intelligence

Finance

Information Technology

Project Management

Accounting

Operations

Skills

Reporting/modelling: Power Bi, Tableau, Qlikview, Sap Business Objects, Oracle Hyperion (Planning, Reporting Studio, Smartview, Hfm), Microsoft Excel (Among Others Excellent Analytics, Thinkcell), Ssas, Ssms, Ssis
User/database Languages: Sql, R (Tidyverse), Spss, Talend Open Studio
Project Management: Scrum, Jira, Confluence

Languages

German

Native

English

Advanced

Spanish

Intermediate

French

Elementary

Chinese

Elementary

Education

Apr 2009 - Mar 2011

University of Regensburg

Master of Science in Economics · Economics · Regensburg, Germany

Sep 2007 - Feb 2008

University of Zaragoza

Zaragoza, Spain

Oct 2005 - Mar 2009

University of Regensburg

Bachelor of Science in Economics · Economics · Regensburg, Germany

...and 1 more

Profile

Created

August 2023

Last Update

August 2024

Need a freelancer? Find your match in seconds.

Try FRATCH GPT

Frequently asked questions

Do you have questions? Here you can find further information.

Where is Bernd based?

Bernd is based in Berlin, Germany.

What languages does Bernd speak?

Bernd speaks the following languages: German (Native), English (Advanced), Spanish (Intermediate), French (Elementary), Chinese (Elementary).

How many years of experience does Bernd have?

Bernd has at least 18 years of experience. During this time, Bernd has worked in at least 13 different roles and for 13 different companies. The average length of individual experience is 1 year and 4 months. Note that Bernd may not have shared all experience and actually has more experience.

What roles would Bernd be best suited for?

Based on recent experience, Bernd would be well-suited for roles such as: Business Data Analyst | PowerBI & Microsoft SQL Server, Developer Microsoft PowerBI (part-time), Team Lead Business Intelligence | Microsoft PowerBI.

What is Bernd's latest experience?

Bernd's most recent position is Business Data Analyst | PowerBI & Microsoft SQL Server at think-cell Software GmbH.

What companies has Bernd worked for in recent years?

In recent years, Bernd has worked for think-cell Software GmbH, Volvo Car Germany GmbH, Avantgarde Talents GmbH, and Korian Deutschland AG.

Which industries is Bernd most experienced in?

Bernd is most experienced in industries like Media, Entertainment and Publishing, Automotive, and Information Technology (IT). Bernd also has some experience in Banking and Finance, Healthcare, and Professional Services.

Which business areas is Bernd most experienced in?

Bernd is most experienced in business areas like Business Intelligence, Finance, and Information Technology (IT). Bernd also has some experience in Project Management, Accounting, and Operations.

Which industries has Bernd worked in recently?

Bernd has recently worked in industries like Automotive, Information Technology (IT), and Healthcare.

Which business areas has Bernd worked in recently?

Bernd has recently worked in business areas like Business Intelligence, Information Technology (IT), and Project Management.

What is Bernd's education?

Bernd holds a Master in Economics from University of Regensburg and a Bachelor in Economics from University of Regensburg.

What is the availability of Bernd?

Bernd is immediately available for suitable projects.

What is the rate of Bernd?

Bernd's rate depends on the specific project requirements. Please use the Meet button on the profile to schedule a meeting and discuss the details.