Hybrid Data Architect: Star Schema & Analytics

The J.M. Smucker Company; Orrville (OH); Hybrid; USD 120,000 - 150,000; Full time

Job summary

The J. M. Smucker Co. is seeking a Data Architect for the Enterprise Data Platform in Orrville, OH. You will design and maintain enterprise data models to enable analytics, reporting, and data-driven decision making.

Hybrid work arrangement allows onsite presence with a minimum of nine days per month, aligning with core business weeks. You will collaborate across data domains to ensure consistent semantic layers, governance, and scalable architectures that support trusted analytics.

Qualifications

• Bachelor’s degree or equivalent experience in Information Technology or related field.
• 8+ years of experience in data modeling, data architecture, analytics, or senior data engineering environments.
• Ability to collaborate across technical teams, business stakeholders, and data domain partners to drive alignment and adoption.
• Advanced SQL skills and experience with large datasets.
• Experience designing data models, metadata structures, and semantic foundations for trusted analytics and AI use cases.
• Experience with modern cloud data platforms such as Databricks and lakehouse architectures.
• Strong understanding of data structures, relationships, and performance optimization.

Responsibilities

• Design, develop, and maintain dimensional data models using star schema methodologies.
• Ensure models are optimized for performance, scalability, and usability.
• Create and maintain conceptual, logical, and physical data models using modeling tools.
• Analyze and profile new data sources to inform modeling and architecture decisions.
• Apply enterprise data modeling standards and validate data model consistency and alignment with requirements.
• Improve data model usability and clarity for downstream analytics and reporting.
• Establish and maintain a consistent semantic layer with standardized metrics and dimensions.
• Align data models with reporting requirements, certified data sources, and analytics standards.
• Collaborate with Data Engineers to ensure pipelines align with models and enterprise standards.
• Recommend improvements to data design, storage, and structure.
• Ensure alignment across source, transformed, and published data layers.
• Support metadata, lineage, and documentation standards.

Skills

Advanced SQL

Data modeling

Dimensional modeling

Databricks

Lakehouse

Collaboration

Communication

Education

Bachelor’s degree in IT or related field

Tools

ER/Studio

Erwin

Atlan

Job description

The J. M. Smucker Co. is seeking a Data Architect for the Enterprise Data Platform in Orrville, OH. You will design and maintain enterprise data models to enable analytics, reporting, and data-driven decision making.

Hybrid work arrangement allows onsite presence with a minimum of nine days per month, aligning with core business weeks. You will collaborate across data domains to ensure consistent semantic layers, governance, and scalable architectures that support trusted analytics.