Job
In this role, you will manage the migration of data to Snowflake, develop requirements, ensure quality control, and coordinate the transition from SAS to modern data management platforms.
This listing has been machine translated. Show original
Job technologies
Your role in the team
- OCI to Snowflake.
- Dimensional modeling: Design and implementation of the cross-functional business unit dimension in the new Snowflake data warehouse.
- Requirements and source analysis: Gathering requirements and analyzing existing OCI data sources and structures.
- Data modeling and quality: Development of the target data model, technical implementation of the solution, and ensuring high data quality.
- Documentation: Creation of comprehensive functional and technical documentation.
- Test design: Development of an end-to-end testing strategy covering unit, integration, and business acceptance tests.
- Quality criteria: Definition of quality standards, acceptance thresholds, and audit-proof test documentation.
- Migration roadmap: Creation and tracking of the migration roadmap across the relevant business units.
- Tool replacement (analysis): Coordinating the transition from SAS Enterprise Guide to Python or a no-code platform.
- Tool replacement (ETL/ELT): Managing the migration from SAS Data Integration to dbt for all ETL and ELT processes.
- Operating Model: Definition of the future operating model, including the associated roles and responsibilities.
- Migration planning: Developing application-specific migration plans and evaluating suitable target technologies.
- Training management: Design and coordination of training sessions for technical users and business departments.
Our expectations of you
Qualifications
- Snowflake: In-depth knowledge of architecture, SQL dialect, data management, and role and permission concepts.
- dbt and Git: Proficient in dbt models, tests, and documentation, as well as Git workflows (branching, pull requests, code reviews).
- Methodology and communication: Strong skills in requirements engineering, stakeholder management, and documentation.
- Language skills: Excellent written and spoken German and English.
- Certifications: Relevant certifications in project management or data engineering are an advantage.
Experience
- Required expertise: Data warehouse and modeling: Several years of data warehouse experience and in-depth knowledge of dimensional data modeling.
- SAS environment: In-depth knowledge of SAS Enterprise Guide or SAS Data Integration, as well as experience with SAS-based ETL migration paths.
- Testing and quality assurance: Experience in developing test concepts for data pipelines and data warehouse objects, including common QA methods.
- Migration Coordination: Proven leadership experience in IT migrations, roadmaps, stakeholder management, and reporting.
- Project management: Experience with both agile delivery models and traditional project planning.
- Desirable skills: Experience with Python, Power BI, or MicroStrategy, industry knowledge of the insurance sector, and knowledge of audit and compliance.
What we offer
- Exciting projects with the technology of tomorrow and responsible tasks from day one.
- Flat hierarchies, an open-door policy, and regular employee check-ins.
- Gross annual salary, all-in: €82,000–€96,000 for a 38-hour workweek.
- 30 days of paid vacation and a flexitime account with flexible working hours.
- Internal and external training programs.
Benefits
Higher take-home pay
Work-Life-Integration
Health, fitness & fun
Topics you will work on
Job locations
About your employer
We at alentum Engineering have successfully established ourselves with our intelligent hardware and software solutions in information technology. We are active in all development phases - from specification to testing and software development to visualization. Our customers benefit from our many years of experience in the automotive industry in the areas of information security, IT infrastructure and digitization.
- 1-49 Employees
- Established Company
- Onsite, Hybrid, Full Remote
- Internet, IT, Telecommunication
Employer reviews
- Career growth
- 4.0
- Working conditions
- 4.4
- Engineering
- 3.2
- Team culture
- 3.7
More jobs
These jobs might also interest you
Hello, let's say WE! We - the HUK-COBURG Insurance Group - are among the top 10 in Germany. Founded over 90 years ago, we are now the leading insurer for private households with over 13 million customers and the largest German auto insurer. Our...
You’ll be joining at a stage where we’re building and evolving our new CRM platform. That’s exactly what makes this role special: you won’t just develop features—you’ll actively help shape the technical foundation of a modern CRM ecosystem. Together...
The role As a Forward Deployed AI Engineer, you go directly into our specialist departments, understand the processes, and develop production-ready AI and automation solutions that will fundamentally change the way the entire GGW Group operates. You do...
