Data Products Designer

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 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. 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 This position was posted on the date cited in the key job details section and is anticipated to remain posted for 21 days from this date or less if not needed to fill the role. 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.