Teradata Data Architect / Data Engineer

About this role

Dice is the leading career destination for tech experts at every stage of their careers. Our client, Astute Solutions LLC, is seeking the following. Apply via Dice today!


We are seeking a senior Teradata Data Architect / Data Engineer to lead the design, development, and optimization of enterprise data warehouse, data integration, and modern data platform solutions for a California state agency. The role owns the data architecture vision — data modeling, ETL/ELT and big-data pipelines, performance tuning, and data governance — while serving as the senior technical authority guiding development teams and state stakeholders through the full project and approval lifecycle. Public sector data warehousing experience and familiarity with California Department of Technology (CDT) project frameworks are strongly preferred.


Key Responsibilities

• Define and own the overall data architecture across the enterprise Teradata warehouse and modern lakehouse/cloud platforms, including logical/physical data models, schema design, and data layer strategy
• Design and develop scalable ETL/ELT and big-data pipelines to ingest, transform, and integrate data from multiple source and legacy state systems
• Build and optimize data pipelines on Databricks / Apache Spark (PySpark, Spark SQL), including Delta Lake and lakehouse/medallion architecture
• Develop, optimize, and tune complex Teradata SQL, BTEQ, stored procedures, macros, and views for performance and scalability
• Architect data integration using Teradata utilities (FastLoad, MultiLoad, TPT, FastExport, TPump) and modern ingestion frameworks
• Design and implement batch and streaming data pipelines (e.g., Kafka, Spark Structured Streaming, Auto Loader)
• Build and manage workflow orchestration (e.g., Apache Airflow, Databricks Workflows, Azure Data Factory)
• Lead performance optimization — query tuning, indexing/PPI strategy, statistics collection, workload management (TASM), Spark cluster/job tuning, and capaci...