Enterprise Data Warehouse Architect

Brief Description

The Enterprise Data Warehouse (EDW) Architect is responsible for the strategic design, governance, and implementation of Rochester Electronics’ enterprise data warehouse environment. This role advances the company’s data modernization strategy by establishing a secure, scalable, and compliant Snowflake‑based platform that unifies data across Manufacturing, Finance, Sales, and Engineering functions.

• Data Architecture & Platform Design
  • Design and implement a Snowflake 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 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 document data lineage and access controls.
• Modeling & Data Standards
  • Develop and maintain Kimball‑style dimensional models for analytical use cases.
  • 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.
• Integration & Automation
  • Partner with analysts and developers to orchestrate automated data pipelines.
  • Manage service accounts, warehouses, and compute isolation for departmental workloads.
  • Develop and document scripts for key rotation, environment cloning, and metadata synchronization.
• Analytics Enablement
  • Collaborate with BI teams to build certified semantic models and Gold‑layer views for Power BI and Tableau.
  • Enable data democratization through reusable datasets and standardized KPI definitions.
  • Support AI and machine learning initiatives through secure data provisioning and feature store development.
  • Work with developers, managers, and service providers to maximize EDW effectiveness.
• Leadership & Collaboration
  • 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 platform adoption, performance, and cost optimization.
  • Coordinate with departmental teams to support business outcomes and influence stakeholders.
  • Offer data‑driven advice on operational improvements and new technology evaluations.
  • Manage smaller side projects such as vendor evaluation, dashboard tools, and IoT interfaces.

• Minimum 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.).
• Preferable experience with Snowpark or machine‑learning data pipelines.
• Familiarity with SQLFluff or automated SQL linting/validation tools.
• Strong understanding of cost governance and monitoring in Snowflake.
• Excellent communication and documentation skills, bridging business and technical audiences.

• Low‑cost medical, dental, vision, and prescription drug coverage (Rochester pays 92% of premiums).
• Paid time off, including vacation, sick leave, and holidays.
• Generous 401(k) match program.
• Tuition reimbursement.
• Flexible spending accounts.