Lead/Principal Snowflake Engineer

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