Data Architect

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.

We are a company committed to creating diverse and inclusive environments where people can bring their full, authentic selves to work every day. We are an equal opportunity/affirmative action employer that believes everyone matters. Qualified candidates will receive consideration for employment regardless of their race, color, ethnicity, religion, sex (including pregnancy), sexual orientation, gender identity and expression, marital status, national origin, ancestry, genetic factors, age, disability, protected veteran status, military or uniformed service member status, or any other status or characteristic protected by applicable laws, regulations, and ordinances. If you need assistance and/or a reasonable accommodation due to a disability during the application or recruiting process, please send a request to View email address on click.appcast.io learn more about how we collect, keep, and process your private information, please review Insight Global's Workforce Privacy Policy:

Skills and 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