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 Austin Tech Scene
Key Facts About Austin Tech
- Number of Tech Workers: 180,500; 13.7% of overall workforce (2024 CompTIA survey)
- Major Tech Employers: Dell, IBM, AMD, Apple, Alphabet
- Key Industries: Artificial intelligence, hardware, cloud computing, software, healthtech
- Funding Landscape: $4.5 billion in VC funding in 2024 (Pitchbook)
- Notable Investors: Live Oak Ventures, Austin Ventures, Hinge Capital, Gigafund, KdT Ventures, Next Coast Ventures, Silverton Partners
- Research Centers and Universities: University of Texas, Southwestern University, Texas State University, Center for Complex Quantum Systems, Oden Institute for Computational Engineering and Sciences, Texas Advanced Computing Center


