Snowflake Data Engineer
Trail Blazer Consulting LLC
Dice Job Match Score™
🔢 Crunching numbers...
Job Details
Skills
- Data Engineering
- SQL
- Snow Flake Schema
- Microsoft Azure
- Python
- Snowflake
- Optimization
- Stored Procedures
- Warehouse
- Machine Learning (ML)
- Cloud Computing
- Employment Authorization
- Artificial Intelligence
Summary
Job Title | Data Engineer (Snowflake) |
Location | Hybrid 3 days onsite Tue-Thur, in Dublin, CA Need nearby candidates |
Type | C2C |
Visa | USC |
Duration | 6 Months |
Interview Mode | video 2-3 rounds |
Need old linkedin with profile pic
Work Authorization (open to ISS/C2C) No Sponsorship Available Interview Process • 1st Round - 45 min, w/ Manager , techno-functional • 2nd Round - 60 min, w/Lead + Sr. Engineer - Technical Deep Dive • 3rd Round - 45 min, w/POC -
Hands-on Snowflake data engineer with strong Azure, Python, and SQL skills who can build working prototypes, troubleshoot complex platform issues, and evaluate new technologies independently.
Reason for position Support and evolve our existing Snowflake/Azure data platform while evaluating and building new data and AI capabilities. The role combines hands-on engineering, platform troubleshooting, research, prototyping, and emerging technology adoption. Team Overview Enterprise data technology team supporting our modern cloud data environment.
The role partners across Data Engineering, Analytics, Architecture, Infrastructure, and related technical teams.
This is not a dedicated production-support role. The engineer will help troubleshoot platform issues and provide broader L2/L3-type technical support when needed, including occasional issues outside normal hours.
Work split: ~60% Innovation / new capabilities ~40% Existing platform / support
The team is continuing to evolve its data platform while exploring new technologies, including AI capabilities, Snowflake Cortex, agents, Apache Iceberg, and automation Project Description Support, enhance, and evolve the enterprise data platform, with a primary focus on Snowflake, Azure, Python, and SQL. The position combines traditional data platform engineering with substantial innovation and POC work.
The engineer will: • Build and prototype new Snowflake capabilities • Develop solutions using Python and SQL • Research emerging data and AI technologies • Build POCs to determine whether new capabilities should be adopted • Experiment with AI/agent-based solutions • Troubleshoot and optimize the existing Snowflake/Azure environment • Improve platform performance, reliability, automation, and cost efficiency • Help establish practical approaches for technologies where mature patterns may not yet exist
The ideal person is a builder + experimenter + data engineer, rather than someone focused primarily on traditional ETL development.
Duties/Day to Day Overview • Approximately 60% innovation / 40% platform support • Research and evaluate emerging Snowflake, cloud data, and AI capabilities • Build rapid POCs and prototypes • Develop hands-on solutions using Python, SQL, Snowflake, and Azure • Experiment with Snowflake capabilities including potential AI/agent use cases • Evaluate new technologies and develop recommendations for adoption • Build within the Snowflake environment • Investigate query history/plans, warehouse sizing, and performance issues • Troubleshoot complex data/platform issues • Participate in root-cause analysis and issue resolution • Help optimize Snowflake performance and consumption
Top Requirements
(Must haves) Experience Target • Approximately 7+ years overall IT experience • 5+ years working with data platforms
Snowflake • 5+ years working with modern data platforms / strong Snowflake experience • Hands-on Snowflake engineering and development • Comfortable building solutions within Snowflake • Strong enough platform knowledge to troubleshoot issues • Understanding of warehouse sizing • Query history / query plan troubleshooting • Performance and optimization knowledge
o Important: Candidate does not need to be a pure Snowflake Administrator. The preference is a builder/engineer with strong platform knowledge. Azure • Strong hands-on Azure experience • Understands how data engineering solutions operate within the Azure ecosystem • Azure is one of the hiring manager's top three skills
Python • Strong hands-on Python development • Must be able to build solutions, automation, and prototypes with Python • Not sufficient to only have conceptual Python knowledge • Python is one of the hiring manager's top three skills
SQL • Strong hands-on SQL • Query development/troubleshooting • Stored-procedure-oriented data work • Ability to use SQL for diagnostics and platform engineering
Builder / POC Mentality Candidate must be comfortable: • Researching unfamiliar technologies • Prototyping new Snowflake capabilities
Building POCs • Testing potential solutions against business/technical use cases • Identifying limitations and trade-offs • Developing a point of view on whether/how technology should be adopted • Working through ambiguity without requiring established patterns
AI Exposure / Hands-On Interest • Some hands-on AI experimentation desired • Candidate does not need to be an AI/ML expert • Preference for someone who has built or experimented with AI, rather than simply consumed tools such as ChatGPT/Copilot • Interest in AI agents and AI-driven automation • Ability to apply AI concepts within the Snowflake/data platform environment
Platform Troubleshooting • Ability to troubleshoot Snowflake/data platform issues • Performance investigation • Root-cause analysis • Production issue resolution • Comfortable providing occasional L2/L3-type support | |
|
|
- Dice Id: 91093714
- Position Id: 9121800
- Posted 8 hours ago
Company Info
About Trail Blazer Consulting LLC
At TRAIL BLAZER we help our IT consultants explore different industries, multiply their skills, and accelerate their career growth with industry-leading firms. We offer the flexibility of direct hire placements, temporary, and project work. With offices nationwide, TRAIL BLAZER combines the resources of a national network with in- depth local expertise. We offer the flexibility of direct placements, and project work.
Trail Blazer Consulting LLC is headquartered in Astoria, NY, USA. We are a leading professional consulting firm with a global database of applicants and state of art technology and process to identify the best and brightest skills.Trail Blazer is committed to provide customer satisfaction through commitment highest standards of services. With a range of skill sets and a flexible support network, we can deliver quick and cost effective resources to our valued Clients. We spend a considerable amount of time and resources screening and hiring top quality consultants, which allows us to provide premier resources that meet and exceed our client expectations.
OUR MISSION, VISION& VALUES:
We at TRAIL BLAZER CONSULTING believe in attaining success. We know that success is important to both our associates and our clients. Our mission is to understand and deliver 100%. With our commitment towards our clients, it helps us in achieving growth, innovation and excellence. We want to be an integral part of that process. To that end, we believe in the following Mission & Vision Statements and set of Core Values:
STAFF AUGMENTATION:
Staff Augmentation, or better known as subcontracting, is primarily outsourcing of manpower on a skill requirement or project completion basis for a limited period of time. From the past few years the IT departments have gone through a difficult phase as they have been pressed to deliver impressive results on multiple initiatives with limited staff. Staffing may be desired when there are a dynamic temporary or permanent people or skilled staff.
IT CONSULTING:
TRAIL BLAZER brings together the key IT consulting services that address aspects of reducing cost, increasing agility and enabling transformation. Our consultations are based on an analytical approach to understand the business problems, resulting in the practical recommendation and actionable plans. Our value proposition is based on a confluence of business knowledge, deep hands-on technology skills and a focused approach through the use of in-house methodologies, frameworks and tools.
CORE VALUES:
TRAIL BLAZER CONSULTING core values convey who we are as an organization and how we deliver value.
VOLUNTEER
our time, talent & resources
ACCOUNTABILITY
as we pursue our aspirations
LEGACY
to impact others lives
UNBEATABLE
as we collaborate & compete
EXTRAORDINARY
in all we do