[Remote] Data Products Designer

Note: The job is a remote job and is open to candidates in USA. 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

Skills

• 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

Benefits

• Hybrid work arrangement
• Healthcare benefits including medical & prescription drug coverage, dental, vision, and mental health & well being
• 401(k)
• Cash balance pension plan
• IBM Employee Stock Purchase Plan
• Financial counseling
• Life insurance
• Short & long-term disability coverage
• Opportunities for performance-based salary incentive programs
• 12 holidays
• Minimum 56 hours sick time
• 120 hours vacation
• 12 weeks parental bonding leave in accordance with IBM Policy
• Other Paid Care Leave programs
• Paid family leave benefits to eligible employees where required by applicable law
• Training and educational resources on a personalized, AI-driven learning platform
• Opportunities to grow skills and obtain industry-recognized certifications
• Diverse and inclusive employee resource groups
• Giving and volunteer opportunities
• Discounts on retail products, services & experiences

Company Overview