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