Data Products Designer

IBM; Chicago (IL); Remote; USD 120,000 - 160,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. You will define data product structures, models, contracts, and metadata consumed by analytics, ML, and GenAI use cases.

You will design and develop data solutions on Big Data and lakehouse technologies, collaborating with Data Engineers, Architects, and Product Owners to ensure scalable, reliable data products across the enterprise.

Qualifications

• Must be able to travel 4 days per week (mandatory).
• 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.

Responsibilities

• Define data products scope, owners, consumers, SLAs, and data contracts.
• Design logical and physical data models for data products on Databricks and AWS.
• Re-engineer legacy data structures into well-modeled data products.
• Define source-to-target mappings for pipelines via Fivetran and SAP sources.
• Align SAP-native data products with non-SAP data models.
• 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.
• Provide technical leadership on complex data solution design and standards.
• Optimize performance, scalability, and reliability of data products and the platform.
• Collaborate with delivery teams to meet business requirements and stakeholder expectations.

Skills

Data modelling

Data architecture

SQL

Databricks

AWS data services

Data governance

Data quality

Education

Bachelor’s Degree

Tools

Delta Lake

Unity Catalog

Erwin

ER Studio

Fivetran

Collibra

SAP BTP

Job description

Introduction

A career in IBM Consulting is built on long-term client relationships and close collaboration worldwide. You\'ll work with leading companies across industries, helping them shape their hybrid cloud and AI journeys. With support from our strategic partners, robust IBM technology, and Red Hat, you\'ll have the tools to drive meaningful change and accelerate client impact. At IBM Consulting, curiosity fuels success. You\'ll be encouraged to challenge the norm, explore new ideas, and create innovative solutions that deliver real results. Our culture of growth and empathy focuses on your long-term career development while valuing your unique skills and experiences.

Your role and responsibilities

Data Products Designer to design and shape business-aligned data products as part of a large data re-engineering program. You will define data product structure, models, contracts and metadata that downstream analytics, ML and GenAI use cases will consume.

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.

This job can be performed from anywhere in the US

Required education

Bachelor\'s Degree

Preferred education

None

Required technical and professional expertise

• Must be able to travel 4 days per week (mandatory).


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

Preferred technical and professional experience

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

ABOUT BUSINESS UNIT

IBM Consulting is IBM\'s consulting and global professional services business, with market leading capabilities in business and technology transformation. With deep expertise in many industries, we offer strategy, experience, technology, and operations services to many of the most innovative and valuable companies in the world. Our people are focused on accelerating our clients\' businesses through the power of collaboration. We believe in the power of technology responsibly used to help people, partners and the planet.

YOUR LIFE @ IBM

In a world where technology never stands still, we understand that, dedication to our clients success, innovation that matters, and trust and personal responsibility in all our relationships, lives in what we do as IBMers as we strive to be the catalyst that makes the world work better.

Being an IBMer means you\’ll be able to learn and develop yourself and your career, you\’ll be encouraged to be courageous and experiment everyday, all whilst having continuous trust and support in an environment where everyone can thrive whatever the personal or professional background.

Our IBMers are growth minded, always staying curious, open to feedback and learning new information and skills to constantly transform themselves and our company. They are trusted to provide on-going feedback to help other IBMers grow, as well as collaborate with colleagues keeping in mind a team focused approach to include different perspectives to drive exceptional outcomes for our customers. The courage our IBMers have to make critical decisions everyday is essential to IBM becoming the catalyst for progress, always embracing challenges with resources they have to hand, a can-do attitude and always striving for an outcome focused approach within everything that they do.

Are you ready to be an IBMer?

ABOUT IBM

IBM\'s greatest invention is the IBMer. We believe that through the application of intelligence, reason and science, we can improve business, society and the human condition, bringing the power of an open hybrid cloud and AI strategy to life for our clients and partners around the world.

Restlessly reinventing since 1911, we are not only one of the largest corporate organizations in the world, we\'re also one of the biggest technology and consulting employers, with many of the Fortune 500 companies relying on the IBM Cloud to run their business.

At IBM, we pride ourselves on being an early adopter of artificial intelligence, quantum computing and blockchain. Now it\'s time for you to join us on our journey to being a responsible technology innovator and a force for good in the world.

IBM is proud to be an equal‑opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, gender, gender identity or expression, sexual orientation, national origin, genetics, pregnancy, disability, neurodivergence, age, or other characteristics protected by the applicable law. IBM is also committed to compliance with all fair employment practices regarding citizenship and immigration status.

OTHER RELEVANT JOB DETAILS

IBM offers a competitive and comprehensive benefits program. Eligible employees may have access to:

• Healthcare benefits including medical & prescription drug coverage, dental, vision, and mental health & well being


• Financial programs such as 401(k), cash balance pension plan, the IBM Employee Stock Purchase Plan, financial counseling, life insurance, short & long- term disability coverage, and opportunities for performance based salary incentive programs


• Generous paid time off including 12 holidays, minimum 56 hours sick time, 120 hours vacation, 12 weeks parental bonding leave in accordance with IBM Policy, and other Paid Care Leave programs. IBM also offers paid family leave benefits to eligible employees where required by applicable law


• Training and educational resources on our personalized, AI-driven learning platform where IBMers can grow skills and obtain industry-recognized certifications to achieve their career goals


• Diverse and inclusive employee resource groups, giving & volunteer opportunities, and discounts on retail products, services & experiences

We consider qualified applicants with criminal histories, consistent with applicable law.

IBM will not be providing visa sponsorship for this position now or in the future. Therefore, in order to be considered for this position, you must have the ability to work without a need for current or future visa sponsorship.

The compensation range and benefits for this position are based on a full-time schedule for a full calendar year. The salary will vary depending on your job-related skills, experience and location. Pay increment and frequency of pay will be in accordance with employment classification and applicable laws. For part time roles, your compensation and benefits will be adjusted to reflect your hours. Benefits may be pro-rated for those who start working during the calendar year.