Data Architect, Enterprise Data Platform

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

Your Opportunity as the Data Architect, Enterprise Data Platform

The Data Architect is responsible for designing and maintaining enterprise data models that support analytics, reporting, and data-driven decision making. This role ensures that data structures are scalable, consistent, and aligned to business needs, while supporting efficient data consumption across the organization. The Data Architect contributes to enterprise analytics data governance and modeling standards by defining data structures, validating implementations, improving model quality and consistency, and working across data domains to ensure alignment between source data, engineered data layers, and published analytics assets. This role applies and enforces dimensional modeling best practices using star schema design, including fact and dimension tables, conformed dimensions, and standardized metrics. Data models are designed to support a unified semantic layer and enable accurate, consistent reporting across tools such as Tableau.

Work Arrangements:

Hybrid - onsite a minimum of 9 days a month primarily during core weeks as determined by the Company; maybe more as business need requires

In this role you will:

Data Modeling & Design

• Design, develop, and maintain dimensional data models using star schema methodology, including defining fact tables, dimension tables, grain, and relationships that support enterprise analytics and reporting.
• Ensure models are optimized for performance, scalability, and usability.
• Create and maintain conceptual, logical, and physical data models using appropriate modeling tools.
• Analyze and profile new data sources to understand structure, quality, relationships, and business context, informing appropriate modeling and architecture decisions.

Model Quality & Standards

• Apply enterprise data modeling standards and best practices across all solutions.
• Validate data models for consistency, accuracy, and alignment with business requirements.
• Identify and resolve issues related to duplication, inconsistency, poor model design, or data quality concerns that impact analytics and reporting.
• Improve data model usability and clarity for downstream analytics and reporting.

Semantic Alignment & Analytics Support

• Establish and maintain a consistent semantic layer, including standardized metrics, dimensions, and business logic that support trusted analytics and reporting.
• Align data models with reporting requirements, certified data sources, and enterprise analytics standards.
• Support analytics teams by providing clear, well-structured, and consumable data models.

Data Architecture & Solution Design

• Develop and guide data architecture decisions related to data structures and design patterns.
• Collaborate with Data Engineers to ensure data pipeline implementations align with the intent of approved data models, enterprise standards, and architectural best practices while meeting performance and scalability requirements.
• Partner with Data Owners, domain experts, engineers, and analytics teams to align data models with business processes, priorities, and enterprise standards.
• Recommend improvements to data design, storage, and structure.
• Ensure alignment across source, transformed, and published data layers.

Governance & Documentation Support

• Support metadata, lineage, and documentation standards.
• Define and document data models, including structure, definitions, and usage guidance.
• Ensure models align with governance standards for ownership, classification, and compliance.
• Contribute to improving discoverability and trust in enterprise data.
• Collaborate with platform, governance, and security teams to ensure data models and architecture designs align with enterprise security, privacy, data classification, and access control standards.

What we are looking for

Minimum Requirements:

• Bachelor’s degree, equivalent experience or specialized training in Information Technology
• 8+ years of experience in data modeling, data architecture, analytics, or senior data engineering environments
• Demonstrated ability to collaborate effectively across technical teams, business stakeholders, and data domain partners to drive alignment and adoption
• Advanced SQL skills and experience working with large datasets
• Experience designing data models, metadata structures, and semantic foundations that support trusted analytics, reporting, and emerging AI use cases
• Experience with Databricks, lakehouse architectures, or similar modern cloud data platforms
• Strong understanding of data structures, relationships, and performance optimization
• Ability to think critically and conceptually, communicate complex data architecture topics clearly, and adapt recommendations for both technical and nontechnical audiences
• Additional skills and experience that we think would make someone successful in this role (not required):
  • Experience creating and maintaining conceptual, logical, and physical data models using enterprise modeling tools such as ER/Studio, Erwin, or equivalent platforms
  • Experience leveraging metadata management, data catalog, lineage, and governance capabilities to improve data discoverability, traceability, and trust across enterprise analytics environments, including platforms such as Atlan or similar solutions
  • Experience working across multiple areas of the analytics lifecycle, including data engineering, data modeling, and business intelligence/reporting solutions
  • Familiarity with Python and modern data engineering workflows
  • Familiarity with source control and collaborative development practices (e.g., Git, GitHub, Azure DevOps)
  • Understanding of modern data platform concepts and workflows
  • Understanding of how data architecture, metadata, and governance enable trusted analytics and AI solutions

The Right Place for You

We are bold, kind, strive to do the right thing, we play to win, and we believe in a strong community that thrives together. Our culture is rooted in our Basic Beliefs, and we believe in supporting every employee by meeting their physical, emotional, and financial needs.

Stay connected with us on LinkedIn

We’re an equal opportunity employer. All applicants will be considered for employment without attention to race, color, religion, sex, sexual orientation, gender identity, genetic information, age, national origin, disability status or protected veteran status.

We’re a community of passionate, talented professionals dedicated to creating food people and pets love—while supporting the communities in which we work and live.

We value what makes each person unique, champion growth and development, and foster collaboration that fuels productivity and drives our shared success.

Learn more about our Thrive Together purpose

At Smucker, we're passionate about creating a workplace where you truly belong. With a culture rooted in our Basic Beliefs and a competitive Total Rewards program, we aim to support every employee by meeting their physical, emotional, and financial needs.

Learn more about working at Smucker

Our culture is sustained and brought to life every day by the people of Smucker and our hiring process is designed to identify the right candidate for every position at our company.

Learn more about our hiring process

The J. M. Smucker Co. (the “Company”) is an Equal Opportunity Employer. No person will be discriminated against in hiring or in any other aspect of their employment on the basis of race, color, religion, sex (including pregnancy), age, national origin, ancestry, citizenship status, sexual orientation, gender identity or expression, transgender status, marital status, familial status, disability, genetic information, protected veteran/military status, or any other characteristic protected by applicable federal, state or local law.