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 HR@insightglobal.com.To learn more about how we collect, keep, and process your private information, please review Insight Global's Workforce Privacy Policy: https://insightglobal.com/workforce-privacy-policy/.
Required Skills & Experience
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
Nice to Have Skills & Experience
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
Benefit packages for this role will start on the 1st day of employment and include medical, dental, and vision insurance, as well as HSA, FSA, and DCFSA account options, and 401k retirement account access with employer matching. Employees in this role are also entitled to paid sick leave and/or other paid time off as provided by applicable law.