Data Warehouse Architect

Job Title:

Data Warehouse Architect III

Location: 100% Remote

Duration: 12 months\+ on W2 with High possibility of extension

This role supports the enterprise Data, AI, and Integrations Architecture organization and focuses on exposing operational technology (OT) data sources for secure and scalable consumption. The Data Warehouse Architect III will act as a senior data architect embedded in OT-related efforts, driving modernization of data pipelines and patterns across the enterprise.

Scope Of Work \& Responsibilities

Architect and modernize data solutions for OT data sources including sensor, time-series, and event-based data.

Design secure data pipelines for highly sensitive data residing in segmented network environments.

Enable reusable, consumable data products rather than point-to-point integrations.

Drive modernization away from antiquated data warehousing patterns.

Leverage Databricks, AWS, ETL/data movement platforms, and cloud networking concepts.

Create, present, and defend architectural diagrams and artifacts through architecture review boards.

Partner closely with OT teams, business data owners, engineers, and enterprise architecture teams.

Required Skills \& Experience

7–9 years of experience as a Data or Data Warehouse Architect.

Strong experience with data modeling, ETL/data movement platforms, and cloud-based architectures.

Hands-on experience with Databricks and AWS.

Experience designing architectures for secure or segmented network environments.

Ability to modernize legacy data warehouse solutions.

Strong communication and presentation skills.

Nice-to-have experience

includes utility or energy data environments, PI/OSI PI, SCADA, and relevant AWS or Databricks certifications.