Enterprise Data Architect

Location & Compensation

• Location:
  
  16 Malcolm Hoyt Drive, Newburyport, MA, 01950, United States
• Base Pay: $ - $ / Year
• Job Category: USA
• Employee Type: FT - Exempt

• Name:
  Stacey Gordon
• Phone:
• Email:

• Data Architecture & Platform Design
  • Design and implement a Snowflake Enterprise Data Warehouse (EDW) using a medallion architecture (Bronze / Silver / Gold).
  • Define and maintain standards for schemas, naming conventions, data tagging, and database roles.
  • Implement RBAC frameworks, network policies, and resource monitors to ensure security, performance, and cost accountability.
  • Oversee the configuration and lifecycle management of dynamic tables, streams, and tasks supporting near real‑time data refresh.
  • Manage platform implementations, upgrades, and IT‑related user training.
• Governance & Compliance
  • Establish and maintain data governance frameworks aligned with ITAR and corporate data protection standards.
  • Implement masking policies, row‑access policies, and sensitivity tagging for financial and restricted data.
  • Collaborate with Compliance, IT Security, and Audit teams to ensure traceability and documentation of all data lineage and access controls.
  • Develop and maintain Kimball‑style dimensional models to support analytical use cases in Manufacturing, Finance, and Sales.
  • Define model grains, surrogate keys, and change tracking mechanisms (including Slowly Changing Dimensions Type II).
  • Standardize fact and dimension table structures for enterprise‑wide consistency and cross‑departmental integration.
  • Partner with cross‑functional analysts and developers to orchestrate automated data pipelines.
  • Manage service accounts, warehouses, and compute isolation for departmental workloads.
  • Develop and document automation scripts for key rotation, environment cloning, and metadata synchronization.
  • Collaborate with BI teams to build certified semantic models and Gold‑layer views for Power BI and Tableau.
  • Enable data democratization through well‑governed, reusable datasets and standardized KPI definitions.
  • Support the integration of AI and machine learning initiatives through secure data provisioning and feature store development.
  • Work with developers, managers, support and service providers to maximize the effectiveness of the EDW.
  • Serve as a technical liaison among Finance, Manufacturing, and Sales departments.
  • Mentor analysts and engineers on Snowflake best practices, dimensional modeling, and secure data design.
  • Provide executive reporting and documentation on data platform adoption, performance, and cost optimization.
  • Provide strong leadership and guidance while working with others specifically related to the IT applications department, project managers and project teams.
  • Coordinate with different departmental teams to produce better business outcomes.
  • Influence stakeholders to support business projects.
  • Provide data‑driven advice on how to expand or refine operations to meet company needs.
  • Manage smaller side projects as assigned to evaluate vendors, tools, and new technologies (e.g., document control, dashboard and reporting tools, imaging solutions, interfaces, IoT, etc.).
  • Consult with managers to determine the role the EDW impacts the business.

• Minimum requirement of bachelor’s degree in computer science, data engineering, or related discipline
• 7+ years of professional experience in data architecture, data engineering, or analytics engineering roles
• 3+ years of hands‑on experience with Snowflake (RBAC, masking policies, dynamic tables, resource monitors)
• Proficiency in SQL and data transformation frameworks such as dbt
• Strong knowledge of Kimball dimensional modeling and data warehouse design patterns
• Experience integrating with ERP and MES systems such as Epicor and Camstar
• Familiarity with Power BI, Tableau, or equivalent BI tools
• Working knowledge of data privacy and compliance frameworks (ITAR, SOX, GDPR, etc.)
• Prefer experience with Snowpark or machine learning data pipelines
• Familiarity with SQL Fluff for automated SQL linting/validation tools
• Strong understanding of cost governance and monitoring in Snowflake
• Excellent communication and documentation skills, with the ability to bridge business and technical audiences

• Outstanding low‑cost medical, dental, vision, and prescription drug coverage;
  Rochester pays 92% of the premiums on behalf of its full‑time employees
• Paid time off, including vacation, sick, and holiday
• Generous match 401K program
• Flexible spending account