Apply Now

Enterprise Data Architect

Newburyport, MA, US • Posted 4 hours ago • Updated 4 hours ago

Full Time

On-site

Fitment

Dice Job Match Score™

🤯 Applying directly to the forehead...

Job Details

Skills

Electronics
Decision-making
Database
Network
Accountability
Lifecycle Management
Streaming
Real-time
End-user Training
Data Governance
Data Security
IT Security
Auditing
Access Control
Modeling
Analytical Skill
Use Cases
Slowly Changing Dimensions
Management
Scripting
Meta-data Management
Semantics
KPI
Artificial Intelligence
Provisioning
Collaboration
Finance
Manufacturing
Sales
Mentorship
Optimization
Leadership
Document Management
Dashboard
Reporting
Interfaces
IoT
Computer Science
Data Architecture
Data Engineering
Analytics
RBAC
Dimensional Modeling
Data Warehouse
Design Patterns
Enterprise Resource Planning
MES
Epicor
Microsoft Power BI
Tableau
Business Intelligence
Privacy
Regulatory Compliance
ITAR
Sarbanes-Oxley
Machine Learning (ML)
SQL
Snow Flake Schema
Communication
Documentation

Electronics
Decision-making
Database
Network
Accountability
Lifecycle Management
Streaming
Real-time
End-user Training
Data Governance
Data Security
IT Security
Auditing
Access Control
Modeling
Analytical Skill
Use Cases
Slowly Changing Dimensions
Management
Scripting
Meta-data Management
Semantics
KPI
Artificial Intelligence
Provisioning
Collaboration
Finance
Manufacturing
Sales
Mentorship
Optimization
Leadership
Document Management
Dashboard
Reporting
Interfaces
IoT
Computer Science
Data Architecture
Data Engineering
Analytics
RBAC
Dimensional Modeling
Data Warehouse
Design Patterns
Enterprise Resource Planning
MES
Epicor
Microsoft Power BI
Tableau
Business Intelligence
Privacy
Regulatory Compliance
ITAR
Sarbanes-Oxley
Machine Learning (ML)
SQL
Snow Flake Schema
Communication
Documentation

Summary

Description

The Enterprise Data Architect is responsible for the strategic design, governance, and implementation of Rochester Electronics' enterprise data warehouse environment. This position plays a critical role in advancing 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.

The Enterprise Data Architect will serve as the technical authority for data architecture, modeling, and governance, ensuring that enterprise data assets are well-structured, compliant with ITAR regulations, and optimized for analytics and AI-driven decision-making.

Responsibilities

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.
- Manages platform implementations and upgrades efforts, and any 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.
Modeling & Data Standards
- 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.

Integration & Automation
- 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.

Analytics Enablement
- 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.

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 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.
- Coordinates with different departmental teams to produce better business outcomes.
- Influences stakeholders to support business projects.
- Provides data-driven advice on how to expand or refine its operations to meet company needs.
- Manages 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 what role the EDW impacts the business.

Qualifications

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 SQLFluff or 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

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.

Dice Id: RTL739290
Position Id: cc2f264215f9c525b859c8cdab7b68ae
Posted 4 hours ago

Create job alert

Never miss an opportunity! Create an alert based on the job you applied for.

Similar Jobs

Data Assurance Specialist

Newburyport, Massachusetts

•

Today

Description The Data Assurance Specialist is a highly technical role responsible for ensuring the accuracy, consistency, and integrity of data across multiple systems. This position requires strong hands-on expertise in data tools and technologies, including SQL, Python, and modern data platforms such as Snowflake, to analyze, validate, and remediate data at scale. The specialist will proactively evaluate data flows between systems to identify inconsistencies, perform root cause analysis, and

Full-time

USD 94,000.00 per year

Senior Snowflake Developer

Boston, Massachusetts

•

Today

Job Description This is a 12-month contract opportunity with a housing and community development organization in Boston. Seeking a Senior Snowflake Developer to build and support a cloud data warehouse using Snowflake, SQL, and Python. High-impact role focused on building data pipelines and enabling reporting/analytics for housing programs. It is ideal for someone strong in Snowflake who can work cross-functionally and own end-to-end data engineering. Contract Duration: 12 Months Required Skill

Easy Apply

Contract

$70 - $80

Snowflake Developer

Hybrid in Boston, Massachusetts

•

16d ago

Position: Senior Snowflake Developer Location: Boston, MA Hybrid Client: Commonwealth of MA Duration: Multi Year Renewable Contract Hours: 37.5 Hours per week Position Summary: The Executive Office of Housing and Livable Communities (EOHLC) Information Technology Division is seeking an experienced Senior Snowflake Developer to design, develop, and support the agencys cloud-based data warehouse environment. This role is responsible for building scalable data solutions that support reporting, an

Easy Apply

Contract

Depends on Experience

AWS Data Architect

Remote

•

10d ago

Job Description AWS Data Architect We are seeking an experienced Data Architect with 15 years of experience in designing and implementing enterprise-scale data platforms on AWS and Snowflake. The ideal candidate will have strong expertise in building scalable data lakes, lakehouses, data warehouses, and high-performance ETL/ELT pipelines. Key Responsibilities Design and architect modern data platforms using AWS and Snowflake. Develop scalable Data Lakes, Lakehouses, and Data Warehouse solutio

Easy Apply

Full-time, Third Party

70 - 70

Search all similar jobs

More jobs at Rochester Electronics, LLC in Newburyport, MA