Demo

Data Warehouse Architect

magnit-xcelenergy
Denver, CO Full Time
POSTED ON 3/11/2026
AVAILABLE BEFORE 5/11/2026

Data Architect – Operational Technology to Cloud (Databricks)

Role Summary

The Data Architect – Operational Technology to Cloud will lead the architecture and design of secure, scalable data pipelines that move operational technology (OT) data from on-premises industrial systems into the enterprise Databricks Lakehouse platform.

This role focuses on enabling governed analytics and AI-ready data products by integrating historian systems, sensor telemetry, and industrial asset data into cloud-based data platforms. The architect will collaborate with business leaders, platform engineers, and security teams to modernize legacy data movement pathways and create efficient, secure methods for delivering operational data across the enterprise.

The position plays a critical role in improving how high-volume industrial data is ingested, secured, and exposed for dashboards, analytics, and AI use cases.


Key Responsibilities

Architecture & Solution Design

  • Lead the end-to-end architecture for ingesting and integrating operational technology data into the Databricks Lakehouse.

  • Evaluate and design modern data movement patterns for historian systems, asset telemetry, and industrial data sources.

  • Architect scalable pipelines using batch, streaming, and CDC ingestion patterns.

  • Design data layers including landing, curated, and serving layers within the lakehouse architecture.

OT Data Integration

  • Integrate data from OSI PI, AVEVA systems, SCADA platforms, and industrial telemetry sources.

  • Design methods for ingesting high-volume asset sensor data with low latency and high reliability.

  • Translate OT asset context and hierarchies into analytics-ready data models.

Cloud & Security Architecture

  • Define networking and security controls for moving data from secure on-prem environments into AWS-hosted Databricks workspaces.

  • Architect solutions using VPCs, subnets, private connectivity, IAM policies, and encryption.

  • Ensure adherence to enterprise security requirements and governance standards.

Data Platform Governance

  • Implement data governance standards including:

    • Unity Catalog-based access controls

    • Data classification and stewardship

    • Metadata management and lineage

  • Establish standards for data quality, observability, and reliability across pipelines.

Cross-Team Collaboration

  • Partner with security, infrastructure, analytics, and operations teams to align on architecture decisions.

  • Create architecture documentation, reference patterns, and implementation playbooks.

  • Support engineering teams during solution delivery and architecture reviews.

AI Data Enablement

  • Ensure operational data is structured and governed for AI, machine learning, and advanced analytics use cases.

  • Support development of AI-ready data products and feature engineering datasets.


Project Overview

This role supports enterprise initiatives focused on modernizing operational data pipelines across the organization.

Currently, OT data from industrial systems is available but often moves through high-latency, costly, or legacy pathways. The architect will evaluate existing infrastructure and design new secure data channels that improve performance, scalability, and cost efficiency.

The goal is to make operational data more accessible for:

  • AI and advanced analytics

  • Enterprise dashboards

  • Operational decision-making

  • Cross-department data products

The architect will help build modern pathways that allow OT data to be securely distributed across the enterprise network while maintaining strict governance and compliance standards.


Required Qualifications

Experience

  • 6–10 years of experience in data architecture, data engineering, or industrial data platforms

  • Experience working in operational technology (OT), utilities, energy, or industrial environments

Technical Skills

  • Strong experience with:

    • Databricks Lakehouse architecture

    • Delta Lake

    • Spark / PySpark

    • Python

  • Experience designing data ingestion pipelines (ETL / ELT / CDC).

  • Familiarity with time-series and asset-centric data modeling.

OT & Industrial Data

Experience integrating data from systems such as:

  • OSI PI Historian

  • AVEVA platforms

  • SCADA systems

  • Asset sensor telemetry

Cloud & Security

  • Experience designing secure data architectures in AWS

  • Knowledge of:

    • VPC networking

    • IAM

    • Encryption

    • Private connectivity

    • Cloud security controls

Governance & Data Management

  • Experience with:

    • Unity Catalog

    • Metadata management

    • Data lineage

    • Data classification

    • Master data governance

Collaboration Skills

  • Ability to communicate with both technical and business stakeholders

  • Experience working across multiple architecture and engineering teams


Preferred Qualifications

  • Experience integrating AVEVA PI Asset Framework with cloud data platforms

  • Experience building real-time or near-real-time OT data pipelines

  • Databricks or AWS certifications

  • Experience working in regulated utility or energy environments

  • Familiarity with IoT device data and industrial telemetry streams


Core Competencies

  • Architecture leadership

  • Security-by-design mindset

  • Systems thinking

  • Cross-team collaboration

  • Technical coaching and mentorship

  • Clear technical documentation and communication


Success Metrics

Success in this role will be measured by:

  • Delivery of secure OT data products within Databricks

  • Reduction in latency and cost of operational data pipelines

  • Faster onboarding of new OT data sources

  • Adoption of standard architecture patterns across teams

  • Positive reviews from enterprise architecture and security boards


Interview Process

  • Round 1: Technical interview with architecture and data platform team members

  • Round 2: Panel interview with cross-functional stakeholders (3 team members)


Ideal Candidate Profile

The ideal candidate combines strong data platform engineering skills with operational technology experience. They understand how industrial assets generate telemetry data and can design secure, modern pipelines that bring that data into cloud analytics platforms.

This role requires someone who can balance technical depth with collaboration, helping multiple teams modernize legacy data infrastructure while maintaining strict governance and security standards.

Salary.com Estimation for Data Warehouse Architect in Denver, CO
$116,999 to $142,433
If your compensation planning software is too rigid to deploy winning incentive strategies, it’s time to find an adaptable solution. Compensation Planning
Enhance your organization's compensation strategy with salary data sets that HR and team managers can use to pay your staff right. Surveys & Data Sets

What is the career path for a Data Warehouse Architect?

Sign up to receive alerts about other jobs on the Data Warehouse Architect career path by checking the boxes next to the positions that interest you.
Income Estimation: 
$114,981 - $143,201
Income Estimation: 
$129,640 - $165,363
Income Estimation: 
$68,745 - $88,154
Income Estimation: 
$87,428 - $116,878
Income Estimation: 
$91,609 - $116,575
Income Estimation: 
$87,428 - $116,878
Income Estimation: 
$115,838 - $142,817
Income Estimation: 
$114,981 - $143,201
Income Estimation: 
$115,838 - $142,817
Income Estimation: 
$129,640 - $165,363
Income Estimation: 
$114,981 - $143,201
Income Estimation: 
$129,640 - $165,363
Employees: Get a Salary Increase
View Core, Job Family, and Industry Job Skills and Competency Data for more than 15,000 Job Titles Skills Library

Job openings at magnit-xcelenergy

  • magnit-xcelenergy Saint Paul, MN
  • Data Analyst II – Master Data & Governance (Requisition 1654) Location: Hybrid – Roseville, MN (preferred) or Colorado Onsite Tuesday–Thursday (Roseville: ... more
  • 9 Days Ago

  • magnit-xcelenergy Denver, CO
  • Project Coordinator – Expert Location: Denver, CO (Remote with occasional onsite meetings preferred) Duration: 12-month contract (high likelihood of extens... more
  • 11 Days Ago

  • magnit-xcelenergy Saint Paul, MN
  • Job Title Construction Project Manager – Gas Transmission (High Risk Role 1524) Locations 1 position – Rice Street Service Center, 825 Rice St, St Paul, MN... more
  • 12 Days Ago

  • magnit-xcelenergy Saint Paul, MN
  • Job Title: Financial Analyst (Project Portfolio Support) Location: Denver or Minneapolis / Roseville (Hybrid: 2–3 days onsite) Position Type: Contract (12 ... more
  • 13 Days Ago


Not the job you're looking for? Here are some other Data Warehouse Architect jobs in the Denver, CO area that may be a better fit.

  • Fleet Data Centers Denver, CO
  • Fleet Data Centers designs, builds and operates mega-scale data center campuses. Fleet provides its customers flexibility and predictability to meet their ... more
  • 9 Days Ago

  • Jobs via Dice Denver, CO
  • Dice is the leading career destination for tech experts at every stage of their careers. Our client, Strategic Staffing Solutions, is seeking the following... more
  • 20 Days Ago

AI Assistant is available now!

Feel free to start your new journey!