Data Warehouse Architect

The Ash Group; Minneapolis (MN); Hybrid; USD 150,158; Full time

Benefits offered by this job

Medical, dental, vision benefits

4% matched 401(k) plan with immediate vesting

Job summary

A leading energy consultancy is hiring a Data Warehouse Architect for a 12-month hybrid contract. The role focuses on modernizing data pipelines in OT systems using Databricks and AWS. With a compensation of $109 per hour, you will be responsible for designing secure data solutions and enabling reusable data products. This role is ideal for those with experience in utility or energy data environments. Apply today to drive innovation and modernization in data practices.

Qualifications

• Must have experience with modern data solutions and data architecture.
• Exposure to voluminous data, preferably sensor type data.
• Utility or energy data environments experience is desirable.

Responsibilities

• Architect and modernize data solutions for OT systems.
• Design secure data pipelines for sensitive information.
• Enable reusable, consumable data products.
• Drive modernization of data warehousing patterns.
• Leverage Databricks and AWS for data solutions.

Skills

Databricks

XDF Lakehouse

Delta

PySpark

Python

Data Processing

Architecture & Integration

OT/SCADA/Telemetry

Security (Encryption, Networking, DMZ, ABAC)

Governance (Metadata, Lineage, Stewardship, Classification, Unity Catalog)

AWS (S3, IAM, IaC)

Deployment & Scalability

Observability

Job description

*** No 3rd Parties and no C2C. Green Card or US Citizens only ***

Summary

The Ash Group is hiring a Data Warehouse Architect for our client, a major electricity and natural gas utility provider. This is a 12 month contract role, working in Denver, CO (Hybrid) offering a pay rate of $109 per hour W2 based on skill set.

• Compensation: $109/hr W2
• Benefits: Medical, dental, vision, and direct primary care benefits. After six months of employment, enjoy a 4% matched 401(k) plan with immediate 100% vesting.
• Duration: 12 months

What You’ll Be Doing

• 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.

What We’re Looking For

• Must have experience with Databricks, XDF Lakehouse, Delta, PySpark, Python; Data Processing (Ingestion, Streaming, Batch, CDC, ELT, ETL); Architecture & Integration; OT/SCADA/Telemetry; Security (Encryption, Networking, DMZ, ABAC); Governance (Metadata, Lineage, Stewardship, Classification, Unity Catalog); AWS (S3, IAM, IaC); Deployment & Scalability (Resiliency, Performance Optimization); Observability, Documentation, Diagramming.
• Exposure to voluminous data, sensor type data is ideal
• Utility or energy data environments, PI/OSI PI, SCADA, and relevant AWS or Databricks certifications are a nice to have

Apply today if you are interested in being a data architect embedded in OT-related efforts, driving modernization of data pipelines and patterns across the enterprise for our client.