Senior Data Engineer – SAP BW Migration

About the project

We are looking for a Senior Data Engineer with strong SAP BW and Data Warehouse experience to support the migration of an existing SAP BW analytical landscape to a modern cloud data platform.

Responsibilities:

• Analyze and reverse-engineer existing SAP BW content - InfoCubes, DSOs, InfoObjects, and BW transformations (including ABAP routines) - to document the data flows and business logic they implement
• Migrate legacy DWH analytical layers to a modern cloud platform: rebuild fact and dimension tables, transformation pipelines, and embedded business logic as SQL-based ELT
• Re-implement BW transformation logic in dbt on Snowflake, ensuring semantic accuracy - business rules embedded in legacy transformations are preserved, not reinterpreted
• Develop and maintain dbt models, including Jinja templating and macros, following the project's established modeling standards
• Build and operate ELT orchestration workflows (Azure Data Factory, Apache Airflow, or equivalent)
• Validate migrated objects against the legacy system to confirm data and logic equivalence before cutover
• Work embedded in an existing mixed internal/external Scrum team (3-week sprints), contributing to the team's object-migration throughput and delivery cadence
• Collaborate with the Product Owner and internal engineers to clarify legacy logic, resolve ambiguities, and align on migration priorities

Must have:

• Proven hands-on experience in data transformation within a DWH context - building and migrating analytical layers (fact/dimension tables, transformation pipelines, business logic translation); this is the primary criterion for the role
• Strong SAP BW knowledge: ability to read and reverse-engineer BW structures (InfoCubes, DSOs, InfoObjects, BW transformations)
• Advanced SQL proficiency; hands-on experience implementing transformation logic as SQL-based ELT - dbt strongly preferred
• Experience with ELT orchestration tools (Azure Data Factory, Apache Airflow, or equivalent)
• Solid data warehousing fundamentals: dimensional modeling, slowly changing dimensions (SCD), partitioning strategies
• Analytical mindset with experience translating legacy DWH logic into modern platforms - this is a migration engagement, not greenfield design; comfort working from existing BW artifacts as the source of truth
• Strong attention to semantic accuracy and detail - preserving, not reimagining, business logic
• Comfortable working embedded in an existing mixed Scrum team; seniority to operate autonomously within an established delivery model
• Regular use of AI tools to improve productivity, automate or reduce repetitive work, support decision-making, and deliver higher-quality outcomes.
• Ability to use AI tools responsibly by structuring effective prompts, critically validating outputs, understanding limitations, and taking ownership of the final result.

• Snowflake experience (target platform) - candidates with strong DWH and SAP BW backgrounds but limited Snowflake exposure will be considered
• ABAP (read-level): ability to interpret existing BW transformation routines is a significant advantage
• Python for pipeline scripting and automation
• Familiarity with dbt Jinja templating and macro development
• Exposure to AI-assisted code generation tooling (e.g., Snowflake Cortex)

At Accesa:

We nurture genuine connections, encourage an active lifestyle, and support the development of a healthy mindset. Our benefits programme is inspired by Maslow’s hierarchy of needs and is designed to prioritize your overall wellbeing.

To live a wholesome experience inside and outside our offices, we need to take care of our overall wellbeing, from the physical aspect to creating a healthy work-life fusion and looking at learning as a lifelong journey and a shared responsibility between our people and our organization.

• Physical Wellbeing: Our wellbeing program includes medical insurance, In-house fitness trainer available remotely and 1 on 1 remote sessions with our Sports and Health Coach focused on nutrition counselling and tailored training plans.

• Work-Life Fusion - Start with at least 21 vacation days (based on seniority) and earn 1 extra day for each completed year of collaboration - up to 29 days - depending on your tenure in the company and/or industry. Enjoy the flexibility to work from both home and the office.

• Growth opportunities: we focus on long-term learning programmes that develop both technical and non-technical skills incrementally. Together with your Career Coach you will discuss what are learning resources and platforms you can access in order to develop your skills.