Data Products Designer

What you'll do

• Define data product scope, ownership, consumers, SLAs, and data contracts with business and technical stakeholders.
• Design logical and physical data models including conceptual, dimensional, and lakehouse/medallion layers on Databricks and AWS.
• Re-engineer legacy data structures into well-modeled, reusable data products rather than replicating existing logic.
• Define source-to-target mappings for pipelines ingested via Fivetran from SAP and non-SAP sources.
• Establish data quality rules, business definitions, and lineage expectations with data engineers and governance teams.
• Develop data solutions on Big Data and lakehouse technologies, including API-based access and debugging complex code.
• Optimize the performance, scalability, and reliability of data products and the underlying data platform.
• Provide technical leadership by guiding team members on standards and approaches for complex data solutions.

What we're looking for

• Must possess a Bachelor's Degree.
• Must be able to travel 4 days per week.
• Must have advanced expertise in data modeling, design, or architecture for complex enterprise environments.
• Must have strong hands-on expertise in dimensional, relational, and lakehouse data modeling, including data products and source-to-target mapping.
• Must have strong SQL skills and experience with Databricks, AWS data services, and tools like Erwin or ER Studio.
• Must have experience designing scalable data solutions for unstructured and real-time data using Kafka, Amazon EventBridge, or Amazon SQS.
• Experience with Fivetran, Collibra, or relational-to-Databricks migrations (preferred).
• Knowledge of SAP IS-U, SAP-native data products, SAP Business Data Cloud, and SAP BTP (preferred).