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

Q: Where is Bernd based?

Bernd is based in Munich, Germany and can operate in on-site , hybrid , and remote work models.

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 and Entertainment , Automotive , and Information Technology . 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 . 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 , and Healthcare .

Q: Which business areas has Bernd worked in recently?

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

Recommended expert

Munich, Germany

Check rate

Experience

May 2022 - Present

4 years 1 month

Berlin, Germany

Business Data Analyst | PowerBI & Microsoft SQL Server

think-cell Software GmbH

Performance optimization and centralization of reporting by creating data models using SSMS (SQL) & SSAS (DAX) and integrating data via SSIS
Optimizing and extending the current PowerBI dataset (in parallel until the SSAS data model is ready)
Expanding current reports (migrating reporting to SSAS source after building the SSAS data model)
Conducting regression analyses, cohort analyses, price/quantity analyses, and strategy project success analyses
Training internal team members

Jan 2022 - Present

4 years 5 months

Cologne, Germany

Business Data Analyst | PowerBI & Microsoft SQL Server

Volvo Car Germany GmbH

SSAS: Adjusting the central data model and calculating needed measures and calculated columns using DAX (e.g. Time Intelligence, projections, rolling forecasts, etc.)
SSMS: Creating and optimizing views based on the existing DB structure to simplify the data model
SSIS: Integrating 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/modeling/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 guide account managers and recruiters
Data modeling and building a data model
Developing relevant measures in collaboration with the KAM lead
Creating specific and flexible sales dashboards
Checking data consistency
Switching 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, executive management, regional/area and facility managers, and departments like HR, Operations, Marketing
Around 20 standard reports for all relevant user groups and special topics such as balanced scorecards and forecasting models
Developing an operating model for allocating centrally booked costs based on causation
Setting up a central data pool in PowerBI Online Service through data integration with PowerBI Dataflows (data sources including SAP BW, MS Dynamics, MS OneDrive, company network, industry-specific 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
Modeling datasets based on dataflows with automated refreshes
Calculating needed measures, including defining them together with stakeholders to address inconsistent calculation logic within the company
Creating audience-specific daily, weekly, and monthly reports on all relevant company topics (nursing, assisted living, outpatient services, HR scheduling, recruiting, marketing & sales) with automated updates
Internal training and ongoing coaching of the four-person team, plus 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 Burda Digital Data Hub (building a company-wide enterprise data warehouse including a self-service BI tool)
Technical leadership 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 delivery)
Developing, optimizing, and automating the distribution of audience-specific dashboards (board, management, departments) via Microsoft Power BI
Company-wide harmonization of measurement methods, including analyzing, adjusting, and implementing a consistent booking logic
Data protection coordinator/ISO for 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, TVSmiles investment case)
Coordination, operational support and monitoring of the entire planning process
Ongoing forecasts, continuous variance analysis and discussions with the 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 analyses, business cases, profitability reviews, benchmarking, identifying potential)
Coordination, operational support and consolidation of 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 planning, and key KPIs
Technical and content overhaul of the asset valuation system
Creation of the business and project plan for launching a free 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 in Product Management - Multi Asset Products

Wealth Management Capital Holding GmbH

Aug 2009 - Mar 2010

8 months

Munich, Germany

Working Student in Group Accounting & Application Management

Scout24 Holding GmbH

Sep 2008 - Aug 2009

1 year

Nuremberg, Germany

Working Student in Product Management & Sales Support

Cortal Consors, BNP Paribas

Jun 2006 - Aug 2007

1 year 3 months

Munich, Germany

Working Student in Receivables Management

BMW Financial Services

Industry Experience

See where this freelancer has spent most of their professional time.

Experienced in Media and Entertainment, Automotive, Information Technology, Banking and Finance, Healthcare, and Professional Services.

Media and Entertainment

Automotive

Information Technology

Banking and Finance

Healthcare

Professional Services

Business Area Experience

See which departments and functions this freelancer has contributed to most.

Experienced in Business Intelligence, Finance, Information Technology, Project Management, Accounting, and Operations.

Business Intelligence

Finance

Information Technology

Project Management

Accounting

Operations

Summary

I have honed my skills in business data analysis, focusing on PowerBI and Microsoft SQL Server to build data models and reporting solutions that work across various industries. I excel in creating automated dashboards, integrating diverse data sources, and developing practical measures that help simplify complex data into clear insights.

My experience ranges from performance optimization and model enhancement to delivering targeted reporting solutions for sales, finance, and operations. I take pride in coaching teams and streamlining processes with a clear focus on data consistency and usability.

Skills

Reporting/Modelling: Power Bi, Tableau, Qlikview, Sap Business Objects, Oracle Hyperion (Planning, Reporting Studio, Smartview, Hfm), Microsoft Excel (E.G. Excellent Analytics, Thinkcell), Ssas, Ssms, Ssis
Application/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

Statistics

Experience

Total positions 14

Experience in Media and Entertainment 8 y

Avg length 1 y 7 m

Longest experience 4 y 4 m

Global Experience

Countries worked in 2 (Germany, China)

Primary country Germany

Expertise

Recent roles Business Data Analyst | PowerBI & Microsoft SQL Server, Developer Microsoft PowerBI (Part-Time), Team Lead Business Intelligence | Microsoft PowerBI

Main industries Media and Entertainment, Automotive, Information Technology

Main business areas Business Intelligence, Finance, Information Technology

Qualifications

Highest degree Master

Profile

Created

August 2023

Last Update

May 2026

Need a freelancer? Find your match in seconds.

Try FRATCH GPT

Frequently asked questions

Have questions? Find more information here.

Where is Bernd based?

Bernd is based in Munich, Germany and can operate in on-site, hybrid, and remote work models.

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 and Entertainment, Automotive, and Information Technology. 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. 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, and Healthcare.

Which business areas has Bernd worked in recently?

Bernd has recently worked in business areas like Business Intelligence, Information Technology, 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 part-time 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.