Data Architect

Position Summary

Data Architect will lead the design and governance of our enterprise data architecture. This role will play a key part in shaping and optimizing how data flows through our organization—from SAP source systems through our cloud-native analytics platform, Databricks. You’ll be responsible for designing scalable, secure, and high-performing data models that serve as the foundation for analytics, reporting, and AI/ML initiatives across finance, supply chain, operations, and commercial domains.

Essential Functions and Duties

• Define and implement end-to-end data architecture standards, including data modeling, data integration, metadata management, and governance across the enterprise.
• Design scalable data models across Bronze, Silver, and Gold layers of a Databricks Lakehouse using Delta Lake and Unity Catalog and DLT.
• Lead data modeling efforts for critical business domains (e.g., finance, materials, logistics, customer) with deep understanding of SAP source systems such as ECC or S/4HANA (e.g., tables like ACDOCA, BKPF, BSEG, MARA, LIPS).
• Collaborate with data engineers to optimize ingestion and transformation processes across streaming and batch pipelines.
• Establish canonical models and semantic layers that power downstream BI tools and self-service analytics.
• Define and enforce data quality, data lineage, and data security policies in coordination with governance teams.
• Work with business stakeholders, product managers, and analysts to translate analytical use cases into high-quality data models and architecture patterns.
• Provide architecture oversight and best practices guidance on data integration tools (e.g., Fivetran), data cataloging, and performance optimization.
• Review and approve physical and logical data model changes across teams to ensure consistency and maintain architectural integrity.
• Partner with IT security and compliance teams to implement PHI/PPI/PII masking strategies and data access controls via Unity Catalog.
• Adheres specifically to all company policies and procedures, Federal and State regulations, and laws. 
• Display dedication to position responsibilities and achieve assigned goals and objectives.
• Always represent the Company in a professional manner and appearance.
• Understand and internalize the Company’s purpose,
• Display loyalty to the Company and its organizational values.
• Display enthusiasm and dedication to learning how to be more effective on the job and share knowledge with others.
• Work effectively with co-workers, internal and external customers and others by sharing ideas in a constructive and positive manner; listen to and objectively consider ideas and suggestions from others; keep commitments; keep others informed of work progress, timetables, and issues; address problems and issues constructively to find mutually acceptable and practical business solutions; address others by name, title, or other respectful identifier, and respect the diversity of our work force in actions, words, and deeds.
• Comply with the policies and procedures stated in the Injury and Illness Prevention Program by always working in a safe manner and immediately reporting any injury, safety hazard, or program violation.
• Ensure conduct is consistent with all Compliance Program Policies and procedures when engaging in any activity on behalf of the company. Immediately report any concerns or violations.
• Other duties as assigned.

Education, Knowledge, Skills, and Experience

Required Education:

• Bachelor’s Degree in a related field or four (4) years relevant experience in lieu of degree.

Required Knowledge:

• Deep understanding of SAP ERP data models, especially core financials, logistics, and materials domains.
• Expertise in dimensional mod