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 Boston, Massachusetts, USA Office
Boston, United States
Similar Jobs
What you need to know about the Boston Tech Scene
Key Facts About Boston Tech
- Number of Tech Workers: 269,000; 9.4% of overall workforce (2024 CompTIA survey)
- Major Tech Employers: Thermo Fisher Scientific, Toast, Klaviyo, HubSpot, DraftKings
- Key Industries: Artificial intelligence, biotechnology, robotics, software, aerospace
- Funding Landscape: $15.7 billion in venture capital funding in 2024 (Pitchbook)
- Notable Investors: Summit Partners, Volition Capital, Bain Capital Ventures, MassVentures, Highland Capital Partners
- Research Centers and Universities: MIT, Harvard University, Boston College, Tufts University, Boston University, Northeastern University, Smithsonian Astrophysical Observatory, National Bureau of Economic Research, Broad Institute, Lowell Center for Space Science & Technology, National Emerging Infectious Diseases Laboratories
