Overview
Hybrid
$60+
Accepts corp to corp applications
Contract - W2
Contract - Independent
Contract - 12 Month(s)
Skills
Agile
Auditing
Bitbucket
Confluence
Data Engineering
Data Extraction
Data Storage
Data Warehouse
Database
Debugging
ELT
Extract
Transform
Load
Git
GitHub
GitLab
Management
Meta-data Management
Microsoft Excel
Microsoft SQL Server
Orchestration
Performance Analysis
Python
SQL
Snow Flake Schema
Software Development Methodology
Streaming
Version Control
Warehouse
Job Details
Title : Sr Snowflake Developer
Location : Hybrid (Arlington, VA)
Must be in USA for 3 years ( Public Trust Clearance background check is required once the job is confirmed. Client will do the clearance process)
Essential Duties & Responsibilities
- Design, build and automate robust ELT data pipelines using Snowflake s native features (Snowpipe, Tasks, Streams) and integrating with external orchestration tools
- Monitor and analyze Snowflake performance, optimize SQL queries and data storage for efficiency, and optimal virtual warehouse usage
- Understand existing data models and database schemas and enhance to support business requirements
- Communicate with product teams and understand data requirements.
- Identify, analyze, and interpret trends or patterns in complex data sets.
- Develop and implement metadata, error logging, and audit for pipelines and other strategies that optimize efficiency and quality.
- Support the bug fixing and performance analysis for data pipelines.
- Analyze and manage 3rd Party and other external data sets.
- Follow an agile development methodology.
Requirements
- Overall 5+ years of experience with Data Engineering projects
- 3+ years of hands-on experience with Snowflake, including its architecture, virtual warehouses, databases, and security features
- Strong command of SQL for complex data extraction, transformation, and loading (ETL/ELT)
- Experience developing and automating ETL/ELT processes within Snowflake and with external orchestration tools
- 3+ years experience in years Agile environment
- Experience in git source control (GitHub, GitLab, bitbucket)
- Identify, analyze, and interpret trends or patterns in complex data sets.
- Support the bug fixing and performance analysis along the data pipeline.
- Analyze and manage 3rd Party and other external data sets.
- MS Office (word, teams, excel), experience with confluence.
- Strongly preferred: SQL Server experience, Python experience in data warehousing projects
- Self-starter, Self-reliant, and thorough knowledge in SDLC
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.