Job Description
MUST BE LOCAL TO TX
Role Overvie
wWe are seeking a Lead / Principal Snowflake Engineer to architect and build scalable, enterprise-grade data platforms on Snowflake. This role will own the end-to-end data lifecycle, including ingestion, transformation, semantic layer implementation, and delivery of Front-end application
.You will act as a technical leader and architect, driving platform modernization, enforcing engineering standards, and ensuring performance, scalability, and cost efficiency
.
Key Responsibiliti
es1. Data Platform Architecture & Modernizati
- onDesign and build scalable Snowflake data platforms using best practic
- esAssess legacy systems and define modernization and migration strategi
- esEstablish architectural standards, governance frameworks, and reusable patter
ns2. Data Engineering & Integrati
- onDevelop end-to-end ELT pipelines from APIs, databases, SaaS platforms, and event strea
- msBuild reliable connectors with robust error handling, retry logic, and data consisten
- cyTransform raw data into clean, normalized, consumption-ready datase
ts3. Data Modeling & Semantic Lay
- erDesign dimensional data models (fact/dimension, star/snowflake schema
- s)Implement business-friendly semantic layers aligned with enterprise reporting nee
- dsBuild aggregations, pre-computed metrics, and optimized data structures for analyti
cs4. Snowflake Engineering & Optimizati
- onDevelop advanced SQL transformations and implement performance tuning strategi
- esManage warehouse sizing, workload optimization, and cost governan
- ceImplement RBAC, data security, versioning, and data sharing mechanis
ms5. BI & Analytics Enableme
- ntAlign Snowflake data models with Power BI (DirectQuery and Import model
- s)Optimize datasets for performance, scalability, and reporting efficien
cy6. Data Quality, Observability & AI Enableme
- ntImplement data validation, monitoring, and alerting framewor
- ksEnsure high reliability and trust in downstream data consumpti
- onLeverage Snowflake Cortex, Agentic AI patterns, and AI tools to automate workflows and improve engineering productivi
ty7. Leadership & Stakeholder Engageme
- ntProvide technical leadership and mentor engineering tea
- msCollaborate with stakeholders to define business and technical requiremen
- tsDrive adoption of best practices in Snowflake and modern data engineeri
ng
Required Qualificati
- ons10+ years of experience in data engineering, data architecture, or related ro
- lesStrong expertise in Snowflake (data modeling, performance tuning, governance, securi
- ty)Proven experience building end-to-end data platforms from scra
- tchDeep knowledge of semantic layer design and BI alignm
- entAdvanced SQL expertise (window functions, PIVOT, GROUPING SETS, et
- c.)Experience with multi-source data integration (RDBMS, APIs, SaaS, streami
- ng)Strong cloud expertise (Azure/AWS) with Snowflake integrat
- ionProficiency in Python for data engineering and automat
- ionFamiliarity with Agentic AI concepts and AI-driven tools to improve development efficiency and automat
ionPreferred Qualificati
- onsExperience with dbt (models, testing, lineage, documentati
- on)Exposure to data observability tools (SOD
- A.)Experience with SnapLogic, AWS S3, or equivalent servi
- cesExperience with Snowflake Cortex / AI-based workfl
- owsDomain experience in Operation Data (Cloud FinOps, AI Tool Ops, Managed Services Data, Agile Delivery Data will be Advanta
ge.Success Crite
- riaAbility to design, architect, and deliver Snowflake platforms end-to-
- endStrong focus on performance, scalability, and cost optimizat
- ionExpertise in data modeling and semantic layer implementat
- ionDemonstrated technical leadership and stakeholder managem
ent