Flexible Data Engineering Apprenticeship Jobs in Reston, VA

## Snowflake Engineer (Snowflake Cortex & Data Engineering)Applylocations: US - VA, McLean: US - Remote (Any location)time type: Full timeposted on: Posted Todayjob requisition id: 42768**Job Family:**Data Science & Analysis**Travel Required:**Up to 10%**Clearance Required:**Ability to Obtain Public Trust**What You Will Do:*** 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.**What You Will Need:*** 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.**What Would Be Nice To Have:*** 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.The annual salary range for this position is $98,000.00-$163,000.00. Compensation decisions depend on a wide range of factors, including but not limited to skill sets, experience and training, security clearances, licensure and certifications, and other business and organizational needs.**What We Offer:**Guidehouse offers a comprehensive, total rewards package that includes competitive compensation and a flexible benefits package that reflects our commitment to creating a diverse and supportive workplace.Benefits include:* 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 #J-18808-Ljbffr