Data Warehouse Architect

Post Date

Jul 23, 2025

Location

Montville,
Connecticut

ZIP/Postal Code

06382
US
Oct 26, 2025 Insight Global

Job Type

Perm

Category

Architect

Req #

HTD-7aea90cb-b238-45d2-9708-f4adba8edc09

Pay Rate

$104k - $130k (estimate)

Job Description

A client of Insight Global is looking to hire a hybrid Data Warehouse Architect. This position is focused on managing and improving an enterprise-wide data architecture, ensuring that data is accessible, secure, and high-performing. The role involves designing and maintaining data warehouse systems, overseeing data storage strategies, and ensuring data quality across platforms. Day-to-day responsibilities include monitoring and troubleshooting failed jobs, performing system maintenance and enhancements, correcting data issues, and contributing to various projects. The individual collaborates with business and IT leadership to understand data needs, supports business intelligence initiatives, and helps train users on data tools. They also play a key role in capacity planning, performance optimization, and ensuring compliance with data privacy regulations like HIPAA. The role requires working on complex technical challenges with minimal supervision and mentoring junior staff.

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

- 2-5 years working with Informatica
- 2-5 years with other ETL tools such as: SSIS, AWS Glue, AWS Data Pipeline, Fivetran, or other open source ETL tools
- 3-5 years of experience with Snowflake and SQL
• 3-5 years of experience as a Data Engineer or Data Architect

Nice to Have Skills & Experience

• Master's degree in computer science or engineering
- Power BI
- Experience working within AI

Benefit packages for this role will start on the 31st 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.