Bernd Steckenbauer
Business Data Analyst | PowerBI & Microsoft SQL Server
Experience
May 2022 - Present
3 years 3 months Berlin, Germany
Business Data Analyst | PowerBI & Microsoft SQL Server
think-cell Software GmbH
- Set up reporting and analytics using Microsoft PowerBI, managed underlying data with SSMS, built and optimized the data model with Microsoft Visual Studio/SSAS
- Improved performance and centralized reporting by creating data models with SSMS (SQL) & SSAS (DAX) and integrating data with SSIS
- Optimized and expanded current PowerBI datasets (in parallel until data model completed in SSAS)
- Expanded current reporting (migrated reports to SSAS source after building SSAS data model)
- Conducted regression, cohort, price/volume, and success analyses for strategy projects
- Trained internal colleagues
Jan 2021 - Present
3 years 7 months Cologne, Germany
Business Data Analyst | PowerBI & Microsoft SQL Server
Volvo Car Germany GmbH
- Set up reporting and analytics using Microsoft PowerBI, managed underlying data with SSMS, built and optimized the data model with Microsoft Visual Studio/SSAS
- SSAS: Adjusted the central data model, calculated required measures and calculated columns using DAX (including time intelligence, projections, rolling forecasts, etc.)
- SSMS: Created and optimized views based on the existing database structure to simplify the data model
- SSIS: Integrated decentralized data sources (SQL Server, CSV, XLSX)
- MS PowerBI: Created automated, audience-specific daily reports for sales & marketing, after sales, production planning, finance, etc. (including exec summaries and detailed analyses)
- Delivered PowerBI, modeling, and DAX training for internal analysts
- Handled project planning and management, as-is analysis, and requirements management (1st step)
Jul 2021 - Oct 2021
4 months Munich, Germany
Developer Microsoft PowerBI (Nebenberuflich)
Avantgarde Talents GmbH
- Developed a daily sales dashboard to guide account managers and recruiters
- Migrated to a new data source (second project)
Dec 2020 - Jan 2021
2 months Munich, Germany
Developer Microsoft PowerBI (Nebenberuflich)
Avantgarde Talents GmbH
- Developed a daily sales dashboard to guide account managers and recruiters
- Modeled data
- Created a data model
- Developed relevant measures in collaboration with the KAM lead
- Built custom and flexible sales dashboards
- Verified data consistency
Mar 2020 - Dec 2021
1 year 10 months Munich, Germany
Team Lead Business Intelligence | Microsoft PowerBI
Korian Deutschland AG
- Built a company-wide reporting and analytics system using Microsoft PowerBI (Desktop and Online Service) for executives, regional and facility management, and departments like HR, operations, and marketing
- Delivered about 20 standard reports for all user groups and special topics like balanced scorecards and forecasting models
- Created an operating model to allocate centrally booked costs to their causes
- Built a central data pool in PowerBI Online Service using PowerBI Dataflows (sources included SAP BW, MS Dynamics, OneDrive, corporate network, and industry systems like DAN, Cannyline, IS Social, Geocon)
- Structured and mapped financial and non-financial data from various source systems, defined and created primary and foreign keys
- Modeled datasets based on dataflows with automated updates
- Calculated required measures, defining logic with stakeholders to ensure consistency across the company
- Produced audience-specific daily, weekly, and monthly reports on all key topics (care, assisted living, outpatient services, HR scheduling, recruiting, marketing & sales) with automated updates
- Conducted internal training and ongoing coaching for a four-person team and built 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 (built a group-wide enterprise DWH with a self-service BI tool)
- Led six internal and external developers
- Acted as liaison between the board, business unit MDs, profit center departments, and IT (requirements management, design, implementation, optimization, data delivery)
- Developed, optimized, and automated distribution of audience-specific dashboards (board, management, departments) via Microsoft Power BI
- Harmonized measurement methods across the group and analyzed, adjusted, and implemented consistent booking logic
- Served as data protection coordinator/ISO for corporate controlling
Sep 2015 - Sep 2017
2 years 1 month Unterföhring, Germany
Senior Controller Digital Entertainment
ProSiebenSat.1 Digital GmbH
- Created business cases and handled financial implementation for new business models and strategic initiatives (e.g., Joyn business case, TVSmiles investment case)
- Coordinated, managed, and monitored the entire planning process
- Produced ongoing forecasts, deviation analyses, and discussions with departments to optimize specific websites (Prosieben.de, Sat1.de, etc.)
- Built and optimized 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 (Hubert Burda Media)
- Automated the entire monthly reporting process (financials and business-specific KPIs)
- Analyzed and helped steer the business unit (performance analyses, business cases, profitability reviews, benchmarking, potential identification)
- Coordinated, managed, and consolidated reach and financial planning
Feb 2012 - Feb 2013
1 year 1 month Munich, Germany
CFO Assistant
Your Family Entertainment AG
- Managed monthly reports including P&L, balance sheet, forecast, cash flow planning, and key metrics
- Redesigned the asset valuation system technically and functionally
- Created 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
Werkstudent Business Intelligence
Scout24 Holding GmbH
Apr 2010 - Sep 2010
6 months Munich, Germany
Werkstudent Produktmanagement Multi Asset Products
Wealth Management Capital Holding GmbH
Aug 2009 - Mar 2010
8 months Munich, Germany
Werkstudent Group Accounting & Application Management
Scout24 Holding GmbH
Sep 2008 - Aug 2009
1 year Nuremberg, Germany
Werkstudent Product Management & Sales Support
Cortal Consors, BNP Paribas
Jun 2006 - Aug 2007
1 year 3 months Munich, Germany
Werkstudent Forderungsmangement
BMW Financial Services
Languages
German
Native
English
Advanced
Latin
Advanced
Spanish
Intermediate
Chinese
Elementary
...and 1 more
Education
Apr 2009 - Mar 2011
Universität Regensburg
Master of Science in Economics · Economics · Regensburg, Germany
Sep 2007 - Feb 2008
Universidad de Zaragoza
ERASMUS exchange semester · Zaragoza, Spain
Oct 2005 - Mar 2009
Universität Regensburg
Bachelor of Science in Economics · Economics · Regensburg, Germany
Certifications & licenses
Bank Clerk (IHK)
Genossenschaftsbank eG München
Similar Freelancers
Discover other experts with similar qualifications and experience