Senior Data Engineer with SAP BW and Snowflake

Technology stackSAP BW (BW/4HANA), SAP extraction (Open Hub, ODP, SLT, CDS views), third-party SAP connectors (Theobald, SNP Glue, Fivetran SAP or similar), Snowflake, dbt, SQL, Python, Snowflake Cortex, Streamlit, semantic models, data modeling, data quality, CI/CDProject overviewThe project supports a large international consumer goods company that is scaling its Snowflake-based data platform. Selected datasets are moved from SAP BW into Snowflake one business case at a time. They feed data products for sales and distribution, retail and market analytics, and e-commerce. The platform is already critical to the business: hundreds of business users work every day with AI-powered analytics built on Snowflake Cortex and Streamlit.TeamMedium team (10-20 people)You will join a distributed data engineering team: an Engineering Manager, internal data engineers and about 9 external contractors, based in the US and South America. Engineers are organized by data product. You will work closely with the client's Lead Data Architect and business stakeholders across domains.Position overviewWe are looking for a very senior hands-on Data Engineer with strong SAP BW and Snowflake experience who has led engineering teams. About 70% of the engineering work is extracting data from SAP BW and integrating it into Snowflake.You will work side by side with a recently appointed Engineering Manager who comes from a non-engineering background, helping them build engineering leadership skills. Together you will grow the team toward independent, high-performing delivery: operating model, engineering practices, standards and delivery discipline. The goal is for the client's team to run independently within about a year. You will get there through coaching-by-doing and knowledge transfer rather than long-term vendor dependency.The client is headquartered in Southern California, USA. Working on site for the first 4–6 weeks is mandatory for this role, to build trust and work directly with the Engineering Manager and the team. After that, you will be on site a few days a week during the following weeks. A valid US visa, or the ability to obtain one quickly, is required.ResponsibilitiesDesign, build and run data pipelines from SAP BW into Snowflake, including full and delta loadsDo hands-on engineering work while coaching the Engineering Manager and the teamHelp the Engineering Manager build engineering leadership skills: planning, code quality, technical decision-making, managing engineers and contractorsEstablish reusable ingestion, modeling and data quality patterns for the teamDefine and roll out engineering standards: code review, testing, CI/CD, documentation, delivery disciplineDeliver data products for sales, distribution and retail analytics in close collaboration with business stakeholdersWork with a distributed team of internal engineers and external contractors across time zonesReduce key-person dependency through knowledge transfer and pairingHelp introduce AI-assisted and agentic engineering practices across the development lifecycleWork with the Lead Architect to keep delivery aligned with target architecture and governanceRequirements7+ years of hands on data engineering experience including lead rolesHands on experience extracting data from SAP BW into a cloud data warehouseStrong hands on experience with Snowflake including data loading performance cost awareness security and access modelExperience with data modeling approaches such as dimensional modeling or Data VaultExperience with data quality practicesExperience with dbtExperience leading a team of around 10 engineersExperience coaching a manager or team lead into an engineering leadership role through hands on collaborationExperience working with distributed teams and external contractors or vendorsExperience applying AI in engineering or data work with a concrete example of problem solution tools and outcomeEnglish Upper Intermediate or higherReadiness to work on site in Southern California for 4–6 weeks at the start of the engagementNice to haveExperience with SAP BW/4HANA, SAP Datasphere or migrations from SAP to cloud platformsSnowflake Cortex, Streamlit or semantic layer experienceCPG, retail or distribution domain; retailer data platforms or syndicated market data (POS, Nielsen-type datasets)Experience building an engineering operating model or data engineering maturity roadmapExposure to Microsoft Fabric or DatabricksExperience with international client-facing engagementsWhat We Offer:Vacation days: Up to 26 business days per year.10 illness/special days off per year (fully paid, no medical papers needed) for all contract typesHealth and life insurance (Luxmed)MyBenefit platform with Multisport optionInternal psychological support serviceEnglish language classes from the first working dayAccess to external learning platforms: O’Reilly, LinkedIn Learning, Udemy, and a wide catalog of diverse internal trainingFlexible workplace: work from the office, from home, or choose a hybrid optionTech Skills Mentoring ProgramOpportunities to develop as a public speaker, mentor, or technical interviewerFully paid idle (bench) when not involved in a projectCertification reimbursement (AWS, GCP, Microsoft, etc.)