Data Products Designer

IBM Consulting is hiring a Data Products Designer to shape business-aligned data products for a large data re-engineering program. The role defines data models, contracts, metadata, and quality expectations, and provides technical leadership to deliver scalable data solutions for analytics, machine learning, and generative AI.

Responsibilities:

• Work with business and technical stakeholders to define data products: scope, ownership, consumers, SLAs, and data contracts
• Design logical and physical data models (conceptual, dimensional, and lakehouse/medallion layers) for data products on Databricks and AWS
• Re-engineer legacy data structures and transformation logic into well-modeled, reusable data products rather than replicating them as-is
• Define source-to-target mappings for pipelines ingested via Fivetran and from SAP and non-SAP sources
• Assess and align with SAP-native data products so that SAP and non-SAP data are modeled consistently
• Maintain models and design artifacts in the enterprise data modeling tools
• Define data quality rules, business definitions, and lineage expectations with data engineers and governance teams
• Produce design documentation and review designs with Data Engineers, Architects, and Product Owners
• Design and develop data solutions on Big Data and lakehouse technologies, including API-based data access, writing and debugging complex code where needed
• Provide technical leadership on the design of complex, high-quality and efficient data solutions, guiding team members on standards and approach
• Optimize the performance, scalability, and reliability of data products and the underlying data platform
• Collaborate with delivery teams to deliver solutions that meet business requirements and stakeholder expectations

Requirements:

• Bachelor's Degree
• Advanced expertise in data modelling, data design, or data architecture, with demonstrated ability to design scalable data models and architectures for complex enterprise environments
• Strong hands-on expertise in dimensional, relational, and lakehouse data modelling, including data products/data mesh concepts and source-to-target mapping
• Strong SQL skills and experience with Databricks (Delta Lake, Unity Catalog), AWS data services, and data modelling tools such as Erwin or ER Studio
• Experience designing scalable, reliable data solutions for unstructured and real-time/near-real-time data using Kafka, Amazon EventBridge, Amazon SQS, or similar technologies
• Ability to optimize modern data platforms for performance and translate business requirements into reusable, governed data products
• must have the ability to work without a need for current or future visa sponsorship
• Experience with Fivetran or similar ELT tools, Collibra or similar metadata/catalogue platforms, and relational-to-Databricks/Lakebase migrations
• Knowledge of SAP IS-U, SAP-native data products, SAP Business Data Cloud, and SAP BTP
• Experience in the utilities or energy industry
• Databricks and/or AWS certification, with Agile delivery experience
• Exposure to NLP, analytics, statistical, or big-data technologies