Rainer S.-Senior Data Engineer | Data Warehouse Architect | BI Consultant
Check rate
Experience
Data Engineer | Data Analyst | Power BI Architect
Banking project
- Analyzed and built a report store with the related data integration workflows.
- Developed and optimized T-SQL stored procedures and SSIS packages for data preparation and loading.
- Developed Power BI reports and delivered business reporting requirements.
Technologies: SQL Server, T-SQL, SSIS, Power BI, Visual Studio 2022, PowerShell, VBA, .NET
Independent Technical Training
Microsoft Fabric / OneLake
- Courses and independent learning in Microsoft Fabric, OneLake, Azure, and Power BI.
Technologies: Microsoft Fabric, OneLake, Azure, Power BI
C# / .NET Developer
Small business / CRM application
- Designed and developed a web-based CRM application using C#, Blazor, and SQL Server.
- Database design, application development, testing, and data analysis with Power BI.
Technologies: SQL Server, C#, Entity Framework, Blazor, Syncfusion, .NET, Power BI
Senior Consultant and Developer
PostFinance
PostFinance | Banking
- Expanded an existing management information system with ETL workflows, reporting, and analysis models.
- Implemented SSIS workflows, stored procedures, SSRS reports, and SSAS cubes.
- Coordinated with business units and delivered work as part of a Scrum team.
Technologies: SQL Server, SSIS, SSRS, SSAS, T-SQL, Visual Studio, C#, .NET
Senior Consultant | Architect | Developer
Swiss Life
Swiss Life | Insurance
- Expanded existing analysis cubes and their related data loading processes.
Technologies: SQL Server 2019, SSAS, MDX, Visual Studio, C#, Python
Senior Consultant | Architect | Developer
Munich Re
Munich Re | Insurance
- Designed and developed a large SSAS Tabular model with complex historical tracking.
- Integrated, quality-checked, and normalized data from different source systems.
- Designed and expanded data warehouse structures, analytical models, and ETL pipelines.
- Worked closely with business teams to deliver technical solutions for complex analytical requirements.
Technologies: SQL Server, SSIS, SSAS Tabular, Power BI, DAX, T-SQL, C#, Python, R
Senior Consultant | Architect | Developer
Banking project
- Contributed to loading an Azure-based data warehouse and developing Power BI solutions.
- Implemented role-based access and provided training while coordinating with the client.
Technologies: Azure SQL, Azure Data Pipeline, Databricks, Power BI, Visual Studio, C#, SSAS, MDX
Senior Consultant | Architect | Developer
Software company
- Designed and implemented a data warehouse for data from a standard software product.
- Developed an extendable Power BI dataset with role-based security, dashboards, and metrics.
- Held workshops with stakeholders and coordinated with clients and internal IT.
Technologies: SQL Server 2019, Power BI, DAX, .NET
Microsoft DAT207x Zertifikat
edX
- Earned the Microsoft DAT207x certificate through edX.
- Completion date: 21.01.2020.
Senior Consultant | Architect | Developer
Swiss Life
Swiss Life | Insurance
- Integrated SAP data and other sources into a SQL Server data warehouse.
- Developed stored procedures, delta loads, and historical tracking.
- Designed and migrated data warehouse structures to Data Vault.
- Implemented partitioning at the relational and cube levels, SSAS models, and custom role-based access.
Technologies: SQL Server 2019, SSIS, SSAS, T-SQL, C#, PowerShell, REST, Azure DevOps, Git, Power BI
Senior Consultant and Developer
Vitra
Vitra | Industrial Design
- Integration of SAP, Tagetik and other sources into a SQL Server 2016 DWH.
- Development of Stored Procedures and extension of SSAS cubes with incremental loading, security and MDX.
Technologies: SQL Server 2016, SSAS, T-SQL, MDX
Senior Consultant and Developer
Adveq AG
Adveq AG | Financial Services
- Integration of heterogeneous data sources into a SQL Server DWH.
- Development of Stored Procedures, data mart views and SSRS reports.
Technologies: SQL Server 2016, SSRS, C#, VB.NET, DevExpress, Java, React
Senior Consultant | Architect | Developer
Swiss Life
Swiss Life | Insurance
- Rule-based data migration to Abacus using mapping tables and Stored Procedures.
- Documented processing of around 10'000 records in less than one second.
Technologies: SQL Server 2012, C#, Abacus
MCSA: SQL Server 2012/2014
Microsoft
- MCSA: SQL Server 2012/2014 certification.
- Certification year: 2016.
- Issued via Acclaim.
MCSE: Data Management and Analytics
Microsoft
- MCSE: Data Management and Analytics certification.
- Certification year: 2016.
- Issued via Acclaim.
Senior Consultant and Developer
Zurich Insurance
Zurich Insurance | Insurance
- Loading a data warehouse from multiple source systems using WhereScape.
Technologies: SQL Server 2012, Oracle 11, WhereScape
Microsoft Certified Solutions Expert: Business Intelligence
Microsoft
- Microsoft Certified Solutions Expert (MCSE).
- Specialization: Business Intelligence.
- Certification number: E559-5838.
- Achievement Date: 20.12.2013.
- Inactive Date: 20.12.2016.
Microsoft Certified Solutions Associate: SQL Server 2012
Microsoft
- Microsoft Certified Solutions Associate (MCSA).
- Certification version: SQL Server 2012.
- Certification number: E517-2808.
- Achievement Date: 20.12.2013.
Microsoft Certified IT Professional: Business Intelligence Developer 2008
Microsoft
- Microsoft Certified IT Professional (MCITP).
- Specialization: Business Intelligence Developer 2008.
- Certification number: E166-8518.
- Achievement Date: 13.02.2013.
Microsoft Certified Technology Specialist: SQL Server 2008, Business Intelligence Development and Maintenance
Microsoft
- Microsoft Certified Technology Specialist (MCTS).
- Certification version: SQL Server 2008, Business Intelligence Development and Maintenance.
- Certification number: E147-9454.
- Achievement Date: 16.01.2013.
Microsoft Certified Professional
Microsoft
- Microsoft Certified Professional.
- Certification number: E092-1384.
- Achievement Date: 21.11.2012.
- Microsoft Certification ID: 6947123.
- Last activity in the Microsoft Certification Profile: 20.12.2013.
Industry experience
See where this freelancer has spent most of their professional time.
Experienced in Banking and Finance, Insurance, Information Technology, and Manufacturing.
Business area experience
See which departments and functions this freelancer has contributed to most.
Experienced in Business Intelligence, Information Technology, and Product Development.
Summary
Senior Data Engineer and Data Warehouse Architect with over 20 years of experience in software development, enterprise data warehousing, business intelligence, and data modeling. Extensive project experience in banking, financial services, and insurance. Key areas include data integration, ETL/ELT, SQL performance, data quality, historical data management, and maintainable data architectures. Extensive experience delivering work independently and collaborating with business units and IT teams.
Skills
- Etl, Dwh, And Cube Developer And Architect
- Database Design And Security
- Microsoft Fabrics, Power Bi, Ssas
- Sql, T-Sql, Mdx, And Dax
- Databases: Azure Sql Server, Full-Stack Ms Sql Server (2012 To 2022), Oracle, Sap, Access
- .Net Framework, C#, Java, Javascript, R, Python, Angular, Blazor, Restful Services, Vba
- Ms Dev Ops, Git
- Various Etl Tools (Informatica, Ssis, Odi)
- Dwh Architecture And Data Modeling
- Etl/Elt
- Sql Optimization
- Ssas Tabular / Multidimensional
- Data Vault
- Data Migration
- Role-Based Security
- Reporting
- Ssrs
- Azure Databricks
- Azure Data Pipelines
- Powershell
- Entity Framework
- Onelake
- Dbt
- Hadoop
- Data Lake
Languages
Education
Fachhochschule Konstanz
Diplom Informatiker (FH) · Computer Science
Certifications & licenses
Microsoft Dat207x Zertifikat
edX
MCSA: SQL Server 2012/2014
Acclaim
Microsoft® Certified Solutions Associate
Microsoft® Certified IT Professional
Microsoft® Certified Technology Specialist
Independent training in Microsoft Fabric, OneLake, Azure, and Power BI (ongoing)
IPMA Project Manager
Panorama Necto
Statistics
Experience
Global experience
Expertise
Qualifications
Frequently asked questions
Have questions? Find more information here.
Rainer is based in Kreuzlingen, Switzerland.
Rainer speaks the following languages: German (Native), English (Advanced).
Rainer has at least 13 years of experience. During this time, Rainer has worked in at least 13 different roles and for 8 different companies. The average length of individual experience is 1 year and 7 months. Note that Rainer may not have shared all experience and actually has more experience.
Based on recent experience, Rainer would be well-suited for roles such as: Data Engineer | Data Analyst | Power BI Architect, Independent Technical Training, C# / .NET Developer.
Rainer's most recent position is Data Engineer | Data Analyst | Power BI Architect.
In recent years, Rainer has worked for PostFinance, Swiss Life, and Munich Re.
Rainer is most experienced in industries like Banking and Finance, Insurance, and Information Technology. Rainer also has some experience in Manufacturing.
Rainer is most experienced in business areas like Business Intelligence, Information Technology, and Product Development.
Rainer has recently worked in industries like Banking and Finance, Insurance, and Information Technology.
Rainer has recently worked in business areas like Business Intelligence, Information Technology, and Product Development.
Rainer attended Fachhochschule Konstanz for Computer Science.
Rainer has 12 certificates. Among them, these include: Microsoft Dat207x Zertifikat, MCSA: SQL Server 2012/2014, and MCSE: Data Management And Analytics.
Rainer is immediately available full-time for suitable projects.
Daily rate distribution
The rates shown represent the typical market range for freelancers in this position based on recent contracts on our platform.
Average rates for similar positions
Rates are based on recent contracts and do not include FRATCH margin.
The average daily rate is the mean of all daily rates from recent contracts of comparable freelancers on our platform.
The median daily rate is the middle value of all daily rates — half of comparable freelancers charge less, half charge more. Unlike the average, it is barely affected by outliers.
Calculated based on our freelancers’ daily rates as of 13 Nov 2026. 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
Marco S.
Stefan C.
Reinhold S.
German P.
Germo G.
Vitali H.
Torsten G.
Stefan W.
Petru K.
Guido K.
Experts recently working on similar projects
Freelancers with hands-on experience in comparable project as a Data Engineer | Data Analyst | Power BI Architect
Stefan D.
Evrim I.
Tim S.
Bernd S.
Michael T.
Christian P.
Ronny H.
Eric B.
Mario T.
Christian D.
Nearby freelancers
Professionals working in or nearby Kreuzlingen, Switzerland
Pedro M.
Martin Z.
Mike B.
Roger V.
Damir M.
Claus N.
Paul V.
Bertram D.
Ioannis K.
Justin R.
