What are the responsibilities and job description for the Data Architect || Racine , WI (Hybrid ) || Contract position at Amaze Systems Inc?
-
Design and implement end-to-end data architecture (Data Lakehouse Data Warehouse)
-
Develop and optimize ETL/ELT pipelines using Databricks (PySpark, Spark SQL)
-
Integrate and migrate data between Teradata and Databricks platforms
-
Build and maintain dimensional data models (star/snowflake schema, SCDs)
-
Ensure data quality, governance, lineage, and security compliance
-
Optimize performance of:
-
Spark jobs (partitioning, caching, cluster tuning)
-
Teradata queries (indexes, partitioning, statistics)
-
-
Collaborate with business stakeholders to translate requirements into scalable solutions