Intellibus · 1 day ago
Lead Snowflake Engineer
Atlanta, GA
Full-time
Remote
Senior Level, Lead/Staff
Maximize your interview chancesInformation Technology & Services
Insider Connection @Intellibus
Get 3x more responses when you reach out via email instead of LinkedIn.
Responsibilities
Design, develop, and maintain data pipelines to ingest, transform, and load data from various sources into Snowflake.
Implement ETL (Extract, Transform, Load) processes using Snowflake's features such as Snowpipe, Streams, and Tasks.
Design and implement efficient data models and schemas within Snowflake to support reporting, analytics, and business intelligence needs.
Optimize data warehouse performance and scalability using Snowflake features like clustering, partitioning, and materialized views.
Integrate Snowflake with external systems and data sources, including on-premises databases, cloud storage, and third-party APIs.
Implement data synchronization processes to ensure consistency and accuracy of data across different systems.
Monitor and optimize query performance and resource utilization within Snowflake using query profiling, query optimization techniques, and workload management features.
Identify and resolve performance bottlenecks and optimize data warehouse configurations for maximum efficiency.
Work on Snowflake modeling – roles, databases, schemas, ETL tools with cloud-driven skills
Work on SQL performance measuring, query tuning, and database tuning
Handle SQL language and cloud-based technologies
Set up the RBAC model at the infra and data level.
Work on Data Masking / Encryption / Tokenization, Data Wrangling / Data Pipeline orchestration (tasks).
Setup AWS S3/EC2, Configure External stages, and SQS/SNS
Perform Data Integration e.g. MSK Kafka connect and other partners like Delta Lake (data bricks)
Qualification
Find out how your skills align with this job's requirements. If anything seems off, you can easily click on the tags to select or unselect skills to reflect your actual expertise.
Required
ETL – Experience with ETL processes for data integration.
SQL – Strong SQL skills for querying and data manipulation
Python – Strong command of Python, especially in AWS Boto3, JSON handling, and dictionary operations
Unix – Competent in Unix for file operations, searches, and regular expressions
AWS – Proficient with AWS services including EC2, Glue, S3, Step Functions, and Lambda for scalable cloud solutions
Database Modeling – Solid grasp of database design principles, including logical and physical data models, and change data capture (CDC) mechanisms.
Snowflake – Experienced in Snowflake for efficient data integration, utilizing features like Snowpipe, Streams, Tasks, and Stored Procedures.
Airflow – Fundamental knowledge of Airflow for orchestrating complex data workflows and setting up automated pipelines
Excellent communication and interpersonal skills, with the ability to effectively collaborate with cross-functional teams and stakeholders.
Proven leadership abilities, with experience mentoring junior developers and driving technical excellence within the team.
Preferred
Bachelor's degree in Computer Science, or a related field is preferred. Relevant work experience may be considered in lieu of a degree.
Company
Intellibus
We are a team of passionate software engineers and entrepreneurs. We love to solve challenging problems efficiently.
Founded in 2015
51-200 employees
Funding
Current Stage
Growth StageCompany data provided by crunchbase
