Data Engineer

Vital IT Services • Allen, TX

87d • $85,000 - $115,000

About The Position

To design, build, and maintain highly reliable data pipelines, storage systems, and transformational schemas; ensuring that secure, clean, and optimized data flows continuously across all core SaaS products and client reporting systems.

Requirements

• 3-5 years of dedicated experience operating as a Data Engineer or Database Developer managing complex, multi-source data environments (experience in high-compliance SaaS or financial services is a major plus).
• Expert-level mastery of advanced SQL (including writing highly performant queries, complex joins, subqueries, and database optimization techniques).
• Solid experience writing scripts in Python or similar development languages to run automated API data extractions, cleansing routines, and custom integrations.
• Strong practical experience with cloud-native data services (e.g., Azure SQL, Cosmos DB, AWS Athena, or Snowflake) and cloud data pipeline engines (e.g., Azure Data Factory, dbt, or Airflow).
• Deep conceptual understanding of star schemas, snowflake schemas, and relational database normalization vs. denormalization strategies.

Responsibilities

• Designing, constructing, and maintaining automated data pipelines (ETL/ELT) to ingest, clean, and transform disparate data sources into organized, high-performance repositories.
• Designing logical and physical database schemas across relational (e.g., SQL Server, Azure SQL) and non-relational (e.g., Cosmos DB) platforms to support application scale and fast query execution.
• Building and optimizing centralized data warehouses or staging environments that aggregate complex transactional insurance data for downstream reporting systems.
• Monitoring, profiling, and tuning database performance - including query execution plan analysis, index optimization, and storage strategy adjustments.
• Implementing rigorous access controls, data masking, encryption standards, and retention policies to ensure absolute compliance with SOC 2 and insurance data-privacy rules.

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level
• Education Level: No Education Listed