Lead Data Engineer - IT

Role

Lead Data Engineer focused on SAP BW / BW/4HANA and SAP Datasphere (Business Data Cloud). This is a senior, hands-on engineering position responsible for designing, building, operating, and optimizing enterprise-scale SAP data solutions that support analytics, reporting, embedded Fiori analytics, and downstream BI platforms.

Key Responsibilities

• Design, develop, and maintain SAP BW / BW/4HANA data models, transformations, and process chains.
• Build and manage data pipelines in SAP Datasphere (BDC), including data acquisition, transformation logic, semantic modeling, and space management.
• Integrate SAP source systems (S/4HANA, ECC) with BW, Datasphere, and downstream analytics platforms.
• Create and optimize SQL, CDS views, transformations, and data models for analytical and operational use cases.
• Optimize data performance, load efficiency, and query response times across SAP data environments.
• Enable SAP Fiori and embedded analytics by exposing data via CDS views and OData services and aligning models with Fiori consumption patterns.
• Support analytics consumption in Power BI and other BI tools; ensure governed semantic layers across SAP and non‑SAP systems.
• Contribute to SAP data modernization, including integration with Microsoft Fabric and cloud data warehouses/lakehouses (Databricks, Snowflake).
• Troubleshoot data quality, performance, and pipeline failures; maintain documentation and data lineage.
• Collaborate with data architects, application teams, analytics teams, and business stakeholders; provide technical guidance and best practices.
• Frequent travel required, including overnight and occasional weekend travel.

Requirements

• Bachelor’s degree with 8–12 years of related experience.
• Deep, hands-on experience with SAP BW / BW/4HANA and SAP Datasphere / Business Data Cloud.
• Experience creating and optimizing CDS views, SQL, transformations, and OData services.
• Experience enabling analytics for SAP Fiori and BI consumption (Power BI preferred).
• Familiarity with integrating SAP source systems (S/4HANA, ECC) and with hybrid cloud patterns.
• Experience with Databricks, Delta Lake, and Spark-based pipelines, and familiarity with lakehouse architectures and tools such as Microsoft Fabric or Snowflake.
• Familiarity with Salesforce integration patterns; Boomi experience is a plus.
• Exposure to applied AI in analytics (Copilot, prompt engineering, RAG) is desirable.
• Hands-on experience with Vibe Coding or similar low-code/no-code frameworks for rapid prototyping of data workflows is preferred.
• SAP certifications (Business Data Cloud, Data Engineer – SAP BW/4HANA) are preferred.

Location & Schedule

• Office location: Libertyville, IL. Beginning May 4, associates are required to be in the Libertyville office a minimum of 4 days per week.

Compensation & Benefits

• Anticipated base pay range: $105,000 - $152,000 yearly (varies by location, experience, and qualifications).
• Eligible to participate in the Hollister Corporate Bonus Plan.
• Benefits include medical, prescription, dental, vision, spending/savings accounts, disability, company-paid parental and caregiver leaves, statutory leaves/disability programs, accident, life, wellbeing programs, education assistance, adoption assistance, voluntary benefits, and a 401(k) plan with auto-enrollment, ROTH and matching contributions.
• Paid time off: 11 paid holidays, vacation (based on service and status), and sick days per statutory/role rules.