Data Architect

Insight Global

Plano, TX, United States

2 months ago

Role details

Contract type

Permanent contract

Employment type

Full-time (> 32 hours)

Experience level

Expert

Experience required

7 years minimum

Working hours

Regular working hours

Job source

dejobs.org

Tech stack

Microsoft Excel Amazon S3 Data Analysis Cloud Computing Cloudera Impala Data Architecture Data Infrastructure Data Warehousing Database Development Distributed Data Store Apache Hadoop Hadoop Distributed File System

+10 more

Apache Hive PostgreSQL Pivot Tables SQL Databases Teradata SQL Cloud Platform System Vba Programming Language Data Management Api Design Restful APIs

Job description

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.

Requirements

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