Snowflake Engineer

CGI•Houston, TX

1d•Hybrid

About The Position

This Senior Consultant role offers hands-on work with Snowflake and a supported growth path toward becoming a Data Architect. The role includes structured mentorship from experienced architects, participation in design reviews and solution patterns, stakeholder discussions, and increasing ownership of technical decisions. Work spans consulting engagements across industries and uses modern Snowflake capabilities across major cloud platforms. The position is based in Houston, Texas, and can be performed in a hybrid work model. The engineer will build and optimize data pipelines, develop data models, implement transformations and orchestration, and apply data governance, security, performance, cost management, and CI/CD practices. The role also involves solution design, client communication, documentation, mentoring, and contributions to reusable practice standards. CGI supports professional development through SnowPro certification access, training time, and community opportunities, as well as a development plan toward an architect role.

Requirements

At least 4 years of experience in data engineering, including hands-on Snowflake experience in production environments.
Strong SQL proficiency, including complex transformations and performance tuning.
Proficiency in Python, including Snowpark or a similar tool, for data processing and automation.
Hands-on experience with Snowflake features such as Snowpipe, Streams and Tasks, Time Travel, cloning, and data sharing.
Experience with Snowflake security and governance, including RBAC, masking, and access controls.
Experience with at least one major cloud platform: Azure, AWS, or GCP.
Experience building production-grade ETL/ELT pipelines, including batch and near-real-time ingestion.
Working knowledge of data modeling and data warehousing concepts.
Experience with Git and CI/CD practices.
Strong communication skills and the ability to work directly with clients and stakeholders.
Demonstrated interest in and aptitude for growing into an architecture role.

Nice To Haves

SnowPro certifications, such as Core, Advanced Data Engineer, or Advanced Architect.
Cloud certifications in an Azure, AWS, or GCP data track.
Experience with dbt and modern transformation frameworks.
Experience with Dynamic Tables, Snowpark, and Snowflake cost governance.
Infrastructure as code experience, such as Terraform.
Exposure to data governance, security, and compliance frameworks.
Experience with BI tools and semantic layers.
Prior consulting or client-facing delivery experience.
Experience leading or mentoring junior team members.
Familiarity with data migration projects, such as moving a legacy warehouse to Snowflake.

Responsibilities

Design, build, and optimize scalable batch and near-real-time data pipelines on Snowflake using SQL, Python, Snowpipe, Streams, Tasks, and Dynamic Tables.
Develop data models, including dimensional, data vault, or layered raw/curated/consumption patterns, to support analytics and reporting.
Build transformation and orchestration workflows using tools such as dbt, Airflow, or Azure Data Factory.
Apply data governance and security practices, including role-based access control, masking policies, row-level security, lineage, and data quality.
Tune query performance and manage costs through warehouse sizing, clustering, caching, and resource monitors.
Implement CI/CD and DevOps practices for data workloads, including Git, automated testing, infrastructure as code, and deployment pipelines.
Participate in solution design sessions and architecture reviews, progressively leading the design of components and full solutions.
Translate business requirements into technical designs and communicate trade-offs to technical and non-technical stakeholders.
Produce technical documentation, including design documents and architecture diagrams.
Mentor junior engineers through code reviews and knowledge sharing.
Contribute reusable frameworks, accelerators, and best-practice standards for the wider practice.
Work on a personal development plan toward an architect role and take on stretch assignments such as pre-sales support, technical assessments, and platform roadmaps.