Senior Snowflake Data Engineer: Cortex & ELT Innovator

Guidehouse; McLean (VA); On-site; USD 113,000 - 188,000; Full time

Benefits offered by this job

Medical Insurance

401(k) Plan

Paid Holidays

Parental Leave

Tuition Reimbursement

Job summary

Guidehouse is seeking a senior data engineer to design, build, and optimize Snowflake data solutions supporting enterprise analytics and reporting. You will develop scalable batch and near real-time data pipelines, perform SQL-based transformations, and contribute to governance and security practices.

Collaborate with architects, analysts, product owners, and stakeholders to deliver high-quality data products.

Qualifications

• Must be able to obtain and maintain a Federal or DoD PUBLIC TRUST before onboarding.
• Bachelors
• TEN (10) or more years of data engineering experience, including 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 VWs, micro-partitions, clustering, caching, and performance optimization.
• Experience designing, implementing, and supporting Snowflake-native capabilities, including Snowpipe, Streams, Tasks, Dynamic Tables and 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.

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

Snowflake

SQL

ETL/ELT

Data pipelines

Python

Snowpark

CI/CD

RBAC

Cloud platforms

Data governance

Education

Bachelor's degree

Tools

Snowpipe

Snowflake Cortex

dbt

Git

IaC

Job description

Guidehouse is seeking a senior data engineer to design, build, and optimize Snowflake data solutions supporting enterprise analytics and reporting. You will develop scalable batch and near real-time data pipelines, perform SQL-based transformations, and contribute to governance and security practices.

Collaborate with architects, analysts, product owners, and stakeholders to deliver high-quality data products.