Data Warehouse Architect

Stafford Gray; Town of Lansing (NY); On-site; USD 140,000 - 210,000; Full time

Job summary

Stafford Gray seeks a Data Platform Architect to drive the target-state architecture for the enterprise data platform, guiding data, analytics, and ML product alignment with the company’s data strategy and landscape.

The role requires leadership of Data Architects, collaboration with Enterprise Architects, and experience building architecture patterns and reference architectures to sustain data-driven decision making.

Qualifications

• Minimum 5 years experience leading Data Architects and aligning data landscape with business using TOGAF/FEAF/DODAF.
• Minimum 5 years experience developing Reference Architectures and Architecture Patterns Library in a large enterprise.
• Minimum 3 years experience driving the RFP process for Data Platform technologies with vendors to co-develop innovative EDP capabilities.
• BS in Computer Science, Data Science, Information Systems, or a related field - required.

Responsibilities

• Track emerging industry capabilities for modern Enterprise Data Platforms (EDP) and develop target-state Data Platform Architecture.
• Architect Data, Analytics, and ML Products aligned with enterprise data strategy, data landscape, data skills, data security, and data sharing needs.

Skills

SQL

Python

R

Java

Education

BS in Computer Science

BS in Data Science

Tools

Delta Lake

Databricks

Data Lake

NoSQL DB

GraphDB

Power BI

Job description

The Data Platform Architect / Data Warehouse Architect (Level 5) tracks emerging industry capabilities for modern Enterprise Data Platforms (EDP), develops target‑state Data Platform Architecture, and architects Data, Analytics, and ML Products aligned with enterprise data strategy, data landscape, data skills, data security, and data sharing needs - supporting the realization of enterprise business strategy outcomes.

Required Skills (Must haves):

1. Minimum 5 years experience leading Data Architects and working with Enterprise Architects to develop Data Landscape, Data Strategy, and Data Architectural approaches using an industry‑standard architecture framework (e.g., TOGAF 9, FEAF, DODAF) to align data landscape with business, application, and technology landscapes in support of a data‑driven business strategy.
2. Minimum 5 years experience developing Reference Architectures and an Architecture Patterns Library, and conducting Architectural Reviews to identify and manage architectural exceptions, ensuring architectural integrity of an Enterprise Data Platform in a large enterprise.
3. Minimum 3 years experience driving the RFP process for selecting Data Platform technologies, partnering with vendors to co‑develop innovative EDP capabilities, driving EDP innovation, and promoting a data‑driven decision‑making culture through Communities of Practice.
4. BS in Computer Science, Data Science, Information Systems, or a related field - required.

Most Preferred Skills:

• Experience with Data Lake, Delta Lake, EDP, Data Warehousing, and Databricks

Key Programming Languages:

SQL, Python, R, Java

Other Technologies/Concepts/Frameworks:

TOGAF, Data Lake, Delta Lake, NoSQL DB, GraphDB, EDP, Data Warehousing, Data Marts, Databricks, Operational Data Stores, Power BI, Tableau