SQL Server Integration Services Experts in Germany
for reliable data pipelines, matched in minutes with vetted professionalsHire experts who design SSIS packages, migrate legacy DTS workflows, connect SQL Server with external systems and improve data quality across reporting environments. FRATCH finds a precise match with vetted, available freelancers quickly.
Meet FRATCH Experts in Germany, who have recently used SQL Server Integration Services
Any-Arlene N.
Last position:
Co-Founder · Data Engineering & Backend at zirikana (Kirundi Bible Web App) – Civic Technology
- Built a Python pipeline that converts lectionary web content into structured daily JSON, applying liturgical-calendar rules for accurate weekday and Sunday coverage.
- Shipped a read-only FastAPI REST API with shared Pydantic models and delivered a Kirundi-first web client for browser and mobile use.
- Owned the data layer and backend architecture, collaborating closely on system architecture and interfaces while automating refreshes with GitHub Actions and validating the ETL with pytest.
- Impact: Created a reliable, API-driven source of truth for daily Bible readings in Kirundi, enabling consistent access to previously unstructured content.
Matthias W.
Last position:
Freelance Consultant Business Intelligence (Self-employed) at mw-consult.it
Data Engineering
Business Analyst
Consulting
2025 – present
Data Engineer & Architect
- Azure Data Factory
- Azure Databricks (PySpark)
- PowerBI Service
Lead developer for the further development of the Modern Data Warehouse, as well as Power BI reports and data models based on the ERP systems Amparex and EyeOffice. Focus on topics for the marketing department with data connection via API to Amplitude and Klaviyo with Python
- 2024 – present
Data Engineer & Architect
- SQL Server (T-SQL)
- SSIS (ETL)
- SSAS Tabular
- PowerBI Report Server
- Atlassian Jira & migration to Azure DevOps with GIT (KANBAN)
Development of Power BI reports and data models based on Infor LN ERP data after migration from Baan, including the underlying data structures with Microsoft SQL Server for further development of the Data Warehouse
Consulting for controlling on the specification of business requirements and development of reporting solutions
- 2025 – 06.2025
Data Engineer & Architect
- PowerBI Dataflows
- PowerBI Service
Cloud migration of the Data Warehouse, as well as Power BI reports and data models from Microsoft Dynamics BC 2021 to Microsoft Dynamics BC Cloud, including migration of the underlying data structures from Microsoft SQL Server to Power BI Dataflows
- 2022 – 06.2024 (ongoing support for data engineers)
Data Engineer & Architect
- SQL Server (T-SQL)
- SSIS (ETL) & BIML
- SSAS Tabular
- Azure DevOps with GIT (SCRUM)
Development of analytical models based on Microsoft Dynamics BC 2021 in combination with data from the company's own MariaDB database, including the setup of the underlying data structures with Microsoft SQL Server to build a Data Warehouse. Merging of the ERP systems BC 2021 and DATEV in the Data Warehouse
Consulting for business users on the specification of business requirements and coaching of developers for the development of reporting solutions
- 2022 – 08.2023
Business Analyst & Interim Manager
- PowerBI Service
- Azure Databricks (PySpark)
- Atlassian Jira (SCRUM)
Project management for reporting solution requirements, as well as development of Power BI reports and data models with data from Azure Databricks based on SAP R/3, Google Analytics, webshop and CRM with a business focus on customer, sales and marketing
- 2022 – 05.2022
Power BI Specialist
- PowerBI Service
- Azure DevOps with GIT (SCRUM)
Development of Power BI reports and data models based on data from Exasol with a business focus on assortment management in purchasing
- 2021 – present (ongoing support for existing customers)
Power BI Specialist & Data Engineer
- SQL Server (T-SQL)
- SSIS (ETL) & BIML
- PowerBI Service
- Azure DevOps with GIT (KANBAN)
- Azure Functions (Python)
Development of Power BI reports and data models based on abas ERP data, including the setup of the underlying data structures with Microsoft SQL Server to build a Data Warehouse.
Synchronization of customer data for Pipedrive CRM via Azure Functions with Python.
Consulting for controlling and management on agile project management, the specification of business requirements and development of reporting solutions
- 2021 – present (ongoing support for existing customers)
Data Engineer & Architect
- SQL Server (T-SQL)
- SSIS (ETL) & BIML
- SSAS Tabular
- Azure DevOps with GIT (SCRUM)
Development of analytical models based on Microsoft Dynamics 365 FO, CS & CRM in combination with Microsoft Dynamics AX 2012 R3, including the setup of the underlying data structures with Microsoft SQL Server to build a Data Warehouse
Concept for the migration of the SQL Server-based Data Warehouse to Microsoft Fabric with planned future implementation and temporary use of a hybrid data architecture for the introduction of Power BI Service during the migration phase
Consulting for business users on the specification of business requirements and development of reporting solutions
Michael T.
Last position:
ETL Developer at Insurance service provider
DWH for customer and financial data
- Extension of the DWH with new data sources
- Report development
- Data quality management
Methodology: Scrum
Tools: Atlassian Confluence & Jira
Databases: Microsoft SQL Server
Programming languages: SQL, T-SQL
ETL: Microsoft SQL Server Integration Services (SSIS)
Frontend platform: PowerBI, Microsoft Reporting Services
Olga M.
Last position:
Telefónica Deutschland Holding AG
- Implemented the BI solution and replaced the old BI landscape
- Led the “Sales Bonus Plan” subproject: expanded the existing solution and migrated to Azure (Databricks)
- Led the “Cognos Migration” subproject: expanded existing data warehouses based on MS technologies (source systems: Oracle), analyzed business requirements and designed the technical solution
- Expanded the relational DWH database
- Developed ETL processes using SSIS
- Developed the multidimensional database (OLAP Cubes/SSAS)
Mario T.
Last position:
Project Lead/Manager / Consultant at all-BI GmbH
- Establishing the Microsoft Fabric platform with the company as the central data warehouse and reporting system.
- The company migrated several operational systems including D365 to new version. The new data warehouse is based on a Fabric/Power BI architecture with Azure cloud Entra Authentication.
Tasks Performed:
- Full administrative responsibility for the Fabric platform F64 and F32 capacities, as well as two F8 capacities for development and prototyping.
- Integration of Fabric with Microsoft Entra.
- Data modeling for the data warehouse bronze, silver and gold layers using data modeling tools.
- Star Schema as well as entity relationship modeling.
- Data modeling for data marts and for dimensional modeling and Power BI (semantic model).
- Design of data models for Microsoft SSAS multidimensional and tabular OLAP cubes using DAX and MDX.
- Definition of design patterns for the ETL team for loading OLAP cubes (Tabular and MD), star schemas and data vault structures.
- Planning and managing team of 4 ETL and reporting developers.
- Performance Tuning of Power BI reports, particularly the semantic layer, as well as the Fabric notebooks
- SQL Performance Tuning.
- DB Design for Azure SQL.
- Reporting directly to project senior management.
Label: Power BI, Fabric, Analysis Services (multidimensional and tabular), D365, SSIS, Tabular Editor, SQL Server and Azure SQL, TOAD Data Modeler, DBSchema, Visual Studio Code, DAX Studio, SSMS, Visual Studio, Jira and Confluence.
Ernst H.
Last position:
Support/Development/Consulting – Process Development, E-Invoicing, XRechnung, ZUGFeRD
- Support and further development of a complex process for creating XML documents for electronic invoices / E-Invoicing (XRechnung, ZUGFeRD)
- Automation of operational processes, process development and optimization
- Development of frontend applications with MS Power Apps
- Porting SQL Server 2016 to SQL Server 2022
- SQL Server database administration
Vincent R.
Last position:
Freelancer at VINROTLAB.IO
- Consulting and creation of various web applications based on SharePoint and the React framework for different clients
- Development and testing of accessible apps for SharePoint
- Creation of various test cases for test automation
- Development of various solutions based on Azure
- Creation of various web services based on .NET
- Development of various SharePoint Framework solutions
- Development of various UI solutions based on SharePoint
- Consulting and creation of various Power Apps applications and Power Automate for the steel industry and an IT consulting company
- Support, consulting, and development with offshore teams for SharePoint 2013, 2016, and microservices for a logistics company
- Consulting, concept design, and development of microservices and web applications based on Microsoft technology and the React framework for a logistics company
- Consulting, concept design, and development of various SharePoint Framework solutions on SharePoint 2016 for logistics
- Consulting for the migration from SharePoint 2010 to 2016 for an IT consulting company
Umut G.
Last position:
Data Architect at BA Technology
I am an experienced data engineer specializing in end‑to‑end data integration, cloud DWH architectures, and high‑quality, governed data products.
I delivered following projects and engagements as a freelancer.
- Data Migration of CRM System for AL-FA Objekt Service Gmbh
- Microsoft Software Resales Partnership
I am looking for freelance roles like: Freelance Data Engineer Cloud Data Warehouse Architect Data Modeling & Architecture Consultant MDM & Data Governance Specialist BI & Analytics Developer
Technical Focus Areas
- Data Engineering & Integration: SQL Server/SSIS, Informatica PowerCenter/IDQ, Talend, Kafka, Azure Data Factory – Delta/CDC/ELT patterns, robust pipelines, monitoring/recovery, data lineage & impact analysis, medallion architecture Bronze/Silver/Gold layers
- DWH & Cloud: Azure SQL / Data Lake / Synapse, AWS Redshift/S3, on‑prem SQL/Oracle – scalable data marts with a strong cost/benefit focus.
- Data Modeling: Atomic (Inmon) and Dimensional (Kimball), Data Vault (Linstedt), Domain‑Driven Design, clear lineage & contracts.
- MDM & Governance: Informatica MDM, IBM MDM, stewardship processes, data quality rules, survivorship/XREF, catalog/glossary, SIF/BES/REST publication.
- Analytics/BI: Power BI, SSAS, Cognos – business‑ready, maintainable data products.
Henok A.
Last position:
Founder and Managing Director at Afworki GmbH IT-Consulting
The goal of Afworki GmbH IT-Consulting is to make small and medium-sized companies more competitive by overcoming challenges in digitalization, automation, and data management.
Tailored technology, strategy, and specialist consulting designed to meet the individual needs of each company.
Analyzing the company's current situation and developing the best possible solution together with the client.
Using both agile and classical IT project management methods to deliver projects on time and within budget.
Focusing on automating and orchestrating all data flows in a data warehouse to create a unified and standardized data foundation.
Considering the dependencies between IT and business to achieve sustainable positive effects.
Employing modern strategies and tools specifically tailored to the company's needs.
Supporting digitalization, the introduction of agile working methods, and the creation of up-to-date reports and analyses.
Objective: streamlining management and enabling well-founded, data-driven decision-making.
Markus I.
Last position:
Senior System Engineer Microsoft at Technidata IT-Service GmbH
As part of the project, I was responsible for operating a Citrix farm for 600 users, including optimizing the user experience and ensuring high availability.
I managed and optimized the entire application landscape of a major customer, evaluated and implemented application updates, and ensured the compatibility and security of the software in use.
I managed user accounts, implemented security policies, and monitored system performance.
I administered Azure Entra ID to control identities and access rights, implemented security policies, and synchronized on-premises directories with the cloud.
I implemented and managed Microsoft Intune for central management of client devices, including the configuration and management of BitLocker for disk encryption.
I managed file servers and NTFS permissions to ensure secure and efficient data access management.
I handled change requests and last-level support tickets efficiently to solve complex system issues and improve user satisfaction.
I supported and advised the customer team on various topics and projects, identified areas for improvement, and implemented best practices.
Technologies used:
- Citrix XenApp and XenDesktop
- Microsoft Windows Server 2012R2 and 2022
- Exchange 2016 and Exchange Online
- Entra ID (Azure AD)
- Entra ID Connect
- BitLocker
- PowerShell scripting
- Microsoft Intune
- LDAP (Lightweight Directory Access Protocol)
- DNS services (Domain Name System)
- Active Directory Certificate Services (AD CS)
Tobias E.
Last position:
C# Fullstack Developer / Scrum Master / Product Owner Cloud Services / Product Owner Infrastructure & Core Services / Head of at TRUMPF Werkzeugmaschinen SE & Co. KG
- Many years of work in different roles within the MES product area, with technical development, agile leadership, and strategic product responsibility for key MES components.
- As C# Fullstack Developer / Scrum Master (2018–2020): further development of a programming system for laser machines, introduction and moderation of Scrum processes, quality assurance through automated tests and documentation.
- As Product Owner Cloud Services (2019–2020): leadership of two AWS-based cloud services for providing laser data and legal documents, definition of the product vision, backlog maintenance, and stakeholder communication.
- As Product Owner Infrastructure & Core Services / Head of DevOps / Product Security (2020–2025): responsibility for core MES components such as Service Orchestrator, Licensing Service, IAM, and AppLauncher, building and maintaining Azure DevOps pipelines for over 70 components, and introducing security standards (CRA).
- Company-wide contact for Azure DevOps and largely responsible for its introduction.
- Standardized versioning of all components.
- Structuring of CI/CD and release pipelines.
- Building an agent scale set with special software configuration.
- Connecting Azure DevOps with ServiceNow.
- Standardizing the integration of security tools such as SonarCloud, Dependency Track, and digital signing.
- Technologies & tools: .NET (C#, 4.8 / Core 3.x / 8), WPF, WCF, REST, OData, JSON, DevExpress, Duende IDP, Azure DevOps, AWS, PowerBI, SonarCloud, Dependency Track, Visual Studio Pro.
- Method: Scrum.
- Project language: German / English.
Moez S.
Last position:
Data Engineer at Loschelder Rechtsanwälte Partnerschaftsgesellschaft mbB
- Designed a future-proof client database for marketing purposes
- Analyzed requirements, designed, and modeled an entity-relationship model
- Consolidated and optimized a client file from various data sources for targeted marketing campaigns
- Worked closely with marketing and IT in an agile environment to iteratively develop the solution
- Technologies and methods: MS Office (mainly Excel), MS Dynamics CRM, MS SharePoint
Hicham M.
Last position:
Freelance Software Developer at Buhl Data Service GmbH
- Backend development: .Net 8, C#, PostgreSQL, Entity Framework Core, REST Web APIs, Docker, Kubernetes, Kafka, Open API Swagger, Apache Airflow, Resharper, Git, Microservices, SOAP, gRPC, Hangfire, OAuth 2, GraphQL
- Interface development for document processing with SmartFix, Softexpansion and Natif.ai: C#, REST API, Resharper, Git
- Deployment: Azure DevOps YAML, Vanilla Helmchart, Rancher, Kubernetes Cluster, Linux Docker, Windows VM, Python
- Unit tests and integration tests
- Telemetry, Kibana, Grafana, Elastic Search
- Work in a Kanban team of 8 developers, 1 tester and one Product Owner
Bernd S.
Last position:
Business Data Analyst | PowerBI & Microsoft SQL Server at 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
Asım Y.
Last position:
Freelance BI/DWH/ETL Specialist at Akbank
- Setting architectural standards for Informatica Power Center development teams
- Maintenance-performance-health for DWH (Exadata) environments
- Qlik Sense / BO reports architectural standards
- Implementing best practices in ETL tasks
- Documentation ETL standards on Confluence
- Dynamic Data Masking rules for GDPR/KVKK regulations by using Informatica DDM tool
- DWH Data model Power Designer
- Upgrade Qlik Sense versions
- Merge all Informatica server's repository databases on one Oracle DB
Discover over 15,000 top freelancers
Statistics of experts using SQL Server Integration Services
Aggregated from the professional profiles of matched freelancers.
Experience
22 years
Position duration
3.2 years
Positions per freelancer
15
Top business areas
Information Technology, Business Intelligence, Project Management
Top industries
Information Technology, Banking and Finance, Manufacturing
Certification focus areas
Information Technology, Project Management, Product Development
Bachelor's degree or higher
83%
Master's degree or higher
61%
Doctorate
12%
Certifications per freelancer
3
Most common languages
German, English, French
Speak two or more languages
97%
Based on our profile pool as of 19 Sep 2026.
Daily rate distribution
The chart shows how the daily rates of freelancers in this technology in Germany are distributed, based on recent contracts on our platform. Each bar covers a rate range — its height shows how many freelancers charge within that range.
Average rates of experts in Germany using SQL Server Integration Services
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 19 Sep 2026. Actual rates may vary depending on seniority level, experience, skill specialization, project complexity, and engagement length.
SQL Server Integration Services experts industry focus
See which industries our matched freelancers work in most often — every figure is calculated live from the freelancers on FRATCH.
- Information Technology (92%)
- Banking and Finance (62%)
- Manufacturing (50%)
- Professional Services (50%)
- Automotive (43%)
- Healthcare (40%)
- Telecommunication (40%)
- Retail (38%)
Please note that freelancers can work across multiple industries, so percentages overlap.
About the technology
What SSIS does
SQL Server Integration Services, commonly called SSIS, is Microsoft’s platform for extracting, transforming and loading data. It orchestrates repeatable workflows between SQL Server, files, APIs, business applications and cloud services. Teams use it to prepare trusted data for reporting, analytics, migration and operational processes.
Core packages and flows
SSIS solutions are built from packages that define control flow, data flow, event handling and dependencies. Professionals configure sources, transformations, destinations, variables, parameters and expressions so each workflow can run consistently.
- Import and export structured or flat-file data
- Clean, validate and reshape records
- Schedule dependencies and error handling
- Load warehouses and reporting databases
Ecosystem and tooling
SSIS works closely with SQL Server, SQL Server Agent, Visual Studio and the Integration Services Catalog. Common work also involves T-SQL, stored procedures, SSISDB deployment, Windows authentication, PowerShell and monitoring through logs and execution reports. Azure Data Factory may complement or gradually replace SSIS in cloud-focused architectures.
Where companies use it
Companies bring in SSIS specialists for data warehouse loading, finance and operations reporting, master-data flows and system migrations. German organizations often run it inside established Microsoft estates, where reliable collaboration with internal database, security and reporting teams matters. Remote delivery works well when environments, access rights and deployment routines are documented.
- Modernize legacy DTS or SSIS packages
- Connect ERP, CRM and SQL Server data
- Build incremental and historical loads
- Investigate failed executions and data gaps
When freelance expertise helps
External expertise is useful when packages have become difficult to maintain, migrations are blocked by hidden dependencies or delivery deadlines exceed internal capacity. A strong professional can audit existing workflows, identify bottlenecks, establish deployment standards and transfer practical knowledge to the permanent team. Clear German or English communication may be important for distributed projects.
What distinguishes strong specialists
The best SSIS professionals understand both the package designer and the wider data architecture. They test row counts, keys, null handling, conversions, retries and restart behavior instead of treating a successful run as proof of quality. They also document lineage, protect credentials, separate environments and make failures visible through useful alerts and logs.
Frequently asked questions
Quick answers to the questions that come up most around SQL Server Integration Services.
SQL Server Integration Services is used to move and transform data between databases, files, applications and services. Companies commonly use SSIS for warehouse loads, reporting preparation, data cleansing, recurring imports and system migrations.
SSIS is often a strong fit for established SQL Server environments, complex package logic and workloads that depend on Windows-based infrastructure. Azure Data Factory is usually considered when orchestration, cloud connectivity and managed scaling are central; some projects combine both.
A capable SQL Server Integration Services professional usually works comfortably with T-SQL, relational modeling, SQL Server Agent and SSISDB deployment. Experience with Visual Studio, PowerShell, Azure Data Factory, source-system APIs and data-quality controls can also be valuable.
The required level depends on package complexity, data volume, security constraints and the number of source systems. A simple import may need focused SSIS knowledge, while a warehouse migration calls for a professional who can handle lineage, performance, recovery and production operations.
Yes. SQL Server Integration Services work can usually be delivered remotely when the professional has secure access to development and test environments, clear deployment procedures and reliable technical contacts. On-site sessions may still help with workshops, restricted systems or complex handovers in Germany.
Ask for examples of package design, deployment, troubleshooting and data validation rather than only tool familiarity. A strong SSIS professional can explain restartability, logging, incremental loads, error outputs and how they protect sensitive connection details.
SQL Server Integration Services can support hybrid scenarios when on-premises SQL Server data must connect with cloud services or managed warehouses. The design should account for gateways, network access, authentication, scheduling and whether selected workloads belong in Azure Data Factory instead.
Typical issues include implicit data conversions, inefficient lookups, hard-coded paths, weak error handling and packages that cannot restart safely. An experienced SQL Server Integration Services specialist traces dependencies, measures execution behavior and improves monitoring before changing production logic.
The average hourly rate of freelancers in Germany who have used SQL Server Integration Services in their recent projects is 99 €, which corresponds to a daily rate of about 791 € based on an 8-hour working day.
Of the freelancers in Germany who have used SQL Server Integration Services in their recent projects, 83% hold at least a Bachelor's degree, 61% hold at least a Master's degree, and 12% hold a doctorate.
On average, freelancers in Germany who have used SQL Server Integration Services in their recent projects have 22 years of professional experience, with a single engagement typically lasting around 3.2 years.
The most common languages among freelancers in Germany who have used SQL Server Integration Services in their recent projects are German (100%), English (97%), and French (25%).
The most common industries among freelancers in Germany who have used SQL Server Integration Services in their recent projects are Information Technology (92%), Banking and Finance (62%), and Manufacturing (50%).
The most common business areas among freelancers in Germany who have used SQL Server Integration Services in their recent projects are Information Technology (98%), Business Intelligence (87%), and Project Management (72%).
Main locations of FRATCH Experts, who have recently used SQL Server Integration Services
Our freelancers and interim experts are at home across the DACH region — available on-site in the major business hubs or fully remote. Choose a location to discover matched specialists, local market insights and up-to-date availability.
Munich 
Frankfurt Countries:
- Germany
- Austria
- Switzerland
Request a free demo
Get in touch with the FRATCH team and we will get back to you within 4 hours.
Would you rather directly get in touch?
We always have the time for a call or email!
Philipp Thomaschewski
FRATCH CEO
