Primary skills: Snowflake Architecture, Data Vault, Data Modeling, ETL, DBT
Required Skills
Strong hands-on experience with Snowflake Architecture.
Lead Data Vault 2.0 (or 1.x where applicable) adoption: hub, link, satellite design, historization patterns, and business key strategy.
Translate business requirements into canonical models and pragmatic consumption layers (raw/landing, raw vault, business vault, information marts).Proficiency in Matillion and/or Informatica.
Lead design and hands-on development of Matillion and/or Informatica pipelines for ingest, transformation, CDC/streaming, and orchestration.
Implement modern ELT patterns leveraging Snowflake features (COPY, Snowpipe, Streams & Tasks, Materialized Views, zero-copy cloning).
Implement error-handling, retry, and idempotent load patterns.
Strong SQL and ETL/ELT development skills.
Knowledge of data warehousing, cloud data platforms, performance tuning, and data governance.
Good communication and stakeholder management skills.
Hexaware Technologies Chicago, Illinois, USA Office
Chicago, United States, 0
Similar Jobs
What you need to know about the Chicago Tech Scene
Key Facts About Chicago Tech
- Number of Tech Workers: 245,800; 5.2% of overall workforce (2024 CompTIA survey)
- Major Tech Employers: McDonald’s, John Deere, Boeing, Morningstar
- Key Industries: Artificial intelligence, biotechnology, fintech, software, logistics technology
- Funding Landscape: $2.5 billion in venture capital funding in 2024 (Pitchbook)
- Notable Investors: Pritzker Group Venture Capital, Arch Venture Partners, MATH Venture Partners, Jump Capital, Hyde Park Venture Partners
- Research Centers and Universities: Northwestern University, University of Chicago, University of Illinois Urbana-Champaign, Illinois Institute of Technology, Argonne National Laboratory, Fermi National Accelerator Laboratory


