Data Architect

Insight Global is seeking a Data Architect for one of our largest financial clients in Plano, TX or Charlotte, NC. The Data Architect/Analyst drives enterprise-wide capacity management and data platform insights by building scalable analytics solutions within the Enterprise Data Warehouse. Partnering with engineering, platform, finance, and operations teams, this role delivers accurate capacity, usage, and forecasting insights to support strategic planning, cost optimization, and platform modernization across enterprise platforms such as Hadoop and Teradata. This role will contribute to building a single source of truth for capacity metrics, automating manual reporting processes, and enabling data-driven decision-making for storage, compute, onboarding demand, support reclamation and hygiene efforts and inventory management across enterprise platforms such as Hadoop and Teradata platforms.

Must Haves:

7-10 years of relevant experience in data analysis, data development, or analytics engineering within large-scale enterprise data warehouse platforms and distributed data systems, including Hadoop, Teradata, and cloud or hybrid data platforms.

Proficiency in SQL across Teradata, Hive, Impala, and PostgreSQL, with hands-on experience designing and maintaining performant data models and transformations in large-scale environments.

Hands-on experience consuming REST APIs and loading API-driven datasets into persisted tables to support procuring point in time data.

Expertise in Excel: v look ups, pivot tables, automation in Excel such as VBA Previous financial enterprise experience

Strong hands-on experience with HDFS, Ozone, and Teradata, including use of HDFS CLI commands to assess storage consumption, along with familiarity with S3-compatible object storage concepts (volumes, buckets, keys).

VBA experience in Excel