Sr Snowflake Engineer

PineQ Lab Technology; Alpharetta (GA); On-site; USD 150,000 - 210,000; Full time

Job summary

PineQ Lab Technology is seeking an experienced Sr Lead – Snowflake Engineer to design, implement, and optimize cloud-based data solutions using Snowflake. The role requires hands-on expertise in Snowflake, SQL, Python, data warehousing, ETL/ELT, and data integration, with a focus on performance and cost efficiency.

The Senior Lead will guide cross-functional teams, drive technical delivery, and mentor engineers while collaborating with business stakeholders to translate requirements into

Qualifications

• 12+ years in IT with data engineering, data warehousing, cloud platforms
• Strong hands-on Snowflake experience with design and optimization
• Experience leading technical delivery and mentoring junior engineers
• Proficient in SQL, Python, and modern data integration
• Knowledge of security, RBAC, and data masking in Snowflake

Responsibilities

• Lead the design, development, and deployment of Snowflake-based data solutions
• Model logical and physical schemas, databases, schemas, tables, and warehouses
• Ingest and transform data from structured and unstructured sources
• Develop and optimize DBT pipelines and data quality checks
• Ensure security, RBAC, data masking, and compliance across solutions
• Provide hands-on guidance and reviews for engineering teams

Skills

Snowflake

SQL

Python

Data warehousing

ETL/ELT design

Data integration

RBAC security

Mentoring

Agile

Tools

DBT

Snowpipe

Time Travel

Data sharing

Job description

Project Duration : 12+ months, with extension

Look for a strong Snowflake candidate with SAP ex

Job Description: We are looking for an experience Sr Lead – Snowflake Engineer to lead the design, development, implementation, and optimization of cloud-based data solutions using Snowflake. The role requires strong hands-on technical expertise in Snowflake, SQL, Python, data warehousing, ETL/ELT, data integration, security, and performance optimization.

The Senior Lead will work closely with business, data, and technology teams to understand requirements, develop scalable data solutions, lead technical delivery, and provide hands-on guidance to the engineering team.

Key Responsibilities

• Lead the development and implementation of scalable and highly available data solutions using Snowflake
• Design and implement logical and physical data models, including databases, schemas, tables, views, and virtual warehouse
• Develop and optimize data ingestion and transformation pipelines into Snowflake from structured and unstructured data sources
• Work with data formats including CSV, JSON, Parquet, and X
• Develop and maintain Snowflake objects including Streams, Tasks, Snowpipe, Stored Procedures, Materialized Views, and Dynamic/External data sharing solutions as required
• Implement Snowflake security using RBAC, user and role management, data access controls, and data masking
• Configure and optimize virtual warehouses, resource monitors, clustering, query performance, and overall Snowflake utilization
• Implement Snowflake capabilities such as Time Travel, Zero-Copy Cloning, Data Sharing, and Fail-safe
• Monitor Snowflake usage and help optimize compute and storage costs based on workload requirements
• Develop complex SQL queries and perform data validation, reconciliation, and data quality checks
• Work with Python, SQL, DBT, and other data engineering tools to support data processing and automation
• Support database and data warehouse migration initiatives, including migration to Snowflake
• Analyze existing data processes and identify opportunities for performance improvement, automation, and optimization
• Collaborate with business stakeholders, developers, QA teams, and other technical teams to translate requirements into effective technical solutions
• Lead technical discussions, code/design reviews, troubleshooting, and production issue resolution
• Provide technical guidance and mentoring to junior and mid-level engineers
• Prepare technical documentation, implementation plans, technical specifications, and status updates
• Ensure solutions follow organizational standards for security, governance, data quality, and compliance
• Participate in Agile ceremonies, sprint planning, estimation, and delivery tracking

Required Skills

• Strong hands-on experience with Snowflake
• Strong SQL development and troubleshooting skills
• Experience with Snowflake Streams, Tasks, Snowpipe, Stored Procedures, Time Travel, Zero-Copy Cloning, Resource Monitors, and Virtual Warehouses
• Strong understanding of data warehousing, ETL/ELT, data modeling, and data integration
• Experience with Python for data processing and automation
• Experience working with DBT and modern cloud data platforms
• Strong understanding of Snowflake security, including RBAC, roles, users, data access controls, and data masking
• Experience with Snowflake performance tuning and cost optimization
• Experience integrating data from multiple sources
• Strong troubleshooting, analytical, and problem-solving skills
• Experience working in an Agile development environment
• Strong communication and stakeholder-management skills
• Ability to lead technical teams while remaining hands-on with development and implementation
• Knowledge of Snowflake/AWS/Redshift/Oracle/SQL Server/Git tools

Preferred Qualifications

• SnowPro Core certification or equivalent Snowflake experience
• Experience with SnowConvert or database migration tools
• Experience with data governance, security, and regulatory requirements
• Experience working with large-scale enterprise data environments
• Strong experience leading technical teams and delivering enterprise data projects

Experience

• 12+ years of overall IT experience with strong experience in data engineering, data warehousing, cloud data platforms, or related technologies
• Strong hands-on experience with Snowflake and enterprise data solutions
• Prior experience in a technical lead or senior technical role is preferred