Cloud Data Engineer: Data Modeling & AI Context

DataJobs; Houston (TX); On-site; USD 110,000 - 150,000; Full time

Job summary

PSS Cross Country Infrastructure Solutions in Houston, TX is seeking a Data Engineer to design and maintain the data architecture that supports business systems and analytics. This role focuses on data modeling, transformation, classification, and governance to ensure data is consistent, documented, and trustworthy.

You will also work on ETL/ELT pipelines to move data into a cloud data warehouse, monitor data quality, and enable AI/LLM-powered applications with properly scoped context.

Qualifications

• 4+ years of data engineering or data architecture experience in production.
• Strong SQL skills and cloud data warehouse experience (Snowflake and MSFT SQL Server preferred).
• Experience building ETL/ELT pipelines.
• Solid understanding of data governance fundamentals: classification, access control, and documentation.
• Understanding of how AI/LLM applications consume data and context windows.
• Excellent communication and ability to be a go-to data resource.

Responsibilities

• Design canonical, well-documented data models for core entities to enable a single source of truth.
• Evolve schemas as business needs change while balancing long-term maintainability.
• Set and enforce data modeling standards and documentation practices.
• Build and maintain ETL/ELT pipelines moving data into a cloud data warehouse.
• Monitor data quality and pipeline health, troubleshooting at the source.
• Integrate new data sources and vendor APIs into the existing architecture.
• Define data classification standards for sensitive data across systems.
• Support data lineage and access control with thorough metadata and documentation.
• Maintain a data dictionary and usable documentation for other teams.
• Design data structures for AI/LLM consumption with well-scoped, accurate context.
• Collaborate with engineering, product, and business teams to translate requirements.

Skills

SQL

Data modeling

Data governance

AI/LLM basics

Communication

Tools

Snowflake

MSFT SQL Server

ETL/ELT

Power BI

GitHub Actions

AWS

Python

Job description

PSS Cross Country Infrastructure Solutions in Houston, TX is seeking a Data Engineer to design and maintain the data architecture that supports business systems and analytics. This role focuses on data modeling, transformation, classification, and governance to ensure data is consistent, documented, and trustworthy.

You will also work on ETL/ELT pipelines to move data into a cloud data warehouse, monitor data quality, and enable AI/LLM-powered applications with properly scoped context.