What are the responsibilities and job description for the Snowflake Lead position at Jobs via Dice?
RESPONSIBILITIES:
Kforce has a client in Englewood, CO that is seeking a Snowflake Lead.
Summary:
The Snowflake Lead owns the Snowflake architecture for the Gold layer, driving incremental processing, serving patterns, performance optimization, and ensuring business-validated, AI-ready data assets are delivered for downstream BI and AI consumers.
Key Responsibilities:
We offer comprehensive benefits including medical/dental/vision insurance, HSA, FSA, 401(k), and life, disability & ADD insurance to eligible employees. Salaried personnel receive paid time off. Hourly employees are not eligible for paid time off unless required by law. Hourly employees on a Service Contract Act project are eligible for paid sick leave.
Note: Pay is not considered compensation until it is earned, vested and determinable. The amount and availability of any compensation remains in Kforce's sole discretion unless and until paid and may be modified in its discretion consistent with the law.
This job is not eligible for bonuses, incentives or commissions.
Kforce is an Equal Opportunity/Affirmative Action Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, pregnancy, sexual orientation, gender identity, national origin, age, protected veteran status, or disability status.
By clicking ?Apply Today? you agree to receive calls, AI-generated calls, text messages or emails from Kforce and its affiliates, and service providers. Note that if you choose to communicate with Kforce via text messaging the frequency may vary, and message and data rates may apply. Carriers are not liable for delayed or undelivered messages. You will always have the right to cease communicating via text by using key words such as STOP.
Kforce has a client in Englewood, CO that is seeking a Snowflake Lead.
Summary:
The Snowflake Lead owns the Snowflake architecture for the Gold layer, driving incremental processing, serving patterns, performance optimization, and ensuring business-validated, AI-ready data assets are delivered for downstream BI and AI consumers.
Key Responsibilities:
- Lead Snowflake architecture for Gold-layer design, incremental processing, and serving patterns
- Review and certify SnowConvert/SnowConvertAI-generated SQL, DDL, and stored logic
- Ensure Gold-layer tables meet AI Readiness and business validation standards
- Guide Snowflake stream engineers on Dynamic Tables, Snowpark, Snowpipe, and performance optimization
- Validate Gold-layer outputs during dual-run validation cycles and support production cutover
- Ensure metadata, lineage, and data contracts are correctly defined and published in Snowflake Horizon
- Leverage Cortex AI capabilities to support AI-ready serving patterns
- Coordinate with downstream BI and AI consumers to ensure compatibility of migrated outputs
- Guide offshore Snowflake engineers on pattern consistency, quality, and performance standards
- 10 years of experience in Snowflake or cloud data warehouse engineering
- Proven experience designing and delivering Gold-layer, business-facing data models at enterprise scale
- Strong background in Snowpark, incremental processing, and AI-ready serving patterns
- Experience with BI consumption patterns, semantic layer design, and downstream consumer alignment
- Experience leading offshore engineering teams in Agile delivery models
- Medallion Architecture
- Data modeling and Data Engineering
- SQL query tuning and optimization
- Dynamic Tables and incremental processing
- SnowSQL and Snowpark development
- Snowpipe for continuous data ingestion
- Cortex AI and Cortex Code
- SnowConvert AI for SQL migration
- Debugging and troubleshooting at scale
We offer comprehensive benefits including medical/dental/vision insurance, HSA, FSA, 401(k), and life, disability & ADD insurance to eligible employees. Salaried personnel receive paid time off. Hourly employees are not eligible for paid time off unless required by law. Hourly employees on a Service Contract Act project are eligible for paid sick leave.
Note: Pay is not considered compensation until it is earned, vested and determinable. The amount and availability of any compensation remains in Kforce's sole discretion unless and until paid and may be modified in its discretion consistent with the law.
This job is not eligible for bonuses, incentives or commissions.
Kforce is an Equal Opportunity/Affirmative Action Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, pregnancy, sexual orientation, gender identity, national origin, age, protected veteran status, or disability status.
By clicking ?Apply Today? you agree to receive calls, AI-generated calls, text messages or emails from Kforce and its affiliates, and service providers. Note that if you choose to communicate with Kforce via text messaging the frequency may vary, and message and data rates may apply. Carriers are not liable for delayed or undelivered messages. You will always have the right to cease communicating via text by using key words such as STOP.