Data Products Designer for Enterprise Data and AI

International Business Machines Corporation; Atlanta (GA); Remote; USD 120,000 - 170,000; Full time

Job summary

IBM Consulting is seeking a Data Products Designer to shape business-aligned data products within a large data re-engineering program across Databricks and AWS. You will define data product structures, models, and metadata; share designs with Data Engineers, Architects, and Product Owners; work with SAP and non-SAP sources.

This role can be performed from anywhere in the US, with frequent collaboration across teams and stakeholders.

Qualifications

• 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.

Responsibilities

• Define data products: scope, ownership, consumers, SLAs, and data contracts.
• Design logical and physical data models for data products on Databricks and AWS.
• Re-engineer legacy data structures and transformations into well-modeled data products.
• Define source-to-target mappings for pipelines ingested via Fivetran and from SAP and non-SAP sources.
• Assess alignment with SAP-native data products for consistent modelling.
• Maintain models and design artifacts in 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.
• Provide technical leadership on design of complex data solutions and guide team on standards.
• Optimize performance, scalability, and reliability of data products and underlying platform.
• Collaborate with delivery teams to meet business requirements.

Skills

Data modelling

Data design

Data architecture

SQL

Databricks

AWS

Erwin

ER Studio

Kafka

Tools

Fivetran

Collibra

ERwin

ER Studio

Job description

IBM Consulting is seeking a Data Products Designer to shape business-aligned data products within a large data re-engineering program across Databricks and AWS. You will define data product structures, models, and metadata; share designs with Data Engineers, Architects, and Product Owners; work with SAP and non-SAP sources.

This role can be performed from anywhere in the US, with frequent collaboration across teams and stakeholders.