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.
Similar Jobs
What you need to know about the Charlotte Tech Scene
Key Facts About Charlotte Tech
- Number of Tech Workers: 90,859; 6.5% of overall workforce (2024 CompTIA survey)
- Major Tech Employers: Lowe’s, Bank of America, TIAA, Microsoft, Honeywell
- Key Industries: Fintech, artificial intelligence, cybersecurity, cloud computing, e-commerce
- Funding Landscape: $3.1 billion in venture capital funding in 2024 (CED)
- Notable Investors: Microsoft, Google, Falfurrias Management Partners, RevTech Labs Foundation
- Research Centers and Universities: University of North Carolina at Charlotte, Northeastern University, North Carolina Research Campus

