frankeconsults GmbH is a specialized consultancy for data migration and data validation in ERP environments. We help companies transfer data from existing systems into new ERP systems in a structured, traceable and reliable way - often in SAP environments, but also in Microsoft Dynamics and other ERP systems.
We combine business process understanding with technical implementation: from the first data extract through transformation and validation to a successful go-live.
As part of a small, specialized consultancy, you will work closely with clients and contribute to real projects and decisions. During the trainee program, you will receive structured guidance and learn directly from experienced consultants.
ERP data migration sits at the intersection of data, business processes and technology. It involves questions such as: Which data is needed in a new system? How should customer, supplier, material or financial data be structured? And how can we prove that migrated data is complete and correct?
You do not need to know the answers yet. The six-month trainee program is designed for people who want to build both the functional and technical foundations from the ground up. A completed university degree is required, but it does not have to be in business or IT. Previous experience in ERP systems, data migration, SQL or consulting is not required.
You will learn how ERP data migrations are planned, implemented and validated. Step by step, you will move from guided exercises to supervised work on real client projects.
The program is intended to prepare you for a Junior Consultant role. After six months, a permanent transition may be possible depending on your development, performance and mutual fit; it is not an automatic guarantee.
The trainee program has three connected phases:
-
Build the foundations: You learn how common business processes, ERP systems, data structures and migration projects fit together.
-
Develop practical skills: You work with Excel, SQL, Power Query and data-validation methods. You also learn to use AI tools responsibly for analysis, documentation and workflow support, to verify their results critically, and to respect data-protection and client requirements.
-
Apply what you have learned: You join real project work under close guidance and gradually take on clearly defined tasks and responsibility.
During the program, you will:
-
learn to analyze and understand data structures in source and target systems
-
prepare, transform and validate data with Excel, SQL and Power Query under guidance
-
build an understanding of business processes in areas such as finance, purchasing, logistics and sales
-
support the documentation of migration rules, assumptions and results
-
use suitable AI applications responsibly to support analysis, documentation and recurring workflows
-
check AI-assisted and manually produced results for accuracy and traceability
-
gain insight into client meetings and help prepare project workshops
-
contribute to our internal templates, methods and tools
-
gradually take on supervised tasks for individual migration objects such as customers, suppliers, materials or financial data
You need a completed university degree, but it does not have to be in business or IT. No particular professional background is required. You are a good fit for us if you:
-
genuinely want to learn about data, business processes and ERP systems
-
enjoy analyzing information, recognizing patterns and understanding how things connect
-
work carefully, reliably and with attention to detail
-
are comfortable using everyday digital tools and willing to learn Excel, SQL, Power Query and AI-supported ways of working
-
ask questions, accept feedback and actively take responsibility for your learning
-
communicate openly and enjoy working with others, including in a remote setting
-
have German skills at roughly C1 level and English skills at roughly B2 level; certificates are not required
Previous knowledge of ERP systems, SQL, data migration or consulting is not expected.
-
A structured six-month learning path covering functional and technical foundations
-
Close mentoring and direct collaboration with experienced consultants
-
Practical training in Excel, SQL, Power Query, data validation and the responsible use of AI tools
-
Gradual involvement in real client projects with clearly guided responsibilities
-
A possible transition into a permanent Junior Consultant role based on your development, performance and mutual fit
-
A small, specialized team with short communication paths
-
Flexible working hours
-
The option to work fully remotely within Germany or from our Cologne office
-
30 vacation days per year, granted pro rata for the six-month term
-
Access to Udemy Business for your professional and technical development
-
Depending on the project, up to 20% travel
We want to keep the process simple and transparent:
-
Short introductory conversation
We talk about you, your motivation and what you want to learn during the trainee program. -
Practical interview with a small data exercise
Together, we work through a small data-structuring task to understand how you think and learn. You do not need prior ERP or SQL knowledge. -
Decision and shared start date
If it is a good fit for both sides, we clarify the next steps and the start of the six-month program.
You do not yet have a technical or functional background in data migration, but you want to learn, think analytically and work carefully? That is exactly who this trainee program is designed for.
You do not need a traditional cover letter. Send us your CV and a few specific sentences about why you want to learn data management and ERP data migration.
Use the application form or send your application to: [email protected]
We welcome applications from all people - regardless of gender, origin, religion, disability, age or sexual orientation. Feel free to tell us how you would like to be addressed, for example with your preferred name or pronouns.
