Data Architect

Reports to the VP of Technology. Designs and builds Alto-Shaam's cloud data platform as a hands-on role: makes the design decisions for how data is modeled, secured, tested, promoted to production and delivered to the business, and then builds them. Alto-Shaam has aligned on a data platform consisting of Fivetran, Snowflake and Claude, and now seeks a qualified individual to own, deploy, and build out that platform. As the first dedicated data role on the platform, also handles day-to-day pipeline monitoring and data support, and helps shape how manufacturing execution systems, connected-equipment data and new applications fit together as the company expands.The ideal candidate for a Data Architect would be able to do the following:Designs and builds the platform's data model, including dimensional models and conformed dimensions shared across finance, manufacturing, sales and service (customer, item, location, fiscal calendar).Documents design decisions as architecture decision records so the platform's design is written down and repeatable.Owns ingestion from Oracle Fusion Cloud, CRM, connected-equipment data and file-based feeds, including connector setup, monitoring and pipeline health.Designs role-based access and data security, dev/test/production environments, CI/CD and orchestration, and warehouse cost management.Puts data quality and governance in place early: data contracts and automated testing (for example, dbt tests), lineage, and master and reference data practices.Builds and extends the semantic layer that dashboards and AI tools query directly.Leads the migration of historical data from legacy business systems into the new platform, reconciling it with current ERP data and documenting legacy business rules and lineage.Translates business requirements into data models and presents design trade-offs to technical and non-technical stakeholders.Partners with the integration team on how data moves between systems (Oracle Integration Cloud or similar) and helps design the data and integration approach for new manufacturing systems, connected-equipment data and future applications.Coaches colleagues who do part-time data work and sets the standards, documentation and onboarding materials for future team members.