Insight Global
Oaks, PA, USA
Job Description This role is responsible for designing, building, and maintaining enterprise data warehouse solutions with a strong focus on Data Vault 2.0. The position owns end-to-end data modeling, including the implementation of Hubs, Links, Satellites, Raw Vault, Business Vault, and downstream Information/Data Marts to ensure scalability, auditability, and historization. Responsibilities include designing dimensional models (star and snowflake schemas), defining proper data grain and conformed dimensions, and translating business and technical requirements into maintainable data architectures. The role architects and optimizes ELT pipelines using Snowflake, Airflow, dbt, and Python, implementing metadata-driven, reusable patterns that support incremental loads, CDC, and data quality validation. This position continuously monitors and improves data warehouse performance, conducts root-cause analysis of defects and performance issues, and ensures production readiness across...

