Recommended expert
Thomas Reick
BI Consultant and Power BI Developer
Experience
Apr 2025 - Present
11 monthsCologne, Germany
BI Consultant and Power BI Developer
Plusnet GmbH
- In-depth forensics on old and new data sources
- Enhancement of existing reports and creation of new data analyses
- Data preparation from source systems and semantic models
- Integration of Azure DevOps
- Tools/Skills: MS Power BI, DAX, MS Office 365, Power Query, M, Power Automate, Redmine, SharePoint, SQL (T-SQL, Oracle), MS Fabric
Apr 2025 - Apr 2025
1 monthBusiness Analyst, BI Consultant and Power BI Developer
audioprotect AG
- Tracking changes in municipality assignment
- Potential data research, modeling, preparation, and calculation
- Geographic allocation/clean-up of customer base
- Aggregation and regionalization of revenues
- Generation of regional sales territories (routing based on customer and potential shares)
- Cartographic and tabular presentation of results
- Derivation of recommendation measures to increase market penetration
- Tools/Skills: MS Power BI, Power Query, M, DAX, Jet SQL (MS Access), GfK RegioGraph
Mar 2025 - Apr 2025
2 monthsBusiness Analyst, BI Consultant and Power BI Developer
elacin GmbH
- Potential data research, modeling, preparation, and calculation
- Geographic allocation/clean-up of customer base
- Aggregation and regionalization of revenues
- Generation of regional sales territories (routing based on customer and potential shares)
- Cartographic and tabular presentation of results
- Derivation of recommendation measures to increase market penetration
- Tools/Skills: MS Power BI, Power Query, M, DAX, Jet SQL (MS Access), GfK RegioGraph
Jan 2024 - Jun 2024
6 monthsMS Power BI / MS SQL Developer
EWR AG
- Designing use cases with business units
- Developing performance-optimized dashboards
- Usability analysis of existing dashboards and optimization
- Structuring reporting requirements
- Advancing the central data warehouse architecture (Microsoft Fabric)
- Creating SQL queries and reports
- Design and development of analytical databases
- System documentation
- Tools/Skills: MS Power BI, DAX, MS Office 365, Power Query, M, MS SQL Server, SSIS, SSRS, Power Automate, Microsoft Fabric
Apr 2022 - Sep 2023
1 year 6 monthsCologne, Germany
BI Consultant and Power BI Developer
Plusnet GmbH
- Providing reports, dashboards, and analyses
- Enhancement of existing reports and creation of new data analyses
- Migration of existing reports to Power BI
- Tools/Skills: MS Power BI, DAX, MS Office 365, Power Query, M, Power Automate, Confluence, SharePoint, SQL (MariaDB, MySQL, PostgreSQL, Oracle)
Sep 2021 - Dec 2021
4 monthsBonn, Germany
BI Consultant and Power BI Developer
Deutsche Post
- Identification of relevant data sources and stakeholders
- Design of consolidation logic and data models
- Development of dashboards and interactive visualizations
- Implementation of the reporting structure in compliance with data protection
- Tools/Skills: MS-Office 2013, SQL-Server 2019, MDX, M, DAX, T-SQL, PowerBI, SharePoint, SSIS, SSAS, SSRS
Nov 2018 - Apr 2021
2 years 6 monthsDüsseldorf, Germany
External BI Consultant
L’Oréal Deutschland
- Monitoring ETL processes, testing and validation procedures
- Development of new cube loads for the D-A-CH region
- Reporting with MS Excel, SSRS and Power BI
- Permission management (Active Directory)
- Tools/Skills: MS-Office 2019/365, SQL-Server, VBA, MDX, M, DAX, T-SQL, PowerBI, SharePoint
Jul 2018 - Sep 2018
3 monthsBonn, Germany
VBA Developer and MS Office Developer
DHL
- Integration of SharePoint data
- Development of plausibility checks and validation procedures
- User training and coaching
- Tools/Skills: MS-Excel, VBA, SharePoint
Jun 2018 - Sep 2018
4 monthsDuisburg, Germany
MS Access and VBA Developer
Deutsche Bahn
- Development of VBA and SQL procedures
- Rollout and adjustments
- Tools/Skills: MS-Excel 2010, MS-Access 2010, PL/2 AS400, VBA
Oct 2017 - Dec 2017
3 monthsEssen, Germany
SQL, VBA and MS Access Developer
ISTA
- Data import and export from source to target systems
- Procedural data processing
- Ad-hoc selections
- Further development of campaign tools
- Support in migrating the parallel Office environment to Qlik Sense
- Development of semi-automatic correction processes and tools for incorrectly captured data
- Tools/Skills: MS-Access 2003/2013, MS-Dynamix, MS-SQL-Server, T-SQL, MS-Excel, VBA
Sep 2016 - Sep 2018
2 years 1 monthMoers, Germany
External BI Consultant
MVZ
- Deriving and validating market potential (DeStatis, GfK, mb-research)
- Data preparation, imports, calculations, and reporting
- Visualization with desktop mapping software RegioGraph
- Reporting, address research and validation (private practice doctors), geocoding
- Competitor environment analysis
- Tools/Skills: MS-Access, RegioGraph, MS-Excel
Feb 2016 - Sep 2018
2 years 8 monthsHamburg, Germany
MS Access and VBA Developer
Philips
- Data imports and exports between source and target systems
- Procedural processing
- Ad-hoc analyses
- Further development of the reporting toolkit (infrastructure, content, KPIs)
- Migration of the Office environment to MS SQL Server
- Introduction of SSRS and Power BI to standardize reporting
- Tools/Skills: MS-SQL-Server, T-SQL, SSIS, ADO DB via MS Access/MS Excel, VBA, pivot reporting with MS-Excel, Power BI
Feb 2016 - Aug 2017
1 year 7 monthsDortmund, Germany
SQL and MS Access Developer
Inlingua
- Maintenance, assistance, and user support
- Integration of new tasks and procedures in third-party form handling
- Rights definition and stored procedure definition
- Automation of exam registrations at the BAMF
- Tools/Skills: MS SQL Server, MS Access 2007 with ADP integration, T-SQL
Summary
Focus on Business Intelligence (BI), data analysis, reporting, database development.
Languages
German
NativeEnglish
AdvancedEducation
Oct 1986 - Jun 1988
Wholesale and foreign trade merchant, fine paper
Oct 1975 - Jun 1984
High school diploma (Abitur) · Germany
Economics (econometrics, statistics)
Certifications & licenses
MS Certified: Power BI Data Analyst Associate
Microsoft, Pearson Vue
Prince2 Scrum Master
People Cert
Data Protection Officer
PersCert TÜV
Profile
Created
Last Update
Need a freelancer? Find your match in seconds.
Try FRATCH GPT More actions
Frequently asked questions
Do you have questions? Here you can find further information.
Where is Thomas based?
Thomas is based in Cologne, Germany and prefers 100% remote projects.
What languages does Thomas speak?
Thomas speaks the following languages: German (Native), English (Advanced).
How many years of experience does Thomas have?
Thomas has at least 8 years of experience. During this time, Thomas has worked in at least 8 different roles and for 12 different companies. The average length of individual experience is 7 months. Note that Thomas may not have shared all experience and actually has more experience.
What roles would Thomas be best suited for?
Based on recent experience, Thomas would be well-suited for roles such as: BI Consultant and Power BI Developer, Business Analyst, BI Consultant and Power BI Developer, MS Power BI / MS SQL Developer.
What is Thomas's latest experience?
Thomas's most recent position is BI Consultant and Power BI Developer at Plusnet GmbH.
What companies has Thomas worked for in recent years?
In recent years, Thomas has worked for Plusnet GmbH, audioprotect AG, elacin GmbH, EWR AG, and Deutsche Post.
Which industries is Thomas most experienced in?
Thomas is most experienced in industries like Information Technology (IT), Beauty and Cosmetics, and Telecommunication. Thomas also has some experience in Healthcare, Education, and Transportation and Logistics.
Which business areas is Thomas most experienced in?
Thomas is most experienced in business areas like Business Intelligence, Information Technology (IT), and Marketing. Thomas also has some experience in Sales.
Which industries has Thomas worked in recently?
Thomas has recently worked in industries like Beauty and Cosmetics, Telecommunication, and Utility Services.
Which business areas has Thomas worked in recently?
Thomas has recently worked in business areas like Business Intelligence, Information Technology (IT), and Marketing.
What is Thomas's education?
Thomas attended education in Wholesale and foreign trade merchant, fine paper.
Does Thomas have any certificates?
Thomas has 3 certificates. These include: MS Certified: Power BI Data Analyst Associate, Prince2 Scrum Master, and Data Protection Officer.
What is the availability of Thomas?
Thomas is immediately available full-time for suitable projects.
What is the rate of Thomas?
Thomas's rate depends on the specific project requirements. Please use the Meet button on the profile to schedule a meeting and discuss the details.
How to hire Thomas?
To hire Thomas, click the Meet button on the profile to request a meeting and discuss your project needs.
Average rates for similar positions
Rates are based on recent contracts and do not include FRATCH margin.
1000
750
500
250
Market avg: 770-930 €
Market avg: 770-930 €
The rates shown represent the typical market range for freelancers in this position based on recent contracts on our platform.
Actual rates may vary depending on seniority level, experience, skill specialization, project complexity, and engagement length.
Similar Freelancers
Discover other experts with similar qualifications and experience
Experts recently working on similar projects
Freelancers with hands-on experience in comparable project as a BI Consultant and Power BI Developer
Nearby freelancers
Professionals working in or nearby Cologne, Germany