[Remote] Snowflake Engineer (Snowflake Cortex & Data Engineering)
Note: The job is a remote job and is open to candidates in USA. Guidehouse is a company that specializes in data science and analysis, and they are seeking a Snowflake Engineer to design and optimize data solutions. The role involves developing data pipelines, maintaining SQL solutions, and supporting enterprise data architectures.
Responsibilities
- Design, develop, and optimize Snowflake data solutions supporting enterprise analytics, reporting, and data-driven decision making
- Build scalable batch and near real-time data ingestion and processing pipelines using Snowpipe, Streams, Tasks, Dynamic Tables, and Snowpark
- Develop and maintain advanced SQL-based solutions, including complex stored procedures, UDFs, views, and reusable data transformation frameworks
- Design and implement enterprise-grade ELT/ETL pipelines and metadata-driven automation frameworks
- Optimize Snowflake performance, scalability, reliability, and cost through query tuning, workload optimization, and platform best practices
- Implement secure, governed data solutions leveraging Snowflake native capabilities, including RBAC, data sharing, and governance controls
- Design and support enterprise data warehouse, data mart, and lakehouse architectures
- Integrate data from cloud, on-premises, API, and SaaS data sources
- Collaborate with architects, analysts, product owners, and business stakeholders to deliver high-quality data products and solutions
- Provide production support, monitoring, troubleshooting, incident resolution, and continuous platform improvement
- Support AI and advanced analytics initiatives leveraging Snowflake Cortex, Snowpark, and related Snowflake capabilities
Skills
- Must be able to OBTAIN and MAINTAIN a Federal or DoD 'PUBLIC TRUST'; candidates must obtain approved adjudication of their PUBLIC TRUST prior to onboarding with Guidehouse. Candidates with an ACTIVE PUBLIC TRUST or SUITABILITY are preferred
- Bachelors Degree
- FIVE (5) or more years of data engineering experience, including TWO (2) years of hands-on Snowflake experience
- Experience in SQL development with extensive experience building and optimizing complex queries against large datasets
- Experience developing and maintaining stored procedures, UDFs, views, and data transformation logic
- Deep understanding of Snowflake architecture, including Virtual Warehouses, micro-partitions, clustering, caching, and performance optimization
- Hands-on experience designing, implementing, and supporting Snowflake-native capabilities, including Snowpipe, Streams, Tasks, Dynamic Tables, Change Data Capture (CDC) patterns
- Experience administering secure, scalable Snowflake environments and implementing RBAC, data access controls, and governance frameworks
- Experience building scalable ELT/ETL frameworks and enterprise data pipelines
- Experience with data quality, reconciliation, monitoring, and operational support processes
- Knowledge of cloud platforms such as AWS, Azure, or GCP
- Experience with CI/CD pipelines, Git-based source control, Infrastructure as Code (IaC), and automated deployment practices
- Familiarity with production support, observability, incident management, and operational readiness best practices
- Hands-on experience implementing Snowflake Cortex capabilities and AI-powered data solutions
- Familiarity with production support, observability, incident management, and operational readiness best practices
- Experience with Cortex AI functions, semantic search, intelligent data applications, and AI-driven analytics
- Experience leveraging Snowpark (Python) for advanced data engineering, analytics, and AI/ML workloads
- Understanding of Retrieval-Augmented Generation (RAG), vector search, LLM-powered applications, and generative AI use cases within Snowflake
- Experience with dbt and modern analytics engineering practices
- Strong Python development experience
- SnowPro Core, SnowPro Advanced, or other Snowflake certifications
- Experience supporting regulated industries or large enterprise environments
- Experience designing cloud-native data products that support machine learning, advanced analytics, and AI initiatives
Benefits
- Medical, Rx, Dental & Vision Insurance
- Personal and Family Sick Time & Company Paid Holidays
- Parental Leave
- 401(k) Retirement Plan
- Group Term Life and Travel Assistance
- Voluntary Life and AD&D Insurance
- Health Savings Account, Health Care & Dependent Care Flexible Spending Accounts
- Transit and Parking Commuter Benefits
- Short-Term & Long-Term Disability
- Tuition Reimbursement, Personal Development, Certifications & Learning Opportunities
- Employee Referral Program
- Corporate Sponsored Events & Community Outreach
- Care.com annual membership
- Employee Assistance Program
- Supplemental Benefits via Corestream (Critical Care, Hospital Indemnity, Accident Insurance, Legal Assistance and ID theft protection, etc.)
- Position may be eligible for a discretionary variable incentive bonus
Company Overview