Data Platform Engineer: Secure Pipelines & Warehouses

Vital IT Services; Allen (TX); On-site; USD 90,000 - 130,000; Full time

Job summary

Vital IT Services is looking for a Data Engineer to design, build, and maintain highly reliable data pipelines, storage systems, and schemas for SaaS products and client reporting. You will optimize data flows, ensure security and SOC 2 compliance, and collaborate with cross-functional teams on data architectures.

The role requires 3–5 years of experience with SQL, Python, and modern cloud data tools and a strong track record in high-compliance environments. WFO in Allen, TX may apply.

Qualifications

• 3–5 years of dedicated experience as a Data Engineer or Database Developer
• Advanced SQL including complex joins, queries, and optimizations
• Proficiency in Python or similar scripting languages for data extraction and cleaning
• Experience with cloud data services and data pipeline engines (Azure Data Factory, Airflow, dbt)
• Understanding of star/snowflake schemas and relational modeling

Responsibilities

• Design, construct, and maintain automated data pipelines (ETL/ELT) to ingest, clean, and transform data sources
• Model logical and physical database schemas across relational and non-relational platforms
• Build and optimize centralized data warehouses and staging areas for reporting
• Tune query performance, indexing, and storage strategies to meet SLAs
• Implement data security controls and SOC 2/compliance measures

Skills

Advanced SQL

Python scripting

Query optimization

Cloud data services

Data warehousing concepts

Tools

Azure SQL

Cosmos DB

AWS Athena

Snowflake

Azure Data Factory

dbt

Airflow

Job description

Vital IT Services is looking for a Data Engineer to design, build, and maintain highly reliable data pipelines, storage systems, and schemas for SaaS products and client reporting. You will optimize data flows, ensure security and SOC 2 compliance, and collaborate with cross-functional teams on data architectures.

The role requires 3–5 years of experience with SQL, Python, and modern cloud data tools and a strong track record in high-compliance environments. WFO in Allen, TX may apply.