Sven Ricke - Data Engineer
Data Engineer & Automation Specialist

Sven Ricke

Turning business requirements into scalable data solutions.

With 8 years of experience crafting intelligent automation systems and seamless data integrations, I transform complex data challenges into elegant, scalable solutions.

Services

Data Engineering

Building robust data pipelines and ETL processes

Automation

Streamlining workflows with intelligent automation

Integration

Connecting systems for seamless data flow

Data Migration

Post-merger data migrations ensuring consistency, integrity, and business continuity

Business Translation

Translating business and domain knowledge into code

Excel Expert

Enterprise VBA tools (legacy) - Everything can be done in Excel!

About Me

Problem Solver with International Experience

My Philosophy

I am a dedicated problem solver driven by a deep interest in understanding how businesses truly work beneath the surface. For me, technology is never the goal itself—it is a tool to translate business logic into robust, scalable and elegant solutions.

Rapid Adaptability

I have a strong ability to quickly adapt to new technology stacks and unfamiliar domains. This became especially evident when I successfully designed and implemented a complete ERP-to-Salesforce integration within just three months—despite having no prior integration background at the start. What matters most to me is not the specific tools used, but understanding the underlying processes, data flows, and constraints that define a system.

Tailored Solutions

I strongly believe that every project is unique. The key to a successful solution lies in deeply understanding the business logic, the existing architecture, and the operational reality—only then can the right technical design be crafted. My approach is analytical, pragmatic, and always tailored to the specific problem at hand, rather than applying generic, one-size-fits-all solutions.

International Experience

My four years of studying and playing football in the United States further shaped this mindset. They strengthened my English proficiency and, more importantly, taught me adaptability, discipline, and how to collaborate effectively with people from diverse cultural and professional backgrounds.

Fast Learner

Self-taught new technologies

International

4 years USA experience

Team Player

Empathetic and flexible

Innovation

Creative approaches

Problem Solver

Analytical and pragmatic mindset

Leadership

2+ years leading complex technical projects and teams

Technical Expertise

Specialized in data engineering, automation, and enterprise solutions

T-SQL

Expert

Python

Expert

VBA

Expert

SQL Server

Expert

ERP Systems

Expert

Salesforce

Expert

Data Migration

Expert

Microsoft Power Automate

Expert

ETL Pipelines

Expert

Workflow Automation

Expert

Data Integration

Expert

Document AI

Expert

REST API Development

Advanced

Business Intelligence

Advanced

Google Cloud Platform

Advanced

JavaScript/Node.js

Intermediate

SAP

Intermediate

Vercel

Intermediate

Projects

Key projects demonstrating technical expertise

AI-Powered Document Processing & Customs Automation

Currently developing AI-based automation solutions for international logistics operations, integrating complex customs clearance workflows with data processing systems. The project involves AI-based extraction and processing of invoices, integration with US customs clearance logic, Excel-ready data preparation and import modules, system integration and workflow optimization, custom automation architecture development, Vercel deployment and front-end development, and Google Cloud integration.

Node.jsDocument AIGoogle CloudREST APIVercelExcel AutomationERP Integration

Impact: Currently saving 4 FTEs (In Progress)

In Progress

Complete Salesforce Integration Suite

Full-scale Salesforce integration completed in 3 months. Implemented multiple data pipelines for various domains and objects with both unidirectional and bidirectional synchronization. Custom field mapping, workflow automation, and seamless ERP integration.

SalesforceREST APIData PipelinesERP IntegrationWorkflow Automation

Impact: Single source of truth enabling real-time, data-driven decisions

Real-Time Webshop-to-ERP Data Pipelines

Design and implementation of real-time data pipelines between webshops and ERP systems, including intelligent address matching (fuzzy matching), automated article creation in ERP, cross-department notifications, and seamless integration into existing business processes. Includes automated consumables ordering for contract customers, contract validation, input validation, customer-friendly consumables views, and automated model-to-cartridge mappings for fully automated contract-based ordering.

T-SQLERPFuzzy MatchingReal-time Pipelines

Impact: Fully automated ordering

Automated Service Billing & ERP Booking

Custom development of automated billing and accounting logic for service calls, fully embedded into ERP infrastructures using T-SQL scripting and custom business logic.

T-SQLERPAutomationBusiness Logic

Impact: 100% automated billing

Centralized Monitoring for M2M Devices

Aggregation of multiple M2M systems into a single monitoring platform, including threshold management and automated notifications when limits are exceeded.

M2MMonitoringIoTNotifications

Impact: Unified device monitoring

Salesforce Vendor Integration

Implementation of on-demand Salesforce integrations to make vendor articles searchable directly within Salesforce. Enables opportunity-based article selection and real-time purchase price validation.

SalesforceREST-APIIntegration

Impact: Seamless vendor integration

M2M Suite Integrations into ERP

Integration of multiple M2M platforms into ERP systems to enable automated ordering, threshold-based triggers, counter data synchronization, and fully automated billing processes.

M2MERPIoTAutomation

Impact: End-to-end automation

Contract Analytics & Evaluation Platform

Development of advanced contract evaluation tools for complex print and service environments. Consolidates contract revenues, fixed and variable income, service deployment costs, and operational expenses to provide full transparency across all contracts and enable data-driven business decisions.

Business IntelligenceSQLAnalyticsReporting

Impact: Complete contract transparency

Contract Usage & Overconsumption Analysis

Tools to track customer usage of contract-included services and compare actual consumption against contractual limits using complex business logic. Enables early detection of overusage and preparation of customer-facing reports.

SQLBusiness LogicAnalyticsReporting

Impact: Proactive usage tracking

Service Performance & Revenue Analytics

Analytics solutions to track field service engineers, including performance, proficiency, utilization, and revenue contribution.

Business IntelligenceAnalyticsKPI Tracking

Impact: Data-driven workforce insights

Logistics & Order Planning Tools

Development of database-driven planning tools that consolidate open orders and streamline logistics workflows, significantly improving operational efficiency.

SQLLogisticsPlanning Tools

Impact: Streamlined operations

Advanced SQL Consulting & Data Operations

High-impact SQL data manipulations, mass updates in production systems, and creation of cross-departmental reports to support critical business decisions.

SQLT-SQLDatabase Operations

Impact: Enabled critical data operations

ERP Backlog Cleanup & Optimization

Systematic cleanup and restructuring of ERP backlogs, including contracts, service calls, and operational data to restore process efficiency and data quality.

ERPData QualityT-SQLOptimization

Impact: Restored data integrity

Data Migration for Mergers & Acquisitions

End-to-end data migration during company acquisitions, including data cleansing, mapping, validation, and seamless integration into existing ERP landscapes.

ETLData MigrationERPData Quality

Impact: Zero-downtime migration

Technical Implementation of E-Invoicing (X-Rechnung)

Technical introduction and integration of X-Rechnung standards into enterprise billing and accounting processes.

X-RechnungXMLIntegrationCompliance

Impact: E-invoicing compliance

IT Consulting & Enterprise Architecture

Strategic consulting and hands-on expertise for integrating new systems into complex enterprise architectures.

Enterprise ArchitectureSystem Integration

Impact: Successful system integrations

Automated Lead Generation & Web Scraping

Web scraping solutions for automated lead generation, including data extraction from public sources and fully automated outbound acquisition emails for automotive suppliers.

PythonWeb ScrapingAutomation

Impact: Automated lead acquisition

Professional Experience

8+ years in Data Engineering & Automation

Jan. 2025 - Present

Freelance Data Engineer & Automation Specialist

Self-Employed
Remote

Providing expert data engineering and automation solutions to businesses. Specializing in complex integrations, workflow automation, and data-driven process optimization.

Python, T-SQL, VBA, JavaScript/Node.js, REST API DevelopmentSQL Server, ERP Systems, SAP, Salesforce, Data MigrationMicrosoft Power Automate, ETL Pipelines, Workflow Automation
Apr. 2021 - Present · 4 years

Business Data Engineer

GREEN IT Das Systemhaus GmbH
Dortmund, Germany (Hybrid)

Responsible for data-driven management and optimization of company-wide processes. Implementation of automation projects ranging from VBA solutions to CRM integration.

Real-time webshop-to-ERP data pipelines with fuzzy matching and automated article creationContract analytics and evaluation platform for complex print and service environmentsAutomated service billing and ERP booking logic
Jan. 2024 - Dec. 2025 · 2 years

Team Lead Project Management

GREEN IT Das Systemhaus GmbH
Dortmund, Germany (Hybrid)

Was responsible for coordinating and supporting internal projects to achieve lasting efficiency gains. Drawing on extensive expertise and data-driven problem-solving, I identified challenges and developed tailored solutions. In close collaboration with other team leaders, I implemented strategic company objectives and optimized business processes. In doing so, I oversaw major projects – from Salesforce integrations to complex migration processes in the context of acquisitions.

Close collaboration with other team leadersStrategic implementation of company objectivesOptimization of business processes
Oct. 2020 - Mar. 2021 · 6 months

Master Thesis - Balanced Scorecard

GREEN IT Das Systemhaus GmbH
Dortmund, Germany (Hybrid)

Automated Visualization of a Balanced Scorecard - Selection and Testing of Standard Software

Development of automated visualization solutionsEvaluation of standard softwareMaster thesis project
2017 - 2021 · 4 years

Student Assistant – Service Management & Executive Support

GREEN IT Das Systemhaus GmbH
Dortmund, Germany

Developed VBA, SQL, and T-SQL tools for performance analysis and management reporting. Optimized service and operational processes.

Developed VBA, SQL, and T-SQL tools for performance analysis and management reportingOptimized service and operational processesCreated customized reports for key customers and stakeholders

Education

Academic Background

Master of Science (M.Sc.)

Business Information Systems

Fachhochschule Dortmund
Sept. 2016 - March 2021
  • Master Thesis: Balanced Scorecard Automation
  • Focus on Business Intelligence

Bachelor of Business Administration (BBA)

Management and Information Systems

Francis Marion University
Sept. 2011 - Dec. 2015
  • Student Athlete Soccer
  • 4 years USA experience
  • International teamwork

Client References

What industry leaders say about my work

SQL Query
SELECT reference, testimonial, rating
FROM clients
WHERE manual_work = TRUE;
Result:
⚠️ 0 rows returned
All clients successfully automated. No manual work detected in the database.

Get in Touch

From manual work to smooth automation — let's talk.

Get In Touch

Feel free to reach out through any of these channels:

Quick Message

© 2025 Sven Ricke